Welcome to the software you've always wanted...

Nov 10

2010

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.

RSS Feed

No comments yet.

Leave a comment!

Follow Me on Pinterest
To top