Hi All..
A customer will place an order for few items to a company.
Company will make sales order, which will contain the customer name and items list and their price.
Is there any table, which will store the sale order data..??
If so, how the system will assign the number of items (say 10) with one customer..???
If we want a report reflecting the details of items per customer, how to fetch the data..????
How this type of data is maintained in the database tables..??
Please give your ideas/suggestions....
Regards
Pavan