Page 1 of 1

Inventory Change Types

Posted: Fri Dec 12, 2008 11:47 am
by Nongkiau
I've looked into the Access file behind the software, and I found that all inventory changes are found in the table InvChange. This is a quite interesting information. Each change carry in identity, "changetype", and I've identified the following:

0: Adjusted Inventory Upward
1: Delete order
3: Receive Voucher
6: ????
7: Adjusted Inventory Downward
8: Sold
10: ????
13: Return Voucher

I cannot figure out what 6 and 10 represents. Does 2, 4, 5, 9, 11, 12 exist?

Re: Inventory Change Types

Posted: Fri Dec 12, 2008 3:49 pm
by Abacre
We define it as the following:

ICT_ADD_MANUAL_ADJUST =0; // manually adding item for adjustment
ICT_ADD_ORDER_ITEM =1; // removed item (added into InvChange)
ICT_ADD_ORDER_MOD =2; // removed modifier (added into InvChange)
ICT_ADD_RECEIVE_VOUCHER =3; // received item by receive voucher
ICT_ADD_RETURN_ORDER_ITEM =4; // return menu item on refund
ICT_ADD_RETURN_ORDER_MOD =5; // return menu modifier on refund
ICT_ADD_RETURN_VOUCHER =6; // when deleting Return Voucher
ICT_DEL_MANUAL_ADJUST =7; // manually removing item for adjustment (for example, because of loss)
ICT_DEL_ORDER_ITEM =8; // client ordered item
ICT_DEL_ORDER_MOD =9; // client ordered item with modifier
ICT_DEL_RECEIVE_VOUCHER =10; // when deleting Receive Voucher
ICT_DEL_RETURN_ORDER_ITEM =11;
ICT_DEL_RETURN_ORDER_MOD =12;
ICT_DEL_RETURN_VOUCHER =13; // returned item by return voucher

Re: Inventory Change Types

Posted: Sun Dec 14, 2008 11:32 am
by Nongkiau
Thanks a lot. This helps to look into a few things.

I realised that "6" has meddled with our stock count, could be myself :) I would love to be able to disable te functions we don't need. Less functions, less errors. That's just a suggestion for coming versions.

Re: Inventory Change Types

Posted: Thu Aug 20, 2009 4:57 am
by Nongkiau
Is there any way to see when a change to the InvChange table has occured? There's a field called sdate, but it's empty.

I would like to do monthly statistics based on this.

Re: Inventory Change Types

Posted: Thu Aug 20, 2009 10:24 am
by Abacre
The field sdate was not updated. We corrected it. It will be available in next minor version.

Re: Inventory Change Types

Posted: Mon Dec 07, 2009 6:47 am
by Nongkiau
"The field sdate was not updated. We corrected it. It will be available in next minor version."

Is this correction available yet?

Re: Inventory Change Types

Posted: Mon Dec 07, 2009 8:23 am
by Abacre
The correction is already available since 22 August 2009 when we released v4.1.