Sale of inventory is not updating stock account

Highlighted
Contributing Cover User PA-Accounts
9 Posts
Contributing Cover User
Australia
PA-Accounts
Contributing Cover User

9Posts

0Kudos

0Solutions

Sale of inventory is not updating stock account

Hi,

 

We recently moved from Account Right Premier to Account Right Live and I have just noticed that the stock account has not been credited for the sale of inventory. We sell a fair bit of inventory and only 2 sales for July can be seen in the stock account and the amount makes no sense.

I have checked the set up of the I buy, I sell, I inventory and they are all correct as to the previous Account Right Premier. 

Has anyone seen this before.

 

Thank you
Joanne

14 REPLIES
MYOB Moderator Steven_M
20,831 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

20831Posts

2310Kudos

2903Solutions

Re: Sale of inventory is not updating stock account

Hi @PA-Accounts

 

I would recommend going to  Inventory>>Items Register and select the particular items and date range. This will show you all transactions entered for that item over that date range. Ideally, you should see that sales based transactions are reducing the On Hand and Current Value of that item.

 

In terms of the accounts behind those transactions, I would recommend going to the Sales>>Transaction Journal this will show you the transactions showing the accounts recorded with your sale based transactions. You should see a similar situation for each sale of an item that has been set to I Inventory this Item:

 

Attachment.PNG


If you are not seeing something similar to the above I would be reviewing the setup of your items.

 

Do let us know how you get on and if you require further assistance. If further assistance is required a screenshot of two of what you are seeing would be appreciated.


Kind Regards,
Steven
MYOB Client Support
Contributing Cover User PA-Accounts
9 Posts
Contributing Cover User
Australia
PA-Accounts
Contributing Cover User

9Posts

0Kudos

0Solutions

Re: Sale of inventory is not updating stock account

Steven,

 

Thanks for the reply, had already tried those options. Attached sales register and Inventory set up. Please have a look as I can't see where I have missed anything. Please note that this file was updated by MYOB from Account Right Premier to Account Right Live.

 

Thanks for your help.

Joanne

MYOB Moderator Steven_M
20,831 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

20831Posts

2310Kudos

2903Solutions

Re: Sale of inventory is not updating stock account

Hi @PA-Accounts

 

Can you provide a screenshot of the transaction? i.e. click into the arrow next to the transaction and take a screenshot. 

For reference purposes can you also ensure that the item on that transaction is SR3-5, which was the one listed on the previous screenshot.


Kind Regards,
Steven
MYOB Client Support
Contributing Cover User PA-Accounts
9 Posts
Contributing Cover User
Australia
PA-Accounts
Contributing Cover User

9Posts

0Kudos

0Solutions

Re: Sale of inventory is not updating stock account

Steven

 

Please find transaction attached for SR3-5.

MYOB Moderator Steven_M
20,831 Posts
MYOB Moderator
New Zealand
Steven_M
MYOB Moderator

20831Posts

2310Kudos

2903Solutions

Re: Sale of inventory is not updating stock account

Hi @PA-Accounts

 

I think we need to step back a little bit from the screenshot you have provided so far.

 

Basically, the best way for us to see what is occurring is the get the following screenshots:

  • One of the item setup - Profile tab.
  • One of the sales transaction i.e. Enter Sales where that item is being used
  • One of that Transaction Journal for that sale based transaction - Sales>>Transaction Journal>>Navigate to that transaction
  • Also one of that transaction recap - open the relevant invoice and select Edit>>Recap Transaction.

This way we can go through and see that transaction from the item setup through to accounts involved.


Kind Regards,
Steven
MYOB Client Support
Contributing Cover User PA-Accounts
9 Posts
Contributing Cover User
Australia
PA-Accounts
Contributing Cover User

9Posts

0Kudos

0Solutions

Re: Sale of inventory is not updating stock account

Steven,

 

Thanks for the help. But I managed to talk to the help line and they got it sorted. Appears that something was wrong in the program and its now fixed.

 

Regards

Joanne

Contributing Cover User PA-Accounts
9 Posts
Contributing Cover User
Australia
PA-Accounts
Contributing Cover User

9Posts

0Kudos

0Solutions

Re: Sale of inventory is not updating stock account

Steven

 

It appears that the call support was not correct and the problem has not been fixed.

Please see attached screen shots as previously requested.
I hope that you can see a problem somewhere as I can't.

 

Thanks
Joanne

Ultimate Partner Mike_James
3,440 Posts
Ultimate Partner
New Zealand
Mike_James
Ultimate Partner

3440Posts

1272Kudos

412Solutions

Re: Sale of inventory is not updating stock account

Hi @PA-Accounts@Steven_M, if I may comment, your item set-up shows a total cost of nil, with an on-hand quantity. When the cost is nil, no cost of sale will be recorded. Can you explain why the total cost is nil? How are these items being added to stock?


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Contributing Cover User PA-Accounts
9 Posts
Contributing Cover User
Australia
PA-Accounts
Contributing Cover User

9Posts

0Kudos

0Solutions

Re: Sale of inventory is not updating stock account

All this information was transferred over from a V19 file in June. Would there be a reason that the costs would not have been transferred over?

 

Thanks

Joanne

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