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
  • 141 views

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

Userlevel 7
Badge +18

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

 

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


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