Reporting on Ship-To Address for items purchased by a Customer

Business Central/NAV User Forum
1

Hi All,

Im trying to report on a customer that has a several Ship-To addresses to provide a list of items that was purchased by each Ship-To Address

Example:-

Customer A has Ship-To Addresses of Sydney and Melbourne. Each of the Ship-To addresses have purchased different items.

I was trying to get this report by running the “Customer/Item Sales” Report 113, but It just displayed all item purchases for Customer A and there was no filter to say report only on items that was Ship-To Sydney Only.

Can someone please help me with this?

Cheers.

2

In Customer Dataitem ReqFilterFields property add “Ship-to Filter”

Or

After running report, below Customer Posting Group, you can add “Ship-to Filter”

3

i have tried this but it returns the same results.

I was hoping that this would also filter the results but it doesnt seem to.

4

the report is using value Entry table but we dont have Ship to Code Field in Value Entry Code.

In order to meet your requirements you need to create a new field in Value Entry table and flow the value.

For the future transactions only it will work…

Or Better to create a new report same as 113 but use Table 110 Sales Shipment Header in place of Customer and filter on Ship to Code [Y]