Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Tracking Customers

(0) ShareShare
ReportReport
Posted on by

Is there a way to track customer payments to multiple revenue accounts throughout multiple years without using the subsidiary ledger?

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Tracking Customers

    Ok, just trying to make sure this was not something simple that could be resolved with a little research. Thank you for the advice. Will contact our partner.

  • Warren R. Pease Profile Picture
    730 on at
    RE: Tracking Customers

    No, I am not talking about the Sales Transaction Entry window.   Your decision not to use your partner is frankly setting your self up to fail and waste the investment you have made in GP.   On line training really does nothing to address designing business processes to work with GP.    It is kind of like expecting to read your car's owner manual and then know how to drive.  

    Warren.

  • Community Member Profile Picture
    on at
    RE: Tracking Customers

    Warren,

    Are you talking about using transaction entry in the sales module? If so, is this something that is covered in any of the online training? We currently do not use that feature. We do have a partner, but we are trying to utilize all of the resources provided with our service plan before having to call them to step in.  

  • Warren R. Pease Profile Picture
    730 on at
    RE: Tracking Customers

    No, you do the receipt right on the RM Transaction Window.  

    I really think you need to pull in a GP Partner to help you with the business process here.   If you don't have a good one, then we can talk.

    Warren.

  • Community Member Profile Picture
    on at
    RE: Tracking Customers

    So basically just change around the distribution when I am entering a receipt. Also, what about the apply button. Even though right now there may be no invoice to apply this receipt to, if I did have to invoice this customer for some reason in the future, could a receipt from the past be applied to that new invoice? Is there a way to stop these cash receipts from being applied to anything in the future?

  • Warren R. Pease Profile Picture
    730 on at
    RE: Tracking Customers

    If you do a RM Transaction you can enter the receipt right on that window.   The receipt is automatically applied to the "invoice", so zero dollars are moved into AR.   Transaction history is moved to AR, but it is fully applied.    

    This also makes a receipt in BR, that then needs to be deposited (with other receipts possibly).  

    This also makes a GL entry.   DR-Cash, CR-Revenue.

    Warren

  • Community Member Profile Picture
    on at
    RE: Tracking Customers

    Warren,

    yes we do use the bank rec. right now we are entering the donations as receipts through bank transactions. Could you explain #2 a little more in detail? Are you saying we could enter these payments as receipts without having to apply them to an invoice?

  • Warren R. Pease Profile Picture
    730 on at
    RE: Tracking Customers

    Do you have a competent GP Partner to work with?

    Warren

  • Community Member Profile Picture
    on at
    RE: Tracking Customers

    Is there somewhere I could see an example of using the customer id with the journal entry? That would most likely apply to most of our donations.

  • Warren R. Pease Profile Picture
    730 on at
    RE: Tracking Customers

    Most of my NFP clients use a donation management software and we integrate with that.   Based on your questions, I assume that you do not.    

    There are several issues to consider here.  

    1) Do you want to use Bank Rec?   If so, then doing a GL entry will not work as it does not hit Bank Rec.   You would need to do a Bank Transaction to update both Bank Rec and GL.    However that begs the question about receipts vs. deposits in Bank Rec.  

    2) You don't necessarily need to do an Invoice (in SOP or Invoicing).   You could do a RM Transaction and apply the cash at the same time as entry.    This does mean that you need to have customer(s) setup.   It would be a one step operation however.  

    3) Does you GL Account setup reflect the different streams?

    I could go on and on with several more issues.    

    Hope this helps more than confuses.

    Warren

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans