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 NovA
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
MYOB Moderator Steven_M
33,603 Posts
MYOB Moderator
New Zealand
MYOB Moderator

33,603Posts

4,497Kudos

4,880Solutions

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

Contributing Cover User NovA
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

MYOB Moderator Steven_M
33,603 Posts
MYOB Moderator
New Zealand
MYOB Moderator

33,603Posts

4,497Kudos

4,880Solutions

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

Contributing Cover User NovA
6 Posts
Contributing Cover User
Australia
Contributing Cover User

6Posts

1Kudos

0Solutions

Re: Inventory Rounding

Cheers, thanks so much for your help Smiley Happy

OneFin
2 Posts
Cover User
Australia
Cover User

2Posts

0Kudos

0Solutions

Re: Inventory Rounding

 
MYOB Moderator Neil_M
11,862 Posts
MYOB Moderator
MYOB Moderator

11,862Posts

1,402Kudos

1,679Solutions

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

OneFin
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