Hi,
I would like to create a table form Item ledger entry that contains the following fields :
Posting date, Item No, Entry Type, Document type, Location, Quantity
the quantity i need is : sum of quantity with Posting date, Item No, Entry Type, Document type, Location as filters.
with NL rows it worked perfectly , you find attached what i did.
but i need the sames result in a table, so that i can create a Pivot tables and charts ?
any suggestions,
Regards ;
Date
Votes
1 comment
-
Jet Reports Historic Posts In your report, you have multiple rows on the same row so I wasn't sure what you were trying to do but could you do something like:
=NL("table","item ledger entry",{"Posting Date","Item No.","Entry Type","Document Type","Location","Quantity"})to create a table from your item ledger entry table and output those fields only.
You could always add filters as needed but that would be the basic structure to create an Excel table space in using Jet.
Please sign in to leave a comment.