Auto apply sales prepayment credit memo

  • Auto apply sales prepayment credit memo

    Posted by josh-kandiko on December 28, 2016 at 9:25 am
    • Josh Kandiko

      Member

      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

      Member

      December 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
      ————————————————————————-

    • Tammy Radecke

      Member

      December 29, 2016 at 11:10 AM

      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

      Member

      December 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
      ————————————————————————-

    • Josh Kandiko

      Member

      December 29, 2016 at 3:27 PM

      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
      ————————————————————————-

    • Kim Dallefeld

      Member

      January 3, 2017 at 6:08 PM

      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

      Member

      November 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

      Member

      November 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.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!