Skip to main content
Answer

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

  • October 24, 2022
  • 2 replies
  • 182 views
H
Jr Varsity II
Forum|alt.badge.img

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.

Best answer by Naveen Boga

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

 

    2 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • October 24, 2022

    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 - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Leonardo Justiniano
    D
    Chris Hackett
    H
    Jr Varsity II
    Forum|alt.badge.img
    • hthuy24
    • Author
    • Jr Varsity II
    • October 25, 2022

    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 

    Terms & ConditionsCookie settingsAccessibility statement
    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