Solved

DAC Schema Browser - Identify the code of an item

  • 16 October 2023
  • 4 replies
  • 102 views
T
Rank
Userlevel 3
Badge

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”?

 

 

 

icon

Best answer by travislawson 17 October 2023, 13:52

View original

4 replies

C
Rank
Userlevel 7
Badge +9

Hi @travislawson Please find the steps below to view the possible values of a field in Acumatica.

**Please perform this on a Test instance or a local Acumatica instance to avoid issues.

Steps:

  1. Inspect Element on the field( Sales Order->Shipments tab->Shipment Type)

          use keyboard shortcut Ctrl+Alt or Customization → Inspect Element

  1. 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

 

  1. Click on Combo box Values and the values will be shown.

 

Chandra M
C
Rank
Userlevel 7
Badge +9

Hi @travislawson Please review the above details and let me know for any assistance.

Thanks

Chandra M
T
Rank
Userlevel 3
Badge

Thanks @ChandraM.  I think I may have found an easier method after posting this.

 

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. 

 

C
Rank
Userlevel 7
Badge +9

Hi @travislawson Thanks for the update! 
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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved