Open Forum

Expand all | Collapse all

Item Card - qty on purch. order not populating

  • 1.  Item Card - qty on purch. order not populating

    Posted May 14, 2019 09:15 AM
    Edited by Kristina O'Donnell May 14, 2019 09:25 AM
    Hello -

    I'm writing to see if anyone can help me with an issue we have when viewing and item card. The qty on purchase order does not populate.  For item A I know there is a PO however the quantity shows 0.  When I double click on it it it brings be to the PO and I can see that there is 2000 eaches.

    Any suggestions on why it isn't populating the total on the item card view?

    I also want to that this item A PO is a PO that is created from the subcontracting worksheet from a released production order.  If we create a PO for a material not created from this subcontracting worksheet the quantity populates fine.

    Thanks,
    Kris

    ------------------------------
    Kristina O'Donnell
    FoodState
    Manchester NH NH
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Item Card - qty on purch. order not populating

    TOP CONTRIBUTOR
    Posted May 14, 2019 10:58 AM
    If the quantity is on a Blanket Purchase Order it will not be included in Qty. on Purch. Order. This would be the first thing I would check. If this is not the issue, check the filters on the list that opens when you drill down to the Purchase Line List. You may have a customization to the filters. This may help you find it.

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Item Card - qty on purch. order not populating

    TOP CONTRIBUTOR
    Posted May 14, 2019 11:34 AM
    Here is the formula:

    Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),Type=CONST(Item),No.=FIELD(No.),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Expected Receipt Date=FIELD(Date Filter)))

    So if the quantity has already been received (is no longer outstanding) you would see a 0. Also make sure you don't have any FlowFilters applied. They would "slice" the data. So if you had a Location Filter of BLUE assigned it would only include the quantity if the Location Code on the Purchase Line was BLUE.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Item Card - qty on purch. order not populating

    TOP CONTRIBUTOR
    Posted May 15, 2019 07:57 AM
    A subcontract PO is not a purchase of product, it is a purchase of service. A subcontract PO comes from a route step. The route is the processes done to the items on the bill of material. Therefore, you are not buying Item A, you are buying a service to produce Item A. The production output will produce Item A.



    Sent from my Verizon, Samsung Galaxy smartphone



    Academy - Online Interactive Learning from Experts


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