You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Upload Customers from Spreadsheet - Customer Bank Account sheet

Received Response
44
Views
3
Comments
edited Jan 30, 2019 4:31PM in Receivables & Collections 3 comments

Summary

Having trouble figuring out how to create Customer Bank Account when creating the Customer

Content

We're using the Upload Customers from Spreadsheet functionality to create Customers in Fusion Receivables.  We have to create bank accounts for many of them, which is used to identify the Customer in lockbox AutoMatching.  However, we're having trouble figuring out how to populate the spreadsheet appropriately.  The Customer Account & Site gets created, but not the Bank Account.

The spreadsheet indicates Bank Name and Bank Branch Name are required.  That's not a problem, we always create them prior to creating the accounts.  However, the spreadsheet also says the combination of Bank Name & Bank Branch Name must be unique.  We have several customers who use the same Bank & Bank Branch.  We're not able to figure out what Oracle is validating here.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!