Feedback

[prashants]

• https://github.com/maduranga2u/Inventory/blob/master/webzash_inventory.sql

I suggest you use id as bigint(18) and character set as utf8. Check my mysql script and follow that. Also use FOREIGN KEY constrain to maintain data integreity.

https://github.com/prashants/webzash/blob/master/Config/Schema.Mysql.sql

• Do you have any plans for handling sales and purchase returns, etc.
• How do you plan to handle carry forwarding inventory for the next year.

[maduranga2u]

mysql script updated according to your script.

Still not planing for Sales or Purchase returns so could you please advice.

I will used same method u used to carry forwarding for the next year.

could u please advice to different database using inventory correct way or wrong.

[prashants]

There are lot of things when comes to dealing with inventory. I would suggest that you send a message to the webzash google groups about your project. There are few people on the list that are interested in it. Here are some more things that I could think of

• Inventory items can have their closing stock calculated using different methods like LIFO/FIFO/Average, etc
• Add option for delivery charges, vat/taxes, discounts when adding sales or purchase entries
• Use the webzash account selection rather than manually updating the database settings

[maduranga2u]

Great thanks for your comment and i will work on that.

[prashants]

What you are trying to do is replicate ERP features. I suggest have a look at erpnext.com.

[maduranga2u]

Most of client main requirement is account updated with daily basis. so i am used manually updated account using feed.Please advised me are there any other option.

[prashants]

Sorry I didnt get what you meant by 'feed'.

[maduranga2u]

Current application Feed process

1.When creating sales or purchase account entries save on my inventory database. 2.When using feed process on this application all selected date account entries grouping and then process to current account database.

These are the currently used process for this application.

[prashants]

You mean to say that you enter data into inventory database and then at the end of the day process it and add to the account database ?

[maduranga2u]

yep. In current application it not automatic process.

[prdpspkt]

The easiest way to maintain both repository and get benefit of both features is to merge both of them. I'm interested in this project but new to cakePHP.