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…
Hello Sage 100 Community,
I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout:
Account No.
Debit
Credit
Posting Comment
Journal Comment
6570-00
500.00
0.00
Test comment…
We have an item we need to bring in that is a large value item. The problem with this is that we are bringing it in through RMA. We need it in the system but cant have this value show in our books. Is there any way to have its value show Zero in our books…
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…
My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ?
Thank you,
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…
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
Hello,
I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me.
My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN.
We utilize the WO module to purchasing, including…
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?
My users are experiencing an issue where the accounting department is still performing month end closing processes for the previous month after start of the next month so the current General Ledger period is still last month and does not match the current…
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…
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?
Hi
I am currently creating a new database in Sage 100 but stuck on the General Ledger Account Structure
where it is not allowing me to choose between Standard and Segmented accounts type.
The option for segmented does not appear although am registered…
Hello,
We had a strange event occur a few days ago. For one of our batches, the Cash Receipts Journal processed all of our checks except for the last 4 in the batch. However, the full batch was posted to the General Ledger, and the full amount shows…
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…
