I am trying to achieve automating customer payment...
# suitescripts
santhosh kumar
09/30/2021, 6:39 AMI am trying to achieve automating customer payment against credit amount(journal entry,credit memo& unapplied payments).
For example -ABC Customer has unapplied payment of Rs 10000,credit memo of Rs 5000,
and journal entry of Rs 2000. I am creating of invoice 50000 ,Upon saving of invoice ,in a UserEvent trigger i am trying to knock off the invoice amount 50000 with the existing credit amount of Rs 17000.In this scenario i can't apply journal entry amount of Rs 2000.I need to establish a link between Journal and the customer invoice.Please provide the script bundle for
this entire customization.please do the needful asap.
b
battk
09/30/2021, 6:57 AMyour approach sounds wrong
battk
09/30/2021, 6:58 AMnormally you would create a customer payment transaction to apply all those different transactions to the invoice
s
santhosh kumar
09/30/2021, 7:11 AMThanks for your reply.yes i have to auto apply journal entry amount against invoice(userevent aftersubmit).How can i acheive that.
b
battk
09/30/2021, 7:20 AMlearn how to create a customer payment for that invoice using the ui
battk
09/30/2021, 7:22 AMshould involve clicking the
Accept Payments
santhosh kumar
09/30/2021, 7:33 AMhactually i need automate applying the credits towards that payment...i that i please let me know how to apply journal credit for that customer
b
battk
09/30/2021, 7:35 AMcan you do it in the ui?
s
santhosh kumar
09/30/2021, 7:42 AMyes i can...i need to replicate the same issue in suitescript
b
battk
09/30/2021, 7:42 AMyou do the same thing in script
battk
09/30/2021, 7:44 AMyou use record.transform to mimic the effect of the
Accept Paymentbattk
09/30/2021, 7:45 AMthen Record.setSublistValue to mark the same checkboxes you would in the ui
battk
09/30/2021, 7:46 AMthat will usually involve using Record.findSublistLineWithValue or Record.getSublistValue to find which line you want to mark
s
santhosh kumar
09/30/2021, 7:59 AMi tried with record.transform but its creating a new payment record...problem that payment amount is again credited to customer paymnet
santhosh kumar
09/30/2021, 8:00 AMi need to knock off credit amount(journal entry amount) without creating a payment record
santhosh kumar
09/30/2021, 8:01 AMjust i need to establish a link between journal and invoice record
b
battk
09/30/2021, 8:21 AMthere is no native equivalent for what you are asking for
battk
09/30/2021, 8:22 AMyou need to create the customer payment to properly record the application of credits
battk
09/30/2021, 8:35 AMnetsuite might not actually create the customer payment if the credits balance out the payment amount to 0, but it will apply the chosen crediting transactions to your invoice
10 Views