Is the createdFrom on an invoice ALWAYS a Sales Or...
# suitescriptc
Chris
02/23/2023, 7:24 PMIs the createdFrom on an invoice ALWAYS a Sales Order record?
d
David B
02/23/2023, 7:42 PMIt could be nothing (standalone invoice), or an Estimate
Not sure of what else
a
al3xicon
02/23/2023, 7:43 PMyeah i'm kind of wracking my brain trying to think what else it might possibly be
🤔 1
al3xicon
02/23/2023, 7:44 PMhonestly didn't even realize you could directly create invoices from estimates
d
David B
02/23/2023, 7:44 PMdoes a memorized invoice count as being created from the memorized transaction?
c
Chris
02/23/2023, 7:50 PMSo far, if it's not empty, then I can only think of SO and Est.
👍 1
s
Shawn Talbert
02/23/2023, 8:26 PMcan intercompany transactions play a role there?
a
al3xicon
02/23/2023, 8:28 PMperhaps - intercompany SO?
al3xicon
02/23/2023, 8:28 PMi don't know that feature well enough to say
s
Shawn Talbert
02/23/2023, 8:30 PMor, can transfer orders be invoiced?
d
David B
02/23/2023, 8:31 PMno, TOs are only TO > IR > IF
s
Shawn Talbert
02/23/2023, 8:31 PMok, wasn't sure if intercompany TOs had invoices in the mix somewhere
d
David B
02/23/2023, 8:32 PMugh, intercompany TOs.... good point
David B
02/23/2023, 8:34 PMeasy answer, script the logic for standalone, sales order and estimate, and
N/emailw
wbermudo
02/24/2023, 5:30 PMit uses governance points though, but if you are scripting something on the invoice and want to be really sure that you only process Invoices created from Sales Order you can use a search.lookupFields
search.lookupFields({type: search.Type.TRANSACTION, id: createdFromId, columns: ‘recordtype’});
This will give you the recordType of the created from transaction (if populated).
👍🏻 1
3 Views