How to compare an orders open value to deposit value


(system) #1
Hi All,



I'm trying to create a report that compares an orders open deposit
value, OrderHed.DepositBal, to an orders current open amount.

I originally just compared it to OrderHed.OrderAmt but that is flawed
because if an order partially ships, the DepositBal goes down but
OrderAmt does not.

There is no "OrderAmtBal" field so I'm trying to figure out how to
calculate an orders open balance.



Summing the ExtPriceDtl of open lines is easy, but how do you handle
freight charges?



Any ideas on how to achieve what I'm trying to do?








Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]