By using this website, you agree to our Terms of Use (click here)
Hi All,
Newbie question here.
I'm trying to create a line-item report that displays the inventory ID, quantity, Description, etc of every single line item in our invoices. However, I'm struggling to create the table relationships in order to be able to have these fields available in the results grid.
Any ideas/resources that could help?
TIA
Is this for AP Invoice?
@rybanez na this would be for the invoices issued by our company, so AR invoices or sales order invoices.
@gzica For AR Invoices:
Header Table: ARInvoce primary key: refnbr
Detail Table: ARTran foreign key: refnbr
For Sales Order
Header Table: SOOrder primary key: OrderNbr
Detail Table: SOLine foreign key: OrderNbr
Pretty sure you can create the generic inquiry using above.