Solved

How to link uploaded files to inventory items in a generic inquiry

  • 4 May 2023
  • 1 reply
  • 190 views
T
Rank
Userlevel 2
Badge

I am trying to get a file id associated with an image for a stock item. I found this information on stack overflow that states that you can link these tables for the entity table and the UploadFile table through the NoteID field. However, I am not having success with this. I think this may be because Stock Items don’t have an associated note id and those are only for screens with associated documents like a sales order, but I’m not sure. I am linking these tables in this way:

I’ve been able to have partial success with this, but it’s very slow and only successful for around 60% of the results. Does anyone know if there is a field that can link between PX.Objects.IN.InventoryItem and PX.SM.UploadFile?

icon

Best answer by aaghaei 5 May 2023, 08:08

View original

1 reply

aaghaei
Rank
Userlevel 7
Badge +9

You will need to join Inventory with NoteDoc on Inventory.NoteID = NoteDoc.NoteID and NoteDoc with UploadFile on NoteDoc.FileID = UploadFile.FileID. 
The revisions of Files are kept in UploadFileRevision table and can be joins on FileID to UploadFile

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

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