SR 3-11875360031
CENTRAL FLORIDA INVESTMENTS INC
Customer want to setup one accounting rule for both Projects and Non Project related requisitions.
customer has two accounting rules
1. For Purchasing which derives the account based on Item Category
2. For Projects related requisitions
Which works fine for both Independently, but customer is trying to create one Rule which works for both Project and non-project related requisitions
Can you please advise on how to do this setup? Uploading the screen shots showing the current setup they are having on their instance.
Research
======
How can we use Transaction Account Builder(TAB) for project related Requisitions and Purchase Orders? (Doc ID 1955590.1)
PJC: Unable To Access Project Fields On Project-Related Payables Invoice Distribution Line and Can't Setup Transaction Account Builder(TAB) For Projects (Doc ID 1490691.1)
PJC: Create Accounting In Error When Source 'Project Class Code' Value Set In Manage Account Rule (Doc ID 1914752.1)
PJC: How To Navigate Or Find Manage Subledger Applications For Scope Task To Set '‘Project Costing’ Scope (Doc ID 1536294.1)
Transaction Account Builder in Oracle Fusion Procurement (Doc ID 1507175.1)
Answer -
Hi Ramesh,
It looks like you are ONLY overlaying the Account segment for both project and non-project related lines. To combine all the rules, you should do the following
1) Creating a new account rule of type 'Segment'
2) In the Rules section, create the following rules
3) In your Transaction Account Defintion, specify the rule from step 2 above as your Account Segment overlay rule
The explanation is this -
a) The system will first derive a complete charge account based on the account combination rule in your TAD
b) Then the system will call the overlay segment rule. The system will check Rule 1 in your overlay rule. It says to check if the line is of type expense and also has an Expenditure Org ID (you get this when you specifiy Project Details for the line). If the conditions are true, it will look at the attached mapping set and will not call Rule 2. If the conditions are false, it will move to Rule 2
CENTRAL FLORIDA INVESTMENTS INC
Customer want to setup one accounting rule for both Projects and Non Project related requisitions.
customer has two accounting rules
1. For Purchasing which derives the account based on Item Category
2. For Projects related requisitions
Which works fine for both Independently, but customer is trying to create one Rule which works for both Project and non-project related requisitions
Can you please advise on how to do this setup? Uploading the screen shots showing the current setup they are having on their instance.
Research
======
How can we use Transaction Account Builder(TAB) for project related Requisitions and Purchase Orders? (Doc ID 1955590.1)
PJC: Unable To Access Project Fields On Project-Related Payables Invoice Distribution Line and Can't Setup Transaction Account Builder(TAB) For Projects (Doc ID 1490691.1)
PJC: Create Accounting In Error When Source 'Project Class Code' Value Set In Manage Account Rule (Doc ID 1914752.1)
PJC: How To Navigate Or Find Manage Subledger Applications For Scope Task To Set '‘Project Costing’ Scope (Doc ID 1536294.1)
Transaction Account Builder in Oracle Fusion Procurement (Doc ID 1507175.1)
Answer -
Hi Ramesh,
It looks like you are ONLY overlaying the Account segment for both project and non-project related lines. To combine all the rules, you should do the following
1) Creating a new account rule of type 'Segment'
2) In the Rules section, create the following rules
- Rule 1 for Project related lines and it will have the following condition -* "Destination
Type Code"(PO) = EXPENSE 'AND'
"Expenditure Organization ID" Is not null* . The value type for this rule will be Mapping Set and it will point to the Mapping Set you have created for your projects. - Rule 2 for non-Projected related lines and this will not have any condition. The value type will also be mapping set and this will point to the Mappping Set you have created for item category
3) In your Transaction Account Defintion, specify the rule from step 2 above as your Account Segment overlay rule
The explanation is this -
a) The system will first derive a complete charge account based on the account combination rule in your TAD
b) Then the system will call the overlay segment rule. The system will check Rule 1 in your overlay rule. It says to check if the line is of type expense and also has an Expenditure Org ID (you get this when you specifiy Project Details for the line). If the conditions are true, it will look at the attached mapping set and will not call Rule 2. If the conditions are false, it will move to Rule 2
No comments:
Post a Comment