1,130
Good Morning All
I have a need to import around 2000 payments into GP and Integration Manager does not appear to have a way of doing this. Has anyone come across this problem before and did you find a way of doing it?
All suggestions appreciated
Thanks
David
*This post is locked for comments
Did any SQL maintenance procedures help with correcting any issues with the database? I suppose you could also try a bulk copy out/in. I suppose it would depend on how many years of data there is.
Hi Richard,
Yes ouch it is. I have managed to get all the transactions in (I think), with exception of the PM payments which I will use your suggestion. They will still have the corrupted current Live database to refer back to after we cutover to the new database. Glad it's not me doing the reconciling!
Thanks
David
Ouch, I guess DR was not top of mind with this client. Hopefully this will work out for them. They have a tough road ahead trying to recreate the last two months work. So turn off posting to the ledger and then create a financial batch to read in the proper balances. Of course, how are they going to know what is correct? Is there anything they can check their balances against?
Hi Richard,
Thanks once again for the reply. The situation I am dealing with is a corrupt database and the last know good backup is from around 2 months ago. I have exported all transactions via smartlist from the corrupt database (which they are still using as live) and put them back in again into the restored database using integration manager. I think that the payments going in as credit notes and then loading the same transactions as bank adjustments could solve the problem.
Thanks again
David
I would import those same transaction as bank transactions. When you have done these two imports how do you plan on reconciling your AP GL balance and your AP AP balance? How about the same balances for your cash account? Will you be turning off posting to GL? Will you be importing beginning balances that will already include these transactions?
The best you can do with IM is to import the payments as credit memos and them apply them as if they were payments.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (