Open Forum

Expand all | Collapse all

Unit cost integration

  • 1.  Unit cost integration

    Posted 26 days ago
    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 25 days ago
    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