Item Sales by State

emulsified

I haven't written a Navision 4.0 Native Report in quite a while and I have to create a new report that can give me the quantity of items sold for a given item or items within a posting date range.

I believe the report should have tables:
Customer
Value Entry

There should be. Data Link of Customer."No." and "Value Entry"."Source No." I believe.

I need to see the Invoiced Quantities as a Sum for each State I filter by.

Can anyone give my brain a bump?

binilabraham

Just go through this link;
https://msdn.microsoft.com/en-us/library/dd355280.aspx
This will give you some basic idea of grouping. Thena implement the same in your report

binilabraham

Just go through this link;
https://msdn.microsoft.com/en-us/library/dd355280.aspx
This will give you some basic idea of grouping. Thena implement the same in your report

emulsified

I tried a couple of ways, I thought I had it but it isn't working the way I want it. I'm not sure which tables I should be using for the Total Quantity of an Item Sold.

I'm trying to have my report function like this:

1. User enters a State or States under the Customer tab. (Example: PA|AZ)
2. User enters an Item No. under either a Sales Invoice Line, Item Ledger Entry, or Value Entry tab (not sure which to use). (Example: AB1X2Z&AB9Q74)
3. User enters a Posting Date range. (Example: 01/01/16..12/01/16)
5. User runs report.

Generated report should look similar to this output:

State(s)
PA
    Item           Quantity Sold
       AB1X2Z             54
       AB9Q74             14

AZ
    Item           Quantity Sold
       AB1X2Z             21
       AB9Q74              8

What is the best way to go about this?

emulsified

The Customer/Item Statistics report was close enough. I ended up making a copy of it and modifying the formatting just a bit. Thank you.