# Getattachments 

**URL:** <https://community.velixo.com/t/getattachments/102>\
**Category:** Q&A\
**Tags:** Acumatica\
**Created:** [May 14, 2025, 6:01pm UTC](https://community.velixo.com/t/getattachments/102 "2025-05-14T18:01:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ariann](https://community.velixo.com/letter_avatar_proxy/v4/letter/a/cab0a1/32.png) [@Ariann](https://community.velixo.com/u/Ariann)\
**Post date:** [May 14, 2025, 6:01pm UTC](https://community.velixo.com/t/getattachments/102/1 "2025-05-14T18:01:19Z")

</div>

Hi,

I’ve been trying to figure out the Velixo Formula for GETATTACHMENTS, but I keep having an error. I followed step by step the following guide, but I’m still not able to make it work : [GETATTACHMENTS function : Velixo Help Center](https://help.velixo.com/support/solutions/articles/153000231201-getattachments-function#How-to-define-key-fields)

I would like to extract the PDF file associated with Bill #134950 in Acumatica (Bills and adjustments). Could you help me out please? Note that my Excel is in French (ASSEMB.V = VSTACK)

 ![](https://community.velixo.com/uploads/default/original/1X/4f13bff12b74c31db6a1c1b5d28ea7c36e481aaf.gif)

Thank you in advance for your help

 ![Screenshot.png](https://community.velixo.com/uploads/default/original/1X/460d13a2716d141b473487f8ee713066afd690cb.png)

---

<div class="post-metadata">

**Author:** ![Velixo\_Team](https://community.velixo.com/letter_avatar_proxy/v4/letter/v/f19dbf/32.png) [@Velixo\_Team](https://community.velixo.com/u/Velixo_Team)\
**Post date:** [May 14, 2025, 6:53pm UTC](https://community.velixo.com/t/getattachments/102/2 "2025-05-14T18:53:56Z")

</div>

Let’s do some minor changes to your function in order to match the documentation.

My system is configured for the EN-US settings, so my function would look like this:

=GETATTACHMENTS(B2,B3,HSTACK(VSTACK(“Type”,“ReferenceNbr”),VSTACK(B6,B7)))

The first part of my array consists of all the Key field names (“Type” & “ReferenceNbr”). The second part consists of all the key values (cells B6 and B7).

Each part is created using the VSTACK function. These are then combined using the HSTACK function.

My bill (002769) has an attachment (“23444.pdf”):

 ![](https://community.velixo.com/uploads/default/original/1X/d6fc2966ddc6eb2e260344c11ce7579222e6b6ec.png)

My Distribution List looks like this:

 ![](https://community.velixo.com/uploads/default/original/1X/c7527e67cf99fca11dba825f730e0b4b04e8306c.png)

And my report looks very similar to yours:

 ![](https://community.velixo.com/uploads/default/original/1X/7b62306bde545e446d82e996daa2776b2d0a2ba5.png)

When I distribute the report, this is the resulting PDF file:

Page 1 (the MyReport worksheet)

 ![](https://community.velixo.com/uploads/default/original/1X/c2e36637e3274d938b4457f7d20cdce09dcc284a.png)

Page 2 (the contents of 23444.pdf)

 ![](https://community.velixo.com/uploads/default/original/1X/7e0e07824bb61f8ecb453120ccd50d2ac7c656dc.png)

Try your report with the slightly modified GETATTACHMENTS function.

---

<div class="post-metadata">

**Author:** ![Ariann](https://community.velixo.com/letter_avatar_proxy/v4/letter/a/cab0a1/32.png) [@Ariann](https://community.velixo.com/u/Ariann)\
**Post date:** [May 14, 2025, 7:25pm UTC](https://community.velixo.com/t/getattachments/102/3 "2025-05-14T19:25:58Z")

</div>

Hi there! Thanks for the quick reply. I tried modifying the function, but the result is still not working :

 ![](https://community.velixo.com/uploads/default/original/1X/97c0a262a9ff3cb028eab403f19d3fa5eb138b2b.png)

 ![](https://community.velixo.com/uploads/default/original/1X/065f7fc8eb47a25be0b808df4f75caf83671d841.png)

 ![](https://community.velixo.com/uploads/default/original/1X/1a5a25b4f2777f5bf0237e05ceb960f0572a1709.png)

Do you see anything else that I could try? I also tried with the values in French and English as well (Invoice, Bill, Facture)

---

<div class="post-metadata">

**Author:** ![Velixo\_Team](https://community.velixo.com/letter_avatar_proxy/v4/letter/v/f19dbf/32.png) [@Velixo\_Team](https://community.velixo.com/u/Velixo_Team)\
**Post date:** [May 19, 2025, 3:48pm UTC](https://community.velixo.com/t/getattachments/102/4 "2025-05-19T15:48:05Z")

</div>

Please reach out to the Velixo Help Desk ([support@velixo.com](mailto:support@velixo.com)) so that they can assist you with this.

---

<div class="post-metadata">

**Author:** ![Mark\_S](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/22d042/32.png) [@Mark\_S](https://community.velixo.com/u/Mark_S)\
**Post date:** [October 27, 2025, 12:44am UTC](https://community.velixo.com/t/getattachments/102/5 "2025-10-27T00:44:17Z")

</div>

I have been trying for a while to get this to work as well as it would be a fantastic way to pull large volumes of docs for various BAU activities

I think I have the GI and GETATTACHMENTS function configured correctly

 ![](https://community.velixo.com/uploads/default/original/1X/dda5068b086fbac2e4e032fb2cd8eff717f86fdc.jpeg)

However I am getting this error

 ![](https://community.velixo.com/uploads/default/original/1X/63c78475b40064b6dea68160cc726daf6675ef57.jpeg)

Any help would be much appreciated!

---

<div class="post-metadata">

**Author:** ![Ariann](https://community.velixo.com/letter_avatar_proxy/v4/letter/a/cab0a1/32.png) [@Ariann](https://community.velixo.com/u/Ariann)\
**Post date:** [October 31, 2025, 7:45pm UTC](https://community.velixo.com/t/getattachments/102/6 "2025-10-31T19:45:48Z")

</div>

I realise I did not follow up on this topic, but the problem was that I was using **Velixo Classic** instead of **Velixo NX**. The function “getattachments” did not work with Velixo Classic. I appreciate your help!
