Hello,
Im trying to build GI with ARInvoice being linked to SalesOrder. I tried to use InvoiceNbr in both but no luck. How can I do it?
Best answer by jinin
View originalHello,
Im trying to build GI with ARInvoice being linked to SalesOrder. I tried to use InvoiceNbr in both but no luck. How can I do it?
Best answer by jinin
View originalHi
If yes, below is the query to link the Sales Order to Invoice. You can use the same joins in the GI to fetch the details. Let me know if you need any help on the GI.
select * from SOOrder S inner join SOOrderShipment SS on S.CompanyID=SS.CompanyID and S.OrderType=SS.OrderType and S.OrderNbr=SS.OrderNbr
Inner Join ARTran AR on AR.CompanyID=S.CompanyID and AR.SOShipmentType = SS.ShipmentType and AR.SOShipmentNbr = SS.ShipmentNbr
Where S.CompanyID=2 and S.OrderNbr='SO006683'
Thanks for reply but I need a bit different stuff. Im tracking Invoice updates and need to filter invoices by sales order properties. So I need to build relations between AR.ARInvoice and SO.SOOrder tables.
Hi
Please find the below GI sample. You can add conditions and result grids based on your requirement.
Hi
Please find the below GI sample. You can add conditions and result grids based on your requirement.
Thanks @jinin,
The problem I do not have permissions to import GI if possible could you please create screenshot with relations tab?
Hi
Please find the screenshots
Hi
Please find the screenshots
I used group by and I think it is working now. Thank you anyway.
Has anyone managed to join the ARTran, SOOrder and SOLine tables without causing duplicates?
Hi
We could join the ARTran, SOOrder and SOLine without causing duplicates with the below limitations.
Limitation: The Sales Order has one Shipment and One Invoice.
Screenshots for reference:
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.