MAS90™ is the trademark for copyright software belonging to Sage Software, Inc™.
Create the Import Data File from MAS90
Go to Reports.
Go to the General Ledger section.
Select General Ledger DetailBy Source Report.
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
Click Export (the small envelope icon in upper left corner, next to Print).
Select MS Excel 97-2000 (data only) as format type.
Accept default on Excel Format options.
Enter File Name (enter Co Name – YYYY-MM in front of System-supplied filename).
Select file location.
Importing to FCA™
Select Write Up>Import Transactions>MAS90.
Browse to and select the desired file.
Set the date range of the transactions.
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.
Click OK to import the data.
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.
Article is closed for comments.