Report

aman_mbs
aman_mbs Member Posts: 158
edited 2007-03-21 in NAV/Navision Classic Client
Dear All,

Please provide me the sol for the particular scenario……

Scenario based on (coronus)

In item table I have mentioned two product group code and based on sales invoice line I need particular report:


Item Table,
No.
Product Group Code
1984-W Tube
1988-W Tube
1992-W Tube

Sales Invoice Line,
Doc No.
Sell-To Customer No. Qty Item No.
Product Group Code
103013 01445544 1 1988-W Tube
103017 35451236 1 1992-W Tube
103022 01454545 13 1988-W Tube
103022 01454545 2 1984-W Tube

Required Report,

<Group Code>Tube

Sell-To. Customer No. Qty
01445544 1
35451236 1
01454545 15
Aman Kumar Gupta

Comments

  • vikram7_dabas
    vikram7_dabas Member Posts: 611
    firstly make 2 dataitems
    Item
    Sales Line

    In the dataitemtableview of item table which is in properties use key as no. And in table filter Click the field Posting group code field ,filter and turbo(whatever u wants to filter).the two dataitems should be linked with the no. field of sales line and field "item no." of item table.The sorting should be done in the dataitemtableviews of both the dataitems.ok :whistle:
    Vikram Dabas
    Navision Technical Consultant
  • aman_mbs
    aman_mbs Member Posts: 158
    Dear ,

    Thnks For Help, How Do we know which Product Group Code User will Select & And in table filter there r only two option Const & Filter which Require Static Value..
    Aman Kumar Gupta

Categories