Dear admin,
I need to extract my data and split some most of transactions and reuploaded in to separate entity can you help and explain for me how ?
Regards
You have not provided nearly enough information for anyone to offer help. You need to describe exactly what you are trying to do.
- Backup your businesses
- Restore the backup
- Change it’s name
- Batch delete all the data you do not want (were not going to upload)
- when you have your new businesses as you want it, backup iit up again with out history then restore and use that backup
1 Like
Dear,
Thanks for replay but i need to extract in excel and separate the data and reupload again in excel this is what i need if some one can help me batch file did not show account name its showing as numbers and words i don’t no which account is it
Have you searched the forum? There are already many posts on this forum with techniques to do this.
Then you also need the computer skills to do that task. It is significantly more technically demanding than the alternative approach I suggested which is why I suggested the alternative.
You have not succeeded in searching on the forum for batch update / GUID / VLOOKUP, all of which are relatively easy compared to the task you say you require. Perhaps employing a programer would be the most likely way for you to achieve your requirement.
Dear can you explain more when i download batch the account name is coming as numbers and words not coming as name or account number how to do vlookup
If you have the IT skills, you can use the api (search the forum, there’s lots of post).
Otherwise, you can create your own lookup table by going to each COA entry, clicking on edit and copying the faint grey GUID.
You will have to create the table once and update it with new COA entries from time to time.
Edit: Alternatively, you can create this report transformation:
The catch is that it only works for accounts that have been used at least once.
Thanks all