Example of where to fill out the data:
Bank Parameters Registers - CNAB
Suppliers Register
Accounts Payable Bill
Example of process in execution
Bank Parameters Registers - CNAB
Bank | Bank Branch | Account | Allows Payments | Due Date | Status |
001 | 001 | 001 | Yes | <Blank> | Affiliated without validity limit |
033 | 001 | 001 | Yes | 11/30/14 | Affiliated with validity date |
104 | 001 | 001 | Yes | <Blank> | Affiliated without validity limit |
237 | 001 | 001 | No | <Blank> | Not Affiliated |
341 | 001 | 001 | Yes | <Blank> | Affiliated without validity limit |
Supplier File
Supplier | Bank of Checking Account | Status |
F00001 | 001 | Apt for automatic bordereau |
F00002 | 033 | Apt for automatic bordereau until 11/30/2014 |
F00003 | 104 | Apt for automatic bordereau |
F00004 | 237 | Apt for automatic bordereau until 11/30/2014 |
F00005 | 341 | Apt for automatic bordereau |
F00006 | 399 | Apt for automatic bordereau until 11/30/2014 |
Accounts Payable Bill with balance on 11/20/2014
Bill | Supplier | Due date | Balance |
000001 | F00001 | 12/01/14 | 1000.00 |
000002 | F00001 | 12/01/14 | 2000.00 |
000003 | F00002 | 12/01/14 | 1000.00 |
000004 | F00002 | 12/01/14 | 2000.00 |
000005 | F00003 | 12/01/14 | 1000.00 |
000006 | F00003 | 12/01/14 | 2000.00 |
000007 | F00004 | 12/01/14 | 1000.00 |
000008 | F00004 | 12/01/14 | 2000.00 |
000009 | F00005 | 12/01/14 | 1000.00 |
000010 | F00005 | 12/01/14 | 2000.00 |
000011 | F00006 | 12/01/14 | 1000.00 |
000012 | F00006 | 12/01/14 | 2000.00 |
Generation of automatic bordereau with bordereau date equal to 11/25/2014
Bill | Supplier | Supplier Bank | Due date | Balance | Apt for | Note |
000001 | F00001 | 001 | 12/1/14 | 1000.00 | Yes | |
000002 | F00001 | 001 | 12/1/14 | 2000.00 | Yes | |
000003 | F00002 | 033 | 12/1/14 | 1000.00 | Yes | Bordereau date is previous to limit date. |
000004 | F00002 | 033 | 12/1/14 | 2000.00 | Yes | Bordereau date is previous to limit date. |
000005 | F00003 | 104 | 12/1/14 | 1000.00 | Yes | |
000006 | F00003 | 104 | 12/1/14 | 2000.00 | Yes | |
000007 | F00004 | 237 | 12/1/14 | 1000.00 | No | Not affiliated bank |
000008 | F00004 | 237 | 12/1/14 | 2000.00 | No | Not affiliated bank |
000009 | F00005 | 341 | 12/1/14 | 1000.00 | Yes | |
000010 | F00005 | 341 | 12/1/14 | 2000.00 | Yes | |
000011 | F00006 | 399 | 12/1/14 | 1000.00 | No | Not affiliated bank |
000012 | F00006 | 399 | 12/1/14 | 2000.00 | No | Not affiliated bank |
As result, we would have 4 generated bordereaux for banks 001, 033, 104 and 341.
For banks 237 and 399, the bordereaux are manually generated.
Generation of automatic bordereau with bordereau date equal to 12/01/2014
Bill | Supplier | Supplier Bank | Due date | Balance | Apt for | Note |
000001 | F00001 | 001 | 12/1/14 | 1000.00 | Yes | |
000002 | F00001 | 001 | 12/1/14 | 2000.00 | Yes | |
000003 | F00002 | 033 | 12/1/14 | 1000.00 | No | Bordereau date is after limit date. |
000004 | F00002 | 033 | 12/1/14 | 2000.00 | No | Bordereau date is after limit date. |
000005 | F00003 | 104 | 12/1/14 | 1000.00 | Yes | |
000006 | F00003 | 104 | 12/1/14 | 2000.00 | Yes | |
000007 | F00004 | 237 | 12/1/14 | 1000.00 | No | Not affiliated bank |
000008 | F00004 | 237 | 12/1/14 | 2000.00 | No | Not affiliated bank |
000009 | F00005 | 341 | 12/1/14 | 1000.00 | Yes | |
000010 | F00005 | 341 | 12/1/14 | 2000.00 | Yes | |
000011 | F00006 | 399 | 12/1/14 | 1000.00 | No | Not affiliated bank |
000012 | F00006 | 399 | 12/1/14 | 2000.00 | No | Not affiliated bank |
As result, we would have 3 generated bordereaux for banks 001, 104 and 341.
For banks 033 and 237, the bordereaux are manually generated.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas