Hi all! I've got a tricky one for you.
We need to...
# suitescriptk
kwood
04/06/2022, 11:17 PMHi all! I've got a tricky one for you.
We need to send a very specific XML file to our bank of all paid bills minus credits, which requires tracking the relationship between applied transactions and their applied to transactions, and we need to store a "true" value for a custom checkbox when a relationship has been processed so that we do not process it again.
This relationship is unfortunately not a record in and of itself so there's no way to add a checkbox to it. To resolve this I created a custom "Applied Transaction Relationship Record" with fields for applied transaction, line number, applied to transaction, and whether it's been processed or not by the XML export script.
The tricky part is, the line numbers seem to change periodically on the applying transaction.
TL:DR; My question is - Is there a unique identifier for apply lines on bill credits and bill payments that I can use instead of line number?
kwood
04/06/2022, 11:26 PMI tried lineuniquekey but it doesn't seem to actually refer to apply lines because I get the same one for each line in any given transaction.
b
battk
04/06/2022, 11:27 PMid imagine that the id of the transaction being applied is unique
k
kwood
04/06/2022, 11:29 PMyes that is, but what I'm actually trying to track is the relationship between each applied line in the applying transaction and its applied to transaction
kwood
04/06/2022, 11:29 PMand whether it's already been exported to XML or not
kwood
04/06/2022, 11:29 PMhow can I match it up again on subsequent edits if the line number changes each time?
kwood
04/06/2022, 11:30 PMThe credits are pretty straightforward as they tend to only have one or a few lines, but the payments are created from the "Pay Bills" screen and apply to dozens of bills
b
battk
04/06/2022, 11:31 PMeach bill on the apply sublist of the payment is unique
👍 1
💯 1
k
kwood
04/06/2022, 11:33 PMAha!
kwood
04/06/2022, 11:33 PMso it cannot be listed twice?
kwood
04/06/2022, 11:33 PMgood call
kwood
04/06/2022, 11:34 PMthat should be only a minor rework of the logic. 🙂
kwood
04/06/2022, 11:38 PMNext question, is there an easy way to delete all of a custom record type's records?
b
battk
04/06/2022, 11:40 PMdelete the custom record type
k
kwood
04/06/2022, 11:40 PMEw
kwood
04/06/2022, 11:40 PMI'd rather not lol
kwood
04/06/2022, 11:40 PMI'll just manually delete them. There's only 25 test records at the moment. Thanks!
kwood
04/06/2022, 11:45 PM@battk The unique relationship between any given applied to transaction and its related applying line was the answer, thank you!!!
3 Views