Inventory Change Types

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

[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

[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.

[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.

[Abacre]

The field sdate was not updated. We corrected it. It will be available in next minor version.

[Nongkiau]

"The field sdate was not updated. We corrected it. It will be available in next minor version."

Is this correction available yet?

[Abacre]

The correction is already available since 22 August 2009 when we released v4.1.