Hi there,
I want to be able to autofill the PO# field (otherrefnum) on an invoice when it's generated, we use intercompany transactions so most of our POs and SOs are paired together at the intercotransaction field.
I've built a workflow that fills the PO# on an invoice using the PO Field on the SO. But unfortunately this has also be set manually. So I'd like either the invoice, when it's created, to be able to link down to the PO and fill its PO# field automatically. Or get the SO to fill its PO# field automatically when I run the Manage Intercompany Sales Orders function.
The PO and SO are both linked to each other via the field intercotransaction.
I did try using the formula of {createdfrom.intercotransaction} but that unfortunately puts in the internal ID of the PO and not the value of the field. (SO CLOSE! Can I use this?)
Otherwise, if I could use the Manage Intercompany Sales Orders to prefill the SO with the PO# when it's generated, that would work too. I've tried to make a workflow to do this, but I don't seem to be able to target the correct property of the intercotransaction field.
If I put 'test' as a static value, I do see it appear on an SO after generating it from Manage Intercompany SOs, but if I use a formula of {intercotransaction} I get nothing and if I use {intercotransaction.tranid} I get an error during the generation 'The field otherrefnum contained more than the maximum number ( 45 ) of characters allowed.'.
otherrefnum is the PO# field, so it is trying to fill it with something, but I guess it's not what I'm hoping for (PO78TEST) as it shouldn't be more than 45 characters, haha.
Feel like I'm close to a solution on this, so I'm gonna keep trying, but if anyone can think of a solution in the mean time that'd be greatly appreciated~
Cheers