Description |
When importing tranasctions into the general ledger I am noting that when using a cross reference table I am not getting valid accounts imported into the general ledger.
See the attached video.
[https://www.youtube.com/watch?v=E5hVCR-XRvk]
Test Case
Create a series of accounts in the translation table that will allow us to convert a file with one account map into the new i21 account map.
1) Create account map.
a) go to cross reference tab of gl account detail and add cross references
!pastedImage_d70057_0.png!
2) Create a file for impoirt using the alternate account id's
!pastedImage_d70057_1.png!
(See attached file)
3) Import using the gl import / export function and reference the cross reference
!pastedImage_d70057_2.png!
4) expected result
Imported transaction
10003-0000-000 8.00 (dr)
10000-0005-000 8.00 (Cr)
[http://inet.irelyserver.com/display/GL/Test+Case+Cross+Reference]
|