Does any one know how to recognize the last row of an import? I am trying to have it insert a particular account number at the end of the import to balance the GL batch. Thanks
Best answer by Gabriel Michaud
View originalDoes any one know how to recognize the last row of an import? I am trying to have it insert a particular account number at the end of the import to balance the GL batch. Thanks
Best answer by Gabriel Michaud
View originalHi
I could not find a way to get the last row on import. Can you elaborate the business requirement? Is this a periodic/regular import(or one time)? Cant the line be inserted on source excel (or whatever format used) itself?
Merry Christmas and Happy Holidays!
Regards,
Hi Vkumar
This is a auto repeating import that will be grabbing the file from another system. The other system is not pushing out credit’s and debits. This is for AR transactions so I figured that last entry would be the AR account. If you manually put in a journal transaction and for the last line you enter the account and hit return if auto balances the journal for you. So i was trying to have that happen in my import. thanks
Regards,
Hi Gabriel ,
Those are great suggestions. I’ll try the customization, Thank you !!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.