Easify Forums

Re: Changes to stock quantities - when and by whome

Currently (in version 3.83) stock changes are not recorded with a date / time value.

This could only be worked out by writing your own report (either using Crystal Reports or Excel).

You would need to work this value out by using the Purchases and PurchaseDetails tables in your Easify database to work out when new stock was received.

Here're some guide for making Reports in Excel:

http://easify.co.uk/forums/viewtopic.php?f=6&t=267

http://easify.co.uk/forums/viewtopic.php?f=14&t=902

Re: Changes to stock quantities - when and by whome

..just seems a bit silly when the product history table does not include 'every' change to that stock item - why reinvent the wheel?? after all if I have all the data for sales why not have stock check info and delivery info???

Re: Changes to stock quantities - when and by whome

Just to give you the background to this.. so if a memner of staff is adding stock incorrectly there is no way to trace this..

MC

Re: Changes to stock quantities - when and by whome

Sorry - that was a question...So..if a member of staff was incorrectly making changes to sock..how would you be able to trace this? Apart from the stock figure being wrong???

Ta much

MC

Re: Changes to stock quantities - when and by whome

If a user manually edits the stock level of a product record, this change isn't logged and so cannot be traced.