Search

1 to 10 of 690
Sort by

Discussion Reply
RE: Aging AR - Balance Sheet AR

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...


Discussion Reply
RE: Aging AR - Balance Sheet AR

Thanks Tim! -- Lukas Sundahl Solutions Through Innovative Technologies Tulsa OK --


Discussion Reply
RE: Aging AR - Balance Sheet AR

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...


Discussion Reply
RE: Aging AR - Balance Sheet AR

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 --


Discussion Reply
RE: Aging AR - Balance Sheet AR

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...


Discussion Reply
RE: Aging AR - Balance Sheet AR

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 --


Discussion Reply
RE: Aging AR - Balance Sheet AR

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 --


Discussion Reply
RE: Aging AR - Balance Sheet AR

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...


Discussion Reply
RE: Aging AR - Balance Sheet AR

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...


Discussion Reply
RE: Aging AR - Balance Sheet AR

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. --...