Use the Spreadsheet for Fiscal Attribute Corrections

During the Import AutoInvoice with Fiscal Attributes process, records that pass the validation are transferred to the Fiscal Attributes internal tables.

Records that fail the validation remain in the Fiscal Attributes interface tables. You must correct invalid data and run the Import AutoInvoice with Fiscal Attributes process again.

Each time you run the Import AutoInvoice with Fiscal Attributes process, the process generates a list of records that failed validation. You can display these validation errors as an Excel workbook by follow these steps:

1. From the Billing work area, navigate to the Spreadsheet for Fiscal Attribute Corrections task.
2. Enter the Business Unit, Entity Code, and Event Class of the fiscal attributes.
3. Click Submit.
4. Download the workbook.
5. Connect to the application.
6. Enter your login credentials.
7. Click Submit.
8. Every workbook has these worksheets, each corresponding to a Fiscal Attributes interface table:
   • Fiscal Attribute Headers: JG_FSCL_HDRS_ATRB_INT
   • Fiscal Attribute Header Details: JG_FSCL_HDR_DTLS_ATRB_INT
   • Fiscal Attribute Lines: JG_FSCL_LINES_ATRB_INT
   • Fiscal Attribute Line Details: JG_FSCL_LN_DTLS_ATRB_INT

   You can use the tools available in the workbook to manage the review and update of information.

9. The workbook is populated with the information from the Fiscal Attributes interface tables in this order:
10. You can this workbook only for updating or deleting existing records. You cannot enter new transaction information in this workbook. Each column in a given worksheet corresponds to the columns in the respective interface tables. These additional columns manage the processing of updates:
    • Changed: Tracks changes to a given row. The upload only processes rows marked in this column. Flagged: Indicates rows marked for deletion. When a row is marked for deletion, all the corresponding lines in all the related tables are also deleted.
    • Status: Displays the results of each update to the interface tables. Import Errors: Displays the import rejection reason.
11. You may change or delete records in the workbook and submit them any time. This action updates the corresponding records in the Fiscal Attributes interface tables.
12. Click Submit and run the Import AutoInvoice with Fiscal Attributes process again.