Inventory - Item List

Highlighted
Contributing User CCNaturals
29 Posts
Contributing User
New Zealand
CCNaturals
Contributing User

29Posts

0Kudos

0Solutions

Solved: Go to Solution

Inventory - Item List

In the Items List we have occassional products showing:


Stock on Hand =   -1.4432899320127E_15

 

When you look up these items the SOH does not resemble this same amount.

 

I recall hearing that there was a glitch in the MYOB inventory - and there is a file that should be run to correct this.

Can someone advise what we should do.

 

 

 

18 REPLIES 18
MYOB Moderator Steven_M
2,000 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

31525Posts

4115Kudos

4595Solutions

Re: Inventory - Item List

Hi @CCNaturals 

 

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

Contributing User CCNaturals
29 Posts
Contributing User
New Zealand
CCNaturals
Contributing User

29Posts

0Kudos

0Solutions

Re: Inventory - Item List

HI Steven

 

This report shows negative balances - but the Item List shows it as zero.  So it appears I am unable to adjust these.

 

Contributing User CCNaturals
29 Posts
Contributing User
New Zealand
CCNaturals
Contributing User

29Posts

0Kudos

0Solutions

Re: Inventory - Item List

I have cleared any small balances and nil stock.

 

Except for the page Of Inventorised items showing a negative (which doesnt display on the other lists)

 

Last 4 digits = 3010

AccountRight Premier NZ 2018.4.1

Build 2018.4.21.6556

ID1

MYOB Moderator Steven_M
2,000 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

31525Posts

4115Kudos

4595Solutions

Accepted Solution Solved

Re: Inventory - Item List

Hi @CCNaturals 

 

I've run some scripts over that company file for you which has been known to correct those long decimal places for your items. Do close down and reopen the file before opening that item list.

 

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

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 User CCNaturals
29 Posts
Contributing User
New Zealand
CCNaturals
Contributing User

29Posts

0Kudos

0Solutions

Inventory - negative balances

Steven has run the script on our files - however another negative balance has occurred and this stops us receipting in the delivery of ingredients. 

What creates this N/A against the "average cost" and then we cant process receipts of items.

 

Please see attached form.

MYOB Moderator Steven_M
2,000 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

31525Posts

4115Kudos

4595Solutions

Re: Inventory - negative balances

Hi @CCNaturals 

 

I've re-run those scripts over the company file for you. Can you now try that process again and let us know how you get on with that.

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 User CCNaturals
29 Posts
Contributing User
New Zealand
CCNaturals
Contributing User

29Posts

0Kudos

0Solutions

Re: Inventory - Item List

Steven

 

We are in need of this script to be run again.  The negative balances are preventing  us from doing our BUILDS.

Urgent please.

MYOB Moderator Steven_M
2,000 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

31525Posts

4115Kudos

4595Solutions

Re: Inventory - Item List

Hi @CCNaturals 

 

Sorry about the delay in getting to this enquiry.

 

I've arranged for the scripts to be run for you. Do ensure that you close down and reopen the company file at some point.

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 User CCNaturals
29 Posts
Contributing User
New Zealand
CCNaturals
Contributing User

29Posts

0Kudos

0Solutions

Re: Inventory - Item List

Steven

 

Please see attached. 

When we have an OOS (out of stock item) it is picking up the value of the Case price (retail)  and deducting that off our stock value - where it should be zero price.

We want to show the "unsupplied" item on the invoice to keep track - but this seems to be an error....or taking its information from the wrong source.

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