OrderHed.TotalShipped and TotalInvoiced

[Adrian_Mepham]

Hi every one, I was attempting to make some changes to our customer credit hold dashboard as we realised that we had some orders which were in a state of shipped but not invoiced and the value of these orders was not showing in the credit used for the customer. So, I thought Orderhed.TotalShipped and OrderHed.TotalInvoiced would be the ideal way to trap these orders, unfortunately not. I could not understand why my BAQ was not working as I had expected, so I ran a little test with the results shown below. Can anyone explain to me what is happening and how to put it right.
Thanks
Adrian.

[ckrusen (Calvin Krusen)]

We’re going to need to see your BAQ.

FWIW - some of the field names are misleading in OrderHed. Some containing the word “total” doesn’t include taxes or misc charges.

If you do use misc charges, it can get real complicated. Especially if you have a misc charge that is applied to each shipment.

[Adrian_Mepham]

Hi Calvin, thanks for your response. Things have moved on slightly and I have added a few calculated fields to give me the values. I am trying to update an existing BAQ which already has two OrederHed tables on it, os I wanted to use the TotalShipped and TotalInvoiced fields from on of the existing tables. I tried adding another OrderHed table but I got thousands of rows back. The top line in the last screenshot is all I’m after. Sounds simple doesn’t it?