Our customer wants an OTBI Inventory report that shows the Supplier, Purchase Order, and Lot
Need inventory report: Supplier, Purchase Order, Qty on Hand, Lot Number, Expiration date
I was able to use Inventory Transactions Real time to add the transaction type of Purchase Order Receipt, and the Transaction Source Reference for the PO number. I added the lot #, quantity on hand, and the expiration date. Works fine.
However I am unable to add the Supplier name. I have tried several of the subject areas - supplier, procurement, payables, but get an error message each time. Any suggestions?
Code Snippet (add any code snippets that support your topic, if applicable):