Current date + value from attribute

hpl123

Hi all,
I am trying to create a setting for users to have a custom invoice due date for their invoices. I am trying to have an number attribute called "InvoiceDuedate" in a BO called "Settings" be part of a process to create the invoice and populate the date fields:

"ENTER NEW Invoice WITH Invoice.InvoiceDate=CURRENT_DATE,Invoice.DueDate=CURRENT_DATE+LoggedInSettings.InvoiceDuedate"

The InvoiceDate gets populated with the current date but so does the InvoiceDuedate. Any ideas on why + how to achieve this?

hpl123

I figured this one out. The problem was with the settings BO not being in the context (i think).

FIND Settings WHERE LoggedInSystemUser.LoginName=Settings.Owner
ENTER NEW Invoice WITH Invoice.InvoiceDate=CURRENT_DATE,Invoice.DueDate=CURRENT_DATE+SUM Settings.InvoiceDuedate

hpl123

hpl123 wrote
FIND Settings WHERE LoggedInSystemUser.LoginName=Settings.Owner
ENTER NEW Invoice WITH Invoice.InvoiceDate=CURRENT_DATE,Invoice.DueDate=CURRENT_DATE+Settings.InvoiceDuedate

Removing "SUM". It shouldn´t be there, was a workaround trial i did.

tford

Take a look through the functions & familiarize yourself with them. There are functions that do math with date attributes.

hpl123

Will do. Hadn´t thought about that.