Has anyone ever been successful at summing sales by ship-to address?
If so, how about sales by ship-to by item #?
Thx
1 comment
-
Jet Reports Historic Posts Hi Janice,
There are a couple of things to be aware of when you wish to build such a report:
- NAV does not store the Ship-to Code in the Ledger entry tables;
- Posted documents may be deleted once they're printed.
So, there's not really a reliable way to retrieve sales information by ship-to codes. Of course you could do some customization of NAV, but my suggestion would be to:
- set up Dimension for Ship-to codes;
- set up a Sales Analysis View in the Sales & Marketing menu.
This is available for both NAV 4 and NAV 5.
You could then use the Analysis by Dimension in Sales & Marketing in NAV, or create a Jet Reports report on the Analysis view entries.