Please see to attachment for details of Easy billing software using barcode.
Easy Billing Requirement Document
Firstly, Watever stock (no. of items) come to shop will be added to system.
Add Stock-Wholeseller Bill wise entry in system.
Wholeseller bill format- Quantity of item, Variety Name, Wholesale Price and Amount.
Then finally, total amount.
Add/Edit/View/Delete stock option should also be there.
How to calculate No. of item:
If bill no. 243 has 2 varieties with quantity 10 and 20 respectively.
Then No. of item = 10 + 20 = 30 items
Generation of 3 tags for each item.
Every item will have one unique no. and corresponding to it will be one unique BARCODE.
BARCODE will have following information : unique item no. , Our code and SP
Our code-AANHHHDDMMRRXXXPP(Alpha Numeric and is configurable by the user) where
Stock entry in DB of all unique Nos. generated.
Also, unique no. wise item entry in DB.
Billing using Barcode –
System should be intelligent enough to take care of following situation.
Barcode is tried entered twice. It will take it as one entry only.
Also warn the user.
If two items have same Selling Price (although different barcode), then system should add automatically 1 to previous one quantity in the bill.
No. of bill copies : 2 copies.
Bill Copy Size : 1 A4 size paper should have 4 bills.
Bill format : Bill should have Unique bill no.,Date, Time, Salesman Code, Customer name, Customer phone no., item unique no., quantity, SP(editable), Discount, Amount.
Net payable amount, Amount Paid, Balance amount
DB should also maintain Unique Item No. wise entry corresponding to which entry of every sold item will be updated by date, time and amount sold, customer name and number (if any)
Returned/Exchange Bill Option :Daily Sale Report. (Password protection is required)
Monthly Sale Report. (Password protection is required)
Datewise profit report. (Password protection is required)
Party wise monthly Bill report. (Password protection is required)
GR -> Goods returned to the party.
In this case, bill should contain actual wholesale instead of DP.
Rest process is same as for billing.
Stock Verification ->
When verifying stock, a screen should open with all items currently present at counter as per the system (with one CHECKBOX in front of every item)
Now, user will start scanning BARCODE of actual item present at counter.
As soon as system find that item in its list, a tick will appear in corresponding item.
If actual item is not present in system list, system should make an new entry for that item with red color in its list.
At the end, all the missing item (which donot have tick in their checkbox) will become DARK RED showing as missing.
System should be intelligent to tell if two items (actual one) has same BARCODE by mistake.
Final report will have all MISSING/EXTRA items details.
After verification, missing item will be updated as SOLD/MISSED in DB and EXTRA will be added/updated accordingly.
BARCODE Configuration ->
System should provide us a way to change Barcode later also.
Tag Generation ->
Apart from tag generated at time of bill enetered, system should provide way to generate duplicate tags with barcode later also.
UI should have big fonts preferably HINDI with easy to use (less click required i.e. can be operated by TABS also and sub menu also on main screen itself in the form of big buttons)
Buttons can also be selected by pressing 1/2/3…
Offers handling – There are few offers which needs to be taken care at time of making bill-
1. If customer purchase any item ranging from 550, 665, 765, 865, 965 then one item of Rs. 265 will be free.
2. If customer is not taking free item, then Rs.200 will be deducted from the above amount.
3. This offer can be removed as per the wish of shopkeeper.
4. If customer purchases any item in range 1000 or above, then a discount will be given to customer. Default value of discount is 15% which is editable.
Additional Project Description:
03/06/2013 at 2:01 IST
Email Send whenever any billing occur and at sale opening and closing time
SMS send whenever any bill occur and at sale opening and closing time