Microsoft Dynamics AX (Archived)

Settlement Posting Data type

(0) Share

Report

Posted on by Ding Li

480

Hi All,

I have question about Vendor --- Settle Open transactions (Microsoft AX 2012 R3)

what difference for these three option:

Today's date / Latest Date / Selected Date

How these three option impact financial transaction?

Thanks in advance.

Snipaste_5F00_2018_2D00_11_2D00_08_5F00_16_2D00_20_2D00_24.png

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Those dates can make a difference if you use for example cash discounts.

Depending on the settlement date selected the cash discount might be posted or not.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ding Li 480 on at

Like (0)

Report
Copy link

Link copied!

Dear Ludiwig,

Thanks so much for your answer.

Let me refine my question:

1. when I choose 'Latest date', which date would be here? (let's say if I do settlement today)

2. please take a look into following 2 pictures:

a. when I choose latest date. it shows there is 0.01 transaction

b. when I choose 'today', there is just reverse

what the '0.01' transaction is?

Thanks in advance.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you check and share the transaction and posting type in the general tab of the line with the $0.01 amount?

Best regards

Ludwig

Was this reply helpful? Yes No
Ding Li 480 on at

Like (0)

Report
Copy link

Link copied!

General Tab for 0.01 transaction:

Posting Profile: GEN

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you settle a foreign currency invoice with a payment in this case?

The transaction type indicates that there must be some foreign currency involved.

Assuming that this is the case, can you check the foreign currency rate change between the time the invoice was recorded and the time the settlement was made?

This should explain the difference.

Best regards

Ludwig

Was this reply helpful? Yes No
Verified answer

guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

It can also affect exchange rate revaluation as mentioned. Best to read the help notes on this: docs.microsoft.com/.../settle-open-transactions-vendor-form

To post the actual invoice date from the invoice document the vendor supplied, enter it when posting the invoices in AX so that you can track and age the document. If this is the requirement then check the look at the accounts payable parameter 'require document date on vendor invoice'. This can be set at" none, warning, or error. If set at none then an Ax check isn’t done. If set at error then the document will not post until the date is enterered.

Was this reply helpful? Yes No
Suggested answer

Ding Li 480 on at

Like (0)

Report
Copy link

Link copied!

Dear Magic,

thanks for your information. I will look into it.

I really appreciate.

Was this reply helpful? Yes No
Ding Li 480 on at

Like (0)

Report
Copy link

Link copied!

Dear Ludwig,

Yes, you are right!!.

Thanks so much.

Was this reply helpful? Yes No