Forum Discussion

Luckyrooh1's avatar
Luckyrooh1
Contributing User
2 months ago

Guidance Needed on Reversing Sales Order and Payment

Hello Guys,

Back in December 2021, our client received a sales order and made a payment against it. However, despite receiving the payment, the order was not fulfilled or shipped. As a result, the payment was allocated to the order as a deposit.

To rectify this situation, I am considering advising our client to reverse the payment allocation and subsequently reverse the sales order. I propose dating these reversals for the June 2024 Quarter to ensure they are captured accurately in our FY2024 balances.

Before proceeding, I have a couple of questions:

  1. Upon the reversal of payment allocation, will this action result in the bank details becoming unreconciled? In other words, will the amount float in the bank feed until it is re-allocated or reconciled with a different transaction?
  2. When we reverse the sales order and payment, will this process generate a credit note similar to how it works with sales invoices?

I appreciate your guidance on these matters, as it is crucial that we ensure the proper allocation of this payment to the succeeding invoices of the customer, so we are considering to code the allocated payment as "Credit Note" or if you have other advise, it will be fully appreciated. Thanks in advance

7 Replies

  • AdminKirsty's avatar
    AdminKirsty
    Experienced User

    I was a little confused by the wording of your query, as to whether your client is the customer/purchaser or the seller...  

    I would have expected a credit note would have been the appropriate reverse mechanism for the sales order, and then either applying the deposit to a different sales order, or refunding/receiving the deposit.

     

    This page has adjustment information for Customer entries, and a link to Purchaser entries, which should give you some assistance, depending on what version they are using.

    https://www.myob.com/nz/support/myob-business/sales/customer-returns-credits-and-refunds

     

    Sorry if I have only confused you...  Good luck!

    • Luckyrooh1's avatar
      Luckyrooh1
      Contributing User

      Hi Kirsty, 

      Apologies for the confusion. 

      My Client is the seller. 

      Following up on our previous discussions, just want to confirm if the following steps are correct if we reversed the Sales Order from 2021 with allocated payment.

      1. Reverse the Allocated Payment

      First, should we reverse the payment that is currently allocated to the Sales Order. This involves:

      • Reversing the Payment: Use the reverse function in MYOB to unallocate the payment from the Sales Order. Once we reversed the allocated payment, Does this means, The reversed payment will appear in the bank feed?

      2. Reverse the Sales Order

      Next, we will reverse the Sales Order:

      • Reversing the Sales Order: Locate the Sales Order in the system and reverse it.
      • Were not sure if MYOB might automatically create a Credit Note once we reverse the Sales Order, or we may need to create one manually.

      3. Create a Credit Note (if needed)

      If the system does not automatically create a Credit Note upon reversing the Sales Order:

      • Creating a Credit Note: Manually create a Credit Note for the amount of the reversed Sales Order. This will offset the original amount in accounts receivable.

       

      Thanks!

      • AdminKirsty's avatar
        AdminKirsty
        Experienced User

        Hi there,

        That method would not be one I would try in the first instance...

         

        I would be more inclined to try a process similar to the one outlined in the link I posted above, i.e. create a sale return, noting it as a cancelled order, using a minus amount to match the original order*, and then allocating that resulting account credit to the new order.

        *  i,e,  if the original order was for 5 widgets at $100, your sales return would be for -5 widgets @ $100, then "process the sales return" to apply the credit

         

        Is there a reason you prefer to reverse the existing allocations instead?  Would this be to achieve a particular outcome (that I may be missing, sorry) or is this a method you have used previously elsewhere?

         

        Good luck!

  • AdminKirsty's avatar
    AdminKirsty
    Experienced User

    This issue has a lot of considerations!  While the theory may well apply, you need to make sure dates are correctly aligned, so as not to throw prior completed financial statements. 

     

    At what date was the sales order cancelled?  At what date would you be reversing the entries, using your proposal?

     

    Deleting the sales order would sound the riskier proposal, if you are trying to maintain your finalised/published 2021 data.  Not seeing your current status really limits what assistance can be given like this, sorry.

     

    It's such a pity a moderator hasn't jumped in here with Best Practice direction for you...  I hate to ask, but have you tried calling the support line, to see if they can help (although my recent experience with a bug report would not bring great optimism to that suggestion)?

    • Luckyrooh1's avatar
      Luckyrooh1
      Contributing User

      Hi Kirsty,

       

      I have called the support, and there was no actual remedy for this so we agreed to try my suggestion in the first place. They are also afraid that it will affect the inventory balance. 

       

      Thank you for your replies :)

      • AdminKirsty's avatar
        AdminKirsty
        Experienced User

        Good luck!  I really liked the ability to create a copy of data to test working theories in other software, but that isn't something MYOB permit, sadly.

         

        I hope it works out.  If it does affect your year end inventory balance, what about doing a journal to correct it (reversing it in the appropriate period, if necessary)?  At least that should be easier to delete, if it doesn't give the expected outcome!

         

        Sorry I couldn't be of more assistance.