I see ShipmentType in the SOOrderShipment DAC. It shows char(1) and the visual shows “Shipment, Drop-Ship,etc.” How do I determine what the single character is that represents “Shipment”?
Answer
DAC Schema Browser - Identify the code of an item
Best answer by travislawson
Thanks
When viewing the “Source Data” use a filter to select the data you want.
Then go to Tools, Trace
Then look at the SQL information to find it. In this case it shows me ShipmentType = I.
Hi
**Please perform this on a Test instance or a local Acumatica instance to avoid issues.
Steps:
- Inspect Element on the field( Sales Order->Shipments tab->Shipment Type)
use keyboard shortcut Ctrl+Alt or Customization → Inspect Element
- Click on Customize and expand the screen as shown below till the Fields lelve
3.Select the ShipmentType, and click on “Add and Close” as shown below
- Click on Combo box Values and the values will be shown.
Chandra M
Thanks
When viewing the “Source Data” use a filter to select the data you want.
Then go to Tools, Trace
Then look at the SQL information to find it. In this case it shows me ShipmentType = I.
🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀 ➡️ www.linkedin.com/in/-travis-lawson-/
Hi
Great to hear that have identified another method to get the SOOrder.ShipmentType=’I’.
The solution through the Customize option shows the Description of the Type and Value in tabular form that might be handy.
Have a great day!
Thanks
Chandra M
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.