Importing Bank Statements in OpenERP
Bank Statements from text files can be imported into OpenERP in a simple way. For importing such a file create a wizard to import the text file into the OpenERP. This wizard contains a binary field to import the file. From the wizard select the file to be imported. The file may contain the details such as Bank Name, Bank Code, Customer Name, Customer code, Account number, Invoice number, Date etc. All these values can be read from the file and can be used in the OpenERP as per the need.
Suppose we have a statement file that has the following details:
These detals are Bank Name, Bank Code, Customer Name, Customer code, Account number, Invoice number, Date respectively.
Here is the wizard to import the file.
Following is a simple code to import such a file and to use the details in the file. This code provides functionality to import bank statements from text file.
The details in the statement file will be in the variables bank_name, bank_code, customer_name, customer_code, account_no, invoice_no and date.