Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting into excel
- Thread starter daffuso
- Start date
- Thread starter
- #2
Give us the bigger picture: why?
You can only export one batch at a time from the JE screen, that is the way the beast works.
You have a number of options, depending on your programming skills:
1. Write a VBA macro to export a range of GL batches, you still export one batch at a time, but you can run it from a starting batch to an ending batch.
2. Write VBA to export transactions from either GLPOST or the batch tables.
3. Use something else (like Access) to query the tables and export.
4. Write a macro to consolidate GL's across companies.
5. Buy GL Consolidations, that's why it is there.
I am assuming your desire to export multiple batches relates to an equal desire to import them somewhere else, like in another GL. You see, I am still working on my mind reading skills here, so I may be wrong.
You can only export one batch at a time from the JE screen, that is the way the beast works.
You have a number of options, depending on your programming skills:
1. Write a VBA macro to export a range of GL batches, you still export one batch at a time, but you can run it from a starting batch to an ending batch.
2. Write VBA to export transactions from either GLPOST or the batch tables.
3. Use something else (like Access) to query the tables and export.
4. Write a macro to consolidate GL's across companies.
5. Buy GL Consolidations, that's why it is there.
I am assuming your desire to export multiple batches relates to an equal desire to import them somewhere else, like in another GL. You see, I am still working on my mind reading skills here, so I may be wrong.
- Status
Similar threads
- Locked
- Question