The GST/HST GL File Update program initializes certain fields in the general ledger file (BAGL00.DAT). The program allows you to set the percent exemption field (GL.GSTPCTEX%) and tax code field (GL.GSTTAX$) in each GL record. GL records are selected in the same manner as those selected in the atrieveFinance Report Writer.
We suggest that you run one pass of all GL accounts setting the GST/HST exemption to 100% and the GST/HST tax code to the default code.
You will need to supply the following information:
GL Year
-
The program will only affect the GL records for the specified year. This year defaults to the current year defined in the atrieveFinance Master Profile. You can change this factor to adjust the proper year.
GST/HST Exemption Percentage
-
Enter the percent exempt to be applied to the GL records selected at a later step. Any whole number may be used.
GST/HST Tax Table Code
-
Enter the tax table code for GST/HST to be associated with the selected GL's.
Selection Criteria Screens
The process of selecting desired GL accounts and account ranges is identical to the procedures used for the report writer in atrieveFinance. Please refer to this documentation if not familiar with the selection criteria.
Note: You MUST specify selection criteria. If you do not, no records will be selected for processing. The exception is the field initialization to zero. If 'Y' is entered, ALL GL records will be initialized to zero.
Begin Processing
You will also be prompted to run the process in preliminary or final mode. Preliminary mode will provide a report only; updates will not be done. Run the process in final mode in order to update the GL accounts.