GL Administrator Extract for F9 Report ranges and options

Ranges

If you run this report daily as a stored report and select Unmarked for the (M)arked, (U)nmarked, or (B)oth option, you do not have to specify any ranges. If you select Marked or Both, specify a journal number range to indicate which journals you want to resend to Infor F9.

If you are extracting transactions by selecting Yes for option 5, Extract Transactions - GLET, you can specify a period across two fiscal years in Journal # for Transactions; for example, Dec 2017 to Feb 2018. The range you specify here overrides any value, or the default, specified in option 2, Fiscal Year (Blank - current year). If you are using option 5, we recommend you do not specify a range for both Period for Transactions and Journal # for Transactions. If the two ranges do not overlap, no transactions would be selected.

Options

Directory for Output (Blank - print dir)

In on-premises Distribution SX.e, you can specify a directory in which to save the generated files. If you leave this option blank, the files are saved to the Print Directory that is specified in SA Company Setup.

In CloudSuite Distribution, leave this option blank.

Fiscal Year (Blank - current year)

Specify the fiscal year in which account balances, budget balances, and GL transactions to be extracted have occurred.

Extract Summary Accounts - GLSA?

Select Yes to extract account information to the f9s<cono>.txt file. This option uses the fiscal year specified in option 2, Fiscal Year (Blank - current year).

Extract Summary Budgets - GLSB?

Select Yes to extract budget information to the f9s<cono>.txt file. This option uses the fiscal year specified in option 2, Fiscal Year (Blank - current year).

Extract Transactions - GLET?

Select Yes to extract transaction information to the f9t<cono>.txt file. Uses date range specified in Period for Transactions, which overrides the fiscal year specified in option 2, Fiscal Year (Blank - current year).

(M)arked, (U)nmarked, or (B)oth

Records are marked as sent when they are extracted by the report.

Select M to extract only those records previously sent to F9.

Note: If you run Infor F9 and previously used Microsoft FRx, the (M)arked option is the same extracted date as set up in SA Journal Setup.

Select U to extract only those records that have not been sent to Infor F9. Select this option if you run this report daily as a stored report.

Select B to extract both unmarked and marked records.

Extract Codes - SASTT D and V?

Select Yes to include the codes for departments (D) and divisions (V) for records.

FTP Files Now?

In on-premises Distribution SX.e, select Yes to run scripts that save the flat files to the Print Directory that is specified in SA Company Setup or the directory specified in Directory for Output option.

In CloudSuite Distribution, this option does not affect flat file generation.