report R41540

When we run the item ledger detail report (R41540) we get a
BF on the items. We thought maybe this was because we were
running it for transactions done in February and there are
less than 30 days? Anyone else have this problem or have
any info on it.

Thanks,
Carla Terwilliger
Orlando Utilities Commission
Business Analyst
e-mail www.cterwilliger@ouc.com
 

Mike Dupaix

VIP Member
Carla,

There is a processing option that allows you to print the detail based on a date range (beginning and ending). Any item transactions before the beginning date will be summarized and be reported as BF.

> When we run the item ledger detail report (R41540) we get a
BF on the items. We thought maybe this was because we were
running it for transactions done in February and there are
less than 30 days? Anyone else have this problem or have
any info on it.

Thanks,
Carla Terwilliger
Orlando Utilities Commission
Business Analyst
e-mail www.cterwilliger@ouc.com





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=6846
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

<



Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 
I use the processing option and enter the beginning and
ending month for the transactions. This report is used
every month and it just showed up for February with the
balance forward. We did a mod to the report and made our
own R55 report which summarizes the total quantities of each
item and the total dollar value. Because of the high volume
the totals are not right and we end up manually figuring the
amounts we need. I thought there might be something on the
Accounting side where they have a 30 day monthly cycle and
it's throwing off just February because there are less than
30 days.
 

david_mallory

Well Known Member
Carla,

If you think the wrong inventory item issues totals on R41540 might have
something to do with accounting months, I would go to P0010 company names
and numbers, select the company, and go to Form, Date Patterns (which is
P0008), and do Find, and see what Accounting has set for month beginning and
ending dates. The normal thing is to have, for example, 2/1/01 and 2/28/01
if you are using calendar months.

Dave Mallory Denver Water
 
Discover how to build no-code data integrations and business process automations.
Top