• 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 GL ) …
  • 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…
  • How to print TB for future year.

    Hi, 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…
  • 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…
  • Sage 300 2021

    I was told that Sage 300 2021 will support General Ledger FR 64 bit May I know if this is true?
  • 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.
  • 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…
  • 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 when I go to BKENTH…
  • 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

    Hello, 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

    Hi, 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.