Available and Allocated Inventory being added as a Total Quantity for Target

  • 1
  • Question
  • Updated 4 years ago
  • Answered
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Old

We are trying to understand why available quantities and allocated quantities are added together on the inventory advice when we send it daily. We are assuming that "available quantity" is referring to the quantity that we have available totally in our warehouse. We assume that "Allocated quantity" seems to mean that there is quantity from the "Available Quantity" that is being "allocated" to Target as our trading partner.

If the above was true, the "total quantity" that we are seeing on the inventory advice report should be the "Available Quantity" that we input, isn't that correct? What are we missing or getting confused on?

What field is being used in the inventory advice to specify the amount of inventory that Target has available?

Photo of Raheel Nusratullah

Raheel Nusratullah

  • 70 Points

Posted 4 years ago

  • 1
Photo of Katrina Wolyniec

Katrina Wolyniec, Employee

  • 3,762 Points 3k badge 2x thumb

Thank you for posting to the Support Center!

I have looked into your question and have found out the following:

The only required quantity field on the Inventory Advise form is the Available Quantity.  The Quantity on Order, Quantity Allocated, and Quantity on Hold are not required fields.

I would advise only filling in the required Available Quantity field if the other fields are not contributing to the information Target needs, but seems to be confusing the issue.

Quantity on order should be describes what is on order but not in hand.  Quantity Allocated means the quantity allocated to another party (not what is allocated to Target).  Finally, Quantity on Hold is the quantity that you are holding for anther party as well.

There are times where Target may specifically request this information from you due to a business need, however, if they are not requiring it, I would advise not sending that information at time time.  That will simplify the process and the communication.  If they do request it, I would advise asking Target for clarification how they use the document when it includes that information and if they have best practices for which numbers to put in those fields.

Let us know if you have any further questions and we would be happy to look into the issue.

Thank you!

SPS Commerce Infinite Retail Power

Katrina Wolyniec

Senior Analyst | WebForms Fulfillment Support 

P: 1-888-739-3232 Option 1



[supportcenter.spscommerce.com]Support Center – Get Help. Give Help. Share Ideas.

This conversation is no longer open for comments or replies.