HomeGuides

🧮 ↑ Inventory Transaction (+/- adjustments)

Suggest Edits

What is an Adjustment Inventory Transaction?

Routine changes to inventory, like discovery of a factory shortage or found damaged inventory, etc.. happen from time to time. This inventory transaction upload file contains inventory records that’ve experienced a change in quantity, whether positively (increment) or negatively (decrement), due to an inventory adjustment. For example, a routine cycle count where we discovered that a factory shorted 2 units in a box subsequently results in an adjustment that decrements 2 units From inventory.

When is an inventory transaction posted & uploaded?

An Inventory Transaction is posted after our warehouse operations team physically performs a transaction (like a Cycle Count) resulting in a change in inventory levels. On a regular schedule, our system generates an adjustment transaction file & uploads eligible records to a secure destination. For further details on scheduling & destination location, please request from Ramp IT.

❗️

Client Responsibility

This data flow is not a substitute for client oversight and the client is responsible for managing the adjustment file imports into the client's system. We encourage clients to put duplicate protection controls, and an adjustment process in place before enabling this data flow into the client system. There are several fields to help with duplicate protection, for instance: the adjustment's reference ID, process stamp, internal id, even item, quantity, and direction might be used.

MAPPING FILE SAMPLE ({{processstamp}}.ITXML)

Use the guide below to map Ramp's WMS fields to your ERP via the {{processstamp}}.ITXML file.

🚧

Important notes

  1. inside the , an item may appear one or more times in it's own element.
  2. the value represents the absolute value of the transaction's quantity. A value of "To" indicates the is incrementing while a value of "From" indicates a decrementing value.
  3. for a list of Reference Type values, please ask Ramp IT
  4. The On Hand Qty, In Transit Qty, Allocated Qty, Suspense Qty, and Warehouse values are internal to the WMS & are calculated based on internal processes. As of now, those values are not recommended for ERP mapping.

In the payload example below, the first TransactionHistory records shows the results of a cycle count where item, SUMMERTIME-BLUE-XL, was decremented (From) by 1 quantity. If, in your system you have 10 units on hand, you might decrease your system's inventory by -1, resulting in 9 units on ERP hand. This file is not intended to be used to overwrite inventory in any way.

In the second TransactionHistory record, the adjustment record increments (To) item SUMMERTIME-RED-M by 1 unit. 

<?xml version='1.0' encoding='UTF-8'?>
<WMWROOT>
  <WMWDATA>
    <WMFWUpload>
      <Date>2020-10-09T21:06:01.442Z</Date>
      <NumGroups>3</NumGroups>
      <NumRecs>3</NumRecs>
      <Company>RMP</Company>
      <TransHistories>
        <TransactionHistory>
          <DateTimeStamp>2020-08-13 14:02:23.0</DateTimeStamp>
          <ProcessStamp>Inventory transaction: f96f974a-979e-4172-970f-b17bc40fc152</ProcessStamp>
          <UserStamp>User</UserStamp>
          <ActivityDateTime>2020-08-13 14:02:23.0</ActivityDateTime>
          <AfterAllocQty>0.00000</AfterAllocQty>
          <AfterInTransitQty>0.00000</AfterInTransitQty>
          <AfterOnHandQty>19.00000</AfterOnHandQty>
          <AfterSts>Available</AfterSts>
          <AfterSuspenseQty>0.00000</AfterSuspenseQty>
          <BeforeAllocQty>0.00000</BeforeAllocQty>
          <BeforeInTransitQty>0.00000</BeforeInTransitQty>
          <BeforeSts>Available</BeforeSts>
          <BeforeOnHandQty>20.00000</BeforeOnHandQty>
          <BeforeSuspenseQty>0.00000</BeforeSuspenseQty>
          <Company>RMP</Company>
          <ContainerID>WHB8219470</ContainerID>
          <Direction>From</Direction>
          <InternalID>57926226</InternalID>
          <Item>SUMMERTIME-BLUE-XL</Item>
          <Location>AF-60-D-01</Location>
          <Lot>N</Lot>
          <Quantity>1.00000</Quantity>
          <QuantityUM>EA</QuantityUM>
          <ReferenceID>319485a84d284a4fbc22be64a</ReferenceID>
          <ReferenceLineNum>0.00000</ReferenceLineNum>
          <ReferenceType>Cycle Count</ReferenceType>
          <ToCompany>RMP</ToCompany>
          <TransactionType>40</TransactionType>
          <TransactionTypeDescription>Inventory adjustment</TransactionTypeDescription>
          <UserName>User</UserName>
          <Warehouse>IRV</Warehouse>
          <WorkZone>W-Primary</WorkZone>
        </TransactionHistory>
        <TransactionHistory>
          <DateTimeStamp>2020-08-13 17:03:09.0</DateTimeStamp>
          <ProcessStamp>Inventory transaction: f96f974a-979e-4172-970f-b17bc40fc152</ProcessStamp>
          <UserStamp>User</UserStamp>
          <ActivityDateTime>2020-08-13 17:03:09.0</ActivityDateTime>
          <AfterAllocQty>0.00000</AfterAllocQty>
          <AfterInTransitQty>0.00000</AfterInTransitQty>
          <AfterOnHandQty>1.00000</AfterOnHandQty>
          <AfterSts>Available</AfterSts>
          <AfterSuspenseQty>0.00000</AfterSuspenseQty>
          <BeforeAllocQty>0.00000</BeforeAllocQty>
          <BeforeInTransitQty>0.00000</BeforeInTransitQty>
          <BeforeOnHandQty>0.00000</BeforeOnHandQty>
          <BeforeSuspenseQty>0.00000</BeforeSuspenseQty>
          <Company>RMP</Company>
          <ContainerID>WHB4498842</ContainerID>
          <Direction>To</Direction>
          <InternalID>57951893</InternalID>
          <Item>SUMMERTIME-RED-M</Item>
          <Location>AE-60-C-01</Location>
          <Lot>N</Lot>
          <Quantity>1.00000</Quantity>
          <QuantityUM>EA</QuantityUM>
          <ReferenceID>a87c51450b994391a6570a0d3</ReferenceID>
          <ReferenceLineNum>0.00000</ReferenceLineNum>
          <ReferenceType>Found Inventory</ReferenceType>
          <ToCompany>RMP</ToCompany>
          <ToWarehouse>IRV</ToWarehouse>
          <TransactionType>40</TransactionType>
          <TransactionTypeDescription>Inventory adjustment</TransactionTypeDescription>
          <UserName>User</UserName>
          <Warehouse>IRV</Warehouse>
          <WorkZone>W-Primary</WorkZone>
        </TransactionHistory>
        <TransactionHistory>
          <DateTimeStamp>2020-08-13 17:03:42.0</DateTimeStamp>
          <ProcessStamp>Inventory transaction: f96f974a-979e-4172-970f-b17bc40fc152</ProcessStamp>
          <UserStamp>User</UserStamp>
          <ActivityDateTime>2020-08-13 17:03:42.0</ActivityDateTime>
          <AfterAllocQty>0.00000</AfterAllocQty>
          <AfterInTransitQty>0.00000</AfterInTransitQty>
          <AfterOnHandQty>2.00000</AfterOnHandQty>
          <AfterSts>Available</AfterSts>
          <AfterSuspenseQty>0.00000</AfterSuspenseQty>
          <BeforeAllocQty>0.00000</BeforeAllocQty>
          <BeforeInTransitQty>0.00000</BeforeInTransitQty>
          <BeforeOnHandQty>0.00000</BeforeOnHandQty>
          <BeforeSuspenseQty>0.00000</BeforeSuspenseQty>
          <Company>RMP</Company>
          <ContainerID>WHB4498842</ContainerID>
          <Direction>To</Direction>
          <InternalID>57951924</InternalID>
          <Item>SUMMERTIME-GREEN-S</Item>
          <Location>AE-60-C-01</Location>
          <Lot>N</Lot>
          <Quantity>2.00000</Quantity>
          <QuantityUM>EA</QuantityUM>
          <ReferenceID>eb0918d35fa043afb955b82cc</ReferenceID>
          <ReferenceLineNum>0.00000</ReferenceLineNum>
          <ReferenceType>Found Inventory</ReferenceType>
          <ToCompany>RMP</ToCompany>
          <ToWarehouse>IRV</ToWarehouse>
          <TransactionType>40</TransactionType>
          <TransactionTypeDescription>Inventory adjustment</TransactionTypeDescription>
          <UserName>User</UserName>
          <Warehouse>IRV</Warehouse>
          <WorkZone>W-Primary</WorkZone>
        </TransactionHistory>
      </TransHistories>
    </WMFWUpload>
  </WMWDATA>
</WMWROOT>

Updated over 3 years ago