Due Date Calculation

SavatageSavatage Member Posts: 7,142
edited 2005-04-28 in Navision Attain
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

Comments

  • jmjm Member Posts: 156
    Hi Savatage,

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


    br
    Josef Metz
    br
    Josef Metz
  • SavatageSavatage Member Posts: 7,142
    Works Great! You Rock! 8)
  • fbfb Member Posts: 246
    Hmm -- what about orders entered after June 1st.

    They'll immediately be past due, no?
  • SavatageSavatage Member Posts: 7,142
    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.
Sign In or Register to comment.