***BrainStorm***

[rex028]

The Case is:
i'm going to develop a POS & Inventory web based system by using ASP.NET and MySQL

Here are the descriptions and functions existed:

POS

Purchase Volume Package
Payment: By Cash/ Credit Card
Validation: Check if customer id is exists or not. Clitent must be registered if she wants to purchase volume package.
Database: invoice
cust_vpack

Purchase Contract(Treatment)
Payment: By Cash/ Credit Card
Validation: Check if customer id is exists or not. Clitent must be registered if she wants to purchase a treatment contract.
Database: invoice
cust_treat

Purchase Shaping
Payment: By Cash/ Credit Card
Validation: Check if customer id is exists or not. Clitent must be registered if she wants to purchase a treatment contract.
if customer pays by volume package, system will check if customer has enough volume package credit for this shaping before it adds to the purchasing cart.

Database: invoice
cust_shape

Purchase Product
Payment: By Cash/ Credit Card / Volume Package
Validation: if customer pays by volume package, system will check if customer has enough volume package credit for that product before it adds to the purchasing cart.
Database: invoice

Complete Shaping
Payment: By Shaping Card
Validation: system will check if customer has enough shaping credits
Database: invoice
cust_shape

Compete Treatment Service
Payment: By Cash/ Credit Card / Volume Package Credit/ Contract Credit / Free
Validation: Check if customer id is exists or not. Clitent must be registered if she wants to purchase a treatment contract.
if customer pays by contract credit, system will check if customer has enough contract credit or not.(Both free or paid treatment contract)
if customer pays by volume package, system will check if customer has enough volume package credit before it adds to the purchasing cart.
Database: invoice
cust_treat

Receipt Printing
a receipt will be print when the items above are purchased. Details such as customer name, invoice number, amount and date of purchased will be appear in invoice.

[rex028]

Inventory

Inventory is interact with the POS ...
for example : there are two branches and a Headquarter

the purchased products first stock in the headquarter then assign to each branches
here: how many, where, when the product delievered ... will be record into database

if one of the branch (A) out of stock , they will borrow from other branch(B)
here: how many, where, when the product go .. will be record into database

The database have to +/- the stock automatically while the action did!!

------------------------------------------------------------------------------------------------------

Please give me some SUGGESTION , IDEA , YOURS THINK!!
how's the database should be .... how can it to be enhance !!!

BRAINSTORM EVERYBODY !!!

[rex028]

Any ideas ??

do you think any/what functions should be add ??

[Creosote]

How are you going to get it to print to a receipt printer from ASP.Net? It would be a shame to have to print out the HTML page. I would think you would want something that would print just the receipt data to a printer which could be changed. How are you going to accomplish this with WebForms?

[rex028]

first, according to the customer purchase record , the system will print the receipt ..
the receipt contain products purchased, quantity, cost and date something ...

which data will retrieve from the database ... so i have to build a form for this !

until now ... i still have not a really clear concept how to build this system ...

anyway ... i just have 5 months only to complete this year project !!

i need to gather more and more suggestions, ideas from each of you !!