Sales Price Grid

This Feature explains about the changes and newly added fields for configuring headline rate, discounted rate, and sales price.

Parameters:

Project Management and Accounting > Setup > Project Management Parameters > General > Hour Sales price

Sales Price deviation:

When you turn on the sales price deviation, user can configure the discounted rate and percentage rate.

A new form Headline rate(hour) is introduced to maintain the headline rates which is Valid for “All”. In Sales Price grid we will be able to configure the sales price Valid for “Table” and “Price group” with the discounted rate and percentage changes for sales price.

Sales Price Dimensions:

When user turn on the Sales price dimension parameter. We can reapply the headline rate. It will reflect in corresponding lines of Sales price hours. We can set the sales price hour lines as fixed and this cannot be change when we reapply the headline rate. Instead, a newline will be created if there is no date range for that as standard.

A headline rate and customer rate fields are introduced in hour journal, transaction and invoice proposal. This parameter will allow us to enable another control which is Hour special rates allowed.

So accordingly, we should configure the Financial dimension 1, Financial dimension 2, Financial dimension 3. These three dimensions what we select will be populated in the Sales price (hour) and Headline rate(hour) forms. When you select the resource in the sales price grid then the dimensions will be defaulted from the resource and prerequisite should be set for that.

Fields Description
Sales Price Dimension 1 Dimension is selected from the list of Financial dimensions created. These fields will be displayed in the sales price grid and headline rate form.
Sales Price Dimension 2 Dimension is selected from the list of Financial dimensions created. These fields will be displayed in the sales price grid and headline rate form.
Sales Price Dimension 3 Dimension is selected from the list of Financial dimensions created. These fields will be displayed in the sales price grid and headline rate form.

Hour Special rates

This Hour special rate will enable a check box in Customer level and Customers which are enabled with this will be available for selection in sales price grid(hours). This is applied for the concerned project contract and project linked. When the check box is not enabled, we will not be able to setup sales price for the concerned customer, project contract and project.

Prerequisite:

Set the Default dimension rules to setup the resource dimension as default. This setup will make the financial dimensions to flow from resource to the transactions. Worker dimensions will be used as primary dimension in journals.

Headline rate(hour) New form

Project management and accounting>Setup>Prices>Headline rate(hour)

We can setup the headline rate and sales price and this reapply headline rate button is newly added.

Fields Description
Reapply headline rate This button will allow the headline rate to be changed in sales price grid for Table and Price group types of configurations.
Fields Description
Effective date Date from which the described combination will function.
Role Id Role id of the employee will select here. For example, Consultant.
Category Category of the transaction will be defined here. For example, Travel.
Resources For which resource the record is created.
Financial dimension 1 Cost Center is defined from the MMA parameters attached below highlighted.
Financial dimension 2 Department is defined from the MMA parameters attached below highlighted.
Financial dimension 3 Department is defined from the MMA parameters attached below highlighted.
Valid for In this field by default All is set.
Sales currency Currency for which transaction will be carried.
Headline rate If there is headline rate defined pricing will change to the same rate. However, Pricing is editable. This rate is shown in sales price grid form.
Sales price model There are three options available in sales price model
*Qty
*Contribution rate
*Charges percentage
*Charges amount
Pricing Pricing can be overwritten even if headline rate is defined. This pricing will be defaulted in sales price grid for Valid for All.

Sales Price grid(hour) form

Project Management and Accounting>Setup>Prices>Sales price(hour)

In this form newly three dimensions fields will be visible when the sales price dimensions parameter is on.

User can select the dimensions which are defined in Sales price dimensions parameter.

Fixed rate check box – This will be enabled when Sales price dimensions is on and once this is checked the sales price lined will be marked as fixed. User cannot update when this is on and reapply headline rate will not allow user to make an update here.

This form will allow us to create valid for ‘Table’ and ‘Price group’ type.

This form will allow us to view all the types of configuration.

Fields Description
Effective date Date from which the described combination will function.
Role Id Role id of the employee will select here. For example, Consultant.
Category Category of the transaction will be defined here. For example, Travel.
Resources For which resource the record is created.
Financial dimension 1 Costcenter is defined from the Project Management parameters attached below highlighted.
Financial dimension 2 Department is defined from the Project Management parameters attached below highlighted.
Financial dimension 3 Department is defined from the Project Management parameters attached below highlighted.
Valid for In this field we can select Table or Group.
Sales currency Currency for which transaction will be carried.
Headline rate If there is headline rate defined pricing will change to the same rate. However, Pricing is editable. This rate is shown in sales price grid form.
Sales price model There are three options available in sales price model
*Qty
*Contribution rate
*Charges percentage
*Charges amount
Pricing Pricing can be overwritten even if headline rate is defined. This pricing will be defaulted in sales price grid for Valid for All.
Customer ID If the Valid for is selected as Table, then Client Id can be selected here. If Hour Special rates parameter is On and Client is marked as yes for special pricing required, then Client can be selected here.
Project Contract ID If the Valid for is selected as Table, then Project Contract Id can be selected here. If Hour Special rates parameter is On and If parent Customer is marked as yes for special pricing required, then that child Project Contract ID can be selected here.
Project ID If the Valid for is selected as Table, then Project Id can be selected here. If Hour Special rates parameter is On and If parent Customer is marked as yes for special pricing required, then that child Project ID can be selected here.
Price Group If the Valid for is selected as Group, then the Price Group can be selected here.
Discounted rate The entered rate will be defined as the sales price
Percentage rate Then entered percentage will be reduced if minus is added before or added to the headline rate if not and sales price will be defined based on that.
Fixed rate When this is marked as Yes, Then the sales price cannot be changed when headline rate is reapplied.

Hour journals

Two new display fields are introduced in hour journals under General tab.

Headline rate: Headline rate from Headline rate form

Customer rate: Sales price after the discount

This will be enabled when the two parameters are on Sales price deviation and Sales price dimensions.

Hour Transactions

User will be able to select the Hour transactions and when they click on General. User will be able to see the headline rate and customer rate.

Project > Manage > Transactions> Hour

Invoice proposal

User will be able to see the headline rate and customer rate in the lines when user create invoice proposal.

Reapply sales prices

Reapply sales price feature is used to modify the time entered in transaction level and need to make changes to its sales price in three different rates.

  • Headline rate
  • Calculated rate
  • Entered rate

Headline rate

This rate is defined in Sales price grid form and based on the combination defined amount will be fetched in the transaction level of hour journal.

Calculated rate

Calculated rate is defined in Sales price grid form and based on the combination defined amount will be fetched in the transaction level of hour journal.

Entered rate

Entered rate is the rate which is modified after sales price is fetching automatically from the Sales price grid combination.

Note – This feature is dependent on Sales grid enhancement, please refer the sections for parameters and Headline setup form.

Invoice proposal form

Introduced button in existing reapply sales prices functionality.

  1. Entered rate
  2. Head line rate
  3. Calculated rate

Go to Project Management and Accounting>Project>Manage>Invoice proposal.

Fields Description
Entered Rate Entered rate will apply the price which is modified in hour journal.
Headline rate Headline rate will apply the price of headline rate from sales price grid.
Calculated rate Calculated rate will apply the price of calculated rate from sales price grid.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment