Open Forum

Expand all | Collapse all

Unit cost integration

  • 1.  Unit cost integration

    Posted Jan 22, 2019 12:17 PM
    We are doing an integration to account for transfers between distributors.  Items are returned to a special site and then invoiced from that site to different territories. We want to integrate the unit cost.  The return went successfully with a unit cost. The invoicing integration did not.  Is it possible to override the unit cost through the integration for invoicing?

    Diane Cooper
    Sr. Accounting Specialist
    Lawrence KS

  • 2.  RE: Unit cost integration

    Posted Jan 23, 2019 11:57 AM
    For an IV Item Type Sales Inventory you can only integrate or enter the unit cost for an increase transaction. For a decrease transaction the cost will be determined when the transaction posts based on the Item Valuation Method: LIFO, FIFO, WTAVG Perp etc.
    If you adjust or return an item into a site, the unit cost it comes it at updates the WTAVG Perp and is an entry to the LIFO/FIFO layers table. If you want to make sure that the exact unit cost of that specific Item follows it when it is sold/invoiced then the Item must be serial tracked.

    Thaddeus Suter
    Retus, Inc

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