<@U86RW6Q92> It is a very tricky record to work wi...
# suitescripta
alien4u
06/01/2022, 5:36 PM@Azi It is a very tricky record to work with if you are creating the record make sure you do:
Copy code
const oVendorBillRec = record.create({
type: record.Type.VENDOR_BILL,
isDynamic: true,
defaultValues: {
entity: 'your_entity'
}
});
If you are loading the record make sure you use:
isDynamic: truea
Azi
06/01/2022, 6:59 PM@alien4u I am trying it in Dynamic mode as per your suggestion, but I am still not seeing how I can get hold of that data
a
alien4u
06/01/2022, 6:59 PMWhat that do you need?
a
Azi
06/01/2022, 7:01 PMcredits applied
a
alien4u
06/01/2022, 7:06 PMLoop through the apply sublist and lines with the apply set to true, in some cases == T
a
Azi
06/01/2022, 7:08 PMSo I did that, and it worked for applied to (payments) for bills but not for credits applied
b
battk
06/02/2022, 1:36 AMits not convenient to get from payment to credits
battk
06/02/2022, 1:37 AMsearches and queries represent that relationship as between a credit and a bill
battk
06/02/2022, 1:37 AMwhich complicates things if there are multiple payments to a bill
battk
06/02/2022, 1:38 AMrecords represent that relationship differently depending on if you are viewing/creating a record vs editing it
battk
06/02/2022, 1:40 AMon view/create, you have access to the credits applied on the payment
battk
06/02/2022, 1:40 AMon edit (which includes loading a record) you dont
battk
06/02/2022, 1:45 AMthe credit behaves normally and has an apply sublist no matter the user event type
battk
06/02/2022, 1:47 AMso if you really wanted to, you could do a search/query to get the credits that apply to the payment's bills and load each credit to see which payment it applies to
battk
06/02/2022, 1:47 AMthe other answer is that when printing payment, the applied credits sublist is available
battk
06/02/2022, 1:48 AMyou can print a transaction with a form/template that includes the credits as html, then parse the html to get to the credits
michoel
06/02/2022, 2:01 AMexample code for that method
a
Azi
06/02/2022, 5:46 AMOkay. I guess if this is my only option I will have to go with this absurd answer.
I was actually thinking if there was some way to use a headless browser to scrape the data, but this is definitely a little less absurd.
m
michoel
06/02/2022, 5:49 AMHeadless browser is definitely possible. I've been using puppeteer for a project recently to export/import custom object translations
a
Azi
06/02/2022, 5:52 AMSo I have played around with puppeteer a few years back, but I am not familiar enough to do something like this
m
michoel
06/02/2022, 5:54 AMHopefully I'll publish something in the next few weeks
a
Azi
06/02/2022, 6:01 AM👍
2 Views