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

Stock Balances

SUGGESTED
Posted By

Is there any way to start a fresh with basically a blank stock slate?

Currently using 200c on site and we're having a nightmare with batch traceable items being booked in by HH scanners (datalinx) they are managing to slip into the system with no batch number assigned to them, despite batch entry upon POP receipt, and despite the stock card within stock control (Batch Traceable tab) stating catagorically this product MUST be assigned a batch upon goods reciept.

There are locations that are no longer used - The business i'm with has never used the priority locations to define to the scanners where to find the locations i.e

Product Code 1 / Locations Tab

Location 1/2/3/4/5/6/7/8/9 - All with a priority of 9 - Batches held in QTY reserve.

I've analysed the TraceableItems table and indeed there are entries in there with 0 traceable item details despite the above mentioned - This only happens with certain products, but it's now cascading down at a rapid rate.

Ideally, what i'd like is to be able to import an opening balance sheet and start again. But retain trading history, without having to create a new company and start again with a new opening balance sheet.

What implications would there be if i wiped the stock qty within SQL and the traceable items table? :P - I would never do such a thing, but there must be a more elegant solution to the problems we're facing, without it costing us the earth.

Help =D

Parents
  • 0
    SUGGESTED
    Its not going to be an easy one, I would advise greatly against trying to do it in SQL as that can cause plenty of issues and is not supported by Sage, so if things go wrong then they wont help.

    From what you say, my recommendation here would be to start again on a clean dataset, import headers and opening balances. Set up the stock as is with opening balances and retain the data at now as a historic set to look back on. Thats the cleanest and best way other than zeroing all stock and starting again, though old locations probably wont be able to be deleted and other outstanding data issues in the tables would just be carried across.

    I've seen a lot of datasets over the years where people have tried to hack it in SQL or try working around it and for me the best and cleanest option is starting afresh.
Reply
  • 0
    SUGGESTED
    Its not going to be an easy one, I would advise greatly against trying to do it in SQL as that can cause plenty of issues and is not supported by Sage, so if things go wrong then they wont help.

    From what you say, my recommendation here would be to start again on a clean dataset, import headers and opening balances. Set up the stock as is with opening balances and retain the data at now as a historic set to look back on. Thats the cleanest and best way other than zeroing all stock and starting again, though old locations probably wont be able to be deleted and other outstanding data issues in the tables would just be carried across.

    I've seen a lot of datasets over the years where people have tried to hack it in SQL or try working around it and for me the best and cleanest option is starting afresh.
Children

*Community Hub is the new name for Sage City