Solved

GP 2010 -- Sales (Customer Card)

Posted on 2013-12-03
5
610 Views
Last Modified: 2013-12-05
We have a customer (JoeEnd) that has several different accounts.  For example JoeEnd01, JoeEnd02, JoeEnd03 -- through JoeEnd09.   If we apply a payment to JoeEnd03 and then find out later that it was posted incorrectly, how can we re-direct this payment to JoeEnd06.  We know that we can unapply the payment but then it has to still be applied within the same customer card, JoeEnd03.  Can this be done on the front-end of GP or do we need to do this in the backdoor (SQL).  Thanks!
0
Comment
Question by:pstre
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39695053
There is really no way to do this in the GP user interface as you have it set up. I also strongly recommend not even trying to do this in SQL. There are way too many related tables that would need to be updated and you run the risk of ending up with corrupted data.

If the payments have already been posted your two ways of handling this are:
Void the payment and re-enter it under the correct customer. This might cause issues with Bank Rec if you are using it, so this is only realistic if the payment was entered very recently.
Enter a debit memo for the 'wrong customer' and a credit memo for the 'right customer'. Apply the payment already posted to the debit memo, apply the credit memo to the invoice(s) that it should have paid.

For the future, you may want to look at the National Accounts module in Dynamics GP to address this better. You can create a 'parent' customer for JoeEnd, and assign all the individual JoeEndXX customers as 'children' of this parent. When you enter payments, enter them under the JoeEnd parent account and you can apply them to any invoices for any of the child accounts.
0
 

Author Comment

by:pstre
ID: 39695456
We have National accounts now; however, there are still payments in the wrong place (before we starting using National accounts).  To get these old incorrectly applied payments correct, if we void the payment, will the original invoice now be outstanding so that we can apply the payment correctly to it?
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39695521
Yes, if you void a payment, any invoices it was applied to will now become unapplied. However, if these are in hisrory, you will need to use the PSTL tool to unapply them first before voiding. And if you are using Bank Rec, you may need to do something else in Bank Rec to clean this up.
0
 

Author Comment

by:pstre
ID: 39695676
If we void a payment on JoeEnd03 and the invoice is now unapplied, can we apply the payment to JoeEnd07 or do we have to stay within the same customer, JoeEnd03?

Our problem is that before we started using National Accounts, payments were applied to the wrong customer (for example, JoeEnd03 rather than JoeEnd07) and we are trying to getting the payments applied to the correct customer.
0
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 39695721
In out of the box GP there is nothing you can do to accomplish this. You can only apply transactions to the same customer (so from Customer ABC to Customer ABC) OR from a partner to a child if using national accounts.

There is a customization that Microsoft sells and that one of my customers is using that would let you apply a payment or credit from one child customer to an invoice of another child customer when you are using National Accounts. This is something you would need to talk to Microsoft or your GP Partner about.

Otherwise, you would need to either void/re-enter or do the credit memo/debit memo transactions.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question