In GL after all batches are posted, new.glt disappears. Sys admin has to go into GL>Tasks>Record Entries and create a new.glt file. Users don't get the option to create.
I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path
sales order, main, invoice data entry
the GL detail report that I printed early May for our April rebill, as well as the latest…
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…
We used a Job Cost Direct Costs Journal entry to post a wire fee to one of our jobs. The fee correctly posted to the GL, but when we attempt to complete our monthly bank rec, the wire fee is not showing. How do we ensure the wire fee is recorded in Cash…
Hi,
We have cash accounts set up that haven't had balances in years on our GL and Cash Management.
Can we rename and reuse these accounts?
What is the best practice, please?
Thanks,
Cathé Young
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…
Currently we use payroll for expensing the labor expense on our setup. There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O. When WIP got turned off the offsetting transaction for the…
A General Ledger General Journal entry batch file has been printed but not posted. It is now frozen and cant be updated. I'm getting a message saying the file is in use and that the file is locked by the user in General Journal. Nothing else can be posted…
I have a client on Sage 2021, Product Update 1. When printing the Daily Transaction Register after updating the Daily Sales Journal, the DTR shows incorrect information. It will have the correct Source Journal Number, incorrect Date and the journal postings…
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…
Dear Team,
Re posting the issue again to get more attention , the problem is unsolved and demanding immediate attention.
We have noticed a strange issue in treatment of VAT. The VAT is calculated in AP correctly and reflected in VAT report as well…
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…
Sage 100 2020 Premium (6.20.1)
After deleting old users off a system, the GL drill down from Transaction tab "Updated By" is blank for the deleted users. The deleted user keys are listed in SY_UserHistory.
Short of 'reactivating' the deleted users…
We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account.
To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…
We had our PPP loan forgiven, and our CPA told me to book it in under "Non-taxable income". I spoke with one person that set to setup account 950 to book this as non-taxable revenue. It still shows up on the Income Statement, is this correct?
We are using Sage 100c 2017, Version 5.40.60. I do not see the reversing journal entry icon. I understand that the option to reverse a journal entry through the account maintenance section became available in 2015. Is there a setting I need to adjust…
Hello all!
I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…
I am new to Sage, but trying to create a GL import file for a journal entry. It is not through payroll module, but it is an entry to record weekly payroll through a GL entry. The amounts change weekly, but the accounts and descriptions are consistent…
We have had to add new Other Pay additions for the 2020 year and we are having an issue with the fact that the taxes on these Other Pays are not breaking out departmentally, even though the Other Pay is set up to break out departmentally. Is there another…
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.