Hi
When trying to modify a lease, I see Reverse Journal > Create Lease Journal buttons, then it loops back to the same button.
I can see in the FAM Process Status, when I reached out to NetSuite Support Case # 6781150 - they said that there is zero payments on the lease.
Where can I find this on the lease and how can I correct it?
Tried both Production and Sandbox - System information from Sandbox:
I saw a related post with steps on how to the same issue which I tried below, but I no results returned for (A), thus I cannot proceed further.
https://community.oracle.com/netsuite/english/discussion/4504245/unable-to-modify-fam-lease?utm_source=community-search&utm_medium=organic-search&utm_term=unable+to+modify
A. Do a Transaction Search for Lease with Status = "Pending Process". Take note of the Internal ID.
- Go to Lists > Search > Saved Searches > New
- Click on Transaction
- Under Criteria tab add the following Filter:
- Type: Lease
- Status: Lease: Pending Process
B. Do a Saved Search for FAM Process Records and export to CSV.
- Go to Lists > Search > Saved Searches > New
- Click FAM Process
- Under Criteria tab add the following Filter:
- Process ID: is deactivatePayments
- Status: Failed - Under the Results tab:
-Sort by: PARAMETERS
-Columns: Internal Id, Parameters
C. Find and retain the rows with the Lease Internal IDs from #1 in the PARAMETERS column of the CSV labeled as leaseId (ex: "leaseId":"2142021").
- In the search you would be creating there would be two results, retain only row with Internal ID.
- Delete all the other rows.
D. Do an Update via CSV Import
- Go to Setup > Import/Export > Import CSV
- Import Type: Custom Records | Record Type: FAM Process
- Data Handling: Update
- Field Mapping:
- Internal ID: <from CSV>
- STATUS: Provided Default Value: Queued
- CURRENT STAGE STATUS: Set Value to NULL
- STATE VALUES: Set Value to NULL - Click Next > Enter Import Name
- Click Save & Run
E. After the CSV Import is completed:
- Go to Customization > Scripting > Scripts
- On the Filter > Select 508242 on Bundle Field
- Search for “FAM Trigger Process SS”
- Click “Deployments”
- Edit the "customdeploy_fam_triggerprocess_ss" deployment,
- Click "Save and Execute".
- The Process Manager should start processing the failed "deactivatePayments" process.
- Lease records processed will change its status to "Pending Lease Payments".
To verify:
- When there are no more queued "deactivatePayments" process from the list, Step 1 (Lease Transaction Search) no should return no search results.
Please advise.
Thank you.