Accounts Receivable Payment Processing Handling Invalid Records
Depending on which bank file format your company is using, different pieces of information may be required to import the data into SedonaOffice as a customer payment.
Using the Wells Fargo Bank format as an example, the invoice number is a required field. In the illustration below, the last payment row displays the customer number as 0000, the customer name as Unknown and the invoice number as 0. In the far right column of the Import Lockbox File list is a column labeled Raw Data; the area highlighted is the section that contains the customer number. The User may perform a customer lookup to see if this is a valid customer and to locate the correct invoice number to which the payment corresponds. Corrections may be typed directly into the grid area of this form. Once all corrections have been made, press the Validate Customers button located in the lower right area of this form. Once all customers have been validated, press the Post button.
ss4275