Open Forum

  • 1.  Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 01, 2021 09:20 PM
    Hi,

    When print Aged Accounts Receivables there are certain sales invoices which the system is not picking up and showing up in the mentioned report. I can see the related payments are being shown the report but for some reasons or some how the report is not picking up certain sales invoices posted.

    The user has not used Cash Receipt Journal and applied the payment to the invoice but the user went into Customer Ledger Entry -> picked up document type shown as Payment -> Click on Apply Entries. Once the applies to entry window is shown, from there the process is normal like generating applies to id and picking up the invoice that the payment was going to be matched. Final step was to post application.

    After this, when print Aged Accounts Receivables with parameters as Aging By  Due Date or Transaction Date or Document Date, select print in detail, Period Length = 30D, when print and preview the report, there are 3 invoices that are not shown up in this report.

    Upon checking in customer ledger entry, the sales invoices are shown there.

    Inv#1040418  $3,438.00  (posted on 7/29/21)      Payments are listed:   -$2,275.00 and -$1,163.00, posted on 6/21/21

    Inv#1040345  $41,071.60 (posted on 7/12/21)     Payment is listed:    -$41,071.60, posted on 5/20/21

    Inv#1040432  $41,296.40 (posted on 7/29/21)     Payment is listed:    -$41,296.40, posted on 6/21/21

    When Aged As Off is set to an date as 6/30/21, only payments are showing up and not sales invoices. Any clue as why is it so?

    Regards
    Khan



    ------------------------------
    Khan Wajahatullah
    Hydro Style Pte Ltd
    Singapore
    ------------------------------


  • 2.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 01, 2021 09:58 PM
    The aged as of is looking into posting dates which your invoice posting date is July 2021. The document date and transaction is getting your invoice posting date if this has not been changed while encoding th transactions. The The due date is based on the Customer payment terms example if invoice 1040432 has 30 days payment terms the due date will be August 29, 2021. In summary, when your aging as of 06/30/21 this will invoices will not be included.

    Try changing as of aged to 07/31/21 or As of 08/31/21 then review if those invoice appears.

    Regards,

    Richelle






  • 3.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 02, 2021 06:55 PM
    Hi Richelle,

    Thank you for your reply.
    The invoices that were posted for the customer has no payment terms, the payment terms are blank.
    The invoices that were posted in the month of July - when i check them under posted sales invoices it shows that document date, due date and posting dates are the same; i.e whichever date that was picked in the month of July and was posted. So in this case there is calculation of any dates (for due date) since due to no payment terms defined for the customer.

    I have tried to print the standard aged accounts receivables with all kinds of combinations like Transaction Date, Document Date or Due Date, the invoices dont appear in the report. I have used the date as June, July and also Aug but still those 3 invoices are not shown up in the report.

    ------------------------------
    Khan Wajahatullah
    Hydro Style Pte Ltd
    Singapore
    ------------------------------



  • 4.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 02, 2021 07:19 PM
    Do you have any filtering the report filter? Could you please provide a screenshot of the report filter.

    Regards,

    Richelle






  • 5.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 02, 2021 07:28 PM
    Hi Richelle,

    Thank you for your quick reply.

    I am not sure of the reason but found something new today.
    When run customer ledger entry table, filter on document numbers (those invoices missing in the report) like 1040418, 1040345 & 1040432, the result came out, see below screen


    I am not sure if the report is getting confused as the same document number has been used in Doc Type = Credit Memo as well with different posting dates on all the 3 of them. For some reasons the same document number has been reused in Doc Type = Invoice as well with different posting dates?

    May be you can give me some hints or can you confirm if this could be the reason for Aged Accounts Receivables to skip those 3 invoices.

    Regards
    Khan

    ------------------------------
    Khan Wajahatullah
    Hydro Style Pte Ltd
    Singapore
    ------------------------------



  • 6.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 02, 2021 07:38 PM
    Hi Khan,

    I can also see that the remaining amount is zero. Could you please scroll to the right and check if the "Open" column is tick. Looks like this invoices are bot open anymore. We just need to know which entry it was applied to.

    Regards,

    Richelle






  • 7.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 02, 2021 07:54 PM
      |   view attached
    Hi Richelle,

    I have copied all the records for document numbers (those invoices missing from the report). All the entries are with status for Open as NO. They all are closed successfully.

    But now i suspect that it could be due to the same document number applied for Doc Type;

    Credit Memo & Invoice as well.

    Hence Aged Accounts Receivables is unable to pick up those 3 invoices since the same has been found under credit memo with different posting dates.

    Regards
    Khan

    ------------------------------
    Khan Wajahatullah
    Hydro Style Pte Ltd
    Singapore
    ------------------------------



  • 8.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 03, 2021 05:53 PM
    Hi Khan,

    Aged AR report will only show open ledger entries. By any chance, could you please check the applied entries on those invoices? Also, check the dates which the invoices had applied entries.

    Please example below for your reference.


    Click Entry >Applied Entries

    Under the Applied Customer Entries > the posting date is March 1, 2020.
    This means, if I run the Aged AR by January 2020 and February 2020 the invoice will show. But if I run Aged AR as of March 2020 the invoice will not show in the Aged AR Report.

    Please below example:

    Please below example:
    Please below example:

    I hope this information helps.

    ------------------------------
    Regards,

    Richelle Gatus

    Director of Implementation Services
    Direct: 587-355-9829
    Phone: 403-744-5358
    www.systemasolutions.ca
    ------------------------------



  • 9.  RE: Version 2018, Aged Accounts Receivables (Standard Nav Report) is not picking up certain sales invoices

    Posted Sep 02, 2021 08:23 AM
    Hi Khan,
    Keep in mind that the system is very date sensitive and date driven.  When you set the Aged AR report's date to end at 06/30/21, it does not acknowledge anything after that date. Since your payments are dated prior to the invoices, the report only includes the payments.  The invoices are dated past 06/30/21 so they are not included.

    Hope this helps!

    ------------------------------
    Crystal Tollison
    Innovia Consulting
    Onalaska WI
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role