0

Need help to calculate amount

I need to incorporate the 'Unit Price incl. Line Discount' from Sales Line table to this formula to calculate the amount but I can't make it work.
Any help?

=IF(NF($B7,"Replenishment System")="Purchase",NL("Sum","Sales Line","=(NF(,""Outstanding Quantity"")-NF(,""Reserved Quantity""))","No.","@@"&$E7,"Document Type","Order","Requested Delivery Date",BeforeReportDateRange,"Outstanding Quantity","<>0","Cancelled","False"),(NL("Sum","Sales Line","Outstanding Quantity","No.","@@"&$E7,"Document Type","Order","Requested Delivery Date",BeforeReportDateRange,"Outstanding Quantity","<>0","Cancelled","False")+NL("Sum","Reservation Entry","Quantity","Item No.","@@"&$E7,"Source Type","37","Source Subtype","1","Reservation Status","Reservation","Positive","False","Source ID",NL("Filter","Sales Line","Document No.","Document Type","Order","No.","@@"&$E7, "Requested Delivery Date",BeforeReportDateRange,"Outstanding Quantity","<>0","Cancelled","False"),"Entry No.",NP("Union",NL("Filter","Reservation Entry","Entry No.","Item No.","@@"&$E7,"Source Type","5406","Source Subtype","3","Reservation Status","Reservation","Positive","True"),NL("Filter","Reservation Entry","Entry No.","Item No.","@@"&$E7,"Source Type","32","Source Subtype","0","Reservation Status","Reservation","Positive","True")))))

0 comments

Please sign in to leave a comment.