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
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)
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"):
My Distribution List looks like this:
And my report looks very similar to yours:
When I distribute the report, this is the resulting PDF file:
Page 1 (the MyReport worksheet)
Page 2 (the contents of 23444.pdf)
Try your report with the slightly modified GETATTACHMENTS function.
0 Votes
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
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)
Thank you in advance for your help
Attachments (1)
Screenshot.png
14.9 KB
0 Votes
3 Comments
Velixo Team posted 5 days ago Admin
Please reach out to the Velixo Help Desk ([email protected]) so that they can assist you with this.
0 Votes
Ariann posted 10 days ago
Hi there! Thanks for the quick reply. I tried modifying the function, but the result is still not working :
Do you see anything else that I could try? I also tried with the values in French and English as well (Invoice, Bill, Facture)
0 Votes
Velixo Team posted 10 days ago Admin
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"):
My Distribution List looks like this:
And my report looks very similar to yours:
When I distribute the report, this is the resulting PDF file:
Page 1 (the MyReport worksheet)
Page 2 (the contents of 23444.pdf)
Try your report with the slightly modified GETATTACHMENTS function.
0 Votes
Login or Sign up to post a comment