Item Cost - Purchasing Method

RAMMEDJR

Well Known Member
Release B7331 - SP 11.2
Database - Oracle
Server HP-UX


We are trying to do a mass change to the Costing Method - Purchasing for an
item but am unable to find which file the alias PCSM resides in. To find
this we go to G3014, select Enter/Change Item Cost (P4105), we then do a
find on an item and select. In the Costing Method box we are trying to
change the Purchasing field (alias PCSM). We have 5500+ items I need to do
a mass change to.

Any help would be greatly appreciated.

Thanks

Dave Rammer
Sheboygan County IS
 
Hi

PCSM is from Branch/Plant constants(F41001), menu G4141.
Probably no need for massupdate, because you change the value per branch/plant.

Regards
Carl-Magnus




RAMMEDJR <[email protected]> on 2000-12-11 16:54:25

Please respond to [email protected]

To: [email protected]
cc: (bcc: Carl-Magnus Olsson/TDS)
Subject: Item Cost - Purchasing Method ~~0:2399




Release B7331 - SP 11.2
Database - Oracle
Server HP-UX


We are trying to do a mass change to the Costing Method - Purchasing for an
item but am unable to find which file the alias PCSM resides in. To find
this we go to G3014, select Enter/Change Item Cost (P4105), we then do a
find on an item and select. In the Costing Method box we are trying to
change the Purchasing field (alias PCSM). We have 5500+ items I need to do
a mass change to.

Any help would be greatly appreciated.

Thanks

Dave Rammer
Sheboygan County IS




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=2399
*************************************************************
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
*************************************************************
 
We have changed the PCSM for a branch/plant. If we add a new item it will
bring in the new code, however if we inquire on an existing item it shows
the old code. How do I get the existing items to show the new code.

Thanks

Dave
 
Use program P4105 to change to purchasing cost method per item, PCSM on b/p
level is only a default used when you add an item.

Regards,
André
 
Hi

To succed with this you have to change COCSPO in F4105. This field have the
value of 'P'
on the row for the costmethod you used to have in Branch/Plant Constants. You
know have
to move the 'P' to the costmethod you have specified in Branch/Plant Constants.

There should be a standard program, but I cant find it!

Regards
Carl-Magnus




RAMMEDJR <[email protected]> on 2000-12-11 19:45:06

Please respond to [email protected]

To: [email protected]
cc: (bcc: Carl-Magnus Olsson/TDS)
Subject: RE: Item Cost - Purchasing Method ~~2399:2441



We have changed the PCSM for a branch/plant. If we add a new item it will
bring in the new code, however if we inquire on an existing item it shows
the old code. How do I get the existing items to show the new code.

Thanks

Dave





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=2441
*************************************************************
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
*************************************************************
 
So if I am understanding you correctly in our scenario I should have at
least two lines for each item in the F4105 one for the old code which we
still will be using for the Sales/Inventory cost method and another with the
new code for the Purchasing cost method and the appropriate COCSPO field
setting on each line.

Dave
 
Dave,

In response to your second question, yes, you would have 2 cost types for
each item, one for sales-and-inventory with an I in the CSIN field (rather
than CSPO) in F4105 and 02 in the LEDG field, and one with a P in the CSPO
field in F4105 and 08 in the LEDG field. So in Branch Plant Constants P41001
for each plant/whse you would key 02 in Sales/Inventory Costing Method and
08 in Purchasing Costing method. So if you go to Item Branch Plant P41026,
call up an item and go to Cost Revisions exit you will see type 02 weighted
average cost and type 08 purchasing cost which is last vouched cost (PO
price plus any cost differences from voucher match via PV entries from
voucher match going to F43121 and F4111 and updating F4105 costs).

I changed the descriptions of the cost methods in User Defined Codes to read
"weighted average, stock UOM" for cost type 02, and to read "last vouched
price, Purch UOM" for cost type 08 so person X can understand what he/she is
looking at. Otherwise when you buy it in boxes of 12 and stock it as an
'each' the costs look weird next to each other unless you know the UOM
difference for the item. Have a good one.

Dave Mallory Denver Water
 
Back
Top