Alessandro Lopez Santinelli

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

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

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
• May 22, 2026 00:06
• 0 votes

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

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

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
• Edited August 20, 2025 19:05
• 0 votes

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
• May 07, 2025 15:45
• 0 votes

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

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

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
• September 23, 2024 19:45
• 0 votes

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
• Edited September 17, 2024 16:29
• 0 votes

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
• August 28, 2024 20:15
• 0 votes