Sage 300

Hello, We need to pull a list of invoice credits for our auditors. We need the customer key, document number, date and amount. Which tables do we need to use to extract this information? Ty.

Hi, Is there a table that contains the latest (current) cost by item/location? We are looking into ICIVAL but it contains all transactions that have been processed for each item. Ty.

The error above appeared on one workstation only at a client when posting a Purchase Order. This workstation was fine for several months after the upgrade They were recently upgraded to Sage 300 v2021 PU2. They are also integrated with CRM 2021 if that…

We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…

Hi, Does anyone know how Sage Accpac populate these 2 fields for MISC Charges in table OEAUDD? EXTCOSTH EXTCOSTS What we notice is, when Misc Charges is processed, these 2 fields are populated…