Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Binayak Mohanty
    Payable Flexfield
    Topic posted September 13, 2018 by Binayak MohantyBlue Ribbon: 750+ Points, last edited January 30, 2019, tagged Accounting Hub Cloud Service, Assets, Cash Management, Core HR, Expenses, Financials, General Ledger, Help Center, Invoice Imaging, Payables, Period Close / Reconciliation, Reports, Revenue Management, Sample Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip 
    96 Views, 1 Comment
    Title:
    Payable Flexfield
    Summary:
    Payable Flexfield
    Content:

    Hi,

    I have a requirement to create a DFF for Payable Invoice. The value of the Expense Report invoice should be defaulted to Y if the expense report invoice is created from Credit Card Transactions in Expense. I am planning to create a table validated value set. In the value set definition, the "WHERE" field should contain a validation to capture Invoice number as a bind variable and then compare it with Expense module to identify if it is a credit card based transaction. But i am not sure about syntax to create such kind of value set in Fusion. 

    I appreciate if any one can provide me any feedback for my issue.

    Thanking You

    BM

    Comment

     

    • Becky Alvarez

      I am just curious why you don't try and build some type of OBI report because the expense report would be split in AP and the employee reimbursable amount generates one payment request in ap and the Credit Card transactions on a separate payment request and are going to be paid directly to the card company so you could look at the expense reports and the payment requests that are paid to a credit card company instead of an employee. 

      What you are asking  for above sounds very complex and I have no idea how you would code that and it doesn't appear that you have gotten any feedback with suggestions.  Are you sure there isn't any other way to go about meeting your requirement?