AX 4.0 - Delivery date in reports not updating

(0) Share

Report

Posted on by Community Member

Greetings!

Within my company we have a report that is used to show all open purchase orders(PO). This report is called the "Open PO report". As far as I can tell this is a custom report and it has some minor coding in it (written by our MS partner). An example is the code below:

display dlvdate AVA_PurchDeliveryDate() 
{;
    return PurchTable_1.DeliveryDate;
}

Now for my question. When a PO is made the delivery date is put into the order. It's quite common for the delivery date to be changed afterwards however, this is not reflected in the report. The report will still show the original delivery date.

What could be causing this? I know some fields don't update until you've executed a certain step within AX; is this the case for this field as well?

Thank you for any/all help you may be able to provide.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

jasman 1,413 on at

Like (0)

Report

Have you examined if the business process of changing delivery date and the related system functionality actually changes the field PurchTable.DeliveryDate or it is some other field that is changed ?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

I will suggest please check your delivery date field mapping logic. Is it direct purchtable deliverydate field mapped to report display column. If field is under purchtable and once browse to AOT, can you see the updated value. if yes, it should display in report. Please refresh your data and check.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thank you both for your suggestions. I've got a date with someone from the purchase department this afternoon so I'll dig into how they work with the delivery date fields.

I did notice there's also a delivery date field in the purchase lines. As of now I'm thinking the problem is caused by changing this field instead of the actual PurchTable.DeliveryDate but I'll see for sure this afternoon.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

The report references a different delivery date field from the one that is actually changed by the purchase department. Thank you both for your suggestions!

Was this reply helpful? Yes No