x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 648 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
mtba

How to resolve a stock mess

SUGGESTED
Posted By

Hello All, I'm hoping someone can help me as I'm new to Sage 200. 

About 6 months ago a business we acquired had migrated from Sage 50 to Sage 200 Professional. Unfortunately the information which was migrated in respect of stock was vastly incorrect as the company were using an excel file to manage stock rather than Sage and no one thought to correct the data before migration! 

Anyway to cut a long story short I'm trying to get the stock records inside of Sage corrected, I'm not expecting to bring the historic monthly positions in but would really like to be able to get a revised opening balance position to use going forward. We are doing a full stock take at the end of this month which I'd like to use for the opening balances. The company uses the BOM's functionality so we need to factor this in going forward.  

Looking at the help files, if we amend/adjust the price book and quantities this will create adjustment nominals which presumably we will then need to write off against historic data. Is this the best way to resolve the mess, or would starting again from scratch with a new company in Sage be more appropriate? 

Any feedback/experiences/tips would be more than welcome!

Many thanks in advance. 

Parents
  • 0
    SUGGESTED

    Hi 

    I appreciate that this advice is likely to be too late to assist you but it may be useful to anyone else who finds themselves in a similar position in the future.  I trust you were able to find a satisfactory solution, please share any advice you may have based on your experience.

    Firstly I urge all end users to reach out to their Sage 200 support provider with any problems they are unable to find an answer for in our Help Files or Help Centre.

    Secondly, I would also recommend that any proposed solution is tested using a copy of the data prior to being applied to the live system.

    The integration between stock and nominal is optional, this is determined by the 'Integrate stock management with nominal ledger' setting in  Stock Control, Utilities, System Set Up and then Stock Control Settings. The postings that are made could be further complicated if the 'Generate cost of sales posting for SOP'.

    I personally would recommend using the stock-take function in Sage 200 as this will allow you to process all the products in a particular warehouse on mass - it will also enable you to produce the count sheets from use when doing the physical stock count. You could then view the nominal transactions that are posted as a result of completing the stock-take o determine if any correcting journals may be needed. 

    Regards

    Chris

       

  • 0 in reply to christopher hall

    Hi Chris, many thanks for your response. We haven't sorted it out just yet, but found a workaround to use in the meantime. Will keep all of your pointers in mind as we continue the process though and will post something on here once we resolve the issues. Many thanks since again.

Reply Children
No Data

*Community Hub is the new name for Sage City