Alessandro Lopez Santinelli

1. Community
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?

• View comment
• Alessandro Lopez Santinelli
• May 22, 2026 16:37
• 0 votes

1. Community
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 ...

• View comment
• Alessandro Lopez Santinelli
• May 22, 2026 00:06
• 0 votes

1. Community
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.

• View comment
• Alessandro Lopez Santinelli
• May 21, 2026 23:10
• 0 votes

1. Community
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.  ...

• View comment
• Alessandro Lopez Santinelli
• August 20, 2025 19:05
• Edited
• 0 votes

1. Community
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,...

• View comment
• Alessandro Lopez Santinelli
• May 07, 2025 15:45
• 0 votes

1. Community
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.

• View comment
• Alessandro Lopez Santinelli
• January 20, 2025 18:34
• 0 votes

1. Community
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...

• View comment
• Alessandro Lopez Santinelli
• September 23, 2024 19:45
• 0 votes

1. Community
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...

• View comment
• Alessandro Lopez Santinelli
• September 17, 2024 16:29
• Edited
• 0 votes

1. Community
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...

• View comment
• Alessandro Lopez Santinelli
• August 28, 2024 20:15
• 0 votes

1. Community
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.

• View comment
• Alessandro Lopez Santinelli
• August 27, 2024 20:33
• 0 votes