• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Inventory Valuation Report

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: rrobinson@durr-usa.com
 

prumschlag

Active Member
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 <rrobinson@durr-usa.com> on 12/18/2000 04:10:54 PM

Please respond to jdeworld@jdelist.com

To: jdeworldml@jdelist.com
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: rrobinson@durr-usa.com





--------------------------
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
*************************************************************
 

Gavin Clark

Active Member
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
 

Suni

Active Member
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.
 
G

Guest

Guest
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
 

Bgetty

Active Member
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
 

DFletcher

Member
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


>
 

Alec

Member
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
 
Top