• 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…

  • Disabling "Clear History" in G/L Periodic Processing for certain users

    Hi have been trying to figure out how I can disable "Clear History" for certain Users.) (last item in screengrab)

    Tried unticking "Period End Maintenance" and "History/Budget Maintenance" - both did not work. ( please see list of options for…

  • 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 batch…

  • How to print TB for future year.


    The scenario is like this:

    The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how to…

  • Financial Statements fails to open in MS Office 2019 Pro Plus

    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…

  • 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 balance…

  • Sage 300 2021

     I was told that Sage 300 2021 will support General Ledger FR 64 bit

    May I  know if this is true?


    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.


  • Unbalance G/L from Web API Posting in Functional Currency

    I am using Sage 300 Web API v1.0 with Multi-currency enabled, I post to G/L entries in source currency and it converts to functional currency. The source currency which I posted from is balance but the converted functional currency is not balance. This…

  • 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 balance…

  • 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…

  • 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…

  • Allocation Entry

    I would like to create allocation entries where by the balances from several accounts would be used to generate an allocation entry from a contra account to our inventory account.  the contra account would always like an offset to all of these group of…

  • How to reverse a credit note ( Type: Return ) in Purchase Order (Posted to GL)

    How to reverse a credit note ( Type: Return ) in Purchase Order (Posted to GL) .Since the credit note entered a wrong date , i want to adjust the record , What can i do ? is it open a Debit note to recover it?

  • G/L Transactions Listing - Source and Functional


    I'm in a Canadian company where many of our vendors are in the U.S. I want to use the G/L Transactions Listing to see both the Source (USD) and Functional (CAD) amounts for AP invoices; when I print the listing with this Currency option selected…

  • find deleted entries


    Is there a way to find deleted entries in GL and the amount. These entries came from AR and AP and they've been posted in Subledger.

    And I'd like to know if we can find out the User who deleted these entries.