Inventory Change Types

General discussions about Abacre Restaurant Point of Sale
Post Reply
Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Inventory Change Types

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

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: Inventory Change Types

Post 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
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Re: Inventory Change Types

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

Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Re: Inventory Change Types

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

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: Inventory Change Types

Post by Abacre »

The field sdate was not updated. We corrected it. It will be available in next minor version.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Nongkiau
Posts: 35
Joined: Sun Jul 20, 2008 4:36 am

Re: Inventory Change Types

Post by Nongkiau »

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

Is this correction available yet?

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: Inventory Change Types

Post by Abacre »

The correction is already available since 22 August 2009 when we released v4.1.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Post Reply