Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Importing Receipts fro...
Microsoft Dynamics GP (Archived)

Importing Receipts from PowerCampus

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

My company has been using GP for years, but failed to ever reconcile the bank statements through it. I'm attempting to implement this change, but have a question:

I'm understanding that all deposits must go through the cash receipts/deposits to hit the Bank Reconciliation. Right now, they are entered as Journal Entries. All adjustments are entered as JEs. That change is fine. However, our software for our students' accounts is PowerCampus, which exports the receipts to GP. When this happens, it comes over as a JE, meaning it won't apply to the Bank Reconciliation. Is there a way to have it import as a Cash Receipt instead of a Journal Entry?

Thanks,

Dani

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Importing Receipts from PowerCampus

    So that means the import is built in to PowerCampus. That would mean you will have to understand where the data is coming from and fashion an import with an external tool. All possible, just not as easy as we first hoped.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing Receipts from PowerCampus

    Thank you. I spoke with someone from IT, she said PowerCampus imports directly. We don't use another software.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Importing Receipts from PowerCampus

    Hi,

    I agree with Matt. You'll need to get to provide additional information to the system, but importing it as a cash receipt should not be a problem. Does the JE that you bring over from PowerCampus match your bank statement? If it does, you might want to import an increase adjustment rather than a cash receipt - you wouldn't have to go through the 'deposit' step. Know that you should never, ever have to make a journal entry to cash (unless you're fixing a problem). Always use a Bank Transaction/Deposit. There isn't any transaction that would require using a JE. In fact, I would open my Account Maintenance screen, pull up the Cash account and uncheck the Allow Account Entry checkbox.

    Kind regards,

    Leslie

  • WindyCityGP Profile Picture
    WindyCityGP 1,045 on at
    RE: Importing Receipts from PowerCampus

    You may want to take a look at Nolan's Advanced Bank Rec.

    www.nolanbusinesssolutions.com/.../advanced-bank-reconciliation

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Importing Receipts from PowerCampus

    What are you using to do the actual import? Integration Manager? SmartConnect? Something else?  I'd imagine it would just be changing it out to import in to the Bank Rec module instead of the GL.  You many need to adjust a few things but it should be doable.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans