This website is not affiliated with, sponsored by, or approved by SAP AG.

Payment Terms and Baseline Dates

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, darkduck, Baz

Payment Terms and Baseline Dates

Postby willmarks » Wed Jan 22, 2014 6:30 am

Hi All,
I am having trouble understanding some payment terms in our system. The payment term, for example, 'Net Due 25th Next Month'.

We don't offer cash discounts on our payment terms. Our payment terms were set up by a team of consultants who implemented SAP some time ago.

In SPRO>Financial Accounting New>AR and AP>BUsiness Transactions>Outgoing Invoices/Credit Memos>Maintain Terms of Payment.

Image

I am expecting to see for such a payment term that the 'Fixed Date' and 'Additional months' (under Payment Terms) would be used to calculate the Due Date.

Instead, in this case the 'Fixed Day' and 'Additional months' fields have been completed under 'Baseline date calculation'. So effectively instead of calculating the due date, the payment term moves the Baseline Date to the 25th of the following month and makes the invoice due immediately.

What would be the benefit of configuring the system this way? Instead of having separate baseline and due dates, we now have matching dates. We would like to change this but are unsure why it would have been configured this way to start with. Does anyone have any ideas?

Thanks
William
willmarks
 
Posts: 10
Joined: Wed Jan 15, 2014 7:15 am
Location: Belfast, Northern Ireland, United Kingdom

Re: Payment Terms and Baseline Dates

Postby darkduck » Wed Jan 22, 2014 11:56 am

Both options are correct, as long as they give you the same calculation results.

If you have IDES access, you can see that SAP uses both techniques. See payment terms 0008, JP01, JP10.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Payment Terms and Baseline Dates

Postby willmarks » Thu Jan 23, 2014 4:23 am

Thanks darkduck,
And you see no issue in changing from one method to the other? I need my baseline date to be my document date, which it never will be when using the config shown above.

Thanks
William
willmarks
 
Posts: 10
Joined: Wed Jan 15, 2014 7:15 am
Location: Belfast, Northern Ireland, United Kingdom

Re: Payment Terms and Baseline Dates

Postby darkduck » Thu Jan 23, 2014 9:42 am

In terms of determining the Due Date, I don't see problems with changing one method to another.

Unfortunately, I don't see how you can use baseline date = document date, and still get a fixed payment date in the next month the standard way. It can only be achieved with a user-exit that would substitute values in the fields for number of days in payment terms.



http://www.sapexpert.co.uk
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Payment Terms and Baseline Dates

Postby willmarks » Fri Jan 24, 2014 4:49 am

Hi Darkduck,
I'm not sure I follow you. The due date is still a 'fixed day' - see screenshot on original post.

The baseline will be the document date (as selected) as I wouldn't be using the 'Baseline date calculation'.

Thanks
William
willmarks
 
Posts: 10
Joined: Wed Jan 15, 2014 7:15 am
Location: Belfast, Northern Ireland, United Kingdom

Re: Payment Terms and Baseline Dates

Postby darkduck » Fri Jan 24, 2014 5:11 am

William,
In the scenario shown above, your Baseline date will be the 29th of the next month. Zero days payment terms will apply.

You can easily check this in your sandbox.

If you want your baseline to be document date, but still have 29th of the following month to be the due date, then you need user-exit that will calculate the number of days between the doc.date and the required due date and populate the number of days in the document's field.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Payment Terms and Baseline Dates

Postby willmarks » Fri Jan 24, 2014 7:52 am

Hi darkduck,
It can be achieved without user exits. I will complete the 'fixed date' and 'additional months' fields under the 'Payment terms' and remove the values from the 'Baseline date calculation' fields.

Then I will have the document date as a baseline date, and due date on 25th of the following month, using only the standard configuration.

William
willmarks
 
Posts: 10
Joined: Wed Jan 15, 2014 7:15 am
Location: Belfast, Northern Ireland, United Kingdom

Re: Payment Terms and Baseline Dates

Postby darkduck » Fri Jan 24, 2014 8:13 am

Yes, you're right. :oops:
This way, the system automatically calculates the number of days for the payment terms, leaving the baseline date as requested.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Payment Terms and Baseline Dates

Postby willmarks » Wed Jan 29, 2014 6:15 am

Thanks for all the replies.
willmarks
 
Posts: 10
Joined: Wed Jan 15, 2014 7:15 am
Location: Belfast, Northern Ireland, United Kingdom

Re: Payment Terms and Baseline Dates

Postby darkduck » Mon Feb 17, 2014 3:55 am

SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?


Return to Financials

Who is online

Users browsing this forum: No registered users and 4 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.