Question

How Acumatica differenciate if an attachment is uploaded from "Files" or "Image" section of the Expense Receipt?

aaghaei
Rank
Userlevel 7
Badge +9

Hello All,

Does anyone know how Acumatica differenciate if an attachment is uploaded from "Files" or "Image" section of the Expense Receipt?

If we upload a jpg from “Upload Image” of the Expense Receipt Screen, the platform shows the “Image Preview” but if we attach the same file from the “Files” on top of the screen it is not previewed.

I checked UploadFile, UploadFileRevision and NoteDoc and both of the records are Identical except to their FileID that of course should be a Unique Indentifier anyways.

I also checked the EPExpenseClaimDetails and couldn’t find a possible reference to the File which is uploaded using the “Upload Image”. 

All I can find in the graph, its extensions or the page is a “PXImageUploader” in the page nothing else.

Any help is appreciated.

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*.

4 replies

K
Rank
Userlevel 5
Badge +1

To my knowledge it doesn’t once it hits the File Maintenance. The only difference is that you can more easily call on the Image Field as it’s available for Generic Inquiries without having to join all necessary Tables to get to the File Data.

 

Curious to see if somebody found something else.

aaghaei
Rank
Userlevel 7
Badge +9

@krausef77 Thanks for sharing your thoughts but I am pretty sure it shomehow treats them differently otherwise why it would show preview if Upload Image is used and wouldn’t show preview if the exact same image was uploaded using the Upload File.

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*.
K
Rank
Userlevel 5
Badge +1

It’s using a different function for that specific field whereas the Files Tab is for all kinds of Files.

Once it is saved into the Database, in the Tables you mentioned there is no difference that I know of.

Again, the preview and the field itself enables it to be used in a Generic Inquiry more easily and is more user-friendly, yet outside of a different display due to file restrictions on the Image Upload, the file itself is not treated any different.

 

aaghaei
Rank
Userlevel 7
Badge +9

Thanks @krausef77 

Let see what other valued community members have to add.
I have done quite bit of customizations on generating attachments, uploading via code, merging, bulk downloading so I’m not stranger to its world.

Even for the purpose of showing on GI as you mentioned, Acumatica somehow should be able to differentiate these two types otherwise won’t be able to do that. But the question is how?

@darylbowman I recall from previous posts you have done quite a bit of work on File management. Any thoughts here?

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