[CRONUS USA, Inc_$Sales Invoice Line].[Document No_], [CRONUS USA, Inc_$Sales Shipment Line].No_
,[CRONUS USA, Inc_$Sales Shipment Line].Quantity,[CRONUS USA, Inc_$Item Ledger Entry].[Entry No_],[CRONUS USA, Inc_$Value Entry].[Entry No_]
,[CRONUS USA, Inc_$Sales Invoice Line].[Line Amount]
from [CRONUS USA, Inc_$Sales Header]
join [CRONUS USA, Inc_$Sales Shipment Header]
on [CRONUS USA, Inc_$Sales Shipment Header].[Order No_] = [CRONUS USA, Inc_$Sales Header].No_
join [CRONUS USA, Inc_$Sales Shipment Line]
on [CRONUS USA, Inc_$Sales Shipment Header].No_ = [CRONUS USA, Inc_$Sales Shipment Line].[Document No_]
join [CRONUS USA, Inc_$Item Ledger Entry]
on [CRONUS USA, Inc_$Item Ledger Entry].[Document No_] = [CRONUS USA, Inc_$Sales Shipment Line].[Document No_]
and [CRONUS USA, Inc_$Item Ledger Entry].[Document Line No_] = [CRONUS USA, Inc_$Sales Shipment Line].[Line No_]
join [CRONUS USA, Inc_$Value Entry]
on [CRONUS USA, Inc_$Value Entry].[Item Ledger Entry No_] = [CRONUS USA, Inc_$Item Ledger Entry].[Entry No_]
left join [CRONUS USA, Inc_$Sales Invoice Line]
on [CRONUS USA, Inc_$Sales Invoice Line].[Document No_] = [CRONUS USA, Inc_$Value Entry].[Document No_]
and [CRONUS USA, Inc_$Sales Invoice Line].[Line No_] = [CRONUS USA, Inc_$Value Entry].[Document Line No_]
where [CRONUS USA, Inc_$Sales Header].No_ = '6001'
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.