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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cheque Type wont Save ...
Microsoft Dynamics GP (Archived)

Cheque Type wont Save in Cash Receipts

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

Working on GP2015 - just applied the Canadian Payroll Year end - 14.00.1016 and now when we try to enter Cash Receipts we are getting a weird situation.

When we enter Cheque as the document type, enter the cheque number, amount and apply it to the outstanding invoice and then click SAVE - the system just does nothing - it will not save the transaction.

When we take the window as already entered, and change the type from Cheque to CASH - fill the rest of the required fields, we are able to save the transaction.

We have repeated this with 4 different user ID's ranging from Admin to SA to clerk and there is no difference

We have also repeated in a TEST company on a different server - the data is restored to the TEST every weekend - so the data in TEST is no more than a week old.  All configuration is the same between the two servers.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Cheque Type wont Save in Cash Receipts

    Hi Bill,

    Have you tried to enable a DEX_SQL Trace in the DEX.ini (unless you have the GP Power Tools to make your life easier ...) ?

    Are you using there any 3rd party tools that could interfer with the cheque process ?

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    Can you tell me more about this - what will Dex_SQL Trace show or tell us?

    Just want to be clear as I will need to get the DBA and the Server Admins involved in something that directly effects their servers, so I want a clearer understanding of what to expect from this.

    I know it will create a log file of transactions, but not clear on what we will be looking for.

    Thanks Beat.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Cheque Type wont Save in Cash Receipts

    Bill,

    The DEX_SQL trace doesn't involve any DBA... it can be triggered on the GP client side and will write a detailed log file in the folder of your choice..

    If you have the GP Power Tools its much easier because you can start the trace right before running the cheque process and stop it when you're done, whereas without GPPT you have to enable this in the DEX.ini first, start GP and then go thru all the process, which will collect a lot of garbage before you get to the point.

    The idea behind creating is to be able to pinpoint what were the last steps that occured before an error raises in GP (or non-error in case, but it may still be helpful)..

    see more about here :

    support.microsoft.com/.../850996

    dynamicsgpblogster.blogspot.ca/.../enabling-dexsql-logs-with-support.html

    Or when you own GPPT (formerly SDT):

    https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/01/15/how-to-configure-sql-profile-tracing-using-the-support-debugging-tool/

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    Thanks for the clarification I was misunderstanding what you were saying - I was thinking SQL Profiler - yes I am familiar with the Dex Trace as you have described - thanks - I will give this a try.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    Just a quick update.  In addition to not being able to save transactions entered as Cheque type, when we enter Credit Card or Cash we get transactions that do not stop at the Bank Deposit screen and are found directly in the Bank Reconciliation list.

    The challenge here is that it is not consistent.  Some of the transactions in a batch will hold at the Bank deposit screen while others in the same batch are not in that screen and only are found in the Reconciliation window.

    What the heck are we doing wrong.  I have been using CM / Bank for a long time, but I do not recall a setting anywhere that says (1) don't allow cheques and (2) post some transactions directly to Reconciliation and (3) hold some transaction to force user to enter Bank Deposit and post.

    Not sure, maybe I missed an update.

  • Verified answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    One more update - we tested this not only on this client data but on a UAT Server of another system - totally different server, different data, but same version of GP - 14.00.1016 - both updated over the holiday to apply the Canadian Payroll Tax - used the same download site for both companies and neither of them have 3rd party applications that interface in any way with Bank module.

    Thanks

  • Verified answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    Ok so where does Payment Document Entry window come from.  On the Cash Receipts screen, when you click on Additional there is a option for Payment Document Entry and when I open this window and close same ( do nothing ) I am able to save a document with Cheque as the selected type.  

    When we did the Payroll Update we did nothing else but apply the patch, update the company databases and update the client machines.

    Where does this window come from - what got turned on?

  • Verified answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    Sorry but the answer to the problem is that somewhere around the 19th of the month, someone clicked on a button that turned on a feature called Payment Document Management and then proceeded to 'not finish' the installation, but did not realize the problems that his actions caused.

    Lesson - if you activate a feature - intentionally or not - you are best to complete the activation otherwise you will end up with issues such as this - the primary lead on this project estimates that we spent about 3,000 dollars of time and effort trying to resolve a matter that literally was solved / caused by a single click of the mouse.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Cheque Type wont Save in Cash Receipts

    Hi Bill,

    Great you found it.. but I'm still scratching my head to figure out how that got enabled by accident.. this is an addtional module that requires an installation from the GP setup.. no ? .. does that mean someone that had access to the GP client setup activated this module ? or was installed but no one had a clue about its utilitry and then got into the administrator company setup portion and checked the boxes to enable it ?

    This is not tipically a module used in the US & Canada, but mostly in foreign countries to accept other payment methods than cash, credit cards or cheques..

    blogs.msdn.microsoft.com/.../having-the-module-payment-document-management-installed-could-cause-performance-issues-in-purchasing-and-sales-in-us-installs-of-microsoft-dynamics-gp

    PS: found a similar question on GPUG : https://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MID=12976#bm0

    Of course, once you know the source of the problem, it's easy to find related issues reported :-)

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Cheque Type wont Save in Cash Receipts

    Beat, I think you are correct on your assumption that someone turned on the feature.

    We had a situation around the time of the 2016 Tax Update that forced the IT / DBA to 're-install' GP and I think tat they 'over installed' the modules - and include Payment Document Management as a good looking module to add.

    But then of course did not tell anyone ( me ) that they may have added some extras. So now we suffer.

    Question - if the module is 'registered' it shows in the various screen locations - if I 'unregister' will it go away?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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