Negative Inventory Item Causing Issues

Highlighted
alicia_r
3 Posts
User

3Posts

2Kudos

0Solutions

Solved: Go to Solution

Negative Inventory Item Causing Issues

Hi 

 

I have an iventory item which I buy per metre, it's used in some items autobuilds.

I have no idea how, but it has gone into negative (i don't know the exactly quantity as it says -1.065814103640015E-14). My autobuilds take out numbers like 5.7, etc.

The only way I can see this is when i'm entering the code in a purchase, as looking at the item in Inventory shows quantity on hand is 0.

I need to enter a purchase for 120m, but every time I try, it will not save, it says it has had a connection error.

I'm able to save other sales/purchases, but not this one.

Help please.

4 REPLIES 4
MYOB Moderator Steven_M
32,609 Posts
MYOB Moderator
New Zealand
MYOB Moderator

32,609Posts

4,346Kudos

0Solutions

Re: Negative Inventory Item Causing Issues

Hi @alicia_r 

 

We do have a script in which can run over company files that are showing unusually long decimal place or N/A inventory values or a negative inventory message when changing the preferences. Just before we do arrange for that we need for you to check the following:

Please note that if you do have any receive item transactions these would need to be converted into Bills before this process.

  • Go to Inventory>>Item List>>Inventoried tab, click to sort by On Hand (select the column heading). Ensure that no items are showing as having a negative on hand value.
  • Run the Inventory Value Reconciliation report and check to ensure that there no invalid amounts. Invalid amounts being a negative or an item that has 0 on hand but a value in Inventory

If those options are fine and you don't have any negative values we can arrange for the script to be run: For us to do this we need to confirm the following details:

  • Where the company file is stored i.e. online or local
  • What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information
  • What is the company file ID - Help>>About AccountRight

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

alicia_r
3 Posts
User

3Posts

2Kudos

0Solutions

Re: Negative Inventory Item Causing Issues

Hi Steven

 

My responses are in red

 

Please note that if you do have any receive item transactions these would need to be converted into Bills before this process. -  There are none in MYOB to process, I do need to process one but every time i've tried I have issues.

  • Go to Inventory>>Item List>>Inventoried tab, click to sort by On Hand (select the column heading). Ensure that no items are showing as having a negative on hand value. - One code (the one i'm having issues with) shows as negative
  • Run the Inventory Value Reconciliation report and check to ensure that there no invalid amounts. Invalid amounts being a negative or an item that has 0 on hand but a value in Inventory - All other codes are fine, this particular code shows inventory as 0.0 (whereas the others at 0, just show 0) 

If those options are fine and you don't have any negative values we can arrange for the script to be run: For us to do this we need to confirm the following details:

  • Where the company file is stored i.e. online or local - I believe it is online
  • What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information - 7420
  • What is the company file ID - Help>>About AccountRight - 1

Thank you

Alicia

MYOB Moderator Steven_M
32,609 Posts
MYOB Moderator
New Zealand
MYOB Moderator

32,609Posts

4,346Kudos

0Solutions

Accepted Solution Solved

Re: Negative Inventory Item Causing Issues

Hi @alicia_r 

 

I've run the necessary script over that online company file for you. Do ensure that you close and reopen that company file before completing that process.


Do let us know how you get on and if you require further assistance.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

alicia_r
3 Posts
User

3Posts

2Kudos

0Solutions

Re: Negative Inventory Item Causing Issues

Thank you

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post