Receivables & Collections

Get Involved. Join the Conversation.

Topic

    Suresh Kumarasamy
    Upload Receipt using FBDI - Sample
    Topic posted February 5, 2019 by Suresh KumarasamySilver Trophy: 7,500+ Points, last edited February 6, 2019, tagged Cash Management, Collections, Financials, General Ledger, Intercompany, Receivables, Revenue Management, Setup / Administration, Subledger Accounting, Tip, Update, User Interface 
    370 Views, 11 Comments
    Title:
    Upload Receipt using FBDI - Sample
    Summary:
    Upload Receipt using FBDI template
    Content:

    Hi,

    Anybody has sample template to upload AR Standard Receipt using FBDI, I can find a raw template from fusion OER http://www.oracle.com/webfolder/technetwork/docs/fbdi-r13-18b/fbdi/xlsm/ReceivablesStandardReceiptImportTemplate.xlsm

    But if we got some sample template data with template, it will help us to upload with receipt DFF and Receivable specialist.

    Comment

     

    • Brian Wolfe

      If anyone else posts, please ensure sample data does not contain bank account information.  Please see attached, it is an older version, but should be helpful.

    • Suresh Kumarasamy

      Thank you so much Mr.Brian Wolfe. I will try to upload based on this sample file.

    • Rizwan Basha

      Hi,

      Does the receipt FBDI spreadsheet upload allow 

      - Multiple receipts creation (with multiple lines) within single batch/file load 

      - What does the sequence number signify? if I have 10 lines , Can it be same for all lines e.g. '1'  or?

      Appreciate some support here

      Thanks

    • Brian Wolfe

      Please clarify...you have referred to sequence number which is not in the FBDI sheets, if so, please indicate the sheet and column.  I suspect you are asking about the ADFdi upload which is available from the task pane.

      • Rizwan Basha

        Hi Brian, my bad..! Yes, I was referring to ADFDI create receipts spreadsheet. Can we create multiple receipts in single load? And what purpose of sequence number ?

    • Brian Wolfe

      The sequence number represents a given receipt, attached is an example of 1 payment with many remittance references.  If you were to add receipts to the attached example, the next receipt number would be 2, with the availability of entering one or more rows for that sequence number/receipt.

    • Brian Wolfe

      attempting attachment again

      • Rizwan Basha

        Thanks Brian for the sample xlsx, I had success creating one receipt with multiple Invoice references. I'll try out per your suggestion with unique sequence number for different receipt number. Cheers

    • Rizwan Basha

      Hi Brian,

      I had success on creating multiple receipts using the FDBI template by using unique 'Sequence Number' for receipt numbers. Thanks for your support.

      On Another note, how to reuse  a saved spreadsheet for upload? If I start filling in the spreadsheet (say 40+ lines) and when the session expires, I relogin with credentials but it clears all the data. Can we extend the session timeout or is there other options to reuse saved spreadsheet for upload ?

      Thanks

      Rizwan

    • Brian Wolfe

      I do not have any information regarding ADFdi timeouts or sessions settings.  If it were me, I would copy/paste the entered rows to a new workbook, then sign back in, and then paste the receipts back to the active session workbook.