I created what seemed like would be a simple bpm using SalesOrder.Update. It is designed to throw up an informational message if a customer has outstanding invoices over 30 days past due. I encountered a problem with the query not triggering if the statement was InvcHead.DueDate<"today-30" , but would trigger if it was simply "today". I am completely flummoxed! Any ideas or suggestions would be appreciated. The query in it's entirety is as follows:
for each ttOrderHed,
first Customer where (ttOrderHed.company=Customer.Company and
ttOrderHed.CustNum = Customer.CustNum), each InvcHead where (InvcHead.DueDate<“today”
AND InvcHead.OpenInvoice=TRUE AND InvcHead.CreditMemo=FALSE) and Customer.Company=InvcHead.Company and
Customer.CustNum=InvcHead.CustNum) no-lock
for each ttOrderHed,
On Tue, Feb 25, 2014 at 3:38 PM, <melody@...> wrote:<div> <p></p><p>I created what seemed like would be a simple bpm using SalesOrder.Update. It is designed to throw up an informational message if a customer has outstanding invoices over 30 days past due. I encountered a problem with the query not triggering if the statement was <span style="font-size:11pt;">InvcHead.DueDate<"today-30" , but would trigger if it was simply "today". I am completely flummoxed! Any ideas or suggestions would be appreciated. The query in it's entirety is as follows:</span></p>
for each ttOrderHed,
first Customer where (ttOrderHed.company=Customer.Company and
ttOrderHed.CustNum = Customer.CustNum), each InvcHead where (InvcHead.DueDate<"today"
AND InvcHead.OpenInvoice=TRUE AND InvcHead.CreditMemo=FALSE) and Customer.Company=InvcHead.Company and
Customer.CustNum=InvcHead.CustNum) no-lock
</div> <div style="color:#fff;min-height:0;"></div>
I thought so too Habib, but if I just use parens, I get the following error message:
TODAY-30 must be a quoted constant or an unabbreviated, unambiguous buffer/field reference for buffers known to query. (7328)
On Tue, Feb 25, 2014 at 4:18 PM, <melody@…> wrote:<div> <p></p><p>I thought so too Habib, but if I just use parens, I get the following error message:</p><p>TODAY-30 must be a quoted constant or an unabbreviated, unambiguous buffer/field reference for buffers known to query. (7328)</p>
</div> <div style="color:#fff;min-height:0;"></div>
Jim Kinneman
Encompass Solutions, Inc
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, Feb 25, 2014 at 5:18 PM, <melody@...> wrote:<div> <p></p><p>I thought so too Habib, but if I just use parens, I get the following error message:</p><p>TODAY-30 must be a quoted constant or an unabbreviated, unambiguous buffer/field reference for buffers known to query. (7328)</p>
</div> <div style="color:#fff;min-height:0;"></div>