Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Default accounts on unposted cash receipt transactions

(0) ShareShare
ReportReport
Posted on by

Is there a way to run the default accounts for a batch of Cash Receipts transactions? 

In other words, I have a batch of unposted cash receipts. I have brought them in through SmartConnect with no distribution. This was due to the issue where eConnect (and therefore SmartConnect) will not apply invoices where either the apply from or apply to document is not in the functional currency. 

I was able to import the apply information another way, but now I need to run the default accounts for each transaction.

If I bring up each cash receipt and click the Distribution button, the proper distribution populates (the RM10101 for this transaction is empty before clicking the Distribution button).

I want to avoid having to open up all non-functional cash receipts and click the distribution button, so I was hoping there may be a stored procedure I can pass in each payment number and have it default the distributions.

Other than that, does anyone have any indication as to when or if eConnect will support cash application in non-functional currency? If it is entered directly into GP, this has been functional since GP2013.

Thank you.

*This post is locked for comments

  • Tim W Profile Picture
    2,925 on at
    RE: Default accounts on unposted cash receipt transactions

    I don't think this is so much an eConnect issue as a GP issue.  My recollection is entering a CR in other than functional currency you can't apply it though the UI until the document is posted.  How you are forcing in the apply information another way is working around the business logic.  Personally I would approach this differently, bring in the CR's that our MC with no apply record, post them then see if I could automate an apply function at the RM20201 level rather than however you are forcing the apply in the unposted table.   

  • Isaac Olson Profile Picture
    on at
    RE: Default accounts on unposted cash receipt transactions

    Hello,

    Unfortunately the Default Distributions are re-calculated using Dexterity code in Microsoft Dynamics GP, so you would almost need a customization outside of SQL to click the default button for you on the distributions.

    Microsoft Support

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