Options

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 |
football

Answers

  • 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, ...)
    Regards
    xStepa
  • 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
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.