Business Event Conditions display wrong values

Question

When I create a Business Event to trigger off of a new GI, the Values in the Trigger Conditions display incorrectly (do not display as it is shown in the GI). The B/E do work correctly, it is just hard to manage this.

Below I am restricting the BE condition to warehouse ID is less than ‘50’ (and customer id is not correct either). But as you can see the Warehouse ID displays ‘less than 411’ (same with the customer id - displays an incorrect value).

I understand it must be using an internal ACM id or something, but how can I get it to display as the actual field in the GI displays? I am not sure what i am doing wrong here.

Business Event conditions

GI displays the Customer ID and Warehouse ID correctly

Any help or idea would be greatly appreciated.

lauraj46 · Accepted Answer

Hi @lburrow62,As you figured, many of the tables in Acumatica are designed with an internal integer key and a secondfield that is a human readable identifier.For example the Customer data access classhas a primary key of BAccountID and the human readable code is AcctCD. The INSite table (warehouses) has a primary key of SiteID and the human readable code is SiteCD.The SOShipment foreign keysreference the integer fields. The Generic Inquirydoes a join behind the scenes (based on the schema) and automatically displaysthe human readable codes from the related tables. If you need to see the human readable code, you canaddjoins to Customer and INSite inthe GI and then explicitly use the fields AcctCD and SiteCD instead of CustomerID and SiteID.Keep in mind however that in the business event it is more efficient to avoidextrajoins which can bog down the performance. See requirement #2 in the article below:Hope this helps!Laura

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded