Hello. Does anyone where credit card stubs are stored in V12? In version 6 it was XCSPSCNT.
We are in the middle of a migration to V12 and I'm trying to understand how credit card stubs are stored; because I will have to update some of my integrations…
Newbie here.
I am entering items details manually into the different fields of a purchase requisition.
I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…
Hello,
We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure…
Hi There.
We are discontinuing a service with one of our Sage consultants. We wish to take on Transaction integration inhouse (SQL environment).
What is the best way to go about this? Do we have to use a consultant, or can we adapt this technology…
Good morning,
I am using the below SQL statement to get a sales per item number from my Sales History tables ( OESHHD and OESHDT ) as well as item cost in my Sales Posting Journal tables ( OEAUDH and OEAUDD ). However, when I compare my sql output my…
I'm looking for a table/relationship diagram to show what fields are in what tables and what they use to link to other tables? All the info i find in sage and online says this cant be done after 2007 version. That's ridiculous, surely there is a way to…
Hey there!
I only started working with Sage (we use version 2019 R2) a month ago so please bear with me if the answer is too obvious.
Is there a comprehensive tutorial on what needs to be done when creating a new table so that it works in conjunction…
Hello,
The short length of certain text fields is a constant complaint from our customers.
It is very necessary to increase the size of text fields, especially for DES, AX3 and NAM types
Regards
I have used the following T-SQL commands quite often when working on the SQL Server side. There are other ways to find some of this information, but you should have these commands in your toolbox.
Using the SQL Server Management Studio(SSMS) interface…
I tried to delete the Pending communication(comm_status from database in dbo.communication based on User. I can't see the relation between the table other then channel id.I checked in Dbo.comm_link where i can see the relation but i can't find comm_status…
Dears,
How can i make sage crm alignment from left to right permanent coz when i convert it to left to right alignment when i logged it auto convert from right to left
IE 9 :/
Hi,
i am install sage crm 7.1 SP2 and integrate it with Accpac 300 ERP 2012 Every thing is ok but i have problem when go to company and try to make new order or new Quotes the below error happen Please any idea to help ???
Hi
i am create custome entity .net api and then i create tab "Document" and System Act: librarylist but it back for me all document when add new document and its go out entity
how can i add document tab ???
thanks
Hello Everyone. I want to create a screen with two Entities inside it(similar to Quote Entry screen can insert product)
e.g : I have Invoice entity and InvoiceDetail entity. InvoiceDetail use for save many items or products in one invoice. So could…
We have a customer group that is wholesale. In the Matrix Pricing GUI - the group is set to:
Method - Discount Amt
Base - List Price
Amount - 0
The customers in this price group do not show up in the timCustItemPrice table at all.
We have…
When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…
Hi,
We are a Blending & Packaging plant and have v9 Patch 5.
We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...)
We've started to purge out some old data like the ATRACE and investigating into the…
We are on version 11 patch 9 I created a table and a custom import template:
The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…
Good day everyone,
I am Manuel a rookie in the use of Sage X3. Fortunately over time have gotten myself familiar with the Interface and workings of the ERP system but on the development part have been stuck with a few challenge and hoping get it it…
I have the following Graphical query, the two tables are BPCUST AND SINVOICE.
How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018.
When I search for this its outputting all the invoices and duplicating…
Hopefully this is a simple request
I have a Purchase Receipts screen, and each line item has an associated Purchase Order.
I need to display a value from the purchase order (held in the PORDER table) on each line item
If I just add the PORDER…
How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010?
I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…