Open Forum

Expand all | Collapse all

Unapply Payment and Cancel Invoice

  • 1.  Unapply Payment and Cancel Invoice

    Posted Jan 10, 2020 02:00 PM
    We have 4 invoices in D365 Business Central that were paid at the end of December, however our funds were not received and applied to our bank until 2020.  We need to unapply the payments and cancel the invoices in BC and re-enter them with January dates.  Because they are marked as paid in BC, we cannot unapply.

    How should we handle fixing these invoices?

    Thank you

    #D365BusinessCentral


    ------------------------------
    Linda DiGiacomo
    SMB Suite/Nextcorp
    Irving TX
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Unapply Payment and Cancel Invoice

    TOP CONTRIBUTOR
    Posted Jan 10, 2020 05:03 PM
    Linda,

    A couple of questions before I can assist.

    1. Are you describing sales or purchase?
    2. I can understand the need to apply payments (sales or purchase) using a different date, but why do you think you need to cancel the invoices?
    3. Do you need to also recognize the sale (revenue) or purchase (expense) in January rather than December? If it is just the cash application that needs to change dates, there is no need to cancel and re-enter the invoices.

    ------------------------------
    Cynthia Priebe
    New View Strategies
    "The NAV & BC training and process experts"
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Unapply Payment and Cancel Invoice

    TOP CONTRIBUTOR
    Posted Jan 10, 2020 06:58 PM
    Edited by Cynthia Priebe Jan 13, 2020 09:05 AM
    Linda,

    Since you need to recognize the cash receipt and revenue in January, you will need to undo the transactions in the reverse order in which they occurred. For this to work, the cash receipt must be open, not reconciled to a bank statement.

    1. Go to the Customer Card, Customer Ledger Entries. Find the payment you want and undo and unapply the entries.
    UN2. Also from Customer Ledger Entries, from the now unapplied payment entry, select Reverse Transaction. Here you can see the result of the unapply then reverse.
    REV

    Now that the cash receipt has been unapplied and reversed, you should be able to use a correcting credit memo to "undo" the sales invoice if this also needs to be reversed.

    1. From the Customer Ledger Entry for the invoice, navigate to the posted document.

    2. From the Menu, Actions, select Correct, Correct. This will reverse the invoice and create a new invoice with the same information that you can correct (including posting date) prior to posting.
    psi

     


    ------------------------------
    Cynthia Priebe
    New View Strategies
    "The NAV & BC training and process experts"
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Unapply Payment and Cancel Invoice

    SILVER CONTRIBUTOR
    Posted Jan 14, 2020 08:03 AM
    That was a very comprehensive solution to her problem

    There is nothing I can add to that except that I am curious to know, as she mentioned she cannot unapply the payment, why she can't unapply it and what is the error message she is getting when she tried to unapply it

    Yusuf

    ------------------------------
    Yusuf Newland
    MGAC
    Washintgon DC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Unapply Payment and Cancel Invoice

    TOP CONTRIBUTOR
    Posted Jan 14, 2020 09:11 AM
    @Yusuf Newland I think it is possible that
    1) Reverse vs. Unapply was attempted for the first step. 
    2) The payment to be unapplied has been reconciled to the bank. 

    @Linda DiGiacomo if you could let everyone know if the steps provided allowed for a successful undo and if not, specifically what error you are receiving and where. Screenshots are very helpful.

    Thanks,



    ------------------------------
    Cynthia Priebe
    New View Strategies
    "The NAV & BC training and process experts"
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Unapply Payment and Cancel Invoice

    GOLD CONTRIBUTOR
    Posted Jan 13, 2020 09:09 AM
    Hello Linda,
    you state "Because they are marked as paid in BC, we cannot unapply."    What is stopping you from unapplying the payment from the invoice.  If you are using cash accounting method, the invoices can be dated in 2019, and if the application is dated in 2020 then the reports will reflect the revenue or expense in 2020 (you didnt say if you are working with purchase or sales invoices).     In NAV, the invoice date and the application date can be different to reflect proper accounting method reporting (cash vs accruel).  The correct procedure would be to unapply the payment and then complete a new application and be sure to change the date of the application before you post the application. 

    ------------------------------
    Jamie Constantine
    Columbus Global
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role