Splitting Paid Reserves
Split Paid Reserves across cases/bottles or units of measure while preserving ownership.
A Paid Reserve (PR) record should be split when you need to differentiate a number of units for some reason from the original PR. New Paid Reserves can be created into a smaller quantity of the same unit of measure or split into additional PR of smaller units of measure.
Possible reasons for splitting a Paid Reserve:
Your customer wants to withdraw a bottle from a case Paid Reserve.
A number of units on a PR have been assigned to a separate Nominee.
You need to split a PR into two Rotation No.s.
After receipting, you need to set Provenance or Condition specifically on some cases or bottles.
Prerequisites
Knowledge of how to manage paid reserves.
How to split a Paid Reserve record
Paid Reserves are split using the Paid Reserve Jnl, selecting an existing record and setting new Quantity, Unit of Measure and Paid Reserve Split fields.
In the
area, search for Paid Reserve Journal.
Open the page and select the Journal Batch you want to use.
Once the batch number is selected populate the Customer No. filter field with the customer who's Paid Reserve(s) you want to split.
Select the Line ribbon option Process then Get Paid Reserves to Split.
On the Paid Reserve Selection page that appears, select Edit List, find or search for the Paid Reserve record you want to split and enter the Quantity from this record you want to split.
Click OK to copy the Line(s) back onto the Paid Reserve Journal.
From the Paid Reserve Journal you now decide what type of split you want. The Existing Quantity and Existing Unit of Measure fields display what will be removed from the existing PR, the Paid Reserve Split, Quantity and Unit of Measure fields determine how the new PR will be created. You can personalise your page if you are unable to see these columns.
Paid Reserve Split options:
None: One PR record created for the new quantity
Unit of Measure: One PR record created for each Unit
Base Unit of Measure: One PR record created for each of the item's base unit
Convert to Base: One PR record created in Base quantity for the original quantity selected
Scenario: 5 x 6x70cl has been selected from a Paid Reserve containing 100 cases 6x70cl...
5
6x70cl
None
1 new PR record, Qty = 5, UOM = 6x70cl
5
6x70cl
Unit of Measure
5 new separate PR records, Qty = 1, UOM = 6x70cl
5
6x70cl
Base UoM
30 new separate PR records, Qty = 1, UOM = 70cl
5
6x70cl
Convert to Base
1 new PR record, Qty = 30, UOM = 70cl
After posting, in all cases the original PR will display a Remaining Quantity of 95 cases 6x70cl.
Scenario: 1 x 6x70cl has been selected from a Paid Reserve containing 100 cases 6x70cl...
1
6x70cl
None
1 new PR record, Qty = 1, UOM = 6x70cl
1
6x70cl
Unit of Measure
1 new PR record, Qty = 1, UOM = 6x70cl
1
6x70cl
Base UoM
6 new separate PR records, Qty = 1, UOM = 70cl
1
6x70cl
Convert to Base
1 new PR record, Qty = 6, UOM = 70cl
After posting, in all cases the original PR will display a Remaining Quantity of 99 cases 6x70cl.
New Paid Reserve Records
The newly created records have a reference to their original Paid Reserve in the Orig. Paid Reserve No. field and the following fields are copied from it:
Unit Price / Total Price (recalculated for the new Unit of Measure & Quantity)
Unit Cost / Total Cost (recalculated for the new Unit of Measure & Quantity)
Provenance
Condition
Nominee
Exp. Delivery Instruction
Exp. Delivery Ship-to
Last updated
Was this helpful?