Forum Discussion

Ultimate Cover User

3 years ago

Inventory

Hi We have entered a Supplier Bill with one of the lines being an Inventory item with nil in stock, and nil entered in the Bill, Received or Backorder fields. When recording the bill, get errror...

The_Doc
3 years ago
Hi IanChait

Just a thought Ian - I suspect that inventory doesn't see zero in a mathematical sense (that we do - do nothing, change nothing) - but it tries to do a entry to that inventory item and that it's quantity on hand or current value is already negative (even by a tiny weeny bit) and you have merely triggered this fact and hence the message.

Why is it less than zero - or the current value less than zero - because, as you know, MYOB inventory records or shows in single mathematic format but stores the information in double format and this only becomes a problem when you get close to zero for the item.

I run up against this problem constantly - where as the front end of MYOB reports 0 on hand and zero value - but the API shows 0.00 in single format but 0.0000000345 in double format.

And MYOB has to clean this discrepancy up with an inventory script.

The Doc

The_Doc

Ultimate Cover User

3 years ago

Hi IanChait

Just a thought Ian - I suspect that inventory doesn't see zero in a mathematical sense (that we do - do nothing, change nothing) - but it tries to do a entry to that inventory item and that it's quantity on hand or current value is already negative (even by a tiny weeny bit) and you have merely triggered this fact and hence the message.

Why is it less than zero - or the current value less than zero - because, as you know, MYOB inventory records or shows in single mathematic format but stores the information in double format and this only becomes a problem when you get close to zero for the item.

I run up against this problem constantly - where as the front end of MYOB reports 0 on hand and zero value - but the API shows 0.00 in single format but 0.0000000345 in double format.

And MYOB has to clean this discrepancy up with an inventory script.

The Doc

IanChait
Ultimate Cover User
3 years ago
HI The_Doc

Thank you for your reply. This is ridulous, as they are adding 0 qty in a purchase, not even trying to record a 0 qty in a sale.

Will have to het a script run over the file.
- Komal_S
  MYOB Staff
  3 years ago
  Hi IanChait
  
  Please send me the impacted product serial number and company file name by Private message so I can organise to run those scripts.