• How to populate GL Journal Entry - CUSTVEND column

    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…
  • Sage 300 GL batch posting freezes

    Sage 300 Premium (Version 2022) SQL 2019 on Windows Server 2019 GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL…
  • Incorrect GL account type Balance Sheet > Income Statement

    Our client has a few GL account configured as Balance Sheet account instead of Income Statement account. The account was incorrectly created as a balance sheet account. We need to change the account type to income statement but firstly, correct the…
  • IMBLANACE GL WITH AGED PAYABLE

    We have a client running Sage 300 Cloud and they are experiencing imbalance aged payable with GL Any guide on how to get it resolved would be highly appreciated. Regards.
  • Reconciling WIP account in PJC environment

    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…
  • Purchase Order Clearing Account Reconciliation

    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…
  • Data Integrity Bank Entry Error

    Sage 300 ERP 2016, working through my data integrity issues and there is a warning that I would like to resolve. The message is "W: G/L Account 'XXXXXXXX' is inactive, but can be used." It does give a sequence number with the error and when I go to BKENTH…