User-Defined Formula
Discussion List
-
Is it possible to copy the Natural Account from one Debit line to another Debit line through SLA?Summary: Is it possible to copy the Natural Account from one Debit line to another Debit line through SLA? Content (required): Hi Experts, I have requirement to copy Nat…Balakrishna Sivappagari 44 views 5 comments 0 points Most recent by ashtrakhov-Oracle Subledger Accounting & Accounting Hub -
I would like to use a lookup on the "Manage User-Defined Formulas" screen.Summary: I would like to use a lookup on the "Manage User-Defined Formulas" screen. Content (required): Hi, I would like to know why, when I use my 'AUXILIAR DE LA CUENT…Hans Villanueva Rojas 44 views 1 comment 1 point Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
Date data type User Defined Formulas are not available in the Accounting AttributesSummary: Hi Experts, I defined the custom User Defined Formula with data type "Date" . This custom user defined formula is not available in the Accounting Attributes as …Balakrishna Sivappagari 43 views 2 comments 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
How to retrieve the total PO Amount in the Payables application from SLA sources.Summary: Hi Experts, I have requirement to retrieve the total PO amount from Payables application when the invoice is matched with purchase order. Based on the total PO …Balakrishna Sivappagari 55 views 0 comments 0 points Started by Balakrishna Sivappagari Payables, Payments & Cash Management
-
Text limit in the insert of the formulas in the "Manage User-Defined Formulas" screen.Summary: Text limit in the insert of the formulas in the "Manage User-Defined Formulas" screen. Content (required): Hi, I would like to know the character limit (text) t…Hans Villanueva Rojas 13 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
How to Create AP Invoice accounting entries based on Purchasing CategorySummary: Create AP Invoice accounting entries based on Purchasing Category Content (required): Customer requires to create different AP Invoice (or Credit Mamo) entries …Andrius Čėsna 93 views 12 comments 0 points Most recent by Andrius Čėsna Subledger Accounting & Accounting Hub
-
Modify a formula on the 'Manage User-Defined Formulas' screen through a web service.Summary: Modify a formula on the 'Manage User-Defined Formulas' screen through a web service. Content (required): I would like to know if it's possible to modify a formu…Hans Villanueva Rojas 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
Accounts Payable Distribution DFF date field not available in the SourcesSummary: Hi Experts, I have requirement to take the Invoice distributions DFF field(INV_ATTRIBUTE_DATE1) for accounting changes. When i check the payables sources, i see…Balakrishna Sivappagari 34 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to have default cost center segment on the basis of buyer on the inventory based PO's ?Summary: I am trying to default cost center segment on the basis of buyer in the PO . So for this I created a new account rule in Cost accounting SLA in which the source…AkashAgarwal 43 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
Manage User-Defined Formulas SintaxSummary: Hi, we need to transfer an information from AR Receipt to GL line reconciliation reference. The information is store in the file "Comments"(receipt header) and …CM_ 73 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
How to generate sub ledger accounting based on Price Hold?Summary: Our client has a specific requirement to assign Invoice price Variance Code combinations' natural account segment a specific value based on the event of price v…Akash Verma 33 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Subledger Accounting & Accounting Hub -
Mapping set to book in one AR account Domestic and in another AR Foreign CustomersSummary Mapping set to book in one AR account Domestic and in another AR Foreign CustomersContent Hello , I have the business requirement to book in one Accounts Receiva…gabriel kinovisques-163562 29 views 2 comments 0 points Most recent by ChristinaMoore Subledger Accounting & Accounting Hub
-
AP SLA Customization - -Oracle Fusion/21BContent AP SLA Customization Requirement: Based on two accounting segments ( balancing segment & Cost Center) need to derive third segment ( Deparment) Example : Discoun…VijayPatel 63 views 4 comments 0 points Most recent by ChristinaMoore Subledger Accounting & Accounting Hub
-
User Defined Formula in Accounting HubSummary User Defined Formula in Accounting HubContent We want to use the User Defined Formulas for the below scenario The Journal Line value is of Credit in nature. Howe…Indavar 46 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
FAH: Journal line with negative amount as Debit and Positive Line as CreditSummary FAH: Journal line with negative amount as Debit and Positive Line as CreditContent Please note, we are implementing FAH for some of the downstream data sources a…Indavar 21 views 1 comment 1 point Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
AHCS: Foreign Currency Transaction's Accrual Reversal on different (latest) conversion rateContent We understand that Accrual Reversal of foreign currency transactions will take the same exchange rate and it will nullify the entire balance to the penny (correc…Vishnu Kant 128 views 3 comments 1 point Most recent by Vishnu Kant Subledger Accounting & Accounting Hub
-
Is there any option to create JLR with condition by linking with LookupSummary Is there any option to create JLR with condition by linking with LookupContent We have a requirement to create JLR with conditions Condition: if one particular s…Veerendra Chava 36 views 1 comment 0 points Most recent by Venkata Kompella Subledger Accounting & Accounting Hub
-
AHCS: Line Level Sources are not available for use in User Defined FormulaContent Hi, I recently noticed that all the Line Level Sources in a custom Sub Ledger is not available for use in Custom Formulas. Is this by design or I missed somethin…Vishnu Kant 42 views 1 comment 1 point Most recent by Vishnu Kant Subledger Accounting & Accounting Hub
-
AHCS: Different Posting Treatment for Different Rules but same Event_TypeContent Hi, Hope you all are doing well. I could use your help / views in below business scenario: Business Scenario We have an existing custom sub-ledger application (1…Vishnu Kant 26 views 1 comment 1 point Most recent by Vishnu Kant Subledger Accounting & Accounting Hub
-
Bypass / Override Accounted Amount calculation for foreign currency Transactions in Custom SubledgerContent Hi, As per the current Accounting Attributes assignment, for all the foreign currency transactions coming via Custom Subledger, Accounting Hub calculates Account…Vishnu Kant 26 views 2 comments 3 points Most recent by Gaurav Paul Subledger Accounting & Accounting Hub
-
Quarterly Accrual Reversal from Custom SubledgerContent For Accrual Reversal Date in JERS, currently we are using Subledger sources like Same Day, First Date of Current Accounting Period, Last Day of Current Accountin…Vishnu Kant 39 views 1 comment 2 points Most recent by Venkata Kompella Subledger Accounting & Accounting Hub
-
Is it possible to post just in Primary Ledger and not in Secondary Ledger through custom subledger aContent Hi Experts, I was wondering if it is possible to create a JERS and post just in 1 ledger i.e. Primary or Secondary? I assigned JERS / Event Type to just 1 ledger…Vishnu Kant 45 views 8 comments 2 points Most recent by Vishnu Kant Subledger Accounting & Accounting Hub
-
Need to define a source for correction receipt for the Expense Accrual accountContent Hi, When doing a correction of a receipt, we need to have the same Expense accrual accounting flexfield generated when doing a receipt. But for the receipt into …Mohamed jouini 40 views 5 comments 1 point Most recent by Venkata Kompella Subledger Accounting & Accounting Hub
-
Count Function in User defined formula ?Summary Do we have Count Function in User defined formula ?Content Hi All, looking for quick info/help if someone knows if there is a way to write or use the count funct…Gaurav Paul 59 views 2 comments 3 points Most recent by CLAZAR-Oracle Subledger Accounting & Accounting Hub -
Payables Sources for PO to Invoice differencesSummary Capture Variance amounts (PO to Invoice) for Quantities, AmountsContent Hello, We have a need to capture the differences for quantity, price and amount when matc…Stephen Bryant-227427 77 views 8 comments 1 point Most recent by Stephen Bryant-227427 Subledger Accounting & Accounting Hub
-
User Defined Formula with DecimalContent In User defined formulas, we have the following formula ."TRX_LINE_ATTR11" is a DFF in Receivables ToInteger("TRX_LINE_ATTR11") In the Invoice 1.when populating …Athomas 47 views 1 comment 1 point Most recent by Manwesh Jain-30070 Subledger Accounting & Accounting Hub -
SLA to split liability entries on an AP InvoiceSummary Is it possible to create an SLA to split the liability entry into 2 different liability accounts?Content I am trying to determine if this is possible, before I g…Mark Mariano 59 views 3 comments 1 point Most recent by Rajesh G Subledger Accounting & Accounting Hub