Alessandro Lopez Santinelli

1. Comunidad
2. Community Questions and Answers
3. Print and Delivery - Wrong attachment

Josh, Is that PDF layout a native SAP format, or is it a custom format you created?

• Ver comentario
• Alessandro Lopez Santinelli
• 22 de mayo de 2026 16:37
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Print and Delivery - Wrong attachment

Hi Josh,  I use something very similar Could you try the query from the Attachments section and see if it works for you? considering that I already have my files physically defined in a specific ...

• Ver comentario
• Alessandro Lopez Santinelli
• 22 de mayo de 2026 00:06
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Print and Delivery - Wrong attachment

Hi Josh, Could you please share the SQL query you are using in the Attachments section of the Report Action? Regards Alessandro.

• Ver comentario
• Alessandro Lopez Santinelli
• 21 de mayo de 2026 23:10
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Select and Print Document based on UDF Value

Hi Rob! I do something similar. In my case, I first send the email and then update the user-defined field to mark it as sent. That way, on the next B1 Print & Delivery run, it won’t be picked up.  ...

• Ver comentario
• Alessandro Lopez Santinelli
• 20 de agosto de 2025 19:05
• Editado
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Specified data cannot be rendered in a chart

Hello Matthias, I fixed the issue by changing the Windows regional settings. We noticed (at least in our case) that the affected computer was set to "Spain" as the region. We changed it to "Mexico,...

• Ver comentario
• Alessandro Lopez Santinelli
• 7 de mayo de 2025 15:45
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Report Action: Invoice with 3 Attachments?

Hi Thomas, I’m not sure about your version, but in recent versions, yes. I have two regards. Alessandro.

• Ver comentario
• Alessandro Lopez Santinelli
• 20 de enero de 2025 18:34
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. SQL Year function not working for dynamic attachments in Print and Delivery

Hi Paul, try this: Select '\\b1_shr\attachements\picklists\'+SUBSTRING(CONVERT(varchar, docdate, 112), 1, 4)+'\'+CHOOSE(month(DocDate),'January','February','March','April','May','June','July','Augu...

• Ver comentario
• Alessandro Lopez Santinelli
• 23 de septiembre de 2024 19:45
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. B1UP - how to put a UF in "General Functions"?

Hi Marcus, I hope I understood correctly; you need to access the queries saved in SAP (Query Manager). If so, you need to know the IntrnalKey of your query. You can run this query: SELECT T0.Intrna...

• Ver comentario
• Alessandro Lopez Santinelli
• 17 de septiembre de 2024 16:29
• Editado
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Macro is not working

Jobi, try this way, Instead of a simple condition, make it an SQL condition. It's possible that the format of the field marking an error is from the 'Item' field (BOY_1). In my example, I use an SQ...

• Ver comentario
• Alessandro Lopez Santinelli
• 28 de agosto de 2024 20:15
• 0 votos

1. Comunidad
2. Community Questions and Answers
3. Macro is not working

It's very strange; I have the same scenario and it works fine. As Geoff says, turn on debug mode to find the error line. Regards Alessandro.

• Ver comentario
• Alessandro Lopez Santinelli
• 27 de agosto de 2024 20:33
• 0 votos