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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import of AP & AR batches 1

Status
Not open for further replies.
muhaidib

muhaidib

Programmer
Sep 27, 2005
82
SA
Is it possible to export the POSTED AP or AR batches and import them as OPEN batches? What changes in exported .xls are required to show the status as OPEN?

Due to some problem I have to restore couple of days old data and hence this exercise.

 
Sort by date Sort by votes
When you import an exported batch, it's automatically open, there's nothing to change.
 
Upvote 0 Downvote
Thanks tuba2007.

Is it possible to export AR or AP batches selectively or in series?
I recorded a macro to export a batch but its code doesn't show destination file path or its copying procedure to destination.

Can U please explain it.
Thanks
 
Upvote 0 Downvote
No, macros won't record that, you'll have to write it yourself. How many batches are you talking about? If it's less than 30, I wouldn't bother with programming.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ravazz
  • Locked
  • Question
Sage300 2021 Webscreen AP lock batch
Replies
1
Views
216
DjangMan
DjangMan
Mab-a
  • Locked
  • Question
Batch AR Invoice Import Automation
Replies
3
Views
125
Mab-a
Mab-a
Yiren
  • Locked
  • Question
Unapplied Cash Excel Import - Error on posting batch
Replies
0
Views
112
Yiren
Yiren
mydcba
  • Locked
  • Question
open APPYM table with MS Access
Replies
4
Views
288
DjangMan
DjangMan
Mab-a
  • Locked
  • Question
Excel import error
Replies
2
Views
104
Mab-a
Mab-a

Part and Inventory Search

Sponsor

Back
Top