We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-acct] Cannot set up a specific payment term

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by VidhyaDhar (User-friendly SAP FI Consultant)
on Oct 27 at 11:16 PM
Mark this reply as helpfulMark as helpful
Hi

A customized programming is foolproof. I tried writing a program in Fox pro
( as I am not an ABAPer) to ascertain 45 days from the date of the document
and push it to the end of the month in which the invoice falls due. It works
pretty well.

The program logic first adds 45 days to the baseline date ( which is the
document date) and the result is stored to a date variable. This variable is
then parsed and chunked into three variables for *Date, Month and Year*.

If the *Month* is 1, 3 , 5 , 7 ,8 10 or 12 then the *Date* is set to 31

If the *Month* is 2

and if the *Year* is divisible by 4 then *Date* is set to 29 else to
28 (*)

(*) You may have to perform the additional check of divisibility *
Year* by 1000 and the result again by 4 for leap centuries

Otherwise

*Date* is set to 30

Now convert the Date,Month and Year Variables into string counter parts (
using pre-defined functions) and concatenate them in DD MM YYYY format and
convert the result into a date related data type and store the same as a
resultant variable called due date.

The difference between the Due date computed and the Document Date is
substituted as the payment terms. This would give the desired due date for
the invoice item.

The generic logic can be used in ABAP (using the appropriate methodology and
syntax) to compute due dates as desired and this, I think , would be
foolproof.

Regards

VidhyaDhar

---------------Original Message---------------
From: VidhyaDhar
Sent: Wednesday, October 27, 2010 9:42 PM
Subject: Cannot set up a specific payment term

Hi

I guess requirement of payment term such as this has been requested by many
folks. Am not sure there is a comprehensive and foolproof standard solution
to this in Standard SAP by using features such as fixed date and day limit.
This is so on account of the fact that February has lesser number of days
than other months and February has one day more during leap years. Therefore
, I guess it would be a better idea to customize a procedure with the help
of your ABAP folk.

One possible work around could be peg the due date as the last date with
additional month as 1. This is apart from choosing No Default option for
Base line date and manipulating it manually during invoice posting (
choosing a baseline date by manually computing as due date less 45 days ).
However, in my opinion, this is a cheap work around and prone to clerical
error. Therefore, it would be better to develop a customized solution with
the help of an ABAPER.

Regards

VidhyaDhar

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
VidhyaDhar
SAP Accounting Top Contributor

Contributed the most posts in a group for a month to earn a Silver Achievement
Related Content
Most Popular White Papers

In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language