Sage MAS 90 Bar Code Receipt of Goods Import

The Sage MAS 90 and MAS 200 Bar Code Module helps import transactions usually gathered with a scanner (although it’s not required).  While specific scanners are certainly recommended for use with the module, any scanner will do as long as it produces a text file in the appropriate format.

The file must meet the following requirements:

  • ASCII Text format
  • The file name must begin with a specific letter of the alphabet corresponding to the type of transaction records to be imported:
    • “B” for Bill of Materials Transactions
    • “I” for Inventory Transactions
    • “P” for Purchase Order Transactions (receipts or invoices)
    • S” for Sales Order Transactions  (invoices or shipments)
  • The file name should be in an “8.3″ file name format, ending with a *.ODB extension
    (e.g. – “ P1234567.ODB” for a purchase order receipt import file.)

The following table illustrates the ASCII import file format for Sage MAS 90 and MAS 200 Purchase Order Module Receipt of Goods and/or Receipt of Invoice transactions.   Note Records should be terminated with LF or LF/CR combination.   Note – a valid purchase order needs to already exist within Sage MAS 90 or MAS 200 in order for the receipt of goods data to be properly imported.

P/O Receipt of Goods Start Length
Receipt Type (hard code – “G”) 1 1
Receipt Date (YYMMDD format) 2 6
Purchase Order Number 8 7
Invoice Number (optional) 15 10
Invoice Date (YYMMDD format or blank if no invoice) 25 6
Item Number (or Miscellaneous Item Code) 31 15
Receipt Quantity (#####.0000) 46 10
Lot/Serial Number (if applicable) 56 15
PO Line # 71 5

*NOTE – For Version 4.40 (The length of the item number changed from 15 to 30 for expanded item codes), the import does not support the expanded item codes.