Tuesday, February 13, 2018

Calculation Method and Revenue Posting

Calculation Method = None

Project Cost center = A

Contract Value = 100,000
Hours Forecast = 10,000

Total Cost Posted = 7,000
Cost for employee ABS which belongs to Cost Center A = 3000
Cost for employee XYZ which belongs to Cost Center B = 4000

% cost complete = 70% (7000/10,000)
Revenue to recognize = 70,000

Note: In this method, the sales price / amount that is displayed against the posted transaction, is calculated based on sales price setup. This sales price / amount is a tentative indication of what revenue could have been generated from that project transaction. But that is not the actual sales revenue, as the sales revenue in the fixed priced project is through the on-account invoicing (contract value). The entire revenue is recognized on separate 'estimate' fee category (from the project group setup), whenever the revenue recognition is run via the estimate process. System will post the general ledger voucher for the recognized revenue.

Drawbacks:
  1. Entire Revenue of 70,000 is posted to cost center A, as revenue posted in this method follows the dimensions of project.
  2. Revenue per employee is not visible at the transaction level.

Calculation Method = Markup percent – total

Project Cost center = A

Contract Value = 100,000
Hours Forecast = 10,000

Total Cost Posted = 7,000
Cost for employee ABS which belongs to Cost Center A = 3000
Cost for employee XYZ which belongs to Cost Center B = 4000

% cost complete = 70% (7000/10,000)
Revenue to recognise = 70,000
Revenue posted to cost center A = 30,000
Revenue posted to cost center B = 40,000

Note: In this method, the sales price / amount that is displayed against the posted transaction, is calculated based on sales price setup. This sales price / amount is a tentative indication of what revenue could have beeen generated from that project transaction. But that is not the actual sales revenue, as the sales revenue in the fixed priced project is through the on-account invoicing (contract value). Whenever the estimate process is run to recognize the revenue, instead of posting the entire revenue on a fee category (as done in the 'Calculation method = None' process above), system will update the sale value on the individual project transactions posted earlier and will also create a general ledger voucher for the pro-rated recognized revenue per project transaction.

Advantages:
  1. Revenue of 70,000 is posted to cost center A and B on a pro-rata basis. The revenue posted in this method follows the dimensions of individual transaction.
  2. Revenue per employee is visible at the transaction level.
Thanks
Sarang

Wednesday, February 7, 2018

Max Hours Calendar and Maximum Working Time

When the resource is setup for timesheets, he is assigned the 'Period Code' and a 'Max Hours Calendar', however 'Max Hours Calendar' is not mandatory.

In 'Max Hours Calendar' a calendar is selected which has hours specified for the weekdays. Mostly the value is 8 hours per day.

If the 'Max Hours Calendar' is defined on the 'Resource setup' form, then the system restricts the user from entering more hours on the timesheet than specified in the 'Max Hours Calendar'.

If the 'Max Hours Calendar' is NOT defined on the 'Resource setup' form, then the system DOES NOT restrict the user from entering more hours on the timesheet than specified in the 'Max Hours Calendar'.



However if the 'Max Hours Calendar' is defined on the 'Resource setup' form but the situation is such that max hours needs to be overridden for some days, then the user can make use of 'Maximum working time' and specify the values there.In this case system will always take the values from the 'Maximum working time' and not from the 'Max Hours Calendar'. In this case the system restricts the user from entering more hours on the timesheet than specified in the 'Maximum working time' for the days specified.



One small note about the 'Resource scheduling calendar' : The calendar selected here also updates / selects / changes the calendar selected in the 'Calendar' field in the 'Employment' tab of the employee.




The calendar selected in the 'Calendar' field in the 'Employment' tab of the employee is used for ELR.






Thanks
Sarang