Open Forum

Expand all | Collapse all

Sales Order with allocated parts and component drop off when it is transferred to an invoice WO 32610 and 31207

  • 1.  Sales Order with allocated parts and component drop off when it is transferred to an invoice WO 32610 and 31207

    Posted Apr 15, 2019 08:20 PM
    We are having issues where ​​parts or main units that were allocated to the sales order would drop off when it is transferred to an invoice. Our sales order is coming through from another application/portal before it hits GP. It may be an integration issue but I need to pinpoint and investigate how this is occurring before I can connect with the developers. When a sales order have items allocated to it where can I find this in GP tables when I query the database? I'd like to see all of the line items that were allocated to the order. Does anyone know if they have experience this before and how it could have occurred?

    ------------------------------
    Helena Ky
    BSA
    Insight Investments LLC
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Sales Order with allocated parts and component drop off when it is transferred to an invoice WO 32610 and 31207

    GPUG ALL STAR
    Posted Apr 16, 2019 10:03 AM
    Hi @Helena Ky,
    the fact that your SOP processing occurs from an external application might be already a sign that somethings isn't working as it should.. You can check the item allocation from the table IV00102 where all the inventory is tracked for each item, by location.
    The field to look for is called ATYALLOC as it was probably mis-spelled when it was created, not starting with a Q like any other QTY fields (​QTYINUSE QTYINSVC QTYRTRND QTYDMGED QTYONHND, etc..)..
    Running an inventory reconcile on a specific item will correct the IV00102 based on all the current POP & SOP documents.
    Hope this helps.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    GPUG Summit - Post


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