Ditutup

Stock and ledger for retail shop - repost

Table:

1. Maintable: Itemcode, Totalstock, Itemname, Unit (KG, Litre, ml, Number etc.), Model, Brand, Origin, Purchaserate, Transportationcost, Othercost, Purchasevalue (Purchaserate + Transporationcost + Othercost), Remarks

(Maintable is the main stock table where preserve the all items stock)

2. Selltable: Itemname, Model, Brand, Origin, Salerate, Quantity, Totalprice, Payment (full pay or due), Remarks

(Subtable, where I want to preserve item wise sell record- any time I want to see the sell status it may by day, month year. Keep your mind, one customer may purchase more than one item at a time)

3. Customertable: Customercode, Customername, Customerphone, Customeraddress, PurchaseItem, Purchasequantity, Purchasedate, Remarks

(From this table I want to preserve customer information. From where I want to see- which customer purchase which item and It was paid cash or by check or credit (not credit card). Customer may not pay me full at the time of purchase, next time I want to see, which customer is in due.

You may prepare table 2 and 3 within one table but I want those information.

Form:

1. Mainform: All information of table 1 will make input here.

2. Subform: At the time of sell the item to customer, I will entry only item code, all other information of table 2 automatically entry in table 2. I will entry item quantity, if any discount I will mentioned here. VAT will charge to customer. After complete the entry rate wise total price will show in the form.

Key for the software

1. Stock entry (table 1) when any item will store (stock in) I will entry here (Keep your mind - after sell some item may in my shop e.g. Before stock end I will stock more)

2. Sell (table 2): I will click here and a sell form open- First I will entry Customer name, phone # and address then entry Item. (After entry complete, number of item will deduct from main stock (Maintable- Totalstock))

3. Print: After sell item entry I will take print it in my printed bill. If the customer not pay me full due amount will mention in the bill. After some days customer will pay me the due amount; so, I need an option for recall the sell item here (it may based on voucher/bill number or customer number) and adjust the due amount. Amount may no full, in that case rest amount will preserve in the database. It may happen repeatedly.

4. Print will be in my retail store's printed bill so page setup is important here.

All the options mentioned here are not fixed, it may need to update after test the software.

You have to make this software using MS Access. You may use VB code and SQL (Access) other languages are discourage to bid. Only low bid will awarded the project

All Bidders are requested to BID further.

Kemahiran: Microsoft Access, Visual Basic

Lihat lebih lanjut: stock entry project access, print item ledger, stock ledger database access, code ledger access, stock project access, stock ledger access, retail shop stock ledger, voucher entry, voucher discount, model brand, store ledger access, stock entry software access, vat number check, vat charge, test case software, microsoft project price, microsoft access test, access subform, wise setup, vat payment, stock update, retail software, phone shop, ledger, credit shop

Tentang Majikan:
( 0 ulasan ) Bangladesh

ID Projek: #4095031

22 pekerja bebas membida secara purata $123 untuk pekerjaan ini

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$215 USD dalam 10 hari
(620 Ulasan)
7.1
customizedata

I have gone through all points. I am certified MS Access developer. Should i use vb.net / MS access or just MS access.Both options are ok with me.Accept and we start right away

$140 USD dalam 10 hari
(52 Ulasan)
5.0
infoshree80

Having more than 12 yrs of experience in Ms access and VB,sql I have done this type of project before. Please check PM

$145 USD dalam 20 hari
(17 Ulasan)
4.9
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$110 USD dalam 10 hari
(14 Ulasan)
4.9
AmirAly

Greetings sir , kindly Check PMB

$100 USD dalam 10 hari
(14 Ulasan)
4.7
haseebhm

Experienced in VBA and Access specially in applications of this type. I have developed many sales inventory databases of this type.

$100 USD dalam 4 hari
(4 Ulasan)
3.1
nibiranijum

Hi, I am database expert with more than 5/6 years of experience. I also worked for accounting software. I can build this software in perfect way. Please see my relevant projects in my profile. Rgds, Shafiq.

$125 USD dalam 6 hari
(2 Ulasan)
3.0
srdas2012

We are Expert in VB.

$95 USD dalam 15 hari
(6 Ulasan)
2.6
tuanhuynh

Hi, I'm very excited about this project. Hopefully soon be able to participate !

$100 USD dalam 5 hari
(1 Ulasan)
2.2
romimardiansl

i am clearly what you want. i can start now.

$50 USD dalam 10 hari
(1 Ulasan)
1.0
onlyLekha

Will provide initial copy within 3 days.

$75 USD dalam 5 hari
(0 Ulasan)
0.0
ZhiZhang

hi I have ten years experience on MS Access. I have done seven Access DB for client in 2012 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Btw: I were MVP about Micr Lagi

$220 USD dalam 5 hari
(0 Ulasan)
0.0
Pharoa

Thank you for the opportunity to bid on your project. We have a full featured Accounting Software - FinancialWorld(tm) Accounting Software that is specially custom-designed for Retail Store and Merchandising compan Lagi

$200 USD dalam 30 hari
(0 Ulasan)
2.8
minhas760

Hi! Please! have a look into private box for details. Thanks

$150 USD dalam 5 hari
(0 Ulasan)
0.0
divyasavi

yes i can make it.

$100 USD dalam 20 hari
(0 Ulasan)
0.0
surequality

Hello sujanalittle, i am the freelancer since last 10 year doing such customize software development. Quality of work and service is my main strength. The project is ready with me which developed in VB and fulfill al Lagi

$115 USD dalam 7 hari
(0 Ulasan)
0.0
annazreen

dear sir/madam i have work in a software solution company.we have solved more than 45 projects.i ensure we can give a better solution for you. regards annazreen

$200 USD dalam 15 hari
(0 Ulasan)
0.0
sureshjyothijv

I am ready, see

$50 USD dalam 10 hari
(0 Ulasan)
0.0
momtazdhaka

I AM ONE OF THE TOP 10% VB EXPERTS AROUND THE WORLD!! I AM NEW TO FREELANCER BUT I HAVE ACCOMPLISHED SEVERAL JOBS ON ODESK.COM I HAVE DEVELOPED SEVERAL SIMILAR JOBS WHICH ARE BEING USED AT 27 POINT OF SALES ALL O Lagi

$150 USD dalam 21 hari
(0 Ulasan)
0.0
mansooralivw

hi, I am working in MS technologies (esp. VB since 10 years). have a great experience integrating apps with DB. we can complete the project with your full expectations within a stipulated time frame. thanks Lagi

$125 USD dalam 10 hari
(0 Ulasan)
0.0