Open Forum

Blanket PO Release Data (PO Lifecycle)

  • 1.  Blanket PO Release Data (PO Lifecycle)

    TOP CONTRIBUTOR
    Posted 24 days ago
    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
    ------------------------------
    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role