I have a business event I’ve been fighting with for a few days. It works in our Sandbox. The purpose is to move a debit adjustment from one vendor to another by creating a credit adjustment tied to a clearing account, and applying that credit adjustment to the original debit adjustment and then creating a new debit adjustment on the new vendor.
It’s driven by a UDF on the APInvoice. In Sandbox, the user fills in the destination vendor number on the UDF, and the system sees the new value (the BE is setup to monitor all fields on the GI, and trigger when “Record Inserted”) and the BE fires.
I copied (exporting the GIs to XML) everything from Sandbox to Live, and it refuses to fire. I can change the BE trigger to be Action, and then go into the GI and fire off the action from the … menu and it works perfectly. But if I change it back to trigger by record change (Insert), like it is in Sandbox, it fails.
The GI does have a join that links the UDF to the Vendors table (UDF Value = Vendors.AcctCD). I pulled this out and tweaked the GI results and the BE fires when the new record is inserted. Long term this doesn’t work because there are details on the destination Vendor record that I need to include in the process.
I know that UDFs are actually in a separate table in the database, so even if it doesn’t look like I have a join to get the destination vendor, behind the scenes I do. I’m considering creating a custom field in the APInvoice table instead to remove that, but it makes no sense that this works perfectly in Sandbox, but it doesn’t work in Live (even off hours, when there’s no one else signed in). Super frustrating...
