Having this Challenge in NAV Report

luceoluceo Member Posts: 5
edited 2017-04-01 in NAV Three Tier
The Entry Type field of the Item ledger Entry table is an Option field, which has the following values; Purchase, Sales, Positive Adjmt, Negative Adjmt, Transfer, consumption, and Output. I am creating a report that will show all these option values as the Header of each column. I am finding it difficult to do these, how do I go about this. Assist me with codes and everything. The report should look something like this.

Items Description | Purchase | Sales | Positive Adjmt | Negative Adjmt | Transfer | Consumption | Output |


  • Options
    krikikriki Member, Moderator Posts: 9,096
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    vijay_gvijay_g Member Posts: 884
    what did you try? i don't think any implications to develop this report if you are a technical. can you please be specific where are you having issue would be easy to help you. Thanks!
  • Options
    xStepaxStepa Member Posts: 106
    I think, that he wants to group the Item Ledgers by Item No. (& Location, Years, ...)
  • Options
    DuikmeesterDuikmeester Member Posts: 304
    Sounds like a matrix too me. Use the Entry Type as columns and Item No./Description as rows. Then whatever you want inside the cells.
  • Options
    BeliasBelias Member Posts: 2,998
    if Duikmeester guessed what you want to do, it can easily be done throw table wizard, by setting rows, columns Groups and cells
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.