Posts

Posts

  • RR K
    Create an AP Invoice approval rule for PO matched Invoice...5.0
    Topic posted November 28, 2019 by RR KGreen Ribbon: 100+ Points, tagged Payables in Core Financials > Payables & Cash Management public
    Title:
    Create an AP Invoice approval rule for PO matched Invoice (2 way matched)
    Summary:
    Create an AP Invoice approval rule for PO matched Invoice (2 way matched)
    Content:

    Hello team,

    We have a requirement to create an invoice approval rule for the AP invoices matched with PO (specifically 2-way match).

    But I checked the available attributes for approval rule sets and could not find any attribute that tells us the matched PO is 2-way matched.

    Could anyone advise me on how can we achieve this requirement?

    Thanks in advance.

    Ram

     

  • Anil Nair
    How can we setup additional approvers who would need to...
    Topic posted November 27, 2019 by Anil NairBronze Medal: 1,250+ Points, tagged Configuration, Payables, Setup / Administration in Core Financials > Payables & Cash Management public
    Title:
    How can we setup additional approvers who would need to Release hold before the invoice hold is released in the system?
    Summary:
    How can we setup additional approvers who would need to Release hold before the invoice hold is released in the system?
    Content:

    The AP invoice hold notification notifies the requester on the PO and has two options - Release Hold and Acknowledge Hold.If the user selects the Release Hold, the invoice hold is released automatically and the invoice is validated.The user is not expected to release hold directly instead it should go through an additional approval by the approver group (e.g.Buyers) after the requester has pushed the Release Hold button.The Release Hold should be controlled as the invoice exceptions can be bypassed by the requester without fixing the exception which is not expected as all the exceptions should be resolved before releasing hold (mandated by the AP team).

    How can we setup additional approvers who would need to Release hold before the invoice hold is released in the system? 

  • Jesus Escobar
    Accounting line for P2P and P2P with Landing cost3
    Topic posted November 27, 2019 by Jesus EscobarBronze Medal: 1,250+ Points, tagged Cost Management, General Ledger, Inventory & Cost Management Analytics Cloud, Payables in Inventory and Logistics > Costing public
    Title:
    Accounting line for P2P and P2P with Landing cost
    Summary:
    Accounting line for P2P and P2P with Landing cost
    Content:
    Greetings, there is a question about the seats generated by the Landing Cost process for an item import process.
     
     
    If we see the basic case of a Purchase Order the Cost Distribution made are the following
     
    NORMAL INVENTORY ITEM P2P
    REC PO
    Debit                                |    Credit
    -----------------------------------------------------
    Receiving Inspection AC | Accrual    AC
     
     
    INV 
    Debit                             |  Credit
    -----------------------------------------------------
    Inventory Valuation AC | Receiving Inspection AC
     
    INVOICE 
    Debit             |  Credit
    -----------------------------------------------------
    Accrual    AC | Liability AC
     
    PAY
    Debit           |  Credit
    -----------------------------------------------------
    Liability AC | Cash AC
     
     
    LANDING COST PROCESS
    REC PO
    Debit                                | Credit
    -----------------------------------------------------
    Receiving Inspection AC | Accrual    AC
    |
    Receiving Inspection AC |   Landed Cost Clearing AC
     
    INV
    Debit               Credit
    -----------------------------------------------------
    Inventory Valuation AC |   Receiving Inspection AC |
    Inventory Valuation AC |   Receiving Inspection AC
     
    INVOICE 
    Debit                                  |   Credit
    -----------------------------------------------------
    Item Expense                    |
    or                                       |
    Landed Cost Clearing AC | Liability AC

     

    PAY

    Debit                          Credit

    -----------------------------------------------------

    Liability AC         | Cash AC

    The invoice  is with  Charge Invoice Associations when the accounting lines are reviewed, it makes a entry in the Item Expense account  this is correct? 
     
     
    How is the credit to Landed Cost Clearing AC internally cleaned by the SLA?
     
    Thanks.
     
    Version:
    19C (11.13.19.07.0)
    Image:
  • Jennifer Wolfe
    Calculating tax when a Country is selected2
    Topic posted November 26, 2019 by Jennifer WolfeBlue Ribbon: 750+ Points, tagged Configuration, Expenses, Financials, Payables, Setup / Administration, Tip, Update in Core Financials > Expenses public
    Title:
    Calculating tax when a Country is selected
    Summary:
    Expense location is setup as 'Country and State or Province' - calculating tax on Country
    Content:

    In 'Manage Expenses System Options' we have our 'Enable Expense Location Level' set up as 'Country and State or Province' 

    We also have the 'Pay Expense Reports Through' set as 'Third Party' - our third party is PeopleSoft Financials v9.2

    We are a Canadian college.  Our processing and voucher processing is working successfully until we enter an expense location of 'Canada', the voucher build process is erring as it cannot calculate the taxes.

    Any help would be appreciated.

    Thanks,

    Jennifer

  • Sirisha
    Invoice Distribution lines are getting defaulted to some...25.0
    Topic posted November 26, 2019 by SirishaBlue Ribbon: 750+ Points, tagged Payables in Core Financials > Payables & Cash Management public
    Title:
    Invoice Distribution lines are getting defaulted to some suppliers for a Prepayment invoice
    Summary:
    Invoice Distribution lines are getting defaulted to some suppliers for a Prepayment invoice
    Content:

    How the  Distribution combination defaulting on invoice lines on some suppliers for a Prepayment invoice

    Image:
  • Mukund Kudrimoti
    Invoice Approval - Not able to see InvoiceApprovalRuleSet45.0
    Topic posted November 25, 2019 by Mukund KudrimotiRed Ribbon: 250+ Points, tagged Payables, Security, Setup / Administration in Core Financials > Payables & Cash Management public
    Title:
    Invoice Approval - Not able to see InvoiceApprovalRuleSet
    Summary:
    Invoice Approval - Not able to see InvoiceApprovalRuleSet
    Content:

    Hello,

    I am trying to configure Invoice approvals. Somehow I am not able to see InvoiceApprovalRuleSet in the available list of rule. Please see the attached document. What I see is directly the line level rules. Has anyone faced such issue? Appreciate any help at the earliest.

    Is it some user role issue or setup issue?

     

    Version:
    19C
  • Trevor Watson
    AP to General Reconciliation Report145.0
    Topic posted November 22, 2019 by Trevor WatsonBlue Ribbon: 750+ Points, tagged Payables, Period Close / Reconciliation in Core Financials > Payables & Cash Management public
    Title:
    AP to General Reconciliation Report
    Summary:
    How is the Payables Variance figure derived on this report?
    Content:

    I am trying to identify the source of the "Payables Variance" figure on this report.

    The Invoice, Payment and Prepayment figures in the Payables Amount column equal the Accounting Amount column so I presume the Payables Variance comes from the calculation begin balance + invoices - payments - prepayment - closing balance.

    So how are begin and end balance calculated?

    The variance is shown under the "Payables Amount" column so my assumption is that the value is in AP and not GL - is this reasonable?

    Thanks.

     

    Version:
    Cloud 19D
  • philippe SALVI
    BANK STATEMENT FORMAT FILE FOR SPAIN NORMA 4315.0
    Topic posted November 22, 2019 by philippe SALVIGreen Ribbon: 100+ Points, tagged Cash Management, Financials, Payables in Core Financials > Payables & Cash Management public
    Title:
    BANK STATEMENT FORMAT FILE FOR SPAIN NORMA 43
    Content:

    Hi Team,

    I have one of my ERP Cloud customer who work an a project for implementing ERP Financial in Spain

    There is a note in MOS on this, Spain Bank Statement Format Norma 43 (Doc ID 2416185.1)  with a ER (BUG:28254200 - BANK STATEMENT FORMAT FILE FOR SPAIN NORMA 43)

    • Any idea on workaround ?
    • Is there some partners who support this ?

    Many thanks in avance for your support

    Best regards

    Philippe SALVI

     

     

  • Wendy Ware
    Payables Create Accounting Error "does not balance in...Answered35.0
    Topic posted November 21, 2019 by Wendy WareBronze Crown: 15,000+ Points, tagged Expenses, Financials, General Ledger, Payables, Period Close / Reconciliation, Subledger Accounting in Core Financials > Payables & Cash Management public
    Title:
    Payables Create Accounting Error "does not balance in the entered currency"
    Summary:
    "The subledger journal entry does not balance in the entered currency and entered currency balancing is not enabled for the ledger."
    Content:

    Getting error running Create Accounting from Payables on a cancelled payment transaction.  See screenshot of report.  Full error is:

    The subledger journal entry does not balance in the entered currency.
    Cause: The subledger journal entry does not balance in the entered currency
    and entered currency balancing is not enabled for the ledger.
    Action: Verify the entered amounts on the journal entry lines are correct or
    define a valid entered currency balancing account for the ledger.

    We have only ever had one currency type (USD) and the entry appears balanced.  Can anyone offer advice for troubleshooting or resolving this issue?  What is a "valid entered currency balancing account for the ledger?"

    Any assistance appreciated.  Wendy

    Version:
    REL 13.19.07 19C
    Image:
  • Tousif Azam
    Error while approving the invoiceAnswered35.0
    Topic posted November 21, 2019 by Tousif AzamGreen Ribbon: 100+ Points, tagged Payables in Core Financials > Payables & Cash Management public
    Title:
    Error while approving the invoice
    Summary:
    Please see the screenshot. We often get such errors. Any suggestion/advice is much appreciated.
    Version:
    19C
    Image: