simple access database

I need an access database made that is used to track inventory receiving.

An employee would open a form to create a new record where they would enter the Purchase Order # and Date and then for each item:

• The Qty.

• The SKU (limited to SKU table)

• The Warehouse Location(limited to Warehouse Location table)

• Cost

When the SKU is entered, a notes field would fill in to the right with notes about that SKU like specific damage to check for. This data would come from a separate two column table with an SKU and NOTES columns.

I would then need a button to print barcode labels based on that data, where each label would have the SKU, the PO#, the Date, and the Warehouse location printed on the label, and the Qty. field would determine how many of each label to print. It may require something like this, but not sure ?: [url removed, login to view]

When printing, it would be good to have an option to print only selected lines. This would be handy in the event someone entered a SKU wrong, we wouldn't want to print all the labels over again, just the ones that needed corrected.

I also need another button that the user can press once they are done printing labels that will sort of freeze the data and email the received materials list as an excel spreadsheet.

Past PO# records would need to be easily looked up.

I'll also need a similar form created to perform counting for inventory transfers. This form will have 3 coulmns:

• The SKU (limited to SKU table)

• The OLD Warehouse Location (limited to Warehouse Location table)

• The NEW Warehouse Location (limited to Warehouse Location table)

This table will not have a Qty. field on it, Instead each line will be assumed qty. 1 and the SKU may repeat several times in different rows. Lines where all 3 columns match will be totaled and the # of labels printed will be based off of those totals.

Ive attached a picture of the barcode label we need to come close to and also a sample database with SKU, Warehouse Location, and Notes data.

Beceriler: Microsoft Access

Daha fazlasını gör: access database warehouse, sample received form, purchase order form excel, inventory receiving form, i need an access database, excel spreadsheet to labels, warehouse inventory, sku inventory, printing press, create similar access, c# with access database, c with access database, access database, database employee, simple notes database, create purchase order, excel sort date, create access database spreadsheet, barcode based inventory access, excel access table, simple check date, excel print barcode, access 2013 button print form, event spreadsheet, simple access order database

İşveren Hakkında:
( 9 değerlendirme ) Jackson, United States

Proje NO: #4395734



Hi, I am a developer with over 22 years experience building complex database systems and could do this project to your specification. My application would come with a royality free ActiveX barcode control that would on Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 175%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)

Bu iş için 4 freelancer ortalamada $168 teklif veriyor


Please, See my private Message.

in %bids___i_period_sub_35% gün içinde168%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Will provide you with quality [url removed, login to view]

in %bids___i_period_sub_35% gün içinde149%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I have more than nine years experience in Database Administration and Development. I have previous experience in Inventory management system development. Thanks.

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)