Hi All
We're new to 365 BC (v13 on Prem) and go live scheduled for Feb
I have to write blanket PO release report
So basically it's the selected Blanket Po and all related PO's, etc.
Ordinary I could just join from a related PO to the blanket based on the Blanket No and Line No, but in BC the PO's "disappear" once received and invoiced
I see the Blanket PO field in the following tables, so I'd need to get related qty on a release Po whether the Po is open, received invoiced
| Purch_ Cr_ Memo Line |
| Purch_ Cr_ Memo Line |
| Purch_ Inv_ Line |
| Purch_ Inv_ Line |
| Purch_ Rcpt_ Line |
| Purch_ Rcpt_ Line |
| Purchase Line |
| Purchase Line |
| Purchase Line Archive |
| Purchase Line Archive |
So if we assume Blanket PO 123 Line 10000 has Qty of 100
10 are on an open PO
20 have been received
30 have been invoiced
So my Blanket report should (minimally) say that 60 have been released from the blanket
Anyone know where I would get this from, or just the lifecycle of PO data would be useful (from open, to released, to received, to invoiced)
TIA
Mark
------------------------------
Mark Anderson
Director of ERP Systems
Clesen Wholesale
Evanston, IL
------------------------------