Give users the ability to either copy & paste or upload from excel into the General Journal Entry - Lines section. This eliminates a great deal of repetitive data entry.
by: Isaac U. | over a year ago | Integration
Votes
26
Copy/Paste to and from a table (Excel) into General Journal Entry rows
by: Isaac U. | over a year ago | Integration
Comments
I used JD Edwards accounting software years ago that had the ability to copy and paste tables to/from spreadsheets. You could copy a 100 line journal entry into excel, quickly edit, sort, etc. and paste it back into the programs. Even create new entries by copying and pasting. Saves hours of data input and editing. All tables in Sage should have this ability.
We have started to import our journal entries into Sage 100 using Visual Integrator. This allows us to create all JE in excel and then just import that file which not only saves time but it reduces any manual keying errors.