Solved

Adding Custom Field from Stock Item to Inventory Transaction Lines

  • 23 February 2023
  • 1 reply
  • 284 views
K
Rank
Userlevel 5
Badge +1

Hi All,

So I am currently adding a Custom Field onto the Stock item (Kitting Required is separate from any of the typical Kitting functionality in ACM).

I am wondering if it is possible to access this on the Inventory Transfer transaction for example.
Looking at the Inventory Item DAC it looks like it was added to the DAC, yet I am not sure on how to get this field (or any other field not available) to show here:
 

This is where I would need it to get to actually use the value from the Inventory item correct?

I am a little lost on how to let the Field show up in the Transaction Grid and bring over the value it has assigned on the Stock item.

Any thoughts/ideas?

icon

Best answer by Patrick Chen 24 February 2023, 01:02

View original

1 reply

Patrick Chen
Rank
Userlevel 4
Badge +2

So you have a UDF field on the InventoryItem table and you’d like this field to be included in the Transactions grid on IN304000.  Looking at the definition of the Transactions view on IN304000, it is a simple Select into the INTran table.  In order to see the UDF in the transaction grid along with the Inventory transactions, you would need to extend the INTransferEntry graph and override the Transactions view to add a join to the InventoryItem DAC.  Then you would be able to add your UDF to the grid.

https://help-2022r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=5312e75a-6f0a-4b2c-a28c-38da20782087

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