I need to set a value on a purchase order as it’s ...
# suiteflow
j
I need to set a value on a purchase order as it’s being created via DropShip. I tried using a UserEvent and a Workflow and neither seems to be triggered when the PO is created via DropShip. I’ve checked that they are deployed correctly and to all contexts. Any ideas on another method? Basically trying to find a workaround for the fact that dropshipped POs are using the vendor currency instead of the currency of the SO, even when that vendor has both currencies enabled.
m
If you make a saved search of purchase orders where created from type = sales order Then use that saved search as the condition of your set field value action You’d have to use after record submit trigger though
j
I can’t use after submit, once tx is saved, you cannot edit currency.
it’s the currency I need to set at time of create to match the SO currency
j
Does this help? https://suiteanswers.custhelp.com/app/answers/detail/a_id/94463/loc/en_US Kinda looks like exactly what you're trying to do unless I'm misunderstanding. But does feel rather overly involved though.
j
Thanks for the link, unfortunately not, we actually need to change the
currency
field on the transaction record itself 😞
j
If I'm reading between the lines correctly, it sounds they basically ran into the same limitation you're describing, and thus their solution was to store all that data in custom fields. If I had to guess they probably then used that to populate the correct currency on the invoice created from the PO. Since the PO is non-posting that would at least make all the financial statements show up correctly.
I supposed you could always duplicate the PO with a new currency and delete the old one via script if there is no workaround or alternative to modifying the currency 😆
e
This reminds me of the time when I tried to change a Requisition currency before creating the transaction. When creating a Requisition, an employee is restricted to the base currency of his subsidiary, even in a multi-currency set up. I thought that I could create a custom field for currency, and then before submit to change the native currency field. It never worked.