I am new to BAQ so I would appreciate your help.
I need to create an expected payment date column in BAQ. Most of our payment terms are one month later. So, as shown in the screenshot below, I entered “PO DueDate+1M” in SQL Editor, but an error occurred.
Q1. What SQL should I enter to create a column that displays a date one month after the PO’s DueDate? (Could you also tell me the Date Type and Format above?)
Q2. Since I am a beginner, I simply wanted to fix the date as one month later, but I think it would be even better if the date changes according to the terms in the PO. For example, if the term is advance payment, it is displayed as the same day, and if the term is 1 month later, it is displayed 1 month later from Duedate. How do I set it up to do this?
Hi, Thanks for the advice.
I worked with your SQL, but the error message below popped up. And my terms code is below. Could you please give me further advice on why the error occurred?
Thanks in advance!
To take @Chantal’s excellent solution to the next level, you may want to use the Net Days column in the Terms table and add that many days instead of always one month. This will work for all terms no matter how many days before payment is due.
That’s interesting. Actually, That’s what i want. Since I am a BAQ beginner, I chose to set it to 1M because it was easy to set. But, it would be better data if the expected payment date could change depending on the term selected in Terms.
Could you please explain specifically how to set it up to do this? (including SQL)
Thanks in advance!
Thanks to your great advice I created this. (N15, N30, N45,…)
By the way, I’m sorry to bother you, but may I ask one more question?
I created other Terms, but not the term “50% Advance/50% Prior to Ship”.
The exact meaning is 50% down payment and 50% before delivery, but I would like to simply set this to (50% Order date) and (50% Dou date - 7days). Can I set it up like this?
