
Hi, i'm beign asked to create a smartlist, with each line of the open PO with line number, also if there's a partial receipt to show this partial receipt on the line, something like:
PONumber - VendorID - POQty - POReceived - QtyInvoiced - POLineNumber.
I know how to make each individual SmartList but i'm not sure if it is possible to combine them in one, what would happend if a PO line doesn't have a partial receipt? has any one tried something like this?
Regards.
*This post is locked for comments
I have the same question (0)Use a left outer join when adding your tables and you should have no problem with items showing up whether there is a partially received quantity or not.