MAS90

MAS90™ is the trademark for copyright software belonging to Sage Software, Inc™.

Create the Import Data File from MAS90

1. Go to Reports.
2. Go to the General Ledger section.
3. Select General Ledger Detail By Source Report.
   
4. Select the following:
   • Source Type = All
   • Print Comments = Full
   • Source Journal = All (or you can select various individual journals to import)
   • Journal/Register Number = All
   • Posting Date = Range (then enter beginning and ending date)
   • Source Mode = All
     
5. Click Preview.
6. Click Export (the small envelope icon in upper left corner, next to Print).
   
7. Select MS Excel 97-2000 (data only) as format type.
8. Click OK.
   
   
9. Accept default on Excel Format options.
10. Click OK.
    
11. Enter File Name (enter Co Name – YYYY-MM in front of System-supplied filename).
12. Select file location.
13. Click OK.
    

Importing to FCA™

1.  Select Write Up>Import Transactions>MAS90.
2. Browse to and select the desired file.
3. Set the date range of the transactions.
4. Map the client's accounts using the account map grid on the left side of the window by selecting the FCA Write Up account in the Map To column for each of the client's MAS90 accounts.
5. Click OK to import the data.
   
6. Select Import to multiple periods by dates if the export file created in MAS90 contains multiple months of transactions and the transactions are to be imported into multiple periods based upon the date of the transactions.
   
   

The following rules dictate how prior periods will be handled:

• If this option is selected when a MAS90 export file with multiple months (even several years) is being imported into a new (empty) FCA or PBM™ client file and the new client file was created with the current period more recent than the oldest period in the import file, then the program will automatically reset the opening balance period in the FCA or PBM client file and create all prior periods required by the MAS90 import file. All future periods will be created as required.
• If this option is selected when a MAS90 export file with multiple months (even several years) is being imported into a FCA or PBM client file that already has transactions and the earliest period is not as old as the first period in the MAS90 export file, then all months in the MAS90 export file that are prior to the first period in the file will be summarized into the Opening Balance period of the file. All future period entries will be created as required.
• If this option is NOT selected when a MAS90 export file with multiple months is being imported, all data will be imported into the current period regardless of dates.
  
  

• Cancel—Click the Cancel button to close the screen without importing.
• Print—Click Print to print the mapping as displayed in the grid. Due to printer variations, column widths do not print the same as they look on the screen. Use Options>Print Offset to adjust for these differences. 
• Fill Map—The program will look for accounts with the same Lookup as the account number in the file being imported and populate the Map To field with any matches.
• Export Map—Click Export Map to export the mapping displayed in the grid to a txt or csv file.
• Undo by Batch—To delete all transactions imported in a batch, select Writeup>Import Transactions>PBM or FCA. Select the Batch to be deleted in the Undo by batch field and select Undo. Batches that have been imported in prior periods cannot be undone.
• Batch—Each import will be assigned a unique Batch name that follows a similar formatting pattern. Batch MAS90 2020 5-1 indicates that the import is the first MAS90 import done in period 2 of 2020. If another file is imported in the same period using this import, the batch name would be MAS90 2020 5-2.

View Imported Transactions

1. Select Search Transactions from the Utilities menu.
2. Clear the Date fields.
3. Select the Batch from the Batch field drop-down list.

Additional filters may be set to zero in on particular transactions.