Skip to main content

How can I allocate or correct allocations for transactions in the sales or purchase ledger?

A
Written by Andrew McNeice
Updated over 2 months ago
  • We have a number of Unallocated Credits showing on our aged reports. How can we eliminate these?

  • Is it possible to partially allocate a transaction so that there is still some left outstanding?

  • I have allocated a payment to the wrong invoice. How can I correct this?

Transactions that show as outstanding in either the enquiry screen or aged report can be allocated to items that have an inverse value in order to show that they have been accounted for. This is done via the Allocation area within either the sales or purchase ledgers as follows:

  1. In the relevant ledger, select the Allocation button from the ribbon.

  2. Choose Cash Allocation from the drop down list.

  3. Enter the Customer or Supplier code and Run Search to return the unallocated items for that company.

  4. Other criteria based on Date, transaction type etc can be added to narrow the search if required.

  5. The transactions will show two columns - Unalloc Inv/Drs and Unalloc Rec/Crs depending on their type.

  6. Tick the Allocate box by the required transactions on either side to match them to one another.

  7. It is not necessary to allocate the entire value of the transaction. The value to be allocated can be amended in either the Alloc Inv/Drs or Alloc Rec/Crs columns.

  8. Please note that the allocation values must balance to zero. Any discrepancy can seen at the bottom of the screen under Difference.

  9. When ready, select Save & Close (or Save & New if more allocations are to be done)

  10. Amend the Allocation Date and Period if necessary based on your requirement.

  11. Click OK to confirm the allocation.


Allocations from the above process can be reversed or changed as below:

  1. Select Allocation from the Ribbon and choose Correction.

  2. locate the Customer/Supplier as above.

  3. Identify the allocation to be amended

    1. you can establish the reference, date and period etc by using the View Allocation History feature in the Transaction Enquiry Screen.

  4. Tick Correct and enter the value to be unallocated in the Value to Correct box

  5. Click Save & Close or Save & New to process the change.

  6. Enter the Allocation Date and Period for the correction - usually the same as the unwanted original.

  7. Click OK to confirm the change.


​
​

Did this answer your question?