Due Date Calculation

Savatage · 2005-04-28

We have a terms code called SUNTAN
where regardless of the order date the payment is due 06/01 (June 1st)

I have tried
wd-wd+5m (work date minus work date plus 5 months)

but the formula doesn't seem to work..

any ideas how I can get the terms to show June 1st?

Thanks

jm · 2005-04-28

Hi Savatage,

try "-CY+5M" (=beginning of current year + 5 Months) .

br
Josef Metz

Savatage · 2005-04-28

Works Great! You Rock! 8)

fb · 2005-04-28

Hmm -- what about orders entered after June 1st.

They'll immediately be past due, no?

Savatage · 2005-04-28

There won't be any order with those terms after June 1st.

It's a Special Terms order - where we allow qualified customers to purchase large quantities of Suntan Products early in the Suntan Season and give them till June 1st to pay.

Right now I have been going into the Cust Legder Entries and manually changing the Due Date. I've been thinking about figuring out the code for 2 years now - just never got around to it.

Due Date Calculation

Comments

Categories