Skip to Content
0
Former Member
May 27, 2011 at 08:49 AM

Help with Query

32 Views

Hi there,

I am trying to write a query which lists all open Sales Orders where the only open element is Freight.

We have an issue where some Orders have been delivered and invoiced, but the Freight element was not completely delivered and invoiced.

I have looked at the INV3 table, but it does not seem to hold the o/s open Freight value. How would I achieve this?

Thanks

Claudio