tag:blogger.com,1999:blog-5285970135510371565.post6912787257234196562..comments2024-03-29T08:01:13.871-04:00Comments on The Dynamics GP Blogster: "End of Month + Net Days" payment terms due date calculationMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-5285970135510371565.post-2940705656359041442018-08-21T14:27:02.409-04:002018-08-21T14:27:02.409-04:00Quesetion: CSMEUTAH posted...
We had to update th...Quesetion: CSMEUTAH posted... <br />We had to update the trigger to include the pm00400 table since it also holds the duedate column<br /><br /><br />Did anyone determine if this is necessary to make this change? If we create the change on the PM20000 then does it not update this at the time it is posted?billc.edmontonhttps://www.blogger.com/profile/02056178208801333471noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-2364075832993716112015-01-22T08:14:43.106-05:002015-01-22T08:14:43.106-05:00I have a prospect that is using MAS90. They are ve...I have a prospect that is using MAS90. They are very interested in moving to GP, however, I've run into an issue with terms.<br /><br />This company has terms of: "$0.50/ton, 10th proximo net 30".<br /><br />For example, all invoices in January will have a due date of Feb. 10th. If paid, they receive a discount of $0.50 per ton.<br /><br />The second issue here is they want to limit the discount to receiving payment for ALL January invoices in order to give the discount. So, if they had 10 invoices in January, but only received payment on the 10th for 9 invoices, they would not get the discount.<br /><br />Any thoughts? Does anyone know if MAS 90 even does this?<br /><br />ThanksScott Steffennoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-55939945905399205652014-02-27T19:26:07.549-05:002014-02-27T19:26:07.549-05:00We had to update the trigger to include the pm0040...We had to update the trigger to include the pm00400 table since it also holds the duedate column:<br /><br />UPDATE A SET A.DUEDATE =<br />DATEADD(dd, B.DUEDTDS, DATEADD(dd, -1, DATEADD(mm, DATEDIFF(mm, 0, I.DOCDATE) + 1, 0)))<br />FROM pm00400 A<br />INNER JOIN INSERTED I ON (A.CNTRLNUM = I.VCHRNMBR) AND (A.DOCTYPE = I.DOCTYPE)<br />LEFT OUTER JOIN SY03300 B ON (I.PYMTRMID = B.PYMTRMID)<br />WHERE (I.DOCTYPE = 1) AND (I.PYMTRMID LIKE 'EOMPLUSND%')<br />CSMEUTAHhttps://www.blogger.com/profile/07136813705542781706noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-89538909047316745542014-02-27T19:25:02.196-05:002014-02-27T19:25:02.196-05:00Mario, I had to update the pm00400 keys table on t...Mario, I had to update the pm00400 keys table on the payables side since it also keeps the duedate. We noticed this looking up the transaction in inquiry. CSMEUTAHhttps://www.blogger.com/profile/07136813705542781706noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-36809384310121716082013-05-06T15:49:03.595-04:002013-05-06T15:49:03.595-04:00Geoff/Tim,
In further looking at your request, yo...Geoff/Tim,<br /><br />In further looking at your request, you should be able to setup those payment terms as EOM+ND just as I instructed in the article. In this case, your net days will be 60 (2 months) or 90 (3 months). <br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-4164480963638215212013-05-06T15:45:13.501-04:002013-05-06T15:45:13.501-04:00Geoff,
I did not work on this article, but the pa...Geoff,<br /><br />I did not work on this article, but the payment terms should be fairly simple to achieve with a bit of T-SQL scripting - very similar to what has been posted in this article.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-40602074843617550202013-04-30T02:37:50.373-04:002013-04-30T02:37:50.373-04:00Hi Mariano,
I have just found this Payment terms ...Hi Mariano,<br /><br />I have just found this Payment terms method which I require. You mentioned to Tim to read your article. How do I access that article from your site.<br /><br />Regards,<br /><br />Geoff JamesGeoff Jamesnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-24187978069707390582011-07-22T07:41:30.031-04:002011-07-22T07:41:30.031-04:00Tim,
Thanks for writing. I will show how to do the...Tim,<br />Thanks for writing. I will show how to do these special payment terms with the Support Debugging Tool. Look for my article this week.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-19596170107251965352011-07-22T07:40:43.426-04:002011-07-22T07:40:43.426-04:00Tim,
Thanks for writing. I will show how to do the...Tim,<br />Thanks for writing. I will show how to do these special payments with the Support Debugging Tool. Look for my article this week<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-80046085845863380422011-07-22T05:02:23.083-04:002011-07-22T05:02:23.083-04:00My Company use 3 different payment terms and I am ...My Company use 3 different payment terms and I am having an issue with 2 of them. The payment terms used are...<br />1 month (End of following month) - ive set this up using the Next Month option 31 days which is fine<br /><br />2 month (End of 2nd month) - eg. invoice date 22nd july 2011 will be due last day of Sept 2011<br /><br />3 month (End of 3rd month) - eg. invoice dated 22nd july 2011 will be due last day of Oct 2011.<br /><br />I cant work out how to do the last 2 payment terms. <br /><br />Any ideas?timgduncanhttps://www.blogger.com/profile/09256464749174049291noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-51224478940378845922011-04-19T22:17:59.532-04:002011-04-19T22:17:59.532-04:00Ever done any like avg 30 on Friday? We have a cu...Ever done any like avg 30 on Friday? We have a customer which is basically giving 25 days plus # of days until the following friday. This is for cash flow purposes. They also do things like avg 10 on wednesday which is 5 days plus # of days until Wednesday.Robert O'Donnellhttp://www.rocksolid.comnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-61470552103667541092010-08-11T07:23:16.579-04:002010-08-11T07:23:16.579-04:00Nice work...My company deals with numerous EOM+NET...Nice work...My company deals with numerous EOM+NET invoices, though I used a combination of VBA and SQL to get these to work.<br /><br />Triggers are probably more ideal though.jerry hnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-79997572549966691932009-07-16T17:30:14.937-04:002009-07-16T17:30:14.937-04:00Cool!!!Cool!!!Janakhiramhttps://www.blogger.com/profile/04465158187134382030noreply@blogger.com