Forum Discussion

IanChait's avatar
IanChait
Ultimate Partner
3 years ago
Solved

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 message that there are not enough of the Item on hand in the selected location to record this transaction.

 

As this is a Bill, not a Sale, and values for the particular Item are nil, why are we getting this message, and how do we fix it?

  • 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

4 Replies

Replies have been turned off for this discussion
  • Komal_S's avatar
    Komal_S
    MYOB Moderator

    Hi IanChait 

    Apologies for the delay in response. 

     

    What is the current profile of the item? If an inventory adjustment is done prior to recording this purchase to increase both value and quantity, does it then let you record the bill without any errors?  Ideally, this error should only occur when either the quantity or value will go below zero and if that's not the case, do an inventory adjustment, record the purchase, do another adjustment. 


    I will also pass this on to the team in case it's a one-off glitch. 

  • The_Doc's avatar
    The_Doc
    Ultimate Partner

    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's avatar
      IanChait
      Ultimate Partner

      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.