Inventory Valuation Report

Robert Robinson

Robert Robinson

Reputable Poster
One of our companies is trying to run an Inventory Valuation Analysis (DREAMWriter)
report as of 10/31/00. This canned report does not allow for the control of dates,
though; has anyone created a World Writer that allows the creation of inventory balance
reports as of a selected point in time (such as end of month)?





Robert Robinson, CPA/CITP, CNE
Senior Business Systems Analyst
Durr, Inc.
734.459.6800
fax # 734.459.5837
e-mail address: [email protected]
 
We just changed our procedure on this.

During startup, we setup a report that used beginning balances and
re-added/subtracted the Item Ledger transactions to arrive at a month-end
inventory balance.

This was beginning to chew up too many resources, so we are now capturing
inventory balances (custom program) at 12:01 AM on the first day of each month
and printing our month-end reports from this custom file.

Phil






RRobinson <[email protected]> on 12/18/2000 04:10:54 PM

Please respond to [email protected]

To: [email protected]
cc: (bcc: Phil Rumschlag/PHD)
Subject: Inventory Valuation Report ~~0:2881




One of our companies is trying to run an Inventory Valuation Analysis
(DREAMWriter)
report as of 10/31/00. This canned report does not allow for the control of
dates,
though; has anyone created a World Writer that allows the creation of inventory
balance
reports as of a selected point in time (such as end of month)?





Robert Robinson, CPA/CITP, CNE
Senior Business Systems Analyst
Durr, Inc.
734.459.6800
fax # 734.459.5837
e-mail address: [email protected]





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

To get a valuation of stock, at a particular point in time, that I can reconcile against the G/L, I have used the 'Item Ledger' report <2/G41111>. This produces a rather large report but the totals are what interests us. It is important to make sure that the 'From Date' is less than or equal to your beginning balances date, but the 'End Date' can be at any point in time that you want.

Regards

Gavin Clark

Gavin Clark
IT Consultant
World/Oneworld Applications support
World Development
 
due to the constantly changing Quantity on hand fields, any reports we've
done have had to be timed to run at month end. We haven't found any way of
going back and running month end balance for prior months, since the data
doesn't exist in JDE naturally.
If someone else has, I'd be interested to know how.
 
You might want to take a look at the Advanced Stock Valuation Module.
System 39. It has all the reports you'd ever need with full control of the
dates. Basically it does an extract from the item ledger into some Stock
Valuation files and the displays and reports are over these files. It might
be overkill for your situation, but someone out there can probably benefit
from it.

Andy

Andy Klee

Klee Associates
J.D. Edwards Certified Professional
Voice: (970) 856-4811
Cel: (203) 223-5216
www.JDETips.com
 
Re: RE: Inventory Valuation Report

I checked with our IT Dept. We seem to have purchased every other module that JDE has, but not System 39. Any advice? Is it worth acquiring this module or can a WW be developed?
I know that our Warehouse has been requesting a report (for nearly 2 years) that can be used to balance our inventory valuation with our G/L.
Thanks, in advance
Brian
 
Have you looked at the AS OF Inventory file for past months values and on
hand?
Check out menu G4122. Run option 2 to update the As Of file nightly from
Cardx should provide inventory balance for any given date....

Dave Fletcher


>
 
You could try and write WW reports calculating balances at certain dates but
perhaps the Inventory Turn R41116 and
Supply and Demand R4051 reports might be what you are looking for. These are
standard JDE reports and have date selection.

Alec
 
Back
Top