OE import error "Negative Inventory Levels"

SUGGESTED

Hi All,

I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different location.

E.g. (item A at all locations    QOH = 0)

Order 1       item A        Location XYZ       QTY 1   => Imported processed

Order 2       item A        Location TUV       QTY 3  => Stop import and promoted and error "Invalid input. Negative inventory levels are not allowed for item A at location TUV."

Would you address the issue? Thank you.

Parents Reply Children
  • FormerMember
    0 FormerMember in reply to Mike Cook

    I know this is an old issue, but I've been chasing it down for a client.   Sage support says, if Allow Negative Inventory is not enabled, you will not be able to enter an order for which you do not have quantity available, even if you set Quantity Committed to 0.     (I encountered this behavior, and called support for clarification).

    personally, I think that behavior is whacked.  entering an order is not creating a transaction that reduces quantity to below 0.  Shipping the order would...

  • 0 in reply to FormerMember

    Ensure the quantity committed on the import is zero

  • 0 in reply to FormerMember

    yeah, it's wrong.  we have ours set to not allow negative inventory.  Someone is telling you something wrong, or the client is doing something wrong such as not including the "committed" column on an upload in which case they can't specify a zero.  so make sure the column is on there.

    They could also try changing their defaults in OE Options to NOT default the QTY Commited.  It would force them to have to manually commit everything though which sucks, but might be an option