Purchase order line smartlist

(0) Share

Report

Posted on by Alvaro Rodríguez Ochoa

2,395

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

All responses (1)

Answers (1)

Verified answer

KirkLivermont 5,985 on at

Like (0)

Report

RE: Purchase order line smartlist

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.