User-Defined Formula
Discussion List
-
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 42 views 10 comments 0 points Most recent by Andrius Čėsna Subledger Accounting & Accounting Hub -
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 12 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_ 42 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 2 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Subledger Accounting & Accounting Hub
-
Ability to do COGS accounting in Shipping Org rather than Order Booking OrgHi Cloud Experts Currently our Client has US and UK Ledger and OM/ Costing modules enabled on Cloud . Our Client is booking Orders in UK but Shipping from US. In this sc…Renuka Soneja 2 views 0 comments 0 points Started by Renuka Soneja 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 9 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 31 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 23 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 10 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 46 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 15 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 21 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 15 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 15 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 18 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 34 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 19 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 38 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 47 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 26 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 38 views 3 comments 1 point Most recent by Rajesh G Subledger Accounting & Accounting Hub