web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
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

I have the same question (0)
  • Isaac Olson Profile Picture
    Microsoft Employee on at

    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

  • Tim W Profile Picture
    2,925 on at

    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.   

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans