NetLoan - Unsync Transactions (Dynamic Installment)

Overview

The Unsync Transactions feature removes the synced state of selected loans for a specific accounting period. It deletes the schedule lines, journal entries, and related records that were created when transactions were synced, but the underlying transactions themselves are preserved and can be re-synced after corrections are made.

This is different from the Time Machine, which deletes journal entries from a chosen period forward across the full amortization schedule. Unsync Transactions is more targeted: you use a period to filter which loans appear, then select only the loans you want to affect.

What Gets Removed During Unsync

After the schedule lines are removed, the loan's current balance is reset to the ending balance of the prior period. The underlying transactions (payments, draws, fees, etc.) remain in NetSuite and can be re-synced once any corrections are made.

Step by Step Process

1. Navigate to Transaction Sync

Go to NetLoan > Mass Update Loans > Sync Transactions or click the Sync Transactions button on a loan record.

View full size

2. Set the Action to Unsync Transactions

In the Action dropdown, select Unsync Transactions. The page title, sublist, and submit button will update to reflect unsync mode.

View full size

3. Select a Period

Use the Period field to choose an accounting period. This filters the Synced Transactions sublist to show only loans that have schedule lines with period end dates falling within that period. It does not automatically select or affect any loans — it is a filter only.

View full size

You can further narrow the list using the Subsidiary, Lender, Loan Type, and Loan filters.

4. Select the Loans to Unsync

Check the box next to each loan you want to unsync. Use Mark All to select every loan on the current page, or check loans individually. 

5. Submit and Confirm

Click Unsync. A confirmation prompt will appear:

• Single loan: Type CONFIRM and click OK.
• Multiple loans: Enter the exact number of selected loans (e.g., 3) and click OK.

View full size

If you cancel or enter an incorrect value, the job will not be submitted. 

6. Monitor the Job

The system submits a background map/reduce job. You will be redirected to a progress screen. Wait for the job to complete before re-syncing.

What Special Behavior for Overpayment

When a payment that exceeded the loan balance was originally synced, the system split that transaction into two lines: 

1. A payment line applied to the remaining balance
2. An overpayment line linked to an overpayment payment request

During unsync, this split is reversed: 

1. The two amounts are recombined back onto the original transaction line
2. The split overpayment line and its associated overpayment payment request are deleted

This restores the original transaction to its pre-sync state so it can be resynced correctly.

Frequently Asked Questions

Can I re-sync after unsyncing?

Yes. The underlying transactions are not deleted. Once the schedule lines are removed and any corrections are made, navigate back to the Sync Transactions page (in Sync mode) and re-sync the affected loans. 

Can I unsync a single transaction without affecting the whole period? 

No. Unsync operates at the period level for each selected loan — all schedule lines within the selected period for that loan will be removed.

What is the difference between Unsync Transactions and Time Machine? 

Time Machine deletes journal entries from a chosen period forward across the full amortization schedule, typically used for bulk corrections or re-runs. Unsync Transactions is more targeted: you select specific loans and remove their synced state for a single period, leaving all other periods intact.

What happens if I confirm the wrong number of loans? 

The prompt will not proceed, and no job will be submitted. You can re-enter the correct number and resubmit.