Inventory Rounding

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.
Highlighted
Contributing Cover User
6 Posts
Contributing Cover User
Australia
Contributing Cover User

6Posts

1Kudos

0Solutions

Solved: Go to Solution

Inventory Rounding

Hi,

 

I have a file where we are using Build/Auto Build Items and a few times it leaves the items with an incorrect inventory position i.e. one item is .230000000000000036 when it should just be .23


I don't understand why it is even doing this because the build items is only 6 decimal places and I only use 4.

 

Is there any way to fix this because I can only go to 6 decimal places on an adjust inventory?


Thanks,


Stephen

7 REPLIES 7
Highlighted
MYOB Moderator
36,424 Posts
MYOB Moderator
New Zealand
MYOB Moderator

36,424Posts

4,933Kudos

5,313Solutions

Accepted Solution Solved

Re: Inventory Rounding

Hi @NovA

 

Welcome to the MYOB Community Forum, I hope you find it a wealth of knowledge

 

We do have a script in which can run over company files that are showing unusually long decimal place or N/A inventory values. 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

Highlighted
Contributing Cover User
6 Posts
Contributing Cover User
Australia
Contributing Cover User

6Posts

1Kudos

0Solutions

Re: Inventory Rounding

Hi Steven,

 

Thanks for your help.

 

The file is online, the last 4 digits are 4845, the file ID is 17.

If you need anything else please let me know.

 

Thanks Stephen

Highlighted
MYOB Moderator
36,424 Posts
MYOB Moderator
New Zealand
MYOB Moderator

36,424Posts

4,933Kudos

5,313Solutions

Re: Inventory Rounding

Hi @NovA

 

I've just run those scripts over the company file for you that has been known to aid in those long decimal places. I would recommend closing down and reopening the company file before checking.

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

Highlighted
Contributing Cover User
6 Posts
Contributing Cover User
Australia
Contributing Cover User

6Posts

1Kudos

0Solutions

Re: Inventory Rounding

Cheers, thanks so much for your help Smiley Happy

Highlighted
2 Posts
Cover User
Australia
Cover User

2Posts

0Kudos

0Solutions

Re: Inventory Rounding

 
Highlighted
MYOB Moderator
12,660 Posts
MYOB Moderator
MYOB Moderator

12,660Posts

1,501Kudos

1,788Solutions

Re: Inventory Rounding

Hi @OneFin

 

Welcome to the MYOB Community Forum, I hope you find it a great resource.

 

Do feel free to let us know if we can assist with anything

Regards,
Neil

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

Highlighted
2 Posts
Cover User
Australia
Cover User

2Posts

0Kudos

0Solutions

Re: Inventory Rounding

Hello @Neil_M,

I have a rounding issue with my inventory (it's more then two decimal points) on AR 2018.1- how can this be fixed?

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