Nav 2009 R2, Jet Essentials
What is the best way for returning the Sales (LCY) value from a Sales Line.
There is a Line Amount, but this is not LCY & is a total of all original Qty for the line, not what is left to ship.
There is an outstanding Amount (LCY) but this includes VAT
I was going to use Outstanding Qty as the multiplier for what is left to ship - is this correct?
What I am trying to report on, is the Sales (LCY) value of each line, that has a qty still left to ship (to allow for part orders) but it has to be (LCY)
I tried to create a formula that converted the Line Amount using the Currency Code from the Sales Header, but this did not work either
I would have thought that this must be a common field, but am struggling.
please advise, thanks Ian
0 comments
Please sign in to leave a comment.