Negative Inventory Value

Highlighted
Experienced Cover User Archskirt01
36 Posts
Experienced Cover User
Australia
Experienced Cover User

36Posts

5Kudos

0Solutions

Solved: Go to Solution

Negative Inventory Value

We have two items showing incorrect on hand balances - 

ATS20x20x3.0MF4.0 shows a balance of  5.55111512312578E-17

AGA60x60x3.0MF shows a balance of 2.27248775352962E-16

 

No idea how this has happened or how to fix this.

Thank you

9 REPLIES 9
MYOB Moderator Steven_M
32,737 Posts
MYOB Moderator
New Zealand
MYOB Moderator

32,737Posts

4,375Kudos

0Solutions

Accepted Solution Solved

Re: Negative Inventory Value

Hi @Archskirt01 

 

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

Experienced Cover User Archskirt01
36 Posts
Experienced Cover User
Australia
Experienced Cover User

36Posts

5Kudos

0Solutions

Re: Negative Inventory Value

Hi Steve,

I have checked back through our inventory and we did have two items with negative inventory on hand and two items with nil on hand but a negative inventory value.  I have fixed both of these.

I just have one item now where we had adjusted the inventory on hand by 0.006 so the item had nil on hand,

which seems to have created the strange value. 

When i delete the inventory adjustment the item on hand quantity is 0.00600000000000023.

I cant seem to get this to adjust to a 3 digit decimal place so I can adjust this item to nil on hand.

Thank you

Trusted Partner Melinda_vanDyk
29 Posts
Trusted Partner
Australia
Trusted Partner

29Posts

32Kudos

0Solutions

Re: Negative Inventory Value

Hi @Steven_M ,

 

Is it possible to have this script run over my clients file please:

 

  • Online
  • 0568
  • Company file ID 6

Thank you!

Melinda van Dyk
DIRECTOR
MproV Pty Ltd


Adelaide SA
E: melinda@mprov.com.au
P: 0413 159 791
F: 08 8125 6748
MYOB Certified Consultant



MYOB Moderator Gayathri
1,144 Posts
MYOB Moderator
MYOB Moderator

1,144Posts

132Kudos

0Solutions

Re: Negative Inventory Value

Hi @Melinda_vanDyk,

 

Thank you for the post! Welcome to the MYOB Community Forum.

 

If you can send a private message with the details:

  1. The serial number of the company file (Setup>>Company Information).
  2. Account Name
  3. Client ID
  4. Email Address

Here is a link that will take you to your private messages- Private Messages . You can send us a private message here.

 

Thank you.

Cheers,
Gayathri

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

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

32,737Posts

4,375Kudos

0Solutions

Re: Negative Inventory Value

Hi @Archskirt01 

 

Judging by that long decimal place number it sounds like we do need that script to be run. As such, can you confirm the following information:

 

  • 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

Experienced Cover User Archskirt01
36 Posts
Experienced Cover User
Australia
Experienced Cover User

36Posts

5Kudos

0Solutions

Re: Negative Inventory Value

Hi Steven

 

  • The file is online
  • the LAST FOUR DIGITS  -  0506
  •  company file ID -  4

Thank you

Cathie

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

32,737Posts

4,375Kudos

0Solutions

Re: Negative Inventory Value

Hi @Archskirt01 

 

I've arranged for the necessary script to be run over the company file. I would recommend closing down and reopening the company file before reviewing your items.

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

Experienced Cover User Archskirt01
36 Posts
Experienced Cover User
Australia
Experienced Cover User

36Posts

5Kudos

0Solutions

Re: Negative Inventory Value

HI Steven,

 

When will this occur or can we continue using our file whilst this is done?

 

Thank you

Cathie

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

32,737Posts

4,375Kudos

0Solutions

Re: Negative Inventory Value

Hi @Archskirt01 

 

I have run the scripts as of the last message, so, in theory, you should be good to go. We do just recommend closing down and reopening the file to ensure that the script has been actioned as intended.

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

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