Posts

Posts

  • Sridhar Tumati
    AR Invoice audit history available?7
    Topic posted June 15, 2019 by Sridhar TumatiBlue Ribbon: 750+ Points, tagged Receivables in Financials > Receivables & Collections public
    Title:
    AR Invoice audit history available?
    Content:

    Hi,

    Is this feature is available on coming versions.

    Regards,

    Sridhar

  • Alaa Badran
    Autoinvoice Import Error3
    Topic posted June 12, 2019 by Alaa Badran, tagged Receivables in Financials > Receivables & Collections public
    Title:
    Autoinvoice Import Error
    Summary:
    We are facing an error when import the Autoinvoice template
    Content:

    We are facing an error when importing the Autoinvoice template, like the following:

    1 Enter a unique ID for the flexfield Makarem Ledger. (AutoInvoice import process error: {NULL.)

  • Hannah Kehring
    HELP: Mismatch in columns when filtering for Receivables to...
    Topic posted June 11, 2019 by Hannah Kehring, tagged Receivables, Subledger Accounting, Tip in Financials > Receivables & Collections public
    Title:
    HELP: Mismatch in columns when filtering for Receivables to Ledger Reconciliation Report
    Summary:
    Filtering to Exclude Natural Account Creates Mismatch in Columns for Receivables to Ledger Reconciliation Report
    Content:

    Has anyone tried to filter for the Receivables to Ledger Reconciliation Report. When filtering to exclude a Natural Account it creates a mismatch of the columns; does not apply on the Receivables Column just the Accounting Column.

    Has anyone built a customized a report or know of an existing report that could be used as a workaround?

     

    On the Service request I have with Oracle they logged a bug, but then Development kicked back stating the intended functionality of the report is to have mismatched columns haha? I asked for them to elaborate and I got this in response, "If we allow the customer to filter the "receivables" column natural account there could be additional concerns that can be raised. 
    If during the accounting process the accounting rules setup is such that some other account is used while accounting instead of distribution account used while creation of the report, there is no way we can achieve the actual intention of this report. We would prefer not to do this as it would not be apples to apples comparison. "

     

     

    Version:
    19B (11.13.19.04.0)
  • Chris van de Graaf
    How to account for manual entry customer invocies and...1
    Topic posted June 10, 2019 by Chris van de Graaf, tagged Financials, Receivables, Subledger Accounting in Financials > Receivables & Collections public
    Title:
    How to account for manual entry customer invocies and Project Invoices
    Summary:
    Cannot account for manual AR invocies and Project invoices in same BU
    Content:

    Client has both manual entry customer invoices and Project Invoices. But the project invoices fail on autoInvoice import due to the use of AutoAccounting in AR. AutoAccounting for revenue in AR is based on memo lines due to the various different memo lines (and accounts) used. Is there a way to successfully import Project Invoices into Receivables. Volume of manual entry and project invoices invoices is high, so any manual intervention is not really an option.

     

    Any hints to resolve this issue is welcome.

     

    Thanks

     

    Chris van de Graaf 

    Version:
    19A
  • Alan Rowland
    19C - New Features
    Topic posted June 7, 2019 by Alan RowlandGold Medal: 3,500+ Points, tagged Assets, Budgetary Control, Cash Management, Financials, General Ledger, Payables, Receivables, Reports, Subledger Accounting, Update in Financials > Financials — General public
    Title:
    19C - New Features
    Summary:
    The 19C - New Features documentation is available
    Content:

    Available today - https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/19C/19C-financials-wn.pdf

    Inventory and Cost is also available.

     

  • Raj Mohanraju
    Intercompany Transaction Tables1
    Topic posted June 6, 2019 by Raj MohanrajuRed Ribbon: 250+ Points, tagged Financials, General Ledger, Intercompany, Payables, Receivables, Reports, Subledger Accounting in Financials > General Ledger & Intercompany public
    Title:
    Intercompany Transaction Tables
    Summary:
    Intercompany Transaction Tables
    Content:

    We are uploading intercompany transactions via FBDI from a legacy system. Now we are looking for a way to reconcile the intercompany transactions to source to avoid transactions being lost in transit.
    So I'm exploring a report which will list of all impacted Intercompany Inbound and Outbound Transaction Tables [as I would see in the UI]
    a/ populate all intercompany transactions using the batch name [as entered in the FBDI]

    In addition to this I will also need to provide the end result of each intercompany transaction from invoice creation and accounting details as well. SO the report should also:
    b/ populate all intercompany receivables and payables invoice details created for these intercompany transactions
    c/ tables that relate to accounting entries created after intercompany receivables and payables invoices have been created

    Any advise will be greatly appreciated.

  • NADER CHAHLA
    Customer Account Site DFF fbdi Import
    Topic posted June 4, 2019 by NADER CHAHLARed Ribbon: 250+ Points, tagged Receivables in Financials > Receivables & Collections public
    Title:
    Customer Account Site DFF fbdi Import
    Summary:
    19B Customer Account Import template displays Acct Site DFF, but ER 21461953 still in Review
    Content:

    Hi,

    Just dowloaded 19B Customer Account Import template and was surprised to see it includes Acct Site DFF, but ER 21461953 raised to add those DFFs in the template is still in Oracle Review status.

    Is it a missing update on the bug or is it still not possible to upload Acct Sites DFF value via fbdi?

    Thanks for your help,

    Nader

     

    Version:
    R13 19B
  • Suresh Kumarasamy
    Restrict back dated AR invoice & Receipt for particulate...35.0
    Topic posted June 3, 2019 by Suresh KumarasamyBronze Trophy: 5,000+ Points, tagged Financials, Receivables, Revenue Management, Security, Setup / Administration, Tip, User Interface in Financials > Receivables & Collections public
    Title:
    Restrict back dated AR invoice & Receipt for particulate business unit
    Summary:
    Restrict back dated AR invoice & Receipt for particulate business unit
    Content:

    Hello Team

    We need solution to restrict the back dated AR Invoice & AR Receipt.

    e.g. User can select the system date or future date but they should not select the AR transaction date & AR Receipt date less than the system date.

    Regards
    Suersh

  • Surya G
    Upload customers via spreadsheet is error1
    Topic posted June 2, 2019 by Surya GBronze Medal: 1,250+ Points, tagged Receivables in Financials > Receivables & Collections public
    Title:
    Upload customers via spreadsheet is error
    Summary:
    Upload customers via spreadsheet is error
    Content:

    Hi,

    When I try to upload the customers via spreadsheet, it is error out. 

    "Record 225: Rejected - Error on table AR_UPD_CUSTOMERS, column PARTY_NAME.
    second enclosure string not present"

    Earlier I was able to upload the customers without any issues, but now it is showing an error message. Can someone please let me know, if anyone came across the above error?

    Regards,
    Surya

  • Prateek Parasar
    Load Context Sensitive DFF segements through...Answered2
    Topic posted May 30, 2019 by Prateek ParasarRed Ribbon: 250+ Points, tagged Receivables in Financials > Receivables & Collections public
    Title:
    Load Context Sensitive DFF segements through createSimpleInvoice
    Summary:
    Need to load context sensitive dff on header while creating invoice
    Content:

    Hi, I am calling createSimpleInvoice Soap request , part of RecInvoiceService service.

    I am able to create invoice without DFF and also with global DFF segment but finding it hard to send context based DFF.

      <inv:TransactionHeaderFLEX>
                   <tran3:serviceDate>05/06/2019</tran3:serviceDate>
                   <tran3:__FLEX_Context>WWT Sales Channel</tran3:__FLEX_Context>
                   <tran3:__FLEX_Context_DisplayValue>WWT Sales Channel</tran3:__FLEX_Context_DisplayValue>
                   <tran3:salesChannel>test</tran3:salesChannel>
                </inv:TransactionHeaderFLEX>


    In this example Service date is global segment and gets loaded fine, also the context itself gets loaded but salesChannel which is a segment of context WWT Sales Channe does not get loaded, just gets ignored, I suppose I need to send something else but not sure what.

     

    Can anyone help.

     

     

    Version:
    13