Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Importing manual PM payments

Posted on by 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

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Importing manual PM payments

    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.

  • PGS Profile Picture
    PGS 1,130 on at
    RE: Importing manual PM payments

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Importing manual PM payments

    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?

  • PGS Profile Picture
    PGS 1,130 on at
    RE: Importing manual PM payments

    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

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Importing manual PM payments

    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?

  • PGS Profile Picture
    PGS 1,130 on at
    RE: Importing manual PM payments

    Hi Richard

    Thank you for your reply. That will get them in and fix the vendor balances but will leave me with a problem with the bank reconciliation.

    Thanks

    David

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Importing manual PM payments

    The best you can do with IM is to import the payments as credit memos and them apply them as if they were payments.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans