Microsoft Dynamics AX (Archived)

Sales Order Due Date automatically filled when user choose Payment Terms

(0) Share

Report

Posted on by benjamin84

2,075

Dear All,

I want to ask about payment terms and due date in sales order.

In the terms of payment Form, i have payment terms for example 50DP,50%After30Days, i also had set the days 30.

i have choosed the payment terms in Sales Order Header, I want to the due date automatically filled November, 22nd 2017.

how to make its automatically filled ?

do in AX 2012, its doable ? or I miss some setting ?

need your advice,

Thank you

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Yes, Due date calculated based on a term of payment in sales order header.

also, you can use payment schedule

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Hi Mahmoud,

in the form terms of payment I had set the day = 30

but when I create sales order, the due date not automatically filled by system.

my question is how to automatically the due date fill by system ?

really appreaciate your help.

Thanks

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

based on reference from : technet.microsoft.com/.../jj677442.aspx

The due date is calculated based on the invoice date and the terms of payment that are specified for a purchase order or sales order.

so its mean, the due date blank at first when I created SO, later when I create invoice, the due date filled automatically by AX ?

I want to make sure the concept.

Thanks

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

due date calculated with action invoice, not order.

so if you need to update it in sales order you can customize it

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Yes Mahmoud,

in AR, Setup, Payment, Terms of Payment, its already set 30 for field days

all my sales order already invoiced, I checked in due date sales order is blank.

is there any other setting I miss ?

thank you

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

hi benjamin84

I think you are missing the correct place for search

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Mahmoud,

thank you for you nice information.

But my user want to see the due date in the sales order header.
she want to see the due date = invoiced date + 30 days.

i got another reference like this :
technet.microsoft.com/.../dn751509.aspx

but i cant find General ledger > Setup > Set up calculation for invoice issue due date.

Thanks

Was this reply helpful? Yes No
Verified answer

Founar 25 on at

Like (0)

Report

For that you have to associate your terms of payment with a payment schedule (https://technet.microsoft.com/en-us/library/aa572068.aspx).

if you are using 30 days, the allocation as total should do the trick. Link this payment schedule to your current terms of payment and the sales order will make the payment schedule button active (https://technet.microsoft.com/en-us/library/aa548920.aspx)

there your user will be able to not only check the expected due date, but also recalculate it / modify them as well, prior to the posting stage

Let me know if that helped.

thanks

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (1)

Report

Thank you Fernando.

appreciate.

Was this reply helpful? Yes No