Product Support
Module: STOCK CONTROL
Menu Option: BULK WINE STOCK/VESSEL RECON

Problem:

Why is my cost per litre in the Vessel different from the average cost on the Stock file?

   
Cause:

CAUSE 1

A STOCK ADJUSTMENT (changing cost) was processed in the STOCK CONTROL Module.

 

CAUSE 2

The Stock Item volume is different from the Vessel volume for that item. This will cause the effect of a Cellar Worksheet to impact differently on the Stock file.

   
Solution:

SOLUTION 1

Cellar Worksheets will automatically impact on the Stock Control module in regards to costs and volume, but the reverse does not occur. Stock-takes and adjustments do not impact on vessel costs. Follow the procedures below to correct the problem:

 

The System Parameter 'Prod: Use Vessel Cost not Stock Cost' must be set to "NO" if running 'Standard' costing and "YES" if running 'Average' costing.

 

If running 'Average' costing and the cost recorded against the Bulk Wine Stock Item is correct, the following procedure should be followed to correct the cost recorded against the impacted vessels:

 

Go to CELLAR REFERENCE MAINTENANCE, CELLAR OPERATIONS TYPES and remove the GL account set against the 'Cost Allocation' operation. This will break the link with the General Ledger when a Cellar Worksheet with this operation is updated.

 

Do a CELLAR WORKSHEET ENTRY (Type=Cost Allocation) for the relevant Vessels. When the CELLAR WORKSHEET UPDATE is run, the cost will be applied against the Vessel but will not impact the General Ledger. Please ensure you reset the GL account against the Cost Allocation Type after the Cellar Worksheet was updated .

 

The above steps will change the cost on the Stock Item and on the Vessel. This will cause the Stock Item to be incorrect. Follow the procedures below to change the Stock Item cost back to be the same as the Vessel cost. Process a GENERAL LEDGER, GENERAL LEDGER JOURNAL to bring the Balance Sheet stock in line with the STOCK VALUATION report.

 

If the Vessel Wine cost is correct and the Stock Control module is to be corrected, simply follow these steps:

 

Utilise the STOCK ADMINISTRATION, AVERAGE & LAST COST MAINT. option if running 'Average' costing or STOCK MAINTENANCE, STOCK ITEMS option if running 'Standard' costing, and record the vessel cost per litre on the Stock Item.

 

It may be necessary to process a GENERAL LEDGER JOURNAL to ensure the Balance Sheet agrees with the STOCK VALUATION reports.

 

SOLUTION 2

See 'How can I get the Vessel volumes and Stock file to balance?' to solve this problem.

   
See Also

 
    Email


Author:   Jacques Olivier
Published:    
Last Modified:  
Products:   EzyWine, EzyAuction, EzyAccounts
Version:   2003.01.xx | All
Approved By:   Angela Cugola

© 1997-2004 Ezy Systems Pty Ltd - All rights reserved Login
Site Design By: Adrian Lock