How to Distribute Expenditure Cost

In PA_EXPENDITURE_ITEMS_ALL table,

If system_linkage_function(OT & ST) is "Timecards" then run "PRC: Distribute Labor Costs" program to distribute the cost.

If system_linkage_function(USG, INV, WIP & PJ) is "Usages or Inventory or Work In Process or Miscellaneous Transactions" then run "PRC: Distribute Usage and Miscellaneous Costs" program to distribute the cost.

If system_linkage_function(VI & ER) is "Supplier Invoices or Expense Reports" then run "PRC: Distribute Supplier Cost Adjustments" program to distribute the cost.

If system_linkage_function(BTC) is "Burden Transactions" then run "PRC: Create and Distribute Burden Transactions" program to distribute the cost. 

PA_NO_PROJFUNC_CURR_RATE - Project Functional Currency Error

PRC: Distribute Misc and Usage Costs has the following error:

Error: PA_NO_PROJFUNC_CURR_RATE

Complete the below setup to resolve the error.


  • Go to Implementation Options Screen-> Currency Tab and verify the setup what is the date and type.
  • Go to Expenditure Inquiry screen and query the problematic Lines.
  • Click on Show Field and Add the Following Fields
    • Transaction Currency
    • Project Currency
    • Project Functional Currency.
    • Expenditure Item Date ( If in Implementation Options form expenditure date is setup to be considered, else the corresponding field based on the setup in Implementation form)
  • Note Down All the Above Values
  • Go to GL Responsibility --> Setup --> Currency-->Rates-->Daily.
  • Make sure that a rate exist for the following combination.
    • Transaction Currency/Project Currency for the Corresponding Date and Type.
    • Transaction Currency/Project Functional Currency for the Corresponding Date and Type.
    • Project Currency/Project Functional Currency for the Corresponding Date and Type.
  • Save the Changes and re-test the issue.

Book Controls: Changing Divide Depreciation Field: FRM-40200: Field is Protected Against Update

Issue:  
The Divide Depreciation drop down box on the Book Controls screen does not allow update.

Solution:
The Divide Depreciation value for the Asset Book can be changed when the first period of a new fiscal year is the current period.

Make this change after the opening of a new fiscal year.

PA_FUNC_SECURITY_ENFORCED - While creating events through API from Custom Page

Error:

PA_FUNC_SECURITY_ENFORCED - While creating events through API from Custom Page

Solution:
The following functions needs to be added in the Custom menu created for Event creation.



Events maintainence for single project
Activity Management Gateway:Create Event
Activity Management Gateway:Delete Event
Activity Management Gateway:Update Event
Activity Management Gateway:Delete Event OK
Invoice Events Maintainence
Revenue Events Maintainence

CE: Error: FUN_INTRA_RULE_NOT_ASSIGNED' Validating a Bank Account Transfer

Error :

1. FUN_INTRA_RULE_NOT_ASSIGNED
2. Intercompany balancing was unable to generate the intercompany account
3. The intercompany account generated by the intercompany balancing rules is invalid
4. The intercompany account generated by the intercompany balancing rules is invalid

Cause:

The issue is caused as The Intercompany Balancing Rules are not set up.

Solution:

In order to correctly setup The Intercompany Balancing Rules, please follow the steps:

Responsibility - General Ledger

1.Navigate - Setup - Financials - Accounting Setup Manager
2.Find your Ledger
3.Update Accounting Options
4.Operating Units - Update
5.Confirm your Operating Units have been added, or add them if they are not already there.
6.Return to Accounting Options.
7.Intercompany Accounts - Update

8.Define Relationships between your Legal Entities
8.1.For your First Legal Entity
8.2.Click Define Relationships
8.3.Click Add Another Row
8.4.Transacting Balancing Segment = Enter the Balancing Segment Value for your first Legal Entity
8.5.Trading Partner Legal Entity = Enter the name of your Second Legal Entity
8.6.Trading Partner Balancing Segment Value = Enter the Balancing Segment Value for your second Legal Entity
8.7.Click Define Accounts
8.8.Enter your Intercompany Receivables Account
8.9.Enter your Intercompany Payables Account
8.10.Click Apply
8.11.Click Cancel
8.12.For  your second Legal Entity
8.13.Click Define Relationships
8.Click Add Another Row
8.15.Transacting Balancing Segment = Enter the Balancing Segment Value for your second Legal Entity
8.16.Trading Partner Legal Entity = The name of your First Legal Entity
8.17.Trading Partner Balancing Segment Value = Enter the Balancing Segment Value for your first Legal Entity
8.18.Click Define Accounts
8.19.Enter your Intercompany Receivables Account
8.20.Enter your Intercompany Payables Account
8.21.Click Apply
8.22.Click Cancel
8.23.Change Status to Complete
8.24.Click Done

9.Intercompany Balancing Rules - Update
9.1.For your First Legal Entity (LE)
9.2.Create Rule
9.2.1.Source = Cash Management
9.2.2.Category  = Bank Transfers(1)
9.2.3.Balancing Details Tab
9.2.3.1.Populate Debit Balancing Segment Value  - Specific Value you created for your LE
9.2.3.2.Populate Credit Balancing Segment Value  - Specific Value you created for your LE
9.2.3.3.Populate Debit Account
9.2.3.4.Populate Credit Account
9.2.4.Options Tab
9.2.4.1.Default Clearing Balancing Segment Value - Specific Value you created for your LE
9.2.5.Balancing Details Tab
9.2.5.1.Populate Debit Balancing Segment Value  - All Other
9.2.5.2.Populate Credit Balancing Segment Value  - All Other
9.2.5.3.Populate Debit Account
9.2.5.4.Populate Credit Account
9.3.Create Rule
9.3.1.Source = Other
9.3.2.Category  = Other
9.3.3.Balancing Details Tab
9.3.3.1.Populate Debit Balancing Segment Value  - All Other
9.3.3.2.Populate Credit Balancing Segment Value  - All Other
9.3.3.3.Populate Debit Account
9.3.3.4.Populate Credit Account
9.3.4.Options Tab
9.3.4.1.Default Clearing Balancing Segment Value - Specific Value you created for your LE
9.4.For  your second Legal Entity
9.5.Create Rule
9.5.1.Source = Cash Management
9.5.2.Category  = Bank Transfers(1)
9.5.3.Balancing Details Tab
9.5.3.1.Populate Debit Balancing Segment Value  - Specific Value you created for your LE
9.5.3.2.Populate Credit Balancing Segment Value  - Specific Value you created for your LE
9.5.3.3.Populate Debit Account
9.5.3.4.Populate Credit Account
9.5.4.Options Tab
9.5.4.1.Default Clearing Balancing Segment Value - Specific Value you created for your LE
9.5.5.Balancing Details Tab
9.5.5.1.Populate Debit Balancing Segment Value  - All Other
9.5.5.2.Populate Credit Balancing Segment Value  - All Other
9.5.5.3.Populate Debit Account
9.5.5.4.Populate Credit Account
9.6.Create Rule
9.6.1.Source = Other
9.6.2.Category  = Other
9.6.3.Balancing Details Tab
9.6.3.1.Populate Debit Balancing Segment Value  - All Other
9.6.3.2.Populate Credit Balancing Segment Value  - All Other
9.6.3.3.Populate Debit Account
9.6.3.4.Populate Credit Account
9.6.4.Options Tab
9.6.4.1.Default Clearing Balancing Segment Value - Specific Value you created for your LE