Unbatch sales orders and credit notes

Unbatch sales orders and credit notes

Overview

Find out how to unbatch sales orders and credit notes to add, remove, or update transactions in the batch.

You can batch sales orders and credit notes from the same branch with payments of the same method. By creating batches, you minimize the number of transactions to reconcile in your accounting software.

To add, remove, or update the sales orders or credit notes in a batch, you must reset the payment and accounting properties of each transaction and void the batch. Then you can edit the transactions and create a new batch.

1. Create batch report

First, create a report of the transactions in the batch:

  1. Log in to Cin7 Omni.

  2. From the navigation, select Insights. Insights will open in a new browser tab.

  3. From the Insights navigation, select Retail Reports Dashboard.

  4. Select Payments By Branch (Payment Date) from the section Registers and Payments.

  5. Add Batch Ref then Order Ref as rows to the report, as in the image below.

 

Find your batch in the Batch Ref column – you may need to adjust the report’s date range.

Now you must reset the payment and accounting properties of each sales order and credit note in the batch; either keep this report open or make a note the transactions (that is, the Order Refs).

2. Reset sales orders and credit notes

Leave Insights and return to your Cin7 Omni dashboard, which should be open in another browser tab.

Open Sales Orders from the Sales menu in the navigation, and for each sales order in the batch, reset the payment and accounting properties:

  1. Find and open the sales order.

  2. Under the Payments section, delete the Reconcile Date and Batch No for the payment.

  3. Select Save to Admin and

    • delete the Invoice Date

    • delete the Accounting Import Date

    • delete the Payment Batch Ref

    • set Accounting Invoice Status to Not Imported Yet or Reset for Import.

  4. Select Save & Back to List.

Now open Credit Notes from the Sales menu in the navigation, and for each credit note in the batch, reset the payment and accounting properties:

  1. Find and open the credit note.

  2. Under the Payments section, delete the Reconcile Date and Batch No for the payment.

  3. Select Save to Admin and

    • delete the Invoice date

    • delete the Accounting Import Date

    • delete the Payment Batch Ref

    • set Accounting Status to Not Imported Yet or Reset for Import.

  4. Select Save & Back to List.

Check you’ve reset every sales order and credit note by refreshing the Payments By Branch (Payment Date) report (if the report’s still open, select Refresh / Recalculate data). You shouldn’t see your batch in the Batch Ref column; if you do, reset the properties of the remaining sales orders.

3. Void the batch

Once you’ve reset the transactions, void the batch in Cin7 Omni:

  1. From the Accounting menu in the navigation, open Batch Invoices.

  2. Open the batch.

  3. Select Save to Admin.

  4. Select Void.

And finally, void the batch in your accounting software:

4. Re-batch sales order and credit notes

Now the sales orders and credit notes have been unbatched.

You can edit the transactions and create a new batch that includes some or all of the original sales orders and credit notes, and additional ones, too.

To create a new batch, close the register.

Was this article helpful?

Have more questions? Submit a request