Dustin Bellew

1. Community
2. Community Questions and Answers
3. P&D Report Action SQL

This has been solved it was a syntax issue with single quotes.

• View comment
• Dustin Bellew
• May 20, 2020 20:57
• 0 votes

1. Community
2. Community Questions and Answers
3. P&D Report Action SQL

I have tried it both ways using DocNum and DocEntry, they both work from SQL side of things. From within the P&D Report action email is where things get funky when trying to tie the $[$8.0.0] docum...

• View comment
• Dustin Bellew
• May 20, 2020 20:32
• 0 votes

1. B1 Usability Package
2. UF: Macro
3. How to work with Date format in SQL: Set command

IF ($[$BOYX_5.0.0]  > getdate() -1

• View comment
• Dustin Bellew
• June 03, 2020 21:27
• -1 votes