Open Forum

Expand all | Collapse all

Unapply Payment and Cancel Invoice

  • 1.  Unapply Payment and Cancel Invoice

    Posted 16 days ago
    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
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Unapply Payment and Cancel Invoice

    TOP CONTRIBUTOR
    Posted 15 days ago
    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"
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Unapply Payment and Cancel Invoice

    TOP CONTRIBUTOR
    Posted 15 days ago
    Edited by Cynthia Priebe 13 days ago
    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"
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Unapply Payment and Cancel Invoice

    SILVER CONTRIBUTOR
    Posted 12 days ago
    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
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Unapply Payment and Cancel Invoice

    TOP CONTRIBUTOR
    Posted 12 days ago
    @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"
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Unapply Payment and Cancel Invoice

    SILVER CONTRIBUTOR
    Posted 13 days ago
    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
    ------------------------------

    Conference-BCNAVUG_200x200


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