User-Defined Formula
Discussion List
-
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 …Carlo_M. 81 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 52 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 28 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 130 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…User_2025-01-30-00-07-59-110 72 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…User_2025-01-30-00-07-59-110 29 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…User_2025-02-07-09-44-20-578 185 views 3 comments 1 point Most recent by User_2025-02-07-09-44-20-578 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 34 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…User_2025-02-07-09-44-20-578 40 views 1 comment 1 point Most recent by User_2025-02-07-09-44-20-578 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…User_2025-02-07-09-44-20-578 24 views 1 comment 1 point Most recent by User_2025-02-07-09-44-20-578 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…User_2025-02-07-09-44-20-578 24 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…User_2025-02-07-09-44-20-578 37 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…User_2025-02-07-09-44-20-578 53 views 8 comments 2 points Most recent by User_2025-02-07-09-44-20-578 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 38 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 57 views 2 comments 4 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…User_2025-02-10-08-27-07-493 75 views 8 comments 1 point Most recent by User_2025-02-10-08-27-07-493 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 45 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 168 views 3 comments 1 point Most recent by Rajesh G Subledger Accounting & Accounting Hub