I understand your intention, but unfortunately there is no direct way to show this in the report during execution stage. At least you can have an option to set TimeScale units as Month and set a blank space in the payment field lag, so that the money can be distributed throughout the working period(monthwise), you can be aware of how much money need to be released to your sub-contractor 30 days after their claim submission but you can’t display it in a report format, due to the fact that the resouce can be burnt as per the resource working calendar/base calendar.
Bu there is a way(non-realistic) to represent your requirement..........................you have to do some manipulation in the resorce lag in activity form.
so if you want to represent your logic in report format use 60days lag in the resource lag in the activity form and with a blank in the payment lag(timescale units should be month), run the report and see the effect. It works perfectly for me.
Normally subcontractors are paid on a monthly basis, with a certain lag, to cover the payment period to the main contractor by the client in order to maintain cash flow in a good position.
For example,
Suppose an activity has 150 days duration starting in May and ending in September.
If the subcontractors statements are monthly with payments to be made after 30 days , the work of May must be paid by beginning of July, etc.
In P3, if you input 30 days lag in the timescale, the cost to the subcontractor will be 30 days after the completion of 150 days, i.e. by beginning of December!!
I know Primavera did not provide this feature, but there is something that does not make sense in their definition of payment lag.
Joe
Member for
22 years 7 months
Member for22 years7 months
Submitted by Dayanidhi Dhandapany on Thu, 2004-07-22 10:35
If you want to distribute the cost throughout 150days, why do you need to put 1 in the payment lag, just leave that area as blank. or if you mean to pay the money 1 day after the completion of work, you put 1 in the payment lag or if you want to pay the money on the completion date itself, use 0 in the payment lag. what is the meaning of distributing the cost after the completion of work(1-sep-03, in our case). no use, The job is done, hence you have to pay the money for the work-done at one shot on the same-day or on the next-day or may be 7days later or 30days later etc. As far as i know, Primavera did not provide the facility to distribute the cost after completing the job on installment basis.
I hope you can understand the logic now. Still if you have any doubt please dont hesitate to contact me, i will try to clear the doubt at my best.
I can represent your requirement/logic into the same P3 file, you assign 150 days duration to the activity ID. Choose Timescale units as Months (instead of days) in the Timescale tab, make sure payment lag field is blank, run the report, you can see that everymonth end the money will be distributed. If you want to delay the payment in the beginning of the first month, then you put 1 in the payment lag field.
First, the payment lag should indicate :payment lag from the end of the activity.
Second, suppose an activity has a duration of five months.
The subcontractor, for example, is to be paid one month after the end of each month, for the work he has done in that month. If you put a 30 days lag in P3, it will show that the subcontractor will be paid all his entitlements 30 days after he has completed the work, which is not very logical.
I think the lag should mean shifting the value of work done during each period by a certain number of time units.
Joe
Member for
22 years 7 months
Member for22 years7 months
Submitted by Dayanidhi Dhandapany on Thu, 2004-07-22 05:54
Thanks for your compliments, The logic is simple, if you put 0 in the payment lag, you can make the payment at the completion of the activity. If you specify ’7’ you can make the payment(to your sub-contractor for example) after 7 days of completing the activity. Which means eventhough the activity is completed, you will not pay the payment to the sub-contractor until the specified number of days in the payment lag field. If you don’t specifiy anything in the payment lag field on everyday you are paying the money evenly to your sub-contractor.
When i run your report CT-01 in the Tabular Cost Report, yes, i believe you, i saw the strange thing that the cost for the item was appeared as one lumpsump value at end of the finishing activity, i found the reason, take out the ’0’ in the payment lag under the timescale tab, then everything should be ok. you can see the proper distribution on everyday.
(Note: Ive sent your p3file back to you. you can find the rectified CT-01 report)
If you dont mind send me your p3 file to plannerdaya@yahoo.com which will capable of receiving 10mb as fileattachment. Let me have a look and try to help you to solve your problem.
Regards
Daya
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Wed, 2004-07-21 06:29
I presume that you also have a resource allocated to this task; do you have any units per day for this allocation? What is the task’s duration?
I have created one 3 day task and one resource with no limits or price, then allocated the res to the atsk and added a 10000 lump sum; every thing looks ok.
Make sure the Resource/profile table is well setup to match with the task’s duration.
By the way, how big are your project files? Can’t you zip the files to send by mail?
Member for
22 years 7 monthsRE: Cost tabular report different than cost graphi
Dear Joe,
I understand your intention, but unfortunately there is no direct way to show this in the report during execution stage. At least you can have an option to set TimeScale units as Month and set a blank space in the payment field lag, so that the money can be distributed throughout the working period(monthwise), you can be aware of how much money need to be released to your sub-contractor 30 days after their claim submission but you can’t display it in a report format, due to the fact that the resouce can be burnt as per the resource working calendar/base calendar.
Bu there is a way(non-realistic) to represent your requirement..........................you have to do some manipulation in the resorce lag in activity form.
so if you want to represent your logic in report format use 60days lag in the resource lag in the activity form and with a blank in the payment lag(timescale units should be month), run the report and see the effect. It works perfectly for me.
Cheers!!
Daya
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
Daya,
Normally subcontractors are paid on a monthly basis, with a certain lag, to cover the payment period to the main contractor by the client in order to maintain cash flow in a good position.
For example,
Suppose an activity has 150 days duration starting in May and ending in September.
If the subcontractors statements are monthly with payments to be made after 30 days , the work of May must be paid by beginning of July, etc.
In P3, if you input 30 days lag in the timescale, the cost to the subcontractor will be 30 days after the completion of 150 days, i.e. by beginning of December!!
I know Primavera did not provide this feature, but there is something that does not make sense in their definition of payment lag.
Joe
Member for
22 years 7 monthsRE: Cost tabular report different than cost graphi
Hi Joe,
If you want to distribute the cost throughout 150days, why do you need to put 1 in the payment lag, just leave that area as blank. or if you mean to pay the money 1 day after the completion of work, you put 1 in the payment lag or if you want to pay the money on the completion date itself, use 0 in the payment lag. what is the meaning of distributing the cost after the completion of work(1-sep-03, in our case). no use, The job is done, hence you have to pay the money for the work-done at one shot on the same-day or on the next-day or may be 7days later or 30days later etc. As far as i know, Primavera did not provide the facility to distribute the cost after completing the job on installment basis.
I hope you can understand the logic now. Still if you have any doubt please dont hesitate to contact me, i will try to clear the doubt at my best.
Regards
Daya
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
Dear Daya,
If you put 1 in the payment lag, all the cost is put on the first day after the end of the activity. No cost has been put during the whole 150 days.
Joe
Member for
22 years 7 monthsRE: Cost tabular report different than cost graphi
Dear Joe,
I can represent your requirement/logic into the same P3 file, you assign 150 days duration to the activity ID. Choose Timescale units as Months (instead of days) in the Timescale tab, make sure payment lag field is blank, run the report, you can see that everymonth end the money will be distributed. If you want to delay the payment in the beginning of the first month, then you put 1 in the payment lag field.
Daya
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
Daya,
Thank you again.
I have read the P3 help, and it is clear.
However, I am not yet convinced of the logic.
First, the payment lag should indicate :payment lag from the end of the activity.
Second, suppose an activity has a duration of five months.
The subcontractor, for example, is to be paid one month after the end of each month, for the work he has done in that month. If you put a 30 days lag in P3, it will show that the subcontractor will be paid all his entitlements 30 days after he has completed the work, which is not very logical.
I think the lag should mean shifting the value of work done during each period by a certain number of time units.
Joe
Member for
22 years 7 monthsRE: Cost tabular report different than cost graphi
Hello Joe,
Thanks for your compliments, The logic is simple, if you put 0 in the payment lag, you can make the payment at the completion of the activity. If you specify ’7’ you can make the payment(to your sub-contractor for example) after 7 days of completing the activity. Which means eventhough the activity is completed, you will not pay the payment to the sub-contractor until the specified number of days in the payment lag field. If you don’t specifiy anything in the payment lag field on everyday you are paying the money evenly to your sub-contractor.
Regards
Daya
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
Thats great Daya.
I thank you very much.
But what could be the logic behind this?
Joe
Member for
22 years 7 monthsRE: Cost tabular report different than cost graphi
Hello Joe,
When i run your report CT-01 in the Tabular Cost Report, yes, i believe you, i saw the strange thing that the cost for the item was appeared as one lumpsump value at end of the finishing activity, i found the reason, take out the ’0’ in the payment lag under the timescale tab, then everything should be ok. you can see the proper distribution on everyday.
(Note: Ive sent your p3file back to you. you can find the rectified CT-01 report)
i hope you can enjoy it now.
Regards
daya
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
Daya,
The program is sent.
Alexandre couldnt find the problem. If anybody else would be kind enough to assist, I will gladly send him the program.
Joe
Member for
22 years 7 monthsRE: Cost tabular report different than cost graphi
Dear Joe,
If you dont mind send me your p3 file to plannerdaya@yahoo.com which will capable of receiving 10mb as fileattachment. Let me have a look and try to help you to solve your problem.
Regards
Daya
Member for
22 years 9 monthsCost tabular report different than cost graphic
I presume that you also have a resource allocated to this task; do you have any units per day for this allocation? What is the task’s duration?
I have created one 3 day task and one resource with no limits or price, then allocated the res to the atsk and added a 10000 lump sum; every thing looks ok.
Make sure the Resource/profile table is well setup to match with the task’s duration.
By the way, how big are your project files? Can’t you zip the files to send by mail?
Alexandre
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
I forgot to mention that the program is too big to send. It contains 3687 activities.
Joe
Member for
23 years 1 monthRE: Cost tabular report different than cost graphi
Bonjour Alexandre,
I have to mention that I did not prepare this program, but it was referred to me.
The cost was allocated as a lump sum in "Budgeted Cost" box of the Cost window.
Merci
Joe
Member for
22 years 9 monthsRE: Cost tabular report different than cost graphi
hello joe,
how did you allocate the cost to the task?
can you send the file to my address? afaulxbriole@wanadoo.fr
mâa salama