Point of Sale

PHPMaker General Discussion (PHPMaker)
1

Hi,
I want to make a point of sale system in which I want make single screen for adding/Fetching data like below

  1. customer field in top fetch data from customer table in that I just enter mobile/name of customer
  2. Item field - search item from item master
  3. after search / enter from item search list one by one all the items
    4.right side place for total the amount
  4. after press “OK/Save/Add” all the value will store in different different table

Please guide me how to design this form in PHP MakerI am already doing it with different - different form , now I want to do it from single formThank you in advance

2

I just built a point of sale app with phpmaker with different approach from urs. Share you database schema for folks to understand u better

3

sanjeev wrote:

Please guide me how to design this form in PHP Maker

You may use Master/Detail Add to implement this business-logic. Please read Tutorials → Master/Detail topic from PHPMaker Help menu for more info and example.

4

vintoICT wrote:

I just built a point of sale app with phpmaker with different approach from
urs. Share you database schema for folks to understand u better
Hi Please share your idea also…
I have four (4) tables >

Table → 1. Customer (Storing and fetching details of customer)
CustomerID
CustomerName
CustomerPhone
CustomerAddressTable->2 Item Master (Fetching Item details)
ItemID
ItemCode
ItemName
ItemCompany
ItemPriceTable->3 Bill Master (Storing Bill )
BillID
TotalAmount
Discount
ActualBilling
CustomerID
Date
EmployeeIDTable->4 BillI Item Details (Storing Bill Item)
BillID - Reference of Bill Master
ItemID - Reference of Item Master
CustomerID - Reference of Customer Master
Date- Current Date (Sale Date)------------------------If you have some different Idea pleas guide me, but if possible all work to be done in single pageI do not now how to post picture here other wise I post picture of my idea also.Please reply and guide me

5

You will definitely need to write some custom front end codes

6

plz advice me how to do? Is it possible in phpmaker or any other easy way you want to suggest
Thnx in advance

7

mobhar wrote:

You may use > Master/Detail Add > to implement this business-logic. Please read > Tutorials > → > Master/Detail > topic from PHPMaker Help menu for more info and example.