Nullifying a Sequence Number in JSI
Introduction
It can occur where a sequence was duplicated or created incorrectly in JSI due to a crash and needs to be removed. In JSI, sequences cannot be deleted in the General Ledger. If there is no corresponding transaction in the Payables and can't be corrected through the Payables, then there is a way to zero them out so that it appears to be deleted. The following document explains how to do this.
Setup
In JSI go to:
| |
Enter the sequence number. | |
A screen will appear showing the transactions belonging to that sequence number. In this example:
To offset this sequence, all of them must point to the same GL. Note that it doesn't matter which GL you choose.
| |
To do this double click on one of the lines for which you want to change the GL number. | |
Click "Modify". | |
Enter the account number that it should be changed to and click on "Update". | |
The new account number will now be listed. Repeat the process for all the other lines so that each line points to the same GL number. | |
Once completed, the transaction will be offset since the debits and the credits equate to 0 and are all pointing to the same GL account number. |
Related Articles
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 ...Out of Balance Sequence in Payables/Wages
Introduction The following wiki explains how to determine which sequence numbers in payables/wages are out of balance, as well as how to correct them. Finding the Out of Balance Sequence in Payables/Wages In the main JSI menu, go to: Utilities ...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: ...Using Foreign Exchange in JSI Payables
Introduction If Non-Canadian Vendors are entered in JSI, a default foreign exchange rate can be set up to automatically convert the Invoice and Payment values if not entering using absolute dollar. The following document explains how to set this up. ...Running an Integrity Check in JSI
Table of Contents Introduction To Run the Payables Integrity Check To Run the Ledger Integrity Check To Run the Wages Integrity Check By Department Job Code By Employee(s) Introduction If there is a crash in the system due to an interuption in power ...