Solved

Want to add attribute from stock item screen (CST.IN.20.25.00) to Inventory transaction summary screen ( CST.IN.40.60.00)

  • 24 October 2022
  • 2 replies
  • 140 views
H
Rank
Userlevel 4
Badge

I am attempting to add the item code and dangerous class from stock item screen to inventory transaction summary but I dont know how to coding or join which table to do it.

 

Pls help me if u have any idea. 

Thank you in advance.

icon

Best answer by Naveen Boga 24 October 2022, 13:28

View original

2 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi, @hthuy24  You need to Join ==> InventoryItem and CSAnswers tables with the below fields to get the respective Attribute value

InventoryItem → NoteID (field)

CSAnswers → RefNoteID (field) and Attribute ID = Item Code/Dangeours Class

 

Naveen B
H
Rank
Userlevel 4
Badge

Thank you for ur kind advice. Pls can I ask a stupid question, can you point to me how to join the table in customization, I only know join in generic inquiry but this screen doesn't have generic inquiry 

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