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…

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…

Hello, there is a discrepancy between the adjusted book balance of our bank rec and our gl account over a number of periods. The first variance ties perfectly to one entry that appears like it was posted correctly as a bank entry and cleared on the bank…

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…

Hi All, I entered a bank USD entry with the wrong USD to CAD rate. This is messing up the balance of the clearing account and so I would like to reverse the bank entry and re-enter it with the correct USD to CAD rate. However, the bank entry is now…

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.

In AP, I entered a manual ck incorrectly as 4/19/01. When the system tried to post the resulting GL entry, I got this error. I have since voided the manual ck and re-entered it correctly. Now, how to clear this error in the GL posting?

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…

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 have many inactive accounts. Previously, we would get a warning when positing to these accounts. A beep and a visual. This now only happens to some inactive accounts, not any of the newly inactive accounts. We do have the setting in "Common Services…

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…

Hi, In AP GL integration, if the detail description option was not selected to be transferred to GL initially, what happens if this setup is done mid way. Will the detail description be transffered for history data? If not, then how can this be retrieved…

Hi there general newbie question How do we correct a GL code on Sage 300