Long Decimal Places

[rob_d]

We have several inventory items that have very long decimal places.

It's been a long running glitch with AR, that we have usually resolved by having to make inventory adjustments to 'zero' out the offending inventory items.

But we still have a few inventory items we can't fix.

I've tried calling MYOB support (twice now, on hold for 30+ mins each time).

Is there a way to fix this for current items?

And a way to fix it permanently too so it won't happen again?

[Ozchemist]

As my previous reply was removed by moderators, I will try to keep this succinct and light.

You are correct - this problem has a long history with no permanent fix. 

In terms of fixing the issue on an item by item basis, we have found the following helpful - it is not a 100% fix, but works maybe 95% of the time.

1. Do an inventory adjustment to add sufficient qty and $ value to ensure you have both a positive inventory and positive dollar value.

2. Do a "Count Inventory" and set the inventory to a non-zero whole number (e.g. 1) and process the adjustment

3. Do step 2 again - but setting the inventory to 0 and process any adjustment created.

As a separate comment - this is a frustrating fault that needs to be rectified properly in code. Only MYOB has the capacity to institute a re-code to achieve this. And it has been needed for many years. 

As Inventory management is a core feature of an integrated accounting package it needs to work properly or be sufficiently transparent to allow users to fix issues themselves as (if) they arise.

[Steven_M]

Hi @rob_d 

Would you mind confirming the following information as we do have a script (tool) that we can be run over the company file that has helped a number of users with the same situation:

• 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

[rob_d]

Thanks @Ozchemist, these are the "workarounds" we've had to use quite a few times to fix the 'inventory issue', but for some reason won't work this time. Agreed that it's quite frustrating, it never used to happen on the classic versions of MYOB, only the new/online version seems to have these types of issues.

[rob_d]

Hi @Steven_M,

If you could run a script, that would be appreciated.

The file is stored online, serial is 7043 & company ID is 9.

Thank you!

[Steven_M · Accepted solution]

Hi @rob_d 

I've arranged for that script to be run for you.

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

[rob_d]

Thank you @Steven_M, this fixed the issue!

[rob_d]

Hi @Steven_M, this has occurred again whereby we have long decimal places showing for some of our inventory items. Is there any way we can resolve this ourselves? Or do we need to request a script to be run again?

[ChrisMYOB]

Hello @rob_d 

Thank you for letting us know that this is affecting your file again. 

I have processed the script over it and the issue should now be resolved once you log back in.

[rob_d]

Thank you @ChrisMYOB, this has resolved the issue again.