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
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:
Has anyone managed to join the ARTran, SOOrder and SOLine tables without causing duplicates?
I used group by and I think it is working now. Thank you anyway.
Hi
Please find the screenshots
Hi
Please find the screenshots
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 below GI sample. You can add conditions and result grids based on your requirement.
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
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'
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.