Sage 300

Hi all, On the GL Journal Entry screen, entry number finder, there are Customer / Vendor Number and Customer / Vendor Name column, which is related to GLJEH table, CUSTVEND column. I check on it and found that there is no value in this column. I would…

Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

Using Sage 300 Premium 2018, with Purchasing and Inventory Control modules. The PO Clearing account on the balance sheet has no means of reconciliation or audit report that proves the GL. I need a report that shows PO receipts that reconciles to the…

We are using Sage 300 Premium 2018 (Accpac) with the Job Costing module. I don't have a method of auditing the balance of the WIP balance sheet account. The balance is climbing, and it is as if transactions are being "dead-ended" there and not flushed…

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Client is currently revisiting their chart of accounts as it is making report writing impossible. They are also moving to sage intelligence but I had a quick query. They are trying to insert ”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545…