In FACTS 9.0 a new API was created to import G/L entries to support integrations to systems with a financial impact. The Import GL Entries API was created using the 3-level entry type API. Out of balance entries are either rejected or balanced to the out-of-balance account based on the new setting in G/L Static Control F/M (GLF975). A new alert, Imported G/L Transactions (ALC133), was created to indicate when G/L Files get updated from the API for visibility reasons.
These conditions apply regarding the API.
This has a future use of enabling an interface to a 3rd-party payroll product.
These programs were enhanced or created for the new API and alert program.
The GL Static Control FM (GLF925) program was updated to contain a new API Settings tab, which allows you to specify the default journal and memo to use for imported journal entries, when not provided by the API, as well as a setting to indicate whether to automatically balance or reject unbalanced imported entries.
The Imported G/L Transactions Alert (Alert Code: GL-IMPORT) is called/recorded when a G/L Transaction is imported using the API. You can access the Alert Control Center to view and optionally dismiss this alert. The Imported G/L Transactions alert is sent to provide visibility that the import occurred and the transaction can be viewed in G/L Journal Inquiry, provided the user has security to access this program.
A new program, GLC115) was created for any API specific procedures for these processes.
These changes were made to Journal Entry Header procedures to handle running in background.
The Reference Number entry and display fields, where possible, were expanded to 30 characters wide throughout FACTS.
The technical changes for this enhancement are listed in the Infor Distribution FACTS 9.0.0 Release Overview located on inforxtreme.com.
Recurring Invoice Listing (ARR120) has been widened to print the 30-character reference number.
Estimate Entry (JCE110) was changed for the longer reference #.
Job Entry (JCE210) was changed for the longer reference #.
Work Ticket Print (SRP210) was changed for the longer reference number.
These additional defects and programs were also enhanced to include the 30-character reference number expansion.
AR Invoice Print (ARP110)–Expand reference number (Defect 519045)
JC Estimate Print (JCP110)–Expand reference number (Defect 519046)
JC Invoice Print (JCP410)–Expand reference number from 15 to 30 characters (Defect 519047)
Blanket Order Acknowledgment (SOP710)–Expand reference number 15 to 30 characters (Defect 519053)
Returns Authorization (SOP820)–Expand reference number 15 to 30 characters (Defect 519055)
SO Quote–expand reference number 15 to 30 characters on printed output (Defect 519057)
Job Listing (JCR710)–Additional changes for 30 char reference numbers (Defect 492517)
With the addition of the ARRSLP file and an alternate key based on Region, the ARRGNX cross reference file is no longer needed. All references to ARRGNX were replaced with alternate key 1 of the new ARSLSP file when necessary. Programs that wrote or removed records to or from ARRGNX have had the code removed (ARF935). Programs that read ARRGNX for validation were replaced with ARSLSP, key 1 (ARF950). Programs that used ARRGNX for a sort order were replaced with ARSLSP, key 1 (ARR725, ARR726). ARU990 no longer rebuilds the ARRGNX sort file.
Conversion of "SMR" control record to SMBRCH file (Defect 495774)
The SMR control record was converted to a new file, SMBRCH. The following changes were made for this modification:
Note that ODBC and variable names remain the same in the new layout; field number remains the same for non-key zero fields.
call/enter list: branch_code$,branch_desc$,branch_bank$,dom_err_flag.
This routine always opens and closes the channel to SMBRCH.
A new background process, Rebuild Sort Files (S2), was added to FACTS 9.0.0. Currently, S2 only handles AR, AP, and MC Sort Files. Rebuild Sort Files (S2) will be expanded to other modules later, eventually eliminating all rebuild sort file programs. The default is to run this monthly on the 15th of the month, at 1AM. The S2 background process rebuilds the sort files in place, eliminating the need to lock the source files during the rebuild.
The following programs were replaced by S2 and removed from the FACTS system: Rebuild AR Sort Files (ARU990), Rebuild AP Sort Files (APU990) and Rebuild MC Sort Files (MCU990).
The String Template Creator (DOU110) program has been enhanced and renamed to "DO Code Generator". It has been rewritten to include:
• String Templates
• IO Programs
• ION XSDs (XML schemas)
The DO Code Generator can be run by selected modules or selected files. To enter multiple modules or files, separate them by either spaces or commas.
The Item Search includes a check box option whether to exclude inactive items. Previously, the Exclude Inactive Items check box was always defaulted to checked (exclude inactive items). Now, when you select Options>Save Filter Values or Options>Preferences>Save as User Defaults, the current setting of the 'Exclude Inactive Items' check box is saved. When you access the item search again, the saved value will display as the new default.
Previously the length of the description that printed was limited based on the length of the item number you printed. Now, both the full item number and the full description will print on these documents.
Refer to the Sales Orders and Purchase Orders for Enhancement by Module details.
The Where Used feature is based on metadata, and will be expanded to include other types of data in the near future.
Custom data, if defined properly in DO, will be included here as well.
Additionally, for Item F/M (ICF910), when you select in the F/M to delete an item, it will report all occurrences of the item which prevent its deletion.
A new FACTS API was created to create quotes for the ION model. It has an added benefit of, in the future, allowing us to support quotes in Storefront.