Upload Receiving from Bar Code - POUTBC

Overview

This process will create PO receiving records from a flat file downloaded from the BMI barcode scanner. Information can also be recorded into the Stores Inventory and Fixed Asset subsystems if configured to do so.

Scanner File

The barcode file record length must be 200 bytes in length and reside in the data directory. There must be 10 fields in each data record separated by a delimiting character. The field order in each record must be as follows:

Packing Slip
Freight Bill
Carrier
PO number
PO Item number
Quantity Received
Fixed Asset ID
Lot Number
Serial Number
Expiration Date
Tag Number

Sample record: PS123|FB222||PR67261233|1|17|FAID123||||TAG1234

Translation

Packing Slip: PS123
Freight Bill: FB222
Carrier: this field is blank
PO number: PR67261233
PO Item number: 0001
Quantity Received: 17
Fixed Asset ID: FAID123
Lot Number: this field is blank
Serial Number: this field is blank
Expiration Date: this field is blank
Tag Number TAG1234

Fields 4, 5 and 6 are required fields.

Stores Inventory Receiving

The receiving information will be written to the Stores Inventory subsystem when the product being received is defined in PEUPPR as stocked. The warehouse on the PO item record will be the receiving warehouse. If no warehouse is specified on the PO item record, all warehouses will be searched. If a single warehouse stocking the product is found, that warehouse will be used as the receiving warehouse. No assumption is made as to which warehouse will receive the product if stocked in multiple warehouses.

Fixed Asset Generation

A record will be written to the Fixed Asset subsystem when the "FA" flag on the PO item record is "Y." If the Fixed Asset ID from the scanner file is blank, the system will generate the ID.

POUTBC Questions

Enter the name of the scan file: Enter the name of the 200-byte, delimited scanner file, which resides in the data directory.
Receiving date: Defaults to today's date.
This date will be used as the reference date when writing the PO receiving record and the SI transaction record.
Trial Run? (Y/N): Reports will be produced but no updates are performed when run in trial mode. The default is to run in trial mode.