Vouchered YTD

SMain

Member
Hi,

Does anyone have the slightest clue how the voucher year to date (A6AYPD)
and voucher prior year (A6APPD) are calculated in the supplier master
F0401. I know you have to run the Update Voucher YTD Amount job. The
problem I have is that I cannot reconcile the numbers back to anything from
a supplier ledger inquiry screen even after running this job.

Is it based on GL dates, invoices dates or something else. The
documentation doesn't say. I haven't been able to tie it back to either.

For example, I ran the update using my prior year dates as 01/01/2000 to
31/12/2000. My vouchered YTD field says 20763.21 for a supplier, but when
I look at the supplier master the amount vouchered in this year (01/01/2001
- 31/12/2001) is 24396.77. There is no voucher or combination of vouchers
which represents the difference. A similar problem occurs for the previous
year 2000. The amount in the PYE field is 44354.86, but supplier ledger
says 52116.96.

This is really bugging me. Would welcome any input.

Regards,
Suzanne Main.
QBE Insurance Europe Ltd
This e-mail is intended only for the addressee named above. The e-mail
message and/or any attachments may contain confidential or privileged
information, and may not be copied, forwarded or disclosed to any
unauthorised person. If you are not the named addressee (or a person
responsible for forwarding the e-mail to the named addressee), please
notify us immediately by telephoning +44 20 7456 0000, or via e-mail
return.
Visit our website at http://www.qbeeurope.com/



________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp
 

John_Dickey

Reputable Poster
Hello. On the year to date calculation in accounts payable, you need to
look at the dreamwriter version. Processing option 4 (if you look at the PO
screen, it is actually number 3 in the program) controls the calculation of
Prior Year Amount and Current Year Amount.
If you say method 1, here is what happens. Assume your fiscal year ends
December 31, 2000. You are running this option on March 7, 2001. In method
1, the From Date and To date determine the prior year amount. So you would
input 01/01/2000 to 12/31/2001. Any F0411 records between 01/01/2001 and
03/07/2001 become the current year amount.

Okay, what if you use method 2? The program uses the From date and To date
to determine the current YTD amount. So you would input 01/01/2001 to
12/31/2001. Once the current YTD amount is calculated, the program takes
the current value of Current YTD amount - New YTD amount. The difference
becomes prior year amount. So if current year amount field = $10,000 and
the 01/01/2001 to 12/31/2001 = $4,000, the prior year amount becomes $6,000
(10,000 - 4,000) and the current year amount field becomes $4,000.

Yes, this is a bit tricky. I rather prefer the method 1 myself, because I
am not confident of what would be in the Current YTD field for method 2
(thus not confident I would get a good result). The trick with method 1 is
you have to input in processing options 1 and 2 the correct date range.

The program does look at the G/L date field (RPDGJ) to determine what
date/period the F0411 record is in.

Hope this helps. If not, please contact me.


John Dickey
White-Rodgers
(314) 577-1466
 

John_Dickey

Reputable Poster
Oops, I forgot to mention, the program (P04820) does subtract tax amounts
(RPSTAM) in calculating the vouchered amounts. That could be where your
difference is.

John Dickey
White-Rodgers
(314) 577-1466
 

SMain

Member
Hi

Thanks for your input.

We are using method 1. It's very strange but I can't get it to agree. Some
of the suppliers are fine, and others aren't. I've checked to see if the
tax field makes the difference but it's not that either.

It's not a huge issue. I just wondered as I will be converting these fields
to OneWorld soon, and it seems wrong to convert data which is incorrect, or
which you can't explain.

Regards,
Suzanne.





John Dickey <John.Dickey@White-Rodgers.com>@jdelist.com on 07/03/2001
22:30:50

Please respond to jdeworld@jdelist.com

Sent by: owner-jdeworldml@jdelist.com


To: jdeworldml@jdelist.com
cc:

Subject: RE: Vouchered YTD


Hello. On the year to date calculation in accounts payable, you need to
look at the dreamwriter version. Processing option 4 (if you look at the
PO
screen, it is actually number 3 in the program) controls the calculation of
Prior Year Amount and Current Year Amount.
If you say method 1, here is what happens. Assume your fiscal year ends
December 31, 2000. You are running this option on March 7, 2001. In
method
1, the From Date and To date determine the prior year amount. So you would
input 01/01/2000 to 12/31/2001. Any F0411 records between 01/01/2001 and
03/07/2001 become the current year amount.

Okay, what if you use method 2? The program uses the From date and To date
to determine the current YTD amount. So you would input 01/01/2001 to
12/31/2001. Once the current YTD amount is calculated, the program takes
the current value of Current YTD amount - New YTD amount. The difference
becomes prior year amount. So if current year amount field = $10,000 and
the 01/01/2001 to 12/31/2001 = $4,000, the prior year amount becomes
$6,000
(10,000 - 4,000) and the current year amount field becomes $4,000.

Yes, this is a bit tricky. I rather prefer the method 1 myself, because I
am not confident of what would be in the Current YTD field for method 2
(thus not confident I would get a good result). The trick with method 1 is
you have to input in processing options 1 and 2 the correct date range.

The program does look at the G/L date field (RPDGJ) to determine what
date/period the F0411 record is in.

Hope this helps. If not, please contact me.


John Dickey
White-Rodgers
(314) 577-1466




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=6878

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************





________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp
 

John_Dickey

Reputable Poster
Hmmm, so you don't think the tax amount could be causing the problem. On
your Supplier Ledger Inquiry, are you requesting ledger inquiry sequence
number 8, which would be by General Ledger date? The program does use the
General Ledger date field, as I mentioned, in the F0411 record. Would you
have any F0411 records after 12/31/2001? The program does not check for an
end date for current year - it just takes anything after the To date
specified? I would think the inquiry sequence might be the more likely of
the two. Otherwise you would have to go into a test environment for one
vendor with the problem and step through debug to see where the numbers are
coming from. It is possible you have found a program bug - would not want
to rule that out. Hope this helps a bit.

John Dickey
White-Rodgers
(314) 577-1466
 

SMain

Member
Hi there,

Yes, I am using ledger sequence 8.

We don't have any source code here or programmers, so I think I might
recommend we don't bring these fields across since they aren't necessarily
right. Hopefully OneWorld won't have the same bug if that is what it is. I
did wonder if the problem might be the result of us changing our year end
last year from June to December, which meant we only had a six month year.

Regards,
Suzanne.





John Dickey <John.Dickey@White-Rodgers.com>@jdelist.com on 08/03/2001
20:55:51

Please respond to jdeworld@jdelist.com

Sent by: owner-jdeworldml@jdelist.com


To: jdeworldml@jdelist.com
cc:

Subject: RE: Vouchered YTD


Hmmm, so you don't think the tax amount could be causing the problem. On
your Supplier Ledger Inquiry, are you requesting ledger inquiry sequence
number 8, which would be by General Ledger date? The program does use the
General Ledger date field, as I mentioned, in the F0411 record. Would you
have any F0411 records after 12/31/2001? The program does not check for an
end date for current year - it just takes anything after the To date
specified? I would think the inquiry sequence might be the more likely of
the two. Otherwise you would have to go into a test environment for one
vendor with the problem and step through debug to see where the numbers are
coming from. It is possible you have found a program bug - would not want
to rule that out. Hope this helps a bit.

John Dickey
White-Rodgers
(314) 577-1466





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=6960

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************





________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp
 

John_Dickey

Reputable Poster
Well, I have been looking at the source code. The program uses field RPDGJ
from the F0411 to determine current year/prior year status. So I would
think a change in fiscal year should not matter. That gets back to the fact
that your F0401 fields are consistently lower than what your supplier ledger
says they should be, and the example you noted the shortfall seemed to be
pretty close ratio wise for both current year and prior year. Which gets me
back to the program backing out tax calcuations from the RPAG field amount.
The program has a tax calculation routine that is called, and it can use
that calculated amount instead of the RPSTAM field amount when it does the
subtraction (depending on the result returned from the X4008C program).
That would put the F0401 fields less than the supplier ledger, but without
knowing your setup I cannot say for sure that would be the cause. So I am
pretty much out of any other possibilities at this point.

John Dickey
White-Rodgers
(314) 577-1466
 

SMain

Member
Hi,

Thanks for having a look at the code. It really is confusing. Unfortunately
I don't have the time to spend looking at it here as we are in the midst of
a conversion and this is a relatively minor issue.

Best regards,
Suzanne.





John Dickey <John.Dickey@White-Rodgers.com>@jdelist.com on 09/03/2001
16:50:39

Please respond to jdeworld@jdelist.com

Sent by: owner-jdeworldml@jdelist.com


To: jdeworldml@jdelist.com
cc:

Subject: RE: Vouchered YTD


Well, I have been looking at the source code. The program uses field RPDGJ
from the F0411 to determine current year/prior year status. So I would
think a change in fiscal year should not matter. That gets back to the
fact
that your F0401 fields are consistently lower than what your supplier
ledger
says they should be, and the example you noted the shortfall seemed to be
pretty close ratio wise for both current year and prior year. Which gets
me
back to the program backing out tax calcuations from the RPAG field amount.
The program has a tax calculation routine that is called, and it can use
that calculated amount instead of the RPSTAM field amount when it does the
subtraction (depending on the result returned from the X4008C program).
That would put the F0401 fields less than the supplier ledger, but without
knowing your setup I cannot say for sure that would be the cause. So I am
pretty much out of any other possibilities at this point.

John Dickey
White-Rodgers
(314) 577-1466




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=7028

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************





________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp
 
Top