Skip to main content

Next Generation - Sales ledger reverse allocation period example

There are several rules regarding the periods that you can allocate to and they depend on system options and also on your permissions set in the Security Profiles.
​
The following example takes you through a reverse allocation with the Allocate to the latest year and period of the transactions selected turned on and off so you can see the difference in the system behaviour.
​
Turning the option to Allocate to the latest year and period of the transactions selected on or off is done in the System Options Module which is security profile permission driven.
​
If you have access to the System Module, you can either turn the option on or off following the steps below:

  1. Click System then Options then click System Options.

  2. On the Options tab find the Transactions section.

  3. Select the checkbox for the Method of Allocation option to turn the Allocate to the latest year and period of the transactions selected option ON and deselect the checkbox if you wish to turn the option OFF.

Allocate to the latest year and period of the transactions selected options is off:

  1. The system start year date = 01/01/2024.

  2. Current date = 01/03/2024.

  3. Sales Ledger Open or Working period = C1 as in current period one.

  4. A sales ledger invoice was raised in C1.

  5. A partial payment was raised in C2 and another in C3.

  6. The C3 payment was allocated in C3 against the invoice that was raised in C1.

  7. The C2 payment was allocated in C2 against the same invoice raised in C1.

For more information on the Allocation screen and how to process selected transactions, please refer to the Allocation screen and the update allocation processing articles.
​

Scenario

Rules applied

You do not have future period posting permissions.

  • You cannot reverse allocate either of the two transactions and can't process the reverse allocation.

You can post four periods ahead and you have selected both transaction for reversing.

  • Suggested default is C3.

  • You can't select a period earlier than C3 but you can adjust forward to C5.

You can post four periods ahead and you have selected to reverse the C2 allocation.

  • Suggested default is C2.

  • You can't select a period earlier than this, but you can adjust forward to C5.

You can post four periods ahead and you have selected to reverse the C3 allocation.

  • Suggested default is C3.

  • You can't select a period earlier than this, but you can adjust forward to C5.

Allocate to the latest year and period of the transactions selected options is on:

  1. The system start year date = 01/01/2024.

  2. Current date = 01/03/2024.

  3. Sales Ledger Open or Working period = C1 as in current period one.

  4. A sales ledger invoice was raised in C1.

  5. A partial payment was raised in C2 and another in C3.

  6. The C3 payment was allocated in C3 against the invoice that was raised in C1.

  7. The C2 payment was allocated in C2 against the same invoice raised in C1.

Scenario

Rules applied

You do not have future period posting permissions.

  • You can't reverse allocate either of the two transactions and cannot process the reverse allocation.

You can post four periods ahead and you have selected both transaction for reversing.

  • Suggested default is C3.

  • You can't select a period earlier than this, but you can adjust forward to C5.

You can post to four periods ahead and you have selected to reverse the C2 allocation.

  • Suggested default is C3.

  • You can't select a period earlier than this, but you can adjust forward up to C5.

You can post to four periods ahead and you have selected to reverse the C3 allocation.

  • Suggested default is C3.

  • You can't select a period earlier than this, but you can adjust forward up to C5.

Did this answer your question?