![](https://cdn.dynamicscommunities.com/wp-content/uploads/buddypress/groups/1/cover-image/6340fb4129d21-bp-cover-image.jpg)
Auto apply sales prepayment credit memo
-
Auto apply sales prepayment credit memo
Posted by josh-kandiko on December 28, 2016 at 9:25 am-
We’ve been using the sales prepayment functionality against sales orders with success. One question we have is when the time comes to create a sales prepayment credit memo, it doesn’t auto apply the credit memo to the original prepayment invoice, so you have to go into the customer card, view their ledger entries, select the credit memo, hit Actions->Apply Entries->Select the prepayment invoice->Set Applies-to ID and then Post Applications.
This seems like a lot of work given that the system won’t let you manually create a credit memo and apply it from that screen. You have to go through the sales order and create the prepayment credit memo. Is there a setting somewhere to auto apply the entries so our accountants don’t have to manually close each of these documents?
——————————
Josh Kandiko
Saris Cycling Group
Madison WI
—————————— -
Jeane Meade
MemberDecember 29, 2016 at 9:21 AM
Try using “Copy Document”…start the credit memo and copy the sales prepayment invoice.
We have a special program where we buy a particular item from customers and put credit into their account. We use the Sales Return Order to receive the items and credit the customer. Then we either pay them with a check or they can buy product. When they buy product, we create a sales order, then copy the “credit memo” created by the return order, delete the credit memo lines and put in the items they would like to purchase. We have to add the sales shipment date.
If we forget to copy document, we have to manually apply the credit memo to the order.
——————————
Jeane Meade
IT/DBM
Sheldons’, Inc.
Antigo WI
————————————————————————- -
If you go to the Application tab of the Credit Memo you can choose the appropriate invoice to apply the credit against. When you use Copy document it fills this information in for you.
If you don’t want to copy a whole invoice to credit, you can use the Get Posted Document lines to Reverse feature but this requires filling in the document to apply against as well.
——————————
Tammy Rempfer
Group O
Milan IL
————————————————————————- -
Rick Dill
MemberDecember 29, 2016 at 11:31 AM
Hi Josh, there isn’t a setting that can be turned on to automatically apply the credit memo to the Invoice.
It would require a modification to make the application automatically.
——————————
Rick Dill
Consultant
ArcherPoint Inc.
Waupaca WI
————————————————————————- -
Hi All,
Just an update. When going to the credit memo screen and trying to select a ‘Prepayment Invoice’, an error message will appear telling you that you specifically cannot do a manual credit memo against the Prepayment Invoice. So it seems that the developers hard coded the fact that you have to go to the sales order and do the credit memo through it.
That being said, we wrote some code to accomplish what we were looking for (taking the newly created credit memo, applying it to the original prepayment invoice) so that the accountants don’t have to remember to do this for each credit memo that gets created.
——————————
Josh Kandiko
Saris Cycling Group
Madison WI
————————————————————————- -
Josh, you are correct. To do a prepayment credit memo, you need to do this from the original document (purchase order or sales order). The reason is to keep track of the prepayment amount for accurate accounting as invoices are processed against the orders.
It looks like without a modification there is not a way to apply the prepayment credit memo to the prepayment invoice from the originating order. As others have stated, this is very doable.
——————————
Kim Dallefeld
NAV Consultant
Ft Worth, TX
Kim@Dallefeld.com
————————————————————————- -
Adriano Ramiano
MemberNovember 1, 2017 at 3:04 PM
Just to reopen this thread, has anyone actually made the required development change here?If somebody has the mod to share (NAV 2016) then i’d be a very willing customer 🙂
——————————
Adriano Ramiano
——————————
——————————————- -
Adriano Ramiano
MemberNovember 6, 2017 at 8:21 PM
Has anyone applied a solution here?——————————
Adriano Ramiano
——————————
——————————————-
josh-kandiko replied 7 years, 7 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Auto apply sales prepayment credit memo’ is closed to new replies.