We are using GP2010 with SQL 2000. What are the rules used for Apply date when a cash is applied to an invoice in receivable?. We are seeing the apply date is same as payment /document date, we thought it should be the date the cash was applied. We would like to see the acutal date the cash was applied not the document date. How do we achieve this one in Dynamics GP 2010?
Thanks,
Vishnu
*This post is locked for comments
Susan,
Thanks
We got it. I don't remember that we saw this option in the previous version of GP. These payments were old and the GP is showing document date as the default apply date. We can see calender and everything. Do you know is there any way to show the current systems date as apply date instead of the document date. Users are going to make errors if they are changing the date.
Okay, you have the Customer ID and the Type followed by the Document No. and then the applied Date (which is a calendar) which means you can change the date for the apply.
The date it is picking up is the actual date that you put on the original document date. You can change the apply date.
In fact, if you do not immediately apply a payment, you always need to change the apply date and not just accept a date especially if you will wind up crossing months and for reconciliation and reporting purposes.
I didn't think GP2010 would even worked with SQL 2000, that may be the reason you are not seeing the calendar. If s, try just ryping into the date field for the Apply Date. I just looked and the minimum SQL requirements are SQL 2005 with SP3 or SQL 2008 SP1 or SQL 2008 R2 SP1.
For the number of issues and the amount of time that you are going to have to troubleshoot the issues brought on by SQL 2000, upgrade your SQL.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (