standard item cost

SoniaChauhan

SoniaChauhan

Active Member
Hi all,
I have a small problem . I am new to JDE. My manager wants me to make a program which extracts standard cost for item and saves it in SQL table. I was using F4105 file because i get to know this is item cost master file so i thought it will have information for all the items that are present in the system But now i am having a problem because we have already been set menu named cost revision in JDE which gives us all cost for particular item, when i extract cost from that JDE menu i get standard cost for say 112233 item number but when i try to extract standard cost thru VB from F4105 file it says there is no standard cost(07) for this 11223 item number. I am really confused????? Is there any other file which can have all the costs for items? pls help me its really urgetnt for me n i am stuck nowhere
 
Perhaps you have F4105 in multiple libraries. Verify that you are selecting from the F4105 that you intended:
SELECT COITM, COLITM, COLEDG, COUNCS FROM Library/f4105
WHERE coledg='07'
 
In a hury?



JD E does have great documentation to review.

Looks like someone did not enter cost standard




--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316
 
Since the library list is often the fault of the problem ...

to check for multiple files in library list

DSPOBJD OBJ(*ALL/F4105) OBJTYPE(*ALL)=C2=A0

This will tell you where your files are and then you can determine what fil e is being used
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0



--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316
 
It certainly is very possible for an item to not have a cost method 07 reco rd in the F4105 file.=C2=A0 In the F4105 record, there is a field for Purch asing and a separate field for Inventory, that one record for Purchasing an d one for Inventory (keyed by item number, branch plant) is the primary cos t method.=C2=A0 Normally cost method 07 is the primary method for inventory , but it does not have to be.=C2=A0 If you do the cost inquiry, that screen will show you for that part number and branch plant, what the inventory co st method is and what the purchasing cost method is.=C2=A0 You might also h ave data issues in your system as well.=C2=A0 Hard to tell when cannot take a look at your data.=C2=A0 JDE support can start a support session over th e web and look at your data with you, which you may find helpful to underst and your situation.
John Dickey
 
where do u want me to type in this command to get file in different libraries. i never even touched JDe
 
Sonia ,

From a menu in JDE or a systems command line type the following and
press enter:
WRKOBJ *ALL/F4105 *FILE

Tell me what are the libraries that contain the F4105 please.

Jim
 
DSPOBJD OBJ(*ALL/FILENAME) OBJTYPE(*ALL)




--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316
 
Re: RE: standard item cost

There are two of them one is
JDFDATA n PRDDTA
 
RE: RE: standard item cost

Sonia,

Ok that is good. Now be sure when you are doing your data extract that
you are getting the file in library PRDDTA and not the one in JDFDATA.
My guess is that you are getting the data from the file in JDFDATA.

Jim
 
Re: RE: RE: standard item cost

No Jim I am extarcting data from PRDDTA , and it is not givin me desired result. Then i tried from jDfdata, but still in vain. Today I tried STRSQL command to see data in both the files , i didnt get standard cost from any of file in both libraries, but when i did it thru menu i got standard cost. so it clearly means that menu is getting value from smewhere n its not F4105. I think this is not soing to be so easy as i thought.
Thanks anyways
 
Re: RE: RE: standard item cost

i have attached file showing value that is coming from JDE menu, but this value is not present either in PRDDTA?F4105 or JDFDATA/F4105. so now i am not sure which file to access. this is not goibg to be that easy as i thought.
Thanks Jim
 

Attachments

  • 146532-Doc1.doc
    708 KB · Views: 135
RE: RE: RE: standard item cost

Hi Sonia,

No attachments come through JDE List.
In your extract or SQL are you doing a WHERE on the MCU field? If so
you have to be sure you have the value in the right position. And when
looking for the 07 cost method, it needs to be in quotes as it is an
alpha field. I am just grasping at different things since I cannot see
what it is you are actually doing in the extract or SQL commands.

It is easy and you should be able to get the data out of the file the
same as the JDE program is. It has to be on the data selection and how
you are formatting the values.
Jim
 
Re: RE: RE: RE: standard item cost

sql = "SELECT F4105.COLITM,COLEDG,F4105.COUNCS,F4101.IMDSC1 FROM PRDDTA.F4105,PRDDTA.F4101 where F4105.COLITM = F4101.IMLITM AND COLITM='" & TxtPartNbr.Text & "'"
Above is the query which i am using to get the datA. This query works fine for some values but i dont get standard cost for all values.
 
Compare side by side some records hat work and some you are expecting to wo rk.

See what the variances in data are

Either correct the data in the file or change the query




--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316
 
I thought it worked but still i came to satae zero!!!!!!!
Well I chekced the program that is running behind for Item Cost Revision.Hree are the details:-
Source Library:- JDFSRC
Object library :- JDFOBJ
Source File:- JDESRC.
So what this means?
Do i have to access JDFDATA/F4105 instead of PRDDTA/F4105?
Please help me. This program is taking on my nerves now!!!!
 
If you are having this much trouble with this item, I suggest you contact J DE Support for assistance.=C2=A0 JDE support will have the ability to start a web session with you and be able to see what you see and be able to look at your data.=C2=A0 We on this forum can not do that.=C2=A0 If I could log onto your system and look at your data, I am confident that I could =C2=A0 figure out what is going on (probably in less than 5 minutes).=C2=A0 Since we cannot do that, we can only speculate as to a cause, and you end up wast ing time trying to research things that are not the issue.=C2=A0 This shoul d not be this hard.=C2=A0 If you go into a JDE menu and go to item costing maintenance (Function key from Item/Branch screen), and pull up the part nu mber for the branch plant in question, that screen will pull up all F4105 r ecords for that part/branch.=C2=A0 That will tell you what cost methods you have avaible for that part at that branch.=C2=A0 That screen will also tel l you what the inventory cost
method is and what the purchasing cost method is.=C2=A0 You may want to re ad the JDE manuals to learn about item costing.=C2=A0 Anyway, if you see a row for cost method 07 on this screen, it will be in the the F4105 file.=C2 =A0 If you don't see any records at all, that confirms there are no F4105 r ecords at all.=C2=A0 If no cost method 07 row, that confirms no cost method 07 record.=C2=A0 If you see cost records, start another AS/400 session and do a dspjob (option 5) on your first session.=C2=A0 Take option 14 to disp lay open files.=C2=A0 That will show you your open data paths.=C2=A0 There will be a file name and a library name column.=C2=A0 F4105 will be in one o f those rows (may have to page down to find it, and could be in the list mu ltiple times).=C2=A0 Find that row and that will tell you what library you are working with.=C2=A0 If you are not sure how to do a DSPJOB action on an intereactive job, see if you have an AS/400 IT veteran there to help you o ut, or contact IBM Support for
assistance.=C2=A0
John Dickey
 
JDFSRC/JDFOBJ are the source/object libraries for the standard JDE programs. JDFDATA should be the "pristine" data files, ie: sample data supplied by JDE.

Your data should be in PRDDTA and the cost will be in F4105.

Maybe try to select data from F4105 without linking to any other files, just to make sure you get some data. Check that you have some standard cost records (07), and note that "07" is a JDE standard, it doesn't mean the company is using that.

Are there any JDE programmers in the company? They should know about the system and be able to help.

This is unfortunately a sign of the times, where people are let loose to try and get data out of JDE when they don't know JDE or the AS400. In the "old days" we used to learn about systems before we were expected to try and use them, so we knew operating system commands and could find our way around.

I would suggest AS400 Query to view data if you are familiar with it. Often it's easier to view data that way than with SQL.

Good Luck.
Tony
 
I use STRSQL command to query F4105 file. You are right but its really tough for programmer like us who are given tasks and supposed to do it in time limit when we r not at all familiar with JDE. We dnt have JDE programmer here, thats why i am googling net to get my answers,
Thanks
 
Back
Top