Sage and stock control
I'm looking for some advice please.
I will say at the outset that my knowledge of how Sage processes stock is minimal.
I have a client who used Sage 50 Professional 2011.
They keep stock records (have aproximately 1000 stock codes), and the software is set so that it allows stock to go negative.
The basics of the business is that a sales order will be processed, and the stock will go negative. A purchase order will be raised to order the stock. The stock will come in and the purchase order processed to become positive. The stock will go out and the sales invoice raised, so the stock level goes back to zero.
On some items there is actual physical stock held, on others the items are 'special order' so no stock held.
The problem is that the client says that when they do a stocktake the physical stock rarely agrees with the Sage stock figure, so they have no confidence in the Sage figure.
Any ideas why?
My initial thoughts are that they are probably checking physical stock against the wrong stock report or something. Sage will presumably have a number of different stock reports available, but I imagine most of them won't get loaded with the software by default - am I correct thinking this? If so can anyone advise how to access the correct reports?
Am I right in thinking that integration of the stock figure with the Nominal Ledger is by journal, and that the stock module is in effect stand alone from the Nominal and other accounts module, and integrated by journal only?
If this is correct, is the 'good practice' suggested procedure set out somewhere please?
Thanks for any advice.