Skip to main content
Skip table of contents

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: 

  1. Packing Slip
  2. Freight Bill
  3. Carrier
  4. PO number
  5. PO Item number
  6. Quantity Received
  7. Fixed Asset ID
  8. Lot Number
  9. Serial Number
  10. Expiration Date
  11. Tag Number

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

Translation

  1. Packing Slip: PS123
  2. Freight Bill: FB222
  3. Carrier: this field is blank
  4. PO number: PR67261233
  5. PO Item number: 0001
  6. Quantity Received: 17
  7. Fixed Asset ID: FAID123
  8. Lot Number: this field is blank
  9. Serial Number: this field is blank
  10. Expiration Date: this field is blank
  11. 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.