Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
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 _.____.__ |