Item Sales by State

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?
Half-empy or half-full how do you view your database?

Thanks.

Best Answer

Answers

  • binilabrahambinilabraham Member Posts: 45
    Answer ✓
    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
    Software Developer,
    Archerpoint India Pvt. Ltd,Chennai.
  • emulsifiedemulsified Member Posts: 139
    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)
    4. 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?
    Half-empy or half-full how do you view your database?

    Thanks.
  • emulsifiedemulsified Member Posts: 139
    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.
    Half-empy or half-full how do you view your database?

    Thanks.
Sign In or Register to comment.