Open Forum

Expand all | Collapse all

Inventory Costs Adjustments

  • 1.  Inventory Costs Adjustments

    Posted 12 days ago
    I recently had to go into the adjust costs section in GP to adjust the costs of a few items. Is there a way to pull a report that shows all the items that were adjusted ad the amount??

    ------------------------------
    Taryn Lee
    Inventory Manager
    Mid KansasCooperative
    Moundridge KS
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Inventory Costs Adjustments

    TOP CONTRIBUTOR
    Posted 12 days ago
    You can use the below SQL to query the data directly, or you can create a SmartList using the Inventory Purchase Receipts Work GP table, and search for records that have a difference between Unit Cost and Adjusted Unit Cost.

    select * from dbo.IV10200 WHERE ITEMNMBR='YOURITEMNUMBER' AND UNITCOST<>ADJUNITCOST​


    ------------------------------
    Matthew Arp
    Business Systems Developer
    Hunton Group
    Houston TX
    ------------------------------

    Conference-GPUG_200x200


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