Develop a MS Access? Application
?
All below heads should also include some custom fields.
a. Master Style Details: Showing Style #, Colors, Sizes, Style Description, JPEG/GIF/TIF Picture, Prices.
b. Master Customers, Vendors, Colors, Sizes.
c. Master Mode of Shipment
d. Master Salesman
e. Purchase Order (PO): Showing styles placed with the factories by color, size and price, delivery dates x-factory, mode of shipment. Once the goods are shipped by the factory, the database should reduce qty's shipped by the factory and show the final quantities pending. Once shipped complete, we should be able to close the PO.
f. Shipment details: Factories make consolidated shipments, which cosists of different PO's, Style #'s, Colors and Sizes.
g. Sales Order (SO): Showing styles placed by our customers. Quantities shipped to them and balance pending. Once shipped complete, we should be able to close the SO
h. Invoicing: Goods shipped to the customer, showing style, quantities by size, color, Mode of shipment, salesman, total qty i. Packing List of the goods shipped to the customer with Barcode feature. We already have this feature with us and we shall give it to the person, who we select for our project.
j. Reports: Basic reports based on each of the above module, Sales, Purchasing, Shipments, We should be able to customize our reports based on our requirement, using crystal reports or similar application.
A good idea of what we are looking for can be viewed at [[login to view URL]][1]
Only sincere candidates with very strong MS Access skills, apply for this project