Skip to main content

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.

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

 

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