Posts

Posts

  • Sachin Mistry
    Prevent PO, AP, AR, FA, Project Transactions for a...2
    Topic posted August 23, 2018 by Sachin MistryGold Medal: 3,500+ Points, tagged Assets, Cash Management, Collections, Configuration, Expenses, Financials, General Ledger, Intercompany, Payables, Receivables, Revenue Management, Subledger Accounting in Core Financials > General Ledger & Intercompany public
    Title:
    Prevent PO, AP, AR, FA, Project Transactions for a company/legal entity mapped to balancing segment but allow GL journal import
    Summary:
    Prevent PO, AP, AR, FA, Project Transactions for a company/legal entity mapped to balancing segment but allow GL journal import
    Content:

    Our company has made an acquisition. We have setup new company code (balancing segment). We have setup new company, new legal entity, new natural accounts, new cost centers, code combinations so we can upload account balances, activity each month of the sub and report consolidated financials.

    We upload journal balances (Trial Balance) each month of the acquired subsidiary, which we can do with the above setups.

    However if we want to prevent users from this subsidiary company code to create any transactions in PO, AP, AR, Cash, Fixed Assets, Expenses, Project sub ledger inadvertently. How do we prevent these? We want to retain ability to enter/upload journal in GL only but do not want to allow posting in GL from any sub ledgers.

    Is there any creative and simpler way to setup sub ledger accounting rules to accomplish the above?

  • Bryce Wied
    Internal Billing/Recharge Functionality
    Topic posted August 22, 2018 by Bryce WiedRed Ribbon: 250+ Points, tagged Allocations, Configuration, Financials, General Ledger, Help Center, Intercompany, Payables, Public Sector, Receivables, Tip in Core Financials > General Ledger & Intercompany public
    Title:
    Internal Billing/Recharge Functionality
    Summary:
    How do large institutions process internal payments between organizations/departments
    Content:

    Background:

    In the University setting, it is common to have various service units, such as IT Services, Catering, and Printing Services that provide goods or services to other areas of the organization, and that service must be billed for these internal service units to properly record expenses and internal revenue. The business process is quite similar to external customers procuring services from the Organization, but it does not produce AR nor real external revenue - it is just money changing hands within the organization. Additionally, how can the system transact the procurement of these goods and services, and appropriately charge the ordering/providing departments. We've identified a few ways to process these transactions, but still have a few issues with each:

    System Options:

    1. Use GL journal entries to re-allocate funds
      1. Example:
        1. Debit: $100 Ordering Unit Expense Account
        2. Credit: $100 Service Provider Unit Revenue Account
      2. Issues:
        1. This requires giving many people across the organization access to create journal entries
        2. To charge or fund a Project in PPM requires the use of a PPM Miscellaneous batch upload. This means uploading these charges is a bifurcated process based on whether the Service Unit or Provider Unit is related to a PPM Project.
        3. There is no way to procure the services that integrate well with a GL journal entry
    2. Use the Intercompany Module without AR/AP involvement
      1. Example:
        1. Debit: $100 Ordering Unit Expense Account
        2. Credit: $100 Service Provider Unit Revenue Account
      2. Issues:
        1. To charge or fund a Project in PPM requires the use of a PPM Miscellaneous batch upload. This means uploading these charges is a bifurcated process based on whether the Service Unit or Provider Unit is related to a PPM Project.
        2. There is no way to procure the services that integrate well with a GL journal entry
    3. Use the Procurement module requisitioning tool to order goods and services, then a zero-dollar AP invoice to charge the appropriate provider/receiver of goods and services
      1. Example Requisition:
        1. + $100 Ordering Unit Expense Account
        2. - $100 Service Provider Unit Revenue Account
      2. Example AP Invoice. The total is $0 with 1 positive and 1 negative invoice line.
        1. + $100 Ordering Unit Expense Account
        2. - $100 Service Provider Unit Revenue Account
      3. Issues:
        1. Oracle does not allow a negative requisition line
          1. This requires the AP invoice to be manually populated with the negative transaction amount after the req has turned into a PO and the service has been performed.

     

    Code Snippet:
  • Beth Bleijie
    Use a one-time supplier again (R13)95.0
    Topic posted August 22, 2018 by Beth BleijieBronze Trophy: 5,000+ Points, tagged Financials, General Ledger, Payables in Core Financials > Payables & Cash Management public
    Title:
    Use a one-time supplier again (R13)
    Summary:
    When looking at a "one-time" supplier the address and site have cleared (R13)
    Content:

    A one-time supplier has the address and site data cleared to blank. (R13)

    I want to use a one-time supplier again, and if I try to create an address I can't use the same Address Name, even though the old one doesn't exist.  I get this message:
    A record with the value MAIN-PAY already exists. Enter a unique value.

    So, what is the function and purpose of a "one-time" supplier?  And why does it do this with the address?

    Beth

  • Arpan Chakrabarti
    Supplier Bank Account update5
    Topic posted August 22, 2018 by Arpan ChakrabartiGreen Ribbon: 100+ Points, tagged Customization, Fusion, How-To, Payables, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Supplier Bank Account update
    Summary:
    Letting Supplier create or update Bank Account at Site Level
    Content:

    Good Morning!

    Have a quick question and wanted to check if anyone had similar request from clients as this is the third time I am seeing this requirement. I know in Supplier Portal, Suppliers are only allowed to update records at header level. Which is fine, but one information which is Bank account has no relevance at header but Site. The question is can this be done or an enhancement request be created so that Supplier can select a BU and assign a Bank account to that BU on an ongoing basis using Supplier Portal. Currently Supplier adds a bank account it goes to header, and then the Vendor management team has to go and take that information and assign or create at the site level which seems redundant. Please share how you have tackled this in past and if you see a value in changing this particular feature ?

    Best,

    Arpan

  • Nishanth B Jain
    Account Analysis ReportAnswered2
    Topic posted August 22, 2018 by Nishanth B JainBronze Crown: 15,000+ Points, tagged Financials, Payables, Receivables, Reports in Reporting and Analytics for ERP public
    Title:
    Account Analysis Report
    Summary:
    Unable to save Account Analysis Report data model due to lexical parameters
    Content:

    Hi All,

    We have requirement to enable some dff values in this standard report.

    So we just customized this standard report and adding custom code in data set.

    We are facing issue while saving data set after adding our custom code, it is asking some lexical parameters.

    Any help on this, like where we can get these lexical parameters for this report.

     

     

    Image:
  • Judy Hamner
    Can the Asset Book on a PO Invoice be defaulted?2
    Topic posted August 21, 2018 by Judy HamnerSilver Trophy: 7,500+ Points, tagged Assets, Payables in Core Financials > Payables & Cash Management public
    Title:
    Can the Asset Book on a PO Invoice be defaulted?
    Summary:
    PO Invoices for Fixed Asset purchases are causing rework because the Asset Book is not populated from the PO. Is there are way to default the asset book - our books match our AP business units.
    Content:

    Purchase Orders do not carry the Asset Book information for fixed asset purchases.  When Invoices are entered and matched, the Asset Book information on the Invoice is often missed in the entry process.  We have an approval workflow rule to reject invoices that are for fixed asset accounts but where the asset book is missing.  However, this requires rework of the invoice.  Also, in order to add the asset book the original matched line has to be cancelled in order to add the asset book using this work around.  This is an issue with all PO invoices, but it is a bigger issue with electronic invoices that are matched upon import and immediately submitted to workflow.  

    We would like to be able to either 

    1. Default the asset book on the invoice based on the AP Business Unit

    2. Add the Asset book to the Purchase Order so that it is populated with the invoice is matched

    or

    3. Not allow the invoice to be validated without an asset book being populated (and therefore, can still be edited to add the asset book without having to cancel and recreate the invoice line) prior to being submitted to approval workflow.

     

    Or - is there an option available that I am missing?  We would like to eliminate the rework that is caused by this issue.

    Judy

  • Judy Hamner
    R13 - Issue with Invoice Approval Rules4
    Topic posted August 21, 2018 by Judy HamnerSilver Trophy: 7,500+ Points, tagged Financials, Payables, Update in Core Financials > Payables & Cash Management public
    Title:
    R13 - Issue with Invoice Approval Rules
    Summary:
    Invoice workflow is failing in R13. Reason: The indentified "invoice Distribution/reversalFlag" is not valid here.
    Content:

    Invoice workflow is processing in R12.  However, as we are testing R13 functionality, invoice workflow is not working. 

    We attempted to modify the approver on a workflow step for testing purposes.  When we tried to Commit the change, we received an error (See attached screen shot ""Rule Error")

    We then tried to validate the rules and received the following Business Rule Validation: RUL-05717:The Identifier "Invoice Distribution.reversalFlag" is not valid here

    With the Dictionary Object: FinApInvoiceApprovalRules/InvoiceApprovalRuleSet/UKANSFUKURESFund/Pattern[4]/Invoice Distribution/Test[2]/expression[1]

    The rule conditions were not modified and are currently working in Production (R12).  Did this condition expression get removed in R13?  How do we go about fixing the rule so that we have the same type of condition applied? 

    It is critical that this condition be available for our business processes because we do not require workflow approval on cancelled invoice lines.  

    I noticed that there was another post related to AP invoice workflow issues in R13.  Wondering if this is the same issue or not.

    Your assistance is greatly appreciated.

    Judy

     

     

     

     

    Image:
  • Udit Manchanda
    Check Printing on Both sides of Check in Fusion R135
    Topic posted August 21, 2018 by Udit ManchandaBlue Ribbon: 750+ Points, tagged Financials, Payables in Core Financials > Payables & Cash Management public
    Title:
    Check Printing on Both sides of Check in Fusion R13
    Summary:
    Check Printing on Both sides of Check in Fusion R13
    Content:

    Hi,

    We have a requirement where client wants the AP Check printing to be done on both sides of the check. We are on Fusion R13.

    - Front side : normal check data and Remittance Details 

    - Back side : static text on the BACK of each check and some other Details

     

    What should be done to achieve the above requirement.

     

    regards

    Udit

  • Ravi Upadhyayulla
    Corporate Credit Card Expenses35.0
    Topic posted August 15, 2018 by Ravi UpadhyayullaBlue Ribbon: 750+ Points, tagged Expenses, Financials, Payables in Core Financials > Expenses public
    Title:
    Corporate Credit Card Expenses
    Summary:
    Credit card expenses do they need to clear as paid for employee
    Content:

    Hi,

    We have set the corporate credit card payment option as Company. 

    Load the transactions from the CC company and assigned to employees. Create corporate card issuer payment requests to generate invoice/payment request to pay the credit card company.

    Employee submits the expense report for approval to manager (all expenses are business related only). Payment requests are created once audited, does a payment need to be recorded to offset this payment request (but no actual payment going to employee).

    Please clarify the process for us.

    Thanks

    Ravi

  • Ravi Upadhyayulla
    Customer RefundsAnswered3
    Topic posted August 15, 2018 by Ravi UpadhyayullaBlue Ribbon: 750+ Points, tagged Financials, Payables, Receivables in Core Financials > Receivables & Collections public
    Title:
    Customer Refunds
    Summary:
    Refund to customer/party/supplier through AP
    Content:

    Hi,

    Customer paid excess amount on an open invoice. Receipt was applied and the balance was refunded to customer. Entered some comments on the receipt (hoping it will show on the payment request description in AP).

    Aren't the comments or any attachments from the receipt be applied/transferred/linked to the payment request.

    Thanks

    Ravi