I would like to build a smartlist which will include the following columns for purchase order line items:
Purchase order number, Vendor ID/name, amount, GL distribution(s) (for the ones that have been received).
Could somebody please suggest which tables I need to join to accomplish this?
*This post is locked for comments
I have the same question (0)
Hi,
You will need to consider both the Work tables and the History tables, so you will need to use the UNION or Matched Tables concept. I think you will probably be better served to use views. Start with the PurchaseLineItems view. You also may need the Receipt Line tables POP30310 – Receipt Line History (line detail) and POP10500 – Receipt Line Quantities (line detail).
Kind regards,
Leslie
Share
Report
All responses (
Answers (
65,271
