2010
Sage MAS 90 Bar Code Receipt of Goods Import
0 Comments | Posted by Heather in Sage MAS 200, Sage MAS 90, Sage MAS 90 Toolbox
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.












