Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Paul
Why not try this out?
Make the baseline date as no default and enter them on the last calendar
date of the month during document posting. Make the credit terms as 61 days
in your payment term. It is likely to have success rate of 75%.
Now as regards the exceptional 25 % ( only 6 such cases will happen).
Base line date During November,December and January ( Non leap year)
All November dated bills can use 01 Dec as baseline date.
The no default base line can be entered as 29 Jan and 29 Dec during document
posting instead of the last calendar date.
Base line date During November, December and January ( Leap year)
The no default base line can be entered as 30 Jan and 29 Dec during
document posting instead of the last calendar date.
All November dated bills can use 01 Dec as baseline date.
May be you could try the possibility of writing a substitution for tweaking
the baseline date during document posting which could make data entry user
independent.
Try it out please.
Regards
Check out the table below and I have used credit term of 61 days in all
cases and have tweaked baseline date in four exceptional cases marked with
asterix.
NONLEAP YR
LEAP YR
baseline dt due doctored
baseline dt due doctored
29-Jan-10 15-Mar-10 31-Mar-10 *
30-Jan-08 15-Mar-08 31-Mar-08 * 28-Feb-10 14-Apr-10 30-Apr-10
29-Feb-08 14-Apr-08 30-Apr-08
31-Mar-10 15-May-10 31-May-10
31-Mar-08 15-May-08 31-May-08
30-Apr-10 14-Jun-10 30-Jun-10
30-Apr-08 14-Jun-08 30-Jun-08
31-May-10 15-Jul-10 31-Jul-10
31-May-08 15-Jul-08 31-Jul-08
30-Jun-10 14-Aug-10 30-Aug-10
30-Jun-08 14-Aug-08 30-Aug-08
31-Jul-10 14-Sep-10 30-Sep-10
31-Jul-08 14-Sep-08 30-Sep-08
31-Aug-10 15-Oct-10 31-Oct-10
31-Aug-08 15-Oct-08 31-Oct-08
30-Sep-10 14-Nov-10 30-Nov-10
30-Sep-08 14-Nov-08 30-Nov-08
31-Oct-10 15-Dec-10 31-Dec-10
31-Oct-08 15-Dec-08 31-Dec-08
30-Nov-10 14-Jan-11 30-Jan-11*
30-Nov-08 14-Jan-09 30-Jan-09 *
29-Dec-10 12-Feb-11 28-Feb-11 *
29-Dec-08 12-Feb-09 28-Feb-09 *
VidhyaDhar
On Thu, Sep 16, 2010 at 8:46 AM, VidhyaDhar via sap-acct <
sap-acct@groups.ittoolbox.com> wrote:
>
> Posted by VidhyaDhar (User-friendly SAP FI Consultant)
> on Sep 15 at 11:16 PM
> Hi Paul
>
> One small correction..... I made a small slip..... Make sure that all Nov
> dated bills use 01 Dec as baseline date.
>
> Regards
>
> VidhyaDhar
>
> On Thu, Sep 16, 2010 at 8:22 AM, geevidhyadhar . email@removedwrote:
>
> > Hi Paul
> >
> > Why not try this out?
> >
> > Make the baseline date as no default and enter them on the last calendar
> > date of the month during document posting. Make the credit terms as 61
> days
> > in your payment term. It is likely to have success rate of 83%.
> >
> > Now as regards the exceptional 17 % ( only 4 such cases will happen).
> >
> > Base line date During January and December ( Non leap year)
> >
> > The no default base line can be entered as 29 Jan and 29 Dec during
> > document posting instead of the last calendar date.
> >
> > Base line date During January and December ( Leap year)
> >
> > The no default base line can be entered as 30 Jan and 29 Dec during
> > document posting instead of the last calendar date.
> >
> > May be you could try the possibility of writing a substitution for
> > tweaking the baseline date during document posting which could make data
> > entry user independent.
> >
> > Try it out please.
> >
> > Regards
> >
> > Check out the table below and I have used credit term of 61 days in all
> > cases and have tweaked baseline date in four exceptional cases marked
> with
> > asterix.
> >
> > NONLEAP YR
> >
> >
> >
> > LEAP YR
> >
> >
> > baseline dt due doctored
> >
> > baseline dt due doctored
> > 29-Jan-10 15-Mar-10 31-Mar-10 *
> > 30-Jan-08 15-Mar-08 31-Mar-08 * 28-Feb-10 14-Apr-10 30-Apr-10
> >
> > 29-Feb-08 14-Apr-08 30-Apr-08
> > 31-Mar-10 15-May-10 31-May-10
> >
> > 31-Mar-08 15-May-08 31-May-08
> > 30-Apr-10 14-Jun-10 30-Jun-10
> >
> > 30-Apr-08 14-Jun-08 30-Jun-08
> > 31-May-10 15-Jul-10 31-Jul-10
> >
> > 31-May-08 15-Jul-08 31-Jul-08
> > 30-Jun-10 14-Aug-10 30-Aug-10
> >
> > 30-Jun-08 14-Aug-08 30-Aug-08
> > 31-Jul-10 14-Sep-10 30-Sep-10
> >
> > 31-Jul-08 14-Sep-08 30-Sep-08
> > 31-Aug-10 15-Oct-10 31-Oct-10
> >
> > 31-Aug-08 15-Oct-08 31-Oct-08
> > 30-Sep-10 14-Nov-10 30-Nov-10
> >
> > 30-Sep-08 14-Nov-08 30-Nov-08
> > 31-Oct-10 15-Dec-10 31-Dec-10
> >
> > 31-Oct-08 15-Dec-08 31-Dec-08
> > 30-Nov-10 14-Jan-11 30-Jan-11
> >
> > 30-Nov-08 14-Jan-09 30-Jan-09
> > 29-Dec-10 12-Feb-11 28-Feb-11 *
> > 29-Dec-08 12-Feb-09 28-Feb-09 *
> >
> >
> > VidhyaDhar
> >
> >
> >
> > On Wed, Sep 15, 2010 at 8:53 PM, Paul Bastone via sap-acct <
> > sap-acct@groups.ittoolbox.com> wrote:
> >
> >>
> >> Posted by Paul Bastone (Senior FI
> >> consultant)
> >> on Sep 15 at 11:23 AM Hi,
> >>
> >> I am afraid that you may be right about a substitution or hard coding.
> >> I was hoping that there was an easier solution that I had missed.
> >> Kind regards,
> >> Paul
> >>
> >>
> >> From: sap180_fico via sap-acct <sap-acct@Groups.ITtoolbox.com>
> >> To: Paul Bastone email@removed
> >> Sent: Wed, 15 September, 2010 13:40:16
> >> Subject: Re: [sap-acct] Cannot set up a specific payment term
> >>
> >> Posted by sap180_fico
> >> on Sep 15 at 7:41 AM Mark as helpful
> >> For this payment terms cannot be defined in SAP
> >> However, ABAP code can be written to arrive due date...
> >> When user will put Invoice Date, ABAP code (may be substitution.. not
> >> sure)
> >> has start working to fill in baseline date / due date...
> >>
> >> On Wed, Sep 15, 2010 at 4:34 PM, Paul Bastone via sap-acct <
> >> sap-acct@groups.ittoolbox.com> wrote:
> >>
> >> > Posted by Paul Bastone(Senior FI consultant)
> >> > on Sep 15 at 7:06 AM Hello
> >> > I have a special requirement for a payment term and do not know how to
>
> >> set
> >> > it up. I am not sure if it possible to set it up correctly in SAP.
> >> > I am using release ECC6.
> >> >
> >> > The term should be based on invoice date.
> >> > The due date should be calculated as follows:
> >> > You take the invoice date and add 45 calendar days to arrive at a
> date.
> >> The
> >> > due date should then be the last calendar date of the month of the
> >> > calculated date.
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  VidhyaDhar
SAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
