Long Decimal Places

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
rob_d
Experienced User
15 Posts
Experienced User
Experienced User

15Posts

4Kudos

0Solutions

Solved: Go to Solution

Long Decimal Places

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?

17 REPLIES 17
Ozchemist
Experienced Partner
32 Posts
Experienced Partner
Australia
Experienced Partner

32Posts

3Kudos

0Solutions

Re: Long Decimal Places

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
45,180 Posts
Former Staff
New Zealand
Former Staff

45,180Posts

0Kudos

6,759Solutions

Re: Long Decimal Places

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

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| My Account

rob_d
Experienced User
15 Posts
Experienced User
Experienced User

15Posts

4Kudos

0Solutions

Re: Long Decimal Places

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
Experienced User
15 Posts
Experienced User
Experienced User

15Posts

4Kudos

0Solutions

Re: Long Decimal Places

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
45,180 Posts
Former Staff
New Zealand
Former Staff

45,180Posts

0Kudos

6,759Solutions

Accepted Solution Solved

Re: Long Decimal Places

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.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| My Account

rob_d
Experienced User
15 Posts
Experienced User
Experienced User

15Posts

4Kudos

0Solutions

Re: Long Decimal Places

Thank you @Steven_M, this fixed the issue!

rob_d
Experienced User
15 Posts
Experienced User
Experienced User

15Posts

4Kudos

0Solutions

Re: Long Decimal Places

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
1,545 Posts
Former Staff
Former Staff

1,545Posts

0Kudos

173Solutions

Re: Long Decimal Places

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.

Kind regards,
Chris

MYOB Community Support

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

rob_d
Experienced User
15 Posts
Experienced User
Experienced User

15Posts

4Kudos

0Solutions

Re: Long Decimal Places

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

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