The internal ID on a deposit line on a Customer Re...
# suitescriptc
Craig
11/12/2023, 11:13 AMThe internal ID on a deposit line on a Customer Refund does NOT match the internal ID of the Customer Deposit; I assumed it would. Has anyone seen this before? I appreciate it's a super obscure/very specific question.
I'm creating customer refunds based on a search which provides me a list of customers and deposits. I'd like to make sure I'm applying the refund against the correct deposit. I can assume the deposit is at line 0, which will probably work, but that doesn't feel as safe as using record.findSublistWithValue() and passing in the ID of the deposit record to make sure I'm selecting the correct deposit line on the refund.
w
Watz
11/12/2023, 11:21 AMTested it out. It points to a "Deposit Application" transaction in my case. The deposit application is connected to the customer deposit
c
Craig
11/12/2023, 11:23 AMHow did you know which record the internal ID pointed to?
w
Watz
11/12/2023, 11:23 AMWatz
11/12/2023, 11:23 AMBut that is after I have applied and saved the customer refund
Watz
11/12/2023, 11:24 AMThat deposit application is created when I save the customer refund
c
Craig
11/12/2023, 11:24 AMI'm doing this before the refund is saved. It's in dynamic mode though so there's a chance that field is populated before I save.
Craig
11/12/2023, 11:25 AMbut if it's after save then I can't get. Unless I split the script into two. One to create the refunds then one to apply
Craig
11/12/2023, 11:25 AMI'll look into this a little closer later today. Thanks for looking!
w
Watz
11/12/2023, 11:31 AMIn dynamic mode in create, the "doc" in the "deposit" sublist shows the correct id of the "Customer Deposit"
c
Craig
11/12/2023, 11:37 AMI didn’t see that, will verify later, thanks!
Craig
11/12/2023, 9:27 PMThat worked well. Not sure why the internal ID field wasn't working but the doc field has the required ID. Thanks!
Craig
11/12/2023, 9:28 PMContext: a staff member shared an internal discount code on a facebook group so now we have 700 customer deposits that we need to refund because the discount code was 50% 🙂
facepalm 1
s
Shawn Talbert
11/13/2023, 5:08 PMearly black friday deal!
2 Views