Search

saveBinRecords

Create a set of bin records. This is the recommended way to place items into bins (which have arrived with a Purchase Invoice or Inventory Registration) or remove sold items.

After saving and processing each record, API will also update the cumulative quantity of that product in that bin.

This call can also be used for editing existing records. In that case, API will also adjust the summarized quantity of that bin accordingly.

You can send multiple records with one API call; append numbers 1, 2, 3, … to the parameter names to identify values for record 1, record 2, etc. Fore example, binID1, productID1, amount1 for the first record, binID2, productID2, amount2 for the second one and so on.

There is no hard limit to how many records you can send with one call, but it is recommended to keep it below 500. Also, more records take a longer time to process, so make sure you will not hit a timeout while waiting for API’s response.

Input parameters

Parameter nameDescriptionPossible valueRequired
recordID#Leave this field empty when creating a new bin record.Integer
binID#Bin ID. For new bin records, this field is required.Integer
productID#Product ID. For new bin records, this field is required.Integer
amount#Amount. For new bin records, this field is required.Decimal (6 places)
timestamp#Integer (Unix timestamp)
documentID#Document ID.Integer
documentType#Document Type. Possible values:
  • SALES_DOCUMENT - Sales Document
  • PURCHASE_DOCUMENT - Purchase Document
  • INVENTORY_REGISTRATION - Inventory Registration
  • INVENTORY_WRITE_OFF - Inventory Write-Off
  • INVENTORY_TRANSFER - Inventory Transfer
String
creatorID#Creator (employee) ID. For new bin records, this field is required.Integer
reasonCodeID#Reason Code ID.Integer

This call is part of the "Quantities in Bins" API. It is an add-on to ERPLY's standard data model, and it allows you to keep more precise track of inventory quantities — at aisle, shelf and bin level, not just at warehouse level.

If that extra module is not enabled on your account, this API call will return error 1006.

To successfully make use of this API, you need to build an end-to-end integration yourself: make API calls every time inventory is removed from or added to shelves, or relocated in the warehouse, and build a custom report to display current quantities and their locations.

Standard operations in ERPLY (like confirming a sales or purchase invoice) that otherwise automatically adjust inventory levels, do not make any changes to the quantities in bins. Instead, API commands should be sent to remove inventory from bins when an employee goes and actually picks up the items for the shipment.

The calls that make up the "Quantities in Bins" API are: