D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Payment due dates populating incorrectly

  • 1.  Payment due dates populating incorrectly

    GOLD CONTRIBUTOR
    Posted 13 days ago
    Good Day,

    We have picked up a query with regards to the Invoice due dates on the vendor accounts (AP Invoices).

    If we navigate to Accounts Payable - Common- Vendors - All vendors
    Select the relevant vendor and select transactions.

    What we are seeing is the Due dates have populated incorrectly.  This table reflects as the VendTrans.DueDate.  This is a 60 day account whereby the transaction date is the 9th of October 2019 and the due date has been calculated as the 31st of October 2019.
    If we navigate to Accounts payable - Enquiries - Journals - Invoice journal the date is calculated correctly as the 31st of December 2019.  This table reference is VendInvoiceJour.

    What could cause the incorrect due dates to populate in the vend trans table.

    Your input would be greatly appreciated.


    ------------------------------
    Erica Burns
    AX Consultant
    Omnia Group (PTY) LTD
    Johannesburg
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Payment due dates populating incorrectly

    MICROSOFT MVP
    Posted 2 hours ago
    Hi Erica,

    I noticed this question was still unanswered. Initially, the due date should be inherited from the invoice. However, it is possible to agree another date with the vendor and then change it on the vendor transaction. This will be used for the payment proposals where the original posted document (invoice) will not be changed. In that case, you can have a situation like you described.

    ------------------------------
    kind regards,

    André Arnaud de Calavon
    Solution Architect, Microsoft MVP - Microsoft Dynamics Business Solutions
    ------------------------------

    Conference-AXUG_200x200


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