web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Multiple payment terms
Microsoft Dynamics GP (Archived)

Multiple payment terms

(0) ShareShare
ReportReport
Posted on by Steven Church 110

I'm trying to find an automated way of handling a situation that I think requires multiple payment terms or a changing a payment terms on a posted invoice.

The Payment Terms concept I'm trying to apply is say 4% COD (2 day grace period) and 2% EONM.  I know GP doesn't have an EONM option but we can implement this as an EOM + 30 days.

My first reaction was to run a nightly batch job to change the Payment Terms ID on each invoice older than the grace period to change from the 4% COD to 2% EONM.  Am I asking for trouble by doing this?

Does anyone have suggestions on how best to implement this?

*This post is locked for comments

I have the same question (0)
  • slwenzl Profile Picture
    slwenzl 60 on at

    Have you ever figured out how to do this?  I am looking for a way to have multiple payment terms on one customer as well.  For example 15% off if they pay in 15 Days, 10% off if they pay in 20, net 45.  

  • Josh P Profile Picture
    Josh P 2,895 on at

    Hi Steven,

    Changing the payment terms on a posted invoice via SQL is not the best solution simply because of the number of tables to be updated. However, GP does not provide this functionality that I am aware of. If you are insistent on doing this through SQL using a batch, you should run a query that pulls all the tables which contain the field you will be updating, write them down, and compare the tables affected by your SOP transaction.

    SELECT * FROM sysobjects o, syscolumns c

    WHERE o.id = c.id AND o.type = 'U'

    AND c.name = 'PYMTRMID'

    The above will give you a list of all tables that contain the field "PYMTRMID' or payment term id.

    Hope this gets you started in the right direction.

    Regards,

    Josh Pelkola

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Steven,

    Changing the payment terms ID directly in SQL will not actually accomplish what you want.  You would instead need to update the Due Dates, Discount Dates and Discount Amount Available on each transaction.  I would recommend some intensive testing before putting something like this in place, but if done correctly, I think it should work.

  • Josh P Profile Picture
    Josh P 2,895 on at

    This is a good point Victoria.

    If he wants to create reports though based on the payment terms for his invoices, both the terms and the dates would need to be updated, right? Seems like there is a number of issues here that might make performing these types of updates dangerous for data integrity.

    Regards,

    Josh Pelkola

  • slwenzl Profile Picture
    slwenzl 60 on at

    Hello - Thanks for responding.  So it sounds like running a report to get a listing of the invoices that will need to be switched to the second stage of the payment terms, then manually changing each invoice is the only "safe" option available at this point in GP.  Has there been any mention of adding the capability of multiple payment terms on one invoice in future releases?  I feel like this would be something lots of companies would run into, especially if they have a sales force out there trying to offer discounts for prompt payments.  

    Thanks,

    Shanielle

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at

    Please vote for my suggestion ID #670856 on Microsoft Connect as this problem is a good example of what we hope Microsoft will fix.

    connect.microsoft.com/.../gp-payment-terms

  • Josh P Profile Picture
    Josh P 2,895 on at

    Hi Shanielle,

    I think the big problem here is once the invoice is posted, the only information that can be changed from the GP user interface is: Document Date, Due Date, PO Number, and Description as Victoria alluded to above. This is in the Edit Receivables Transaction window. Anything beyond this would be required in SQL.

    The payment terms cannot be changed on the invoice to my knowledge once posted through GP. This is why if you needed to show the new payment terms id for reporting, it would probably need to be done in SQL.

    Also, note that changing the above dates using GP modifies the RM transaction. If you are using SOP invoicing, the original sales invoice does not get changed. Reprinting the invoice would not show an updated payment terms without modifying the sales transaction in SQL. The dates above are meant to adjust the aging.

    Regards,

    Josh Pelkola

  • Steven Church Profile Picture
    Steven Church 110 on at

    Thanks for the feedback everyone.  There is no easy way to accomplish this.

    I really didn't want to come up with a SQL-based solution as there is too much risk for data integrity problems as you folks have pointed out.

    We ended up implementing a customized solution that modified the Payment Terms Setup window and the apply payments windows to provide the customer the exact solution they needed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans