Excel for scanning SC and maintenance of residues
Employer
[no-member:pro]Михаил[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentprepayment is possible
Payment methodsBank transfer
Acceptance of requestsfrom 2019-05-12 until 2019-05-19
Project description
Programmer services are required. I am only considering working with Yur. person (preferably IP).
It is necessary to create a simple database in excel with dop. Functional for creating a sheet with data.
The essence: warehouse with 6000 pallets (20 articles) of goods. Pallet-only accounting
Functional requirements:
Arrival of cargo: form of data entry. Introduces the number of the invoice (physically scanned SC from the document, the scanner after reading the number of the invoice sends "enter" , i.e. On the key "enter" is the transition to the next field input, the driver's name, the number of received articles (affects the number of lines in the act and the number of inputs of the article itself (see). Further), the article is introduced and for each entry, the number of pallets, the number of pallets with marriage, the number of defective pieces. . In the sheet with the remains, lines are created indicating the date (today (), the number of the invoice, the article and the number of pallets, the number of pallets with marriage, the number of units.
Data on the number of the bill of lading, the driver's name, the article of marriage, the number of pallets of marriage and the number of units of marriage are substituted in fixed fields of the sheet "act", which is then printed (to store the sheet for each parish is not necessary, it is enough to print).
Shipment: The form of data entry. It is simply the article, the number of pallets. In the sheet with the remains, a line is created indicating the date (today()), the number of the article and the number of pallets (with the sign “"-"), a sheet is created in a new book for scanning barcodes with batches of pallets. In the scan sheet, fixed fields are filled in according to the template, data is entered starting from the 20th line in the columns "d" and "e"" (the number of scans depends on the number of pallets, 2 barcodes must be scanned on each pallet). Input form: pallet number (scanner reads value and emulates "enter" - transition to the next field), the barcode of the batch (leftsimve() / pravsimve() to isolate 6 digits in the middle of the 20-digit code, the scanner reads the 20-digit code and emulates "enter" - the transition back to scanning the pallet number or the completion of the scan, if the specified number is reached).
It's all a task.
It is necessary to create a simple database in excel with dop. Functional for creating a sheet with data.
The essence: warehouse with 6000 pallets (20 articles) of goods. Pallet-only accounting
Functional requirements:
Arrival of cargo: form of data entry. Introduces the number of the invoice (physically scanned SC from the document, the scanner after reading the number of the invoice sends "enter" , i.e. On the key "enter" is the transition to the next field input, the driver's name, the number of received articles (affects the number of lines in the act and the number of inputs of the article itself (see). Further), the article is introduced and for each entry, the number of pallets, the number of pallets with marriage, the number of defective pieces. . In the sheet with the remains, lines are created indicating the date (today (), the number of the invoice, the article and the number of pallets, the number of pallets with marriage, the number of units.
Data on the number of the bill of lading, the driver's name, the article of marriage, the number of pallets of marriage and the number of units of marriage are substituted in fixed fields of the sheet "act", which is then printed (to store the sheet for each parish is not necessary, it is enough to print).
Shipment: The form of data entry. It is simply the article, the number of pallets. In the sheet with the remains, a line is created indicating the date (today()), the number of the article and the number of pallets (with the sign “"-"), a sheet is created in a new book for scanning barcodes with batches of pallets. In the scan sheet, fixed fields are filled in according to the template, data is entered starting from the 20th line in the columns "d" and "e"" (the number of scans depends on the number of pallets, 2 barcodes must be scanned on each pallet). Input form: pallet number (scanner reads value and emulates "enter" - transition to the next field), the barcode of the batch (leftsimve() / pravsimve() to isolate 6 digits in the middle of the 20-digit code, the scanner reads the 20-digit code and emulates "enter" - the transition back to scanning the pallet number or the completion of the scan, if the specified number is reached).
It's all a task.
