Project Management

Get Involved. Join the Conversation.

Topic

    Chris Van de Graaf
    SLA rule to combine capital and non-capital cost
    Topic posted April 23, 2019 by Chris Van de Graaf, tagged Capital Projects, Project Costing, Project Management 
    153 Views, 10 Comments
    Title:
    SLA rule to combine capital and non-capital cost
    Summary:
    Client has both capital and no capital (billable/expense) cost on a capital project. I need to create a SLA rule to combine this. Capital cost are based on Task DFF and non capital cost are in mapping
    Content:

    Client has capital cost and non capital cost on a capital project. As I can't assign separate rule for capital cost and other cost, I have to combine my accounting logic in a single account rule. Capital cost are derived from a Task DFF. In the task DFF I maintain the asset category which in a separate value set is mapped to a GL account (in the description). For non capital cost I use a mapping set, mapping the expenditure type to the GL account. For both cost types (capital and non-capital) I can create separate account rules, but when I try to combine the two rules into a single (third) rule, I am not able to select the rule for the capital cost I assume that's because the rule type for the capital cost account is Value set. For the non capital cost the rule type is segment. As both rule types are different I assume I can't combine these account rules into another (third) rule.

    Any ideas how to resolve the issue to combine capital and non-capital cost into a single account rule..

    Version:
    19A

    Comment

     

    • Paul Fernandez

      Hi Chris,

      I am assuming you are trying to create a rule for Natural Account since you are using Expenditure Type to map to a GL account.
      I am not sure of your rule based on Task DFF and Asset Category/Value Set.
      But, if you are only using the Rule Type of Segment, you can accomplish this by creating an Account Rule  where you are combining two rules as follows:

      1. With a Mapping Set of Expenditure Type with a

      Condition of ' Expenditure Item Capitalizable Indicator" = N' for you non capitalizable costs.

      2. With a Mapping Set of Expenditure Type with a

      Condition of ' "Expenditure Item Capitalizable Indicator" = Y' for you capitalizable costs (or however you want to derive the
      account value. Here use what works for you, not necessarily a Mapping Set) for Capitalizable Costs'.

      I am assuming that parameter is available though not 100% certain, it was certainly there in EBS.

      Hope the above should work.

      Thanks and regards

      --Paul

    • Chris Van de Graaf

      Hi Paul

       

      Thanks for the information. The condition Expenditure Item Capitalizable Indicator is unfortunately not available. I have to use Task Capitalizable Indicator.. I managed to create the third rule based on the other two rules, i.e. one rule for capital cost and the second rule for non-capital cost. But create accounting ends in an error, which may be caused by other rules.

       

      Thanks

       

      Chris

    • Chris Van de Graaf

      Hi Dustin, Paul

       

      Thanks for the information. I have now created two account rules using the Cost Distribution Capitalizable Indicator as the source. I created a third rule using both existing rules. But apparently you cannot use a third rule which is based on two existing rules. Although the source in both rules is different, SLA treats this as a nested account rule. But your answers have been helpful

       

      Thanks

       

      Chris 

      • Paul Fernandez

        Chris,

        Thanks for the update. We should be able to get this resolved. Please connect with me directly and we can take a look at this.

        Thanks

        --Paul

    • Chris Van de Graaf

      Hi Paul

       

      I have managed to fix the issue. Basically I use a single rule, but in the rules section you assign the relevant mapping sets in the logical order. Priority 1 uses mapping set for capital cost (and also add the correct condition for rule 1), then add the mapping set for rule 2, non capital cost, and add the condition applicable for rule 2. I have tested this use of the single account rule, and the correct accounting entries are generated.

      Thanks for your help.

       

      Chris

      • Paul Fernandez

        Chris,

         

        Thanks for the update. That is how I thought it should be. Glad to hear that you were able to fix it.

        Thanks

         

        --Paul

      • Paul Fernandez

        Chris,

         

        Thanks for the update. That is how I thought it should be. Glad to hear that you were able to fix it.

        Thanks

         

        --Paul