Thanks Karen! I found the issue. There were some journal entries done when we were trying to build historical financial information and before we generated sales invoices in our live environment. For some reason we had 3 invoices where the detail was applied to the G/L, but it did not hit the...
Thanks Tim! -- Lukas Sundahl Solutions Through Innovative Technologies Tulsa OK --
Hi Kristina, 1) How do I verify in the GL detail any entries that were posted directly to the balance sheet account and bypassed the customer ledger? 2) I think our posting groups are set up properly after reviewing. 3) We only operate in USD currently. -- Lukas Sundahl Solutions Through...
It did tie out prior to the one period where the invoices hit only the GL and not the Customer Ledger. Every customer is set up with a customer posting group that connects to the AR account. -- Lukas Sundahl Solutions Through Innovative Technologies Tulsa OK --
Thanks David! I found the issue. There were some journal entries done when we were trying to build historical financial information and before we generated sales invoices in our live environment. For some reason we had 3 invoices where the detail was applied to the G/L, but it did not hit the...
Hi Lukas, The first think I would check is if there are any manual entries in the G/L. -- Karen Vernon Melco International Westminster CO --
Try the Customer - Trial Balance report. If there is foreign currency involved, the trial balance shows the historical rate applied. The Aged Accounts Receivable calculates the balance based on the current exchange rate. -- Tim Metz Shin-Etsu MicroSi, Inc Phoenix AZ --
Hello Lukas, There are a few reasons for your variance and I may not capture them all. 1. Look throug the GL detail to see if anyone posted a journal entry directly to your balance sheet account. a. Do you allow "Direct Posting" to the GL account? Navigate to the G/L Account Card and look...
Did it ever balance? if so, sometime since the last time the report tied to the G/L balance someone posted a transaction directly to the accounts receivable G/L account. Or someone added a new Customer Posting Group and did not assign your Accounts Receivable G/L Account to that new Customer...
Two things to check to start with. First, check to see if there are any non-"System-Created Entries" in the general ledger account. Second, what date option are you using when running the aged A/R. Running by Transaction Date may also be the best option when trying to tie to the G/L. --...