Running an Integrity Check in JSI

Running an Integrity Check in JSI

Table of Contents

  1. Introduction

  2. To Run the Payables Integrity Check

  3. To Run the Ledger Integrity Check

  4. To Run the Wages Integrity Check

    1. By Department

    2. Job Code

    3. By Employee(s)

Introduction

If there is a crash in the system due to an interuption in power or any other incident, it is possible that all or some data tables
were unable to update successfully. This crash can then cause incorrect reporting on reports. The following wiki explains how
to run an integrity check that will recalculate the transactions in each of the files and ensure that all the values are correct after
a crash occurs.
Note: this procedure should be done after completing a reorganization of the files.

 

To Run the Payables Integrity Check

In the main JSI menu, go to:

  • Utilities

  • Reorganize Files

  • Integrity Check

  • Payables

Select "All Vendors."

Click on Proceed.

Once completed, a message will appear to inform the user that the tables have been updated.

Click on "Ok."

If the system finds an out of balance, a message will display with the option to print the log.

For each of the vendors listed in this report, the user should verify the account for accuracy.  Go to Payables -> Vendor File -> Inquiry and confirm that the account is correct.

This is an indication that there was a problem when the transaction(s) were entered. 

       

 

To Run the Ledger Integrity Check

In the main JSI menu, go to:

  • Utilities

  • Reorganize Files

  • Integrity Check

  • Ledger

 

Select "All Accounts."

Begin with Last Year and then Current Year to ensure that both years' values have been updated correctly.

Click on "Last Year/Actual."

Enter the period 0. If a period other than 0 is entered, the program will only run an integrity check for that period. Entering a period of 0 will run an integrity check for all periods.

Click on "Proceed."

Repeat the process again except select "Cur. Year/Actual".   

Reports should now be re-run to confirm the values are correct.

 

To Run the Wages Integrity Check

In the main JSI menu, go to:

  • Utilities

  • Reorganize Files

  • Integrity Check

  • Wages

 

By Department

Select the "By Department" tab.

Select "All Departments."

Enter the appropriate range of pay periods to be recalculated.

Click on "Proceed."

Once completed, a message will appear to inform the user that the tables have been updated.

Click on "Ok."

                             

 

Job Code

Select the "By Job Code" tab.

Select "All Job Codes."

Enter the appropriate range of pay periods to be recalcuated.

Click on "Proceed."

Once completed, a message will appear to inform the user that the tables have been updated.

Click on "Ok."

 



By Employee(s)

Select the "By Employee(s) tab.

Select "All Employees."

Enter the appropriate range of pay periods to be recalculated.

Click on "Proceed."

Once completed, a message will appear to inform the user that the tables have been updated.

Click on "Ok."


    • Related Articles

    • Running a Reindex in JSI

      Table of Contents Introduction Setup Introduction If there is a crash in the system due to an interruption in power or any other incident that affects your processing, it is possible that all or some data tables were unable to update successfully. ...
    • Running a Rebalance on Orders to Style

      Introduction Because the cut and sold screen is the last program to be updated when a transaction is created in JAS, it can occur where the file did not successfully update. If ever there is a discrepancy in this screen, an "Orders to Styles" ...
    • Month-End Closing Procedures for AP in JSI

      Table of Contents Introduction: Suggested Reports for Month-End Payables Balancing: Payables Taxes/Freight Aged Trial Balance Ledger Listing Reports: Adjustments and Write-Off Adjustment Adjustment Report: Write-Off Adjustments: Ledger Reports: ...
    • Accounts Payable - Void a Check

      Introduction The following wiki explains how to void a check in VJSI. Setup In the main VJSI menu, go to: Payables Invoice Payment Void a Check Enter the appropriate check number. Select the appropriate information; click on "Update". The posting ...
    • Changing a GL account number in JSI and its history

      Table of Contents Introduction Setup Introduction The following document explains how to change a GL account number in JSI. It is important to note that  this function will run though ALL the files that have these existing numbers which includes the ...