jpadilla
29th August 2002, 16:36
Can somebody tell me in wich tables are the estimated and actual costs of a project stored??

I need to extract this information to an excel file, but I don't know where can I get it??

Regards
JP

Flip_J
29th August 2002, 17:08
For this kind of question you should specify the version of Baan you are on.

jpadilla
29th August 2002, 17:14
I'm on Baan IVc4

Flip_J
29th August 2002, 17:20
TP or PCS

jpadilla
29th August 2002, 17:26
Hi Flip,

I'm using PCS, I'm trying to get a excel file that contain the same information of the estimated cost by project, the main idea is that the plant manager can make some simulations changing the material or quantity for a specific project.

Any clue??

Regards
JP

Flip_J
29th August 2002, 17:39
Detailed info on the cost is available in inquiry and reports. On the item there is actual and est cost as well and will be updated after est calculation.
If you have identified the info needed in a Baan session it is easy to identify the table by calling up the help on the field. This will display the field code that will help you identify the table. eg tipcs021.cpre - field code. Table is tipcs021

acapulco
29th August 2002, 18:34
Where in Mexico?

venkat500
4th September 2002, 18:21
use tables tipcs350, 360