web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor payment posting...
Microsoft Dynamics AX (Archived)

Vendor payment posting date

(0) ShareShare
ReportReport
Posted on by Community Member

I have encountered a weird issue regarding vendor payments and was wondering if someone could shed some light on this issue.

When creating a vendor payment proposal and have a payment date in the future(Lets say till end of January) I can select over due invoices and invoices which are not due yet.(Due date is after system date)

When I transfer the due invoices to the payment journal, it will get the posting date of today, but transferring invoices which are not due will get an adjusted posting date which is the due date of the invoice.

I find this illogical as the payment will be done that day and the posting will be done that day or the day after. Why is it that AX takes the due date as posting date in the payment journal when invoices aren't due yet? My trial balance will be incorrect with this setting. I also haven't seen any parameter which will affect this.

According to technet it should be the system date: https://technet.microsoft.com/en-us/library/aa599011.aspx
"View or enter the posting date. The system date, which typically is today’s date, is suggested, but you can select another date. When the date on a line has been changed, this date is suggested when a new line is created."

Is there some reason for this behaviour?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Martijn,

    When you created your payment proposal what values did you enter in the payment date, from and to date field? If you enter today's date in the payment date field all invoices should be transferred to the Journal with this date and posted correspondingly. Have you tried that?

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hello Ludwig,

    From and to date are empty(But could be set from 30 oct 2015 to 1 feb 2016), payment date is today and I just select a vendor that has 2 outstanding invoices. One has a due date of 1 feb 2016, the other 30 oct 2015. When transferring the lines to the payment journal, the first invoice gets a posting date of 1 feb 2016(due date of invoice) and the other get 30 dec 2015(system date).

    I have tested this in our own environments and standard contoso.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Martijin,

    Can you check the Setup of your method of payment?

    What is setup in the period field?

    I guess your setup says "invoice".

    If you select "total" instead, AX should summarize all the payments that you want to make into a single line with the payment date specified in the payment proposal form.

    Please give it another try in a demo/test Environment.

    All the best,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Dear Ludwig,

    I'm afraid that workaround doesn't work, I am still getting 2 lines(Which is not what I expected now) with two different dates, while they both should be one.

    I am guessing because the payment that is due in the future is still a separate line due the fact that AX gives it a different posting date.(Normally payments would be summarized to one line with 1 posting date)

    KR,

    Martijn

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Martijn,

    You are right, AX splits the payments up in 2 lines. I guess you need to modify the standard behaviour if you want to have it included in one single line.

    All the best,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Dear Ludwig,

    That is ok, splitting up the lines is not the issue for me.

    Dont you find it strange AX takes the due date of invoice instead of the system date as payment date in the journal? In case of bridge accounting it should always be system date or in case of no bridge accounting, the lines should atleast have the same posting date, preferably the first payment day after today.

    KR,

    Martijn

  • Community Member Profile Picture
    Community Member on at

    Did you guys ever figure out an issue to this outside of customization?

    Also, what is the best way to fix this issue for a check that was posted in the future but the check itself was cashed by the vendor and will be reconciled in a different month then the actual posted check date? Would you recommend making a adjusting general journal to move just the balances from future date to current date? Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans