Prior to importing a journal entry I have sorted my excel document by date and GL number. When I open it in FE NXT and database view the information is in a new order, dates are no longer grouped, which makes reviewing or editing before posting difficult. In the database view journal entry import it keeps the information in the same order as the original.
This is a problem even when manually entering a JE. FE NXT rearranges the lines so if someone is proofing it, it will not match the order the lines were entered. Why would it change the line numbers? Very frustrating.
Hi, I just wanted to add that keeping the same row order is extremely important to any accountant. For most accountants keeping related debits and credits together is how we were trained and when reviewing JEs makes it so much easier. Sorting by account number or date is ok, but not enough
This is a very important feature.