mibuso.com

Microsoft Business Solutions online community
It is currently Wed Sep 03, 2014 1:45 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: 10th - 25th Prox - Payment Terms
PostPosted: Mon Jan 18, 2010 11:39 pm 
Offline

Joined: Wed May 12, 2004 4:41 pm
Posts: 21
Location: Detroit, Michigan
Country: United States (us)
Several of our suppliers are offering Payment terms that use the following Concept of 10th-25th prox.

In a Nutshell these terms mean

If a Supplier invoice is dated on or before the 15th of a Month, Then it is due on the 25th of the same Month. If the Invoice is dated after the 15th of the Month, then it is due on the 10th of the Following Month.

for example

Invoice 123 Dated January 14, 2010 is due on January 25, 2010
Invoice 124 Dated January 20, 2010 is due on February 10, 2010

Most of these invoices deal with a payment discount, But if I can figure out How to set Navision up to perform this due date calculation, using no development, I can resolve all of my setup issues.

This forum is twofold. Does you company / clients have a need for these types of terms? If so, please respond. If this functionality does not currently exist, perhaps we can get a discussion started to get this to get this functionality in the future.

Any Ideas on How to create this payment terms calculation? If so, I am pretty sure that you would be helping out a lot of people, including myself?

Thanks again,

Alan


Top
 Profile  
 
 Post subject: Re: 10th - 25th Prox - Payment Terms
PostPosted: Fri Jan 22, 2010 12:29 am 
Offline

Joined: Thu Apr 10, 2008 9:37 am
Posts: 226
Location: Denver, CO
Country: United States (us)
I believe you would need manual intervention from the user to do this without development. The issue here is creating one Date Formula that does not result in a static output (15th of the following month, 60 days, etc.). So you could have a payment term for each one and then the user could select whichever one was appropriate.

For the first one: D25 and the second 10D+1M-1D


Top
 Profile  
 
 Post subject: Re: 10th - 25th Prox - Payment Terms
PostPosted: Mon Jan 25, 2010 8:35 pm 
Offline

Joined: Wed May 12, 2004 4:41 pm
Posts: 21
Location: Detroit, Michigan
Country: United States (us)
Alex,

Thank-you. I was looking for some confirmation, and also wondering if there was any other way. Your suggestion seems to be the consensus. I really appreciate your Input.

Thanks,

Alanhttp://www.mibuso.com/forum/posting ... 3&t=39485#


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: