Additional Balancing Traction Generated when using Balance By T0 transaction analysis code in Journal
Posted by Syed Qutubuddin on 28 October 2018 05:22 PM
Additional Balancing Traction Generated when using Balance By T0 transaction analysis code in Journal |
Ledger Definition is set to balance by T0. The source file involves 2 journal types, and even though the total amount of debit and credits for T0 codes are all balanced. Journal Import produces additional balancing transaction per journal type.
Journal import report indicates SunSystems is balancing by Journal Type and T0, when it should only be balanced by T0.
According to v4.4 Help: “If you specify a Balance by option of TD-Transaction Date, JT-Journal Type or T0-T9-Transaction Analysis Category, journals are only balanced and sorted by this field in JI=Journal Import; these Balance by options do not affect JE=Journal Entry.”
It indicates Journal Type is an optional balance option, not mandatory.
To test further sing the same source file, in v426 there’s no additional balancing transaction generated. We expect v4.4 to be the same as v426.
Steps To Reproduce:
1. In Ledger Definition, Set Balance By = T0
2. In Journal Types, create journal type PAY, enable T0, and tick ‘Conversion’
3. Create another journal type GJ, enable T0, and tick ‘Conversion’
4. Journal Import attached Colliers.ndf with Post Transaction = No
Review report: Journal is sorted by journal type followed by T0