This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How to fix a sales order and invoice under one customer record and a customer deposit on another customer record for the sales order? It shows the invoice open and the customer deposit unapplied since they are not the same customer. Period is locked and cannot be unlocked

You would need to create 2 offsetting transactions in the system and put notes in the memo of each relating the 2 together.  Make sure the balanicing account is the same for each.

For example you could use:
a Customer Payment deposited to a petty cash acocunt to clear the Invoice AND a Cash Refund applied to the Customer Deposit but drawing from the Petty Cash account

These 2 entries would offset so the NET effect to Petty Cash was $0, but the two transactions are cleared

You could also do the same with 2 journal entries

journal entries is the way to go.  Use customer names to add the customers records.  And  - if this is the same customer with two records - combine two customer records in one

Or if you want to keep the customers separate you can look at other Consolidated Payments feature