I'd like to create report which shows all Posted Purchase Receipt in NAV based on Posted Purchase Invoice Number.
Could you please advise which options/functions I should used. I'm quite new in Jet.
I used 3 NAV tables:
-Purch. Inv. Line
-Value Entry
-Item Ledger Entry
From Purch. Inv. Line I took Document No field -> go to Value Entry (linked via Document No) ->then go into Item Ledger Entry and check receipts Document No (linked via Item Ledger Entry No field to Value Entry table).
The result I got is quite OK (needs some changes to avoid data redundancy) but for sure are better formulas to do that.
0 comments
Please sign in to leave a comment.