Hello,
I am trying to pull together a report and could use a bit of assistance. I'm having issues getting the correct "key" formula. I need to pull by item and am sure the Invoiced Quantity and Actual cost amount is coming from the Item ledger entry table. I also, need the Gross Sales Price by item which I believe is coming from the sales line table. Can someone assist in showing me the correct NL formula to create the key record for this?
Thank you!
Report Filter is based on posting date only at this time for NL function.
(Report Columns)
Item No. Item description Invoiced Quantity Gross Sales Price Cost Amount Actual
Date
Votes
2 comments
-
Jet Reports Historic Posts Actually the Invoiced Quantity could be coming from the Value Entry Table not Item ledger entry.
-
Jet Reports Historic Posts Invoiced Quantity & Actual Cost coming from the Value Entry Table. Thanks.
Please sign in to leave a comment.