Qty in Stock v Running Total

Question

HI 
 I'm having a problem still with stock valuation. For example, here is a product that I have zero stock for, but if I send the activity to Excel, and perform a running total, the running total shows I have -43.5 items in stock, rather than zero. 
 
 On other examples I have tried, I have stock of 10 items, but the running total is showing I have -9. 
 
 Does Sage use something other than the activity to work out stock levels?

AndyR. · Answer

For clarification, the clear stock date is the date it was last run to, not the date that it was last run on. So if Clear Stock was run today using date 31/12/2003 then 31/12/2003 would be the date shown in Help > About, not today's date. That date is also overwritten whenever Clear Stock is run so it only represents the date last used to clear stock transactions. The Quantity In Stock field on the product activity is updated on a transaction by transaction basis so it's generated from all of the stock transactions to date regardless of any transactions removed by Clear Stock. This is why, if Clear Stock is run, it becomes difficult to reconcile as some of the transactions that contributed to that Quantity In Stock balance may have been removed. Andy, Sage UKI

Sage 50 Accounts

Qty in Stock v Running Total

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING