Aging
Discussion List
-
AR Aging to Debt reportHi, Reference to standard report on AR Aging, would like to make a KPI for Debt more than say 60 days Looking for details on any standard tables which could be referred …SaurabhSinghal26 61 views 3 comments 0 points Most recent by Kasthuri Haridass-Oracle Receivables & Collections -
I need to know from which table I can get the data of Audit Report- for ReceivablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S.A.A Dinoli 3 views 1 comment 1 point Most recent by Karan Dass-Support-Oracle Receivables & Collections -
What is the Aging Method for Create Balance Forward Bill process?Summary: What is the aging method being used during the Create Balance Forward Bill Process? Is it 7 Bucket Aging? Can we create a custom aging method and have this cons… -
AR Payment Terms based on periods instead of Calendar daysSummary: Business Requirement: We hope to have new payment terms to show invoices entered each period to have a due date based on fiscal quarter end + 30. For instance, … -
Receivables Aging by General Ledger Account Report - seeded Datamodel not workingSummary: I have been able to customize the Receivables Aging by General Ledger Account Report to be more usefull, by using the seeded datamodel and creating a new report…Anders W. Langholm 21 views 7 comments 0 points Most recent by Tyrion Lannister Receivables & Collections -
How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report.Summary: How to add Cust Account and Cust Site Info to 'Receivables Aging by General Ledger Account Report. Content (required): Problem Description ---------------------…
-
Aging 4 Bucket Report with Currency in FUSION cloudSummary: We are looking for Similar Report of EBS Aging 4 Bucket Report where it has option of getting report by Currency , however In FUSION we dont have that option an…
-
Created Set jobs to transfer inv to AR - can dates be incremented from parent to child auto invoiceSummary: We are experiencing an issue with the Accounting Date in Accounts Receivable (AR) for project invoices in the 24B environment. The following details outline the…Andrew Gaac 22 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Ho do i add PO number to the 'Receivables Aging by General Ledger Account Report'Summary: Need to Add PO Number detail in 'Receivables Aging by General Ledger Account Report'. For that we are trying to customize the same for that but as the main quer…Kasi Eswari 25 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to load approval limits using excel in ARHi Everyone, We have a requirement to bulk upload the approval limits and we are looing for option using excel. Please let me know if there is way to upload using excel.…
-
How to create 8 bucket aging methodHi All Currently, system only support 4 bucket and 7 bucket aging types in AR. May i know how can i create one 8 bucket aging method as below Many thanks
-
OM-AR invoices currency Translations from USD to ILSSummary: Business will create sales orders in USD currency. During AR import process, AR invoice should able to translate the currency code to ILS and invoice should gen…
-
Aging bucket lov is null for Receivables Aging by General Ledger Account ReportSummary: Aging bucket lov is null for Receivables Aging by General Ledger Account Report Content (please ensure you mask any confidential information): While submitting …
-
How does data gets inserted in to ar_aging_extract tableHello, Can someone please let me know how does the data gets inserted in to ar_aging_extract in Oracle . I ran all the standard aging bucket reports but none of them is …Naresh_Sridhar 47 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Can I match a receipt with a transaction from the attached comment on both of themDear all I have a client that want to create transactions and add comments on each transaction and do the same for the receipt and he is asking me if there's a process t… -
How to add BFB Number in Receivables Aging by General Ledger Account Report?Summary: Need to add the BFB Number in the 'Receivables Aging by General Ledger Account Report.' We are trying to customize Q_Invoice query but this in inside a package …
-
AR Receipt Accounting ErrorI have a ledger with BSV values: 101, 102, 103, 104. I used 101 to configure the AR setups, including Transaction Type and Receipt Classes and Methods. I created an AR i…Manam Anil Kumar 23 views 5 comments 0 points Most recent by Manam Anil Kumar Receivables & Collections
-
Submit the Oracle Fusion "Receivables Aging by General Ledger Account" report from OIC via REST APISummary: Hi All, We have a requirement to submit the Oracle Fusion "Receivables Aging by General Ledger Account" report from OIC via a REST API using "exportBulkdata." C…Gireesha Pinnagoda 54 views 7 comments 0 points Most recent by Gireesha Pinnagoda Receivables & Collections
-
Collections Multiple Account Multiple Site NameSummary: We are following in customer structure such that Party - Group Company Account - Multiple Legal Entity under Group Company Bill To Site - Multiple Billing Locat…Savir Bansal -Trinamix 35 views 2 comments 0 points Most recent by Savir Bansal -Trinamix Receivables & Collections
-
Victor Chrabieh 22 views 5 comments 1 point Most recent by Victor Chrabieh Receivables & Collections -
Can we create provisions based on aging in receivables? Can we do automatic write off for these?Summary: We have a requirement to create provisions based on aging according to the following rules: Up to 90 days no action is taken. If aging crosses 90 days system sh…Shivani Verma_999 13 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Receivables Aging by GL Account Report XML Parameters tags are corrected in 24B quarterly releaseSummary: Receivables Aging by General Ledger Account Report XML Parameter tag is corrected in 24B quarterly release. Content (please ensure you mask any confidential inf…Narasimhulu Kondeti 11 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
What is the best way to know all the changes happening to seeded reports during the upgrade?Summary: Is there a best way to know the changes happening to the reports during the upgrade? We recently came across an issue where some of the fields "Receivables Agin…
-
Collections Aging by Collector 7 Bucket ReportSummary: I am having to customize the "Collections Aging by Collector 7 Bucket Report" to add a DFF (Attribute) from the Invoices table (ra_csutomer_trx_all). The DFF va…Arun MK 16 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
How to prevent Sales Orders submission if Customer has Overdue invoicesSummary: How to prevent Sales Orders submission if a Customer has Overdue invoices. Content (please ensure you mask any confidential information): Version (include the v…Suresh Motiki 12 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
predefined aging buckets are missing in Receivables aging by general ledger account reportSummary: While trying to Run Receivables aging by general ledger account report only 4 buckets are showing even the seeded or predefined aging buckets are also missing i…
-
Logic for Supplier Balance Aging ReportI want to know the logic behind the calculations of the columns - unpaid amount, buckets, aging amounts and unallocated amounts in the seeded Program - Supplier Balance …Priyal Pareek 121 views 4 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
Any Customer Hierarchy Balance ReportsSummary: We have a requirement for Customer Hierarchy Balance report which shows balances based on the customer Hierarchy definition in manage Hierarchies. We have 3 lev…Mohan Terli 31 views 1 comment 1 point Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
AR Aging report does not show receipts at riskAR Aging report does not show receipts at risk even though parameter chosen is to Summarize Receipts At risk. Any specific conditions to view the Receipts At Risk in agi…