Business_Day_Back or something else?

christopherb

Hello All,
Ok this is a two part post......I would like to search an OB of payments looking for any due date that are within 10 days then do whatever. The user guide is not clear with the correct syntax for Business_Day_back.

Could someone give me an example with not using the default of 1 day.

Then the second part to my post.... Opinion of the best way to do what I am asking?

Thank you
Chris

tford

Chris,

It appears that Business_Days_Back function with > 1 day can only be used in BO rules & not in a Query or Process FIND action. When I tried to use BUSINESS_DAY_BACK(CURRENT_DATE,2) in a Query I got the error message:

"Internal error. Element BUSINESS_DAY_BACK in query condition Test.TestDate=BUSINESS_DAY_BACK(CURRENT_DATE,2) of query FIND Test WHERE Test.TestDate=BUSINESS_DAY_BACK(CURRENT_DATE,2) cannot be converted to the currently installed version of SQL "

BUSINESS_DAY_BACK with x business days CAN be successfully used in a RULE. For example, to flag instances of Payment BO with DueDate attribute 2 days back, use: Payment.DueDate=BUSINESS_DAY_BACK(CURRENT_DATE,2) Then Test.TwoDaysBack='Yes'

I think there is actually an easier way to achieve your result, though. See next post.

Tom

tford

FYI for other readers, Chris' Payments BO is owned by Contract BO. The Payments BO holds scheduled payments due on a Contract. Each Payment has a Payment.DueDate and also a rule that keeps Payment.BalanceDue up to date.

Chris, try this process:
FIND ALL Contract

FIND Payment
WHERE Payment IN Contract.Payments
AND Payment.BalanceDue>0
AND Payment.DueDate<DATE_ADD(CURRENT_DATE,14)
ORDER BY Payment.CompanyName,Payment.DueDate

DISPLAY DOCUMENT 'Payments Due'

This process assumes that you want to print a report of all unpaid payments due within the next 14 calendar days (approximation of your original 10 business days). Also assumes is that you have a 'Payments Due' report which is "Determined at run time' that summarizes Payments Due by Company Name & Due Date.

Hope this helps,
Tom