mibuso.com
Home› NAV/Navision Classic Client

Resource Use by Customer report

emulsifiedemulsified Member Posts: 139
edited 2009-03-27 in NAV/Navision Classic Client
I'm trying to create a report that will give me the Totals for all Resources for an individual customer by customer "No." by Date Range.

Which table should I start off with to get what I want?
Half-empy or half-full how do you view your database?

Thanks.

Comments

  • matttraxmatttrax Member Posts: 2,309
    I'd go with Customer and Resource Ledger Entry. DataLink using Customer."No." = ResLedg."Source No." where ResLedg."Source Type" = Customer. Then you can use the posting data of the Resource Ledger for your date range.
    Matt Traxinger - ArcherPoint
    My Blog - nav.education
  • emulsifiedemulsified Member Posts: 139
    I understand that part so far.

    The only output I want is one line for each RESOURCE I've got like this (what I want it to look like):

    Resource No. Name Quantity Total Price
    LIDISC Lights Discount -256 -135,953.16
    BOFISC Bound Freight Discount -125 -4,502.22
    DSC Drop Ship Charge 52 8,901.00

    I tried using a Group Footer but it doesn't work. What do I do, I'm scratching my head because I know the answer is probably rather simple but I'm just not seeing it.

    Thanks much.
    Half-empy or half-full how do you view your database?

    Thanks.
Sign In or Register to comment.