Description |
*Import bank transactions*
* Use the Standard GL Import method
*Acceptace critera:*
# Limit the number of records imported in a similar mannner to how we limited GL
# We should use the same method that we used for the import of GL to ensure proper performance
## I believe we limited import file to a certain size.
# we should test with the maximum number of records and ensure that it does not create locks on transaction screens when running imports.
# If one of the transactions fails we shold report the issue and fail and roll back all transactions.
# Currency will default from the bank account
# Transaction should be posted and errors reported if it does not post.
Add an import bank transactions function for opening outstanding checks.
* Add check number to import
File format:
|Field|Source|Field ID| | |
|Bank Account number|Supplied by customer|1| |Required|
|Date| |2| |Required|
|Type|Supplied by custoemer - Bank transction - bank Withdrawal|3| |Required|
|Descripton|Free form from customer|4| |Can be blank |
|Recurring flag|y/n from customer|5| |default to "n" if not supplied|
|Location|Verify to list of valid locations from system manager|6| |Required|
|GL account|Must be valid account - detail record|7| |Default from user profile if not supplied see Fig1
|
|Check no|Supplied by customer|8|added 19.1|Can be blank|
|Loan number|Must be a valid loan number or empty|9|added 19.1|Can be Blank|
|Detail Description|Supplied by customer|10| |Can be Blank|
|Debit|Debit for Withdrawal|11| |Default 0 or necessary value if not suppplied (if credit would not be supplied)|
|Credit|Credit for bank trnsaction|12| |Default 0 or necessary value if not suppplied (if debit would not be supplied)|
|Payee|Free form - overwritten if payee id is supplied|13| |Default to Blank if not supplied|
|Payee address|Free form - overwritten if payee id is supplied|14| |Default to Blank if not supplied|
|city|Free form - overwritten if payee id is supplied|15| |Default to Blank if not supplied|
|State |Free form - overwritten if payee id is supplied|16| |Default to Blank if not supplied|
|zip|Free form - overwritten if payee id is supplied|17| |Default to Blank if not supplied|
|country|Free form - overwritten if payee id is supplied|18| |Default to Blank if not supplied|
|Entity ID|Linked to entity name|19| |Default to Blank if not supplied|
|Pay to address|Linked to location name|20| |Default to Blank if not supplied|
Transaction id - used to link multile transactions together
Default for location if not supplied
Fig1
!pastedImage_d96734_0.png!
!pastedImage_d96734_1.png!
!pastedImage_d96734_2.png|height=465,width=760!
*Sample file:*
1234,123452,1/1/2018,Bank Withdrawal,Outstanding checks,No,Fort Wayne, 456,chk-1234,1278,Description,0,100,George Olney,16125 Aquila ct,Huntertow,in,46748,usa
*Error Vaidations:*
| | |
|Bank Account|Exists in maintenance / bank accounts|
|Date|Valid open Cash managment Period|
|Type|Bank Witdrawal or Bank Transaction|
|Description|check for valid length|
|Recurring|yes / no|
|Location|Valid location from the common information loacation table|
|GL Account|Valid account from the GL Chart|
|Description|Validate length|
|Debit|Must be a positive number|
|Credit|Must be a positive number but only valid with bank transactions|
|Check number|Duplicate Warning|
|