Finance | Project Operations, Human Resources, ...

taCalcDueDatePM stored procedure is not calculating the due date and discount date properly

(0) Share

Report

Posted on by DM-22051448-0

Hello,

I've configured the payment terms as shown below, and when I utilize the /Calculate/ feature within the Payment Term setup window, it correctly computes the Due Date and discount date. However, when I employ the Dynamic GP stored procedure [taCalcDueDatePM] to perform the same calculation, it does not yield the correct results.

USE [TWO]
GO

DECLARE   @return_value int,
       @O_dDISCDATE datetime,
       @O_dDUEDATE datetime,
       @O_iErrorState int,
       @oErrString varchar(255)

EXEC   @return_value = [dbo].[taCalcDueDatePM]
       @I_vVENDORID = N'DM',
       @I_vPYMTRMID = N'2% 10TH',
       @I_vDOCDATE = N'10/19/2023',
       @O_dDISCDATE = @O_dDISCDATE OUTPUT,
       @O_dDUEDATE = @O_dDUEDATE OUTPUT,
       @O_iErrorState = @O_iErrorState OUTPUT,
       @oErrString = @oErrString OUTPUT

SELECT   @O_dDISCDATE as N'@O_dDISCDATE',
       @O_dDUEDATE as N'@O_dDUEDATE',
       @O_iErrorState as N'@O_iErrorState',
       @oErrString as N'@oErrString'

SELECT 'Return Value' = @return_value

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

sandipdjadhav 18,333 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You are missing the Due Days.

Thanks much

Sandip

Was this reply helpful? Yes No
Suggested answer

Mick Egan 3,561 on at

Like (0)

Report
Copy link

Link copied!

Just to add to the Post:

The Stored Procedure's - Discount Date only works when "Discount - Days, Date or EOM" are selected, the other options return Blank.

The Discount is caluclated from the "Due Date" settings, so even though the Payment Terms Example screen returned results, these are not in line with the Stored Procedures caluclations.

We have found the Due Date "EOM" can calculate the current Month's last day instead of the next Month when using "Calculate Days from : Transaction Date"a so you may need to add a Calculation to your returned date to fix this issue, only if using EOM for Due Date. I think you will be fine, as using Discount Date seems to fix the issue.

Mick

Was this reply helpful? Yes No