Viewing Paid Reserves
View and analyse Paid Reserves across customers, items, and locations.
Paid Reserves can be seen from a number of pages; at summary level Paid Reserve Summary, individual Paid Reserve records, and their movements, Paid Reserve Ledger Entries. This information can be accessed directly by searching for the summary or record pages and available as ribbon links from Customer and Item lists and cards.
Prerequisites
Set up paid reserves.
Paid Reserve Summary
The summary page provides a quick and simple summary showing where your Paid Reserves are. Grouped by Location, Duty Status and Unit of Measure you can see how many of each item a customer has, if they are currently on open documents and their value.
Selecting the Paid Reserve option on the page ribbon displays information held against each unique Paid Reserve record.
Paid Reserves
A Paid Reserve record is created for every sale into reserve by a Customer, these can be seen from the Paid Reserves page.
Page fields:
No.
The unique reference for this paid reserve record.
Posting Date
The Posting Date from the document that created the record.1
Source No.
The Customer number and owner of the goods.
Source Name
The customer's above.
Item No.
The item the record relates to.
Item Description
The item's description.
Quantity
The original quantity sold into paid reserve.
Remaining Quantity
The current remaining quantity against the paid reserve. This is updated when documents are shipped.
Qty. Booked
Any quantity of this paid reserve held on documents waiting to be actioned, i.e. Sales Order, Transfer Order, Sales Return Order, Broking, Bottling Order.
Unit Price
The original price the customer paid for the goods. This is used as a value for VAT where necessary.
Unit Cost
The original cost to the company if the paid reserve was created from company stock. Where a paid reserve has been imported via a Paid Reserve Journal the cost value will be zero.
Provenance/Source
Free text field to enter relevant information. See Additional Information at end.
Condition
Free text field to enter relevant information. See Additional Information at end.
Expected Delivery Instruction
Where the goods are En Primeur, this can be used to determine the customer intention when the stock becomes available. See Additional Information at end. The options are: blank, Into Storage, Delivery To Ship-to.
Exp. Delivery Ship-to
If the field above is set to Ship-to you can select a specific delivery point. See Additional Information at end.
Contact Nominee No.
Select a nominee for the paid reserve record. The lookup displays contacts linked to the customer. See Additional Information at end.
Contact Nominee Name
The name for the nominee above. See Additional Information at end.
Document Type
The originating document, i.e. Sales Invoice.1
Document No.
The originating document number.1 The Show Entries ribbon button uses this field and Posting Date to find references to it across Bevica.
Other fields are available:
Rotation No.
Displays the rotation number linked to the reserves Item Ledger Entry.
Internal Information
Free text field to enter relevant information. See Additional Information at end.
Original Paid Reserve No.
Where the Paid Reserve has been created by splitting another paid reserve record, this shows the original reserve number.
Document Date
The Document Date from the document that created the record.1
External Document No.
The External Document No. from the document that created the record.1
Reason Code
The Reason Code the document that created the record.1
Withdrawal Duty Unit Amt. Duty Paid
Displays the duty applicable on a Duty Paid withdrawal if the goods are held in Duty Free. Values are per unit and in local currency. See below.
Withdrawal VAT Unit Amt. Duty Paid
Displays the duty applicable on a Duty Paid withdrawal if the goods are held in Duty Free. Values are per unit and in local currency. See below.
Withdrawal Total Unit Amt. Duty Paid
Displays duty + VAT applicable on a Duty Paid withdrawal if the goods are held in Duty Free. Values are per unit and in local currency. See below.
Paid Reserve records are created from processing either a Sales Order or a Paid Reserve Journal.
From the Paid Reserves page, options on the ribbon take you to related information:
View all movements against the record - select Process, Ledger Entries
View originating document details - select Entry, Find Entries.
See all details held against the record - select Entry, Card
Change Provenance/Source, Condition or Internal Information - select Edit List
Withdrawal Amounts
The three withdrawal amount fields are calculated when the paid reserve is created. If/when duty rates change they can be updated to the latest values by navigating to Bevica Setup, Related, Paid Reserves, Processing, Update Withdrawal Values on Paid Reserves.
Available Quantity
In many scenarios Bevica needs to identify what quantity is available against a particular paid reserve as opposed to the remaining quantity we are holding. This is necessary to prevent the same stock being allocated more than once.
Available Quantity = Remaining Quantity less Qty. Booked, and is calculated when needed.
If you see a message telling you there is insufficient stock for the operation you are doing, navigate to the paid reserve card and click on the Qty. Booked field. This will display where that paid reserve is currently allocated.
Additional Paid Reserve Information
The following fields can store additional information:
Provenance/Source
Condition
Internal Information
Exp. Delivery Instructions
Exp. Delivery Ship-to
Contact Nominee No / Name
The fields are editable on the Paid Reserve record itself or from the Paid Reserve Journal.
When you create a Paid Reserve journal line using Get Paid Reserves to Split or Transfer Ownership the additional information fields are copied to the lines from the existing reserve record. These can be amended manually before posting if necessary.
The Paid Reserve record can also hold Notes, Attachments and Links. These are available from the Paid Reserve Card and List pages, Documents factbox.
You can control which Document types are copied from an existing Paid Reserve to new one via Bevica Setup, Fine Wine - Paid Reserve section.
Last updated
Was this helpful?