5
We got the error: 'There is no data available' because the user changed the customer address during picking by the warehouse.

The issue has been reported here: "Issue KB 288520 Container Content report error when modifying customer address". V10.0.3

My idea is to retrieve the address as it was on that day of the shipment and before somebody changed it? Just paste the 'DestinationPostalAddress' to the address retrieval or am I missing something here? Thinking further if you want to clean up/ archive addresses. What address is then on the shipments/ and loads

This will avoid that in the future somebody wants to print the container list...and the same issue re-appears.

Issue 288520Container Content report error when modifying customer address
Product and version: Finance and Operations
Release: 10.0.3
RESOLUTION
By design
PROBLEM
After changing the details of the customer address, the Container Content report is not working anymore.
Error message: No Data available on report.
REMARKS
The actual result is a consequence of a design constraint when implementing data validity for addresses, including logistical addresses.

The current design is such that WHSShipmentTable.DeliveryPostalAddress is added when the SO has been released to warehouse. Once the customer address is updated on the customer record, this update does not cascade update to active source documents such as sales orders as an example. The address originally applied as the WHSShipmentTable.DeliveryPostalAddress will as a consequence of this not be updated, similar to any sales order address, as the delivery address has expired - is no longer active.

When such a situation occurs, then do the following:

In the container contents Reports form select one container and click on Print containers contents. In the print dialogue, click on Filter under Records to Include. On the query WHSContainerContents form, Click on tab Date Options. Click the radio button Show Records Active As Of. Select a date in the past from before the address expired.

This will print the Container Contents Report with the address originally applied for the Shipment.

No hotfix will be released changing the current behaviour.

STATUS DETAILS
Needs Votes