Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello,
I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…
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…
Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
Hello,
I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…
Hello,
I tried to delete a batch in General Ledger, but I received this error "This batch will be retained because deleted entries exist". Has anyone had this error before? How to fix it.
Thanks a lot!
Jun
How can I change my settings in the GL Module to only show Active accounts on my Trial Balance? Currently it is showing deleted and inactive accounts along with the active? Thank you
Have had 2 clients in the last two weeks come up with mysterious beginning balances on accounts as of the first fiscal year in history. Digging into DFDM, I've found a posting with a BLANK Fiscal Year and Period in both cases. In neither case could I…
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 have 3 company codes in our system. The operational efficiency ratio data on the general ledger analysis report populates for one of our companies but not the other. Has anyone experienced this issue before?
Hello,
Our accounting department brought to my attention that for certain lines on the AR aged invoice report, the "Balance" field is showing exactly double what the "Current" field is. I went and looked in the database thinking there have been double…
Hello,
Our accounting department recently brought to my attention that entering data inside of Cash Receipts Entry only posts to the sub-ledger. They must then go into the daily transaction register in order for this to process to the General Ledger…
Hi - new here. Looking for a bit of help.
I am trying to use the "Select Invoices for Payment" window that pops up from the "Check Printing and Electronic Payment" function. My understanding is that you can use this window to post A/P to the general…
A customer will have several companies that need customized financial reports which have been developed and tested in one company. The same Chart of Accounts and Account Groups exist in each company so we don't anticipate a problem sharing them, but I…
We have revamped our naming convention for "budgets". I want to delete the old budget codes. I went into General Ledger, Setup, GL Options, "Budget" tab. When I click on the old budget name I want to delete, I get a message that states I cannot delete…
Customer is trying to change from fiscal year to calendar year. New customer so entered Fiscal year data from Quick Books. Using Sage now about 4 months. 2017: Fiscal November 2017 to October 2018. Short period 2018: November 2018 to December 2018; Calendar…
When you change the Bank Code in Transaction Journal Entry > Format you get a warning message that the GL account does not match the GL Account, but if you change the GL Account you don't get a warning message. It should provide a warning message any…
You should be able to perform journal reversals without giving security to "create" in Account Maintenance. You should be able to perform journal reversals if you have "view" or "modify" rights.
We have a need to expand to a second location. It has been determined that setting up a secondary Warehouse is the proper route to go. I believe we also need to change the account structure somehow to add to our current 5-digit account #s. Can anyone…
Hello,
I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…
I need to change which Account Group a couple of GL Accounts are located in. I first went into GL/Setup/Main Account Maintenance to make this change, but I get an error message stating:
"This account group has been assigned to a main account used on…
version 4.40 General Ledger
I am creating a list of Standard Journal Entries in the General Ledger. I now want to go back and edit a few, but can not find the setup/maintenance for these. Or can I go into the table via DFDM?
Thanks
P Park