CantSleep

Do you have any duplicates for Customer name? If two Customers share the same name, they would be grouped together and then sumed together. Are your customers disctinct?

VoteforItLink :)

Mahi this is a descent work around for getting Prepayments/Customer Deposits on a Customer statement. The only problem is that you are dirtying your system by creating two transactions. The initial customer Deposit and a new created unapplied payment. I will continue to vote for your Enhancement # 88440. Honestly, customer…

Thank you Wizard of Oz!

Have you tried using internal id? Internal id is sequential. 1. Add a Transactional Body field to your Vendor bill/ invoice 2. Set the default value under validation and defaulting tab to {id} 3. Uncheck store the value.

I'm going to bump this as well. Payable has requested this from us. I'm working to see if Suitescript may do something.

Thank you Paul that formula works!

Thanks everyone for all the suggestions! The code John.Ellis provided worked great! I can use a custom formula field, but I want to leverage this solution for other post save record writing.

If you are using the out of the box netsuite approval system, I believe currently you cannot. Instead a solution would be to use Suiteflow. TheNetsuite Platform Solutions Group - Purchase Order Approval Workflow Bundle can get you started. Per each approval, you could trigger an email based on custom fields.