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.


    Kristina O'Donnell
    Manchester NH NH

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

    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

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

    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

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

    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

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