Easify Forums

Forums -> Products & Stock Control

 Changes to stock quantities - when and by whome

Post Reply
Page 1 of 1 1
Posted by SugarCraftShop

Changes to stock quantities - when and by whome

Hellloooo....

Is there any time stamp/record to pull data from to see when alterations to stock quantities have been made?

Cheers

MC  


MarieClare

www.SugarCraftShop.co.uk Whatever your cake desires...

Posted by John

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


Happy to help - John (Easify Support)

Like our facebook page and always get the latest updates!

Posted by SugarCraftShop

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???


MarieClare

www.SugarCraftShop.co.uk Whatever your cake desires...

Posted by SugarCraftShop

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


MarieClare

www.SugarCraftShop.co.uk Whatever your cake desires...

Posted by SugarCraftShop

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


MarieClare

www.SugarCraftShop.co.uk Whatever your cake desires...

Posted by John

Re: Changes to stock quantities - when and by whome

SugarCraftShop said:

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

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


Happy to help - John (Easify Support)

Like our facebook page and always get the latest updates!

Post Reply
Page 1 of 1 1

Easify Website V 5.0    © 2024 Easify Ltd ® All rights reserved.     Privacy Policy