Does anyone know how to access the `credits` list ...
# suitescriptm
mrob
11/14/2023, 12:40 AMDoes anyone know how to access the
creditsmrob
11/14/2023, 12:46 AMIt's under Apply but it's the 'Credits Applied'... I don't know, sublist type thing (since I assume Apply is the 'proper' sublist but when I query that I'm only seeing the 'Applied To' list/values
mrob
11/14/2023, 12:48 AMmrob
11/14/2023, 12:48 AMwhen i pull up the record and convert to json the only sublist I see with records is the apply one, but it only has the Applied To records
b
battk
11/14/2023, 2:16 AMdepends on when you need to get it, that credits sublist is only available on view or create
battk
11/14/2023, 2:17 AMand if you are trying to get it for an existing payment, there is only view, which is really hard to get outside of a payment viewed in the ui on the beforeLoad
m
mrob
11/14/2023, 2:18 AMYeah chatgpt said it's not accessible, one of my coworkers eventually figured out a strange hacky saved search that seems to work
mrob
11/14/2023, 2:19 AMUntitled
b
battk
11/14/2023, 2:36 AMsaved searches can get you the credits applied to the invoice of the customer payment
battk
11/14/2023, 2:37 AMso if you dont need to deal with invoices with multiple payments/refunds, then that may be good enough
m
mrob
11/14/2023, 2:41 AMIn my case they're all journals, not invoices or credits
b
battk
11/14/2023, 2:56 AMsame answer, take a look at the applied to transaction on the journal
battk
11/14/2023, 2:57 AMits applied to the invoice or whatever other transaction its applied to , not the customer payment
m
mrob
11/14/2023, 8:40 PMRight but I need the customer payment unfortunately. There are no invoices or credits. The customer payment is applying journals to journals
mrob
11/14/2023, 8:41 PMSo I need to find all the journals on the customer payment, apply and credit side and then delete the customer payment and re-save all the journals to unapply everything. But I want to do it from a saved search b/c I don't know how many customer payments need to be deleted (trying to find customer payment with the aracct of 1721, which seems to be another impossible field to query)
mrob
11/14/2023, 8:46 PMDoing this for just the apply side is pretty simple, it's just getting the journals used as credits that's proving to be very difficult
b
battk
11/15/2023, 3:51 AMit doesnt actually sound like you care which jouurnal entry is connected to each customer payment
m
mrob
11/15/2023, 3:59 AMI don't care in particular other than i only want customer payments and journal entries related to a specific ar account
mrob
11/15/2023, 3:59 AMi ended up with this monstrosity...
mrob
11/15/2023, 4:00 AMBasically 2 searches in one with the OR
41 Views