Standard Inventory Transactions Format
  • 13 Sep 2021
  • 1 Minute to read
  • Contributors
  • Dark
    Light

Standard Inventory Transactions Format

  • Dark
    Light

Article summary

A comma-separated text file will be created containing inventory transaction details and events for inventory being handled by Landmark. This file will be placed on Landmark’s FTP server in the "Fulfillment" folder. Login credentials will be provided by Landmark Global.

The Inventory Transaction Format will contain manual adjustment event types logged by operations with descriptions related to the manual adjustment being made for SKUs. Lot information and expiration date will be included if relevant information exists for the adjustment at the time the file is generated.

This file is generated daily.


Header information included in this file:

  • SKU
  • Facility
  • Time
  • Location Type
  • Event (manual adjustment)
  • Description
  • Before Value
  • After Value
  • Lot Number
  • Lot Before Value
  • Lot After Value
  • Expiration Date


Values that can be passed for the Location Type header:

  • Forward - Can be used to allocate and fulfill orders
  • Reserve - Inventory that is "on hand" but not available for fulfillment
  • Quarantine - Inventory awaiting testing or expired
  • Refurbishment - Refurbished return may be entered here
  • Transit - Inventory moving between locations


Values that can be passed for the Description header:

  • Inventory Received (Only manual adjustment inventory received will be displayed in this file.)
  • Cycle Count
  • Damaged
  • Shipped Outside System
  • Facility Usage
  • Recalled
  • Inventory Transfer
  • ** Custom Reason ** (Operations has the ability to enter a custom manual adjustment reason. This reason would display in the description field as logged.)


Please see attached example of Inventory Transactions File

Attachments

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.