CardexVarianceProcessing

F4111 Calculate Variances

Major Business Rule

Object Name: B4100330

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function calculates the variance created when the transaction quantity causes the Quantity on
Hand to go to zero at a cost different than that indicated by the costing method. The dollars left need
to be written off as a variance.

Setup Notes and Prerequisites
The Primary Quantity on Hand, Unit Cost, Extended Cost and Transaction Quantity are required
parameters.

Technical Specification

This function calculates a variance if the transaction quantity causes the quantity on hand to go to
zero at a cost other than the cost defined as the inventory costing method.

If Primary Quantity on Hand is not equal to zero, then Quantity = Primary Quantity on Hand +
Transaction Quantity

If Quantity = zero
Amount = Primary Quantity on Hand * Unit Cost
Variance = Extended Cost + Amount

^

Data Structure

D4100330 - Cardex Variance Processing

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnPrimaryQuantityOnHand	PQOH	MATH_NUMERIC	NONE	NONE
The number of units that are physically in stock. The system displays the quantity on-hand in the primary unit of measure.
mnTransactionQuantity	TRQT	MATH_NUMERIC	NONE	NONE
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and backorders. You enter this value in the Branch/Plant Constants program (P41001).
mnExtendedCost	PAID	MATH_NUMERIC	NONE	NONE
The extended cost or price value of an inventory transaction for an inventory item.
mnVarianceAmount	AEXP	MATH_NUMERIC	NONE	NONE
The number of units multiplied by the unit price.
mnUnitCost	UNCS	MATH_NUMERIC	NONE	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
cCurrencyFlag	CRYR	char	NONE	NONE
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use: Codes are: N Do not use multi-currency accounting. Use if you enter transactions in only one currency for all companies. The multi-currency fields will not appear on forms. The system supplies a value of N if you do not enter a value. Y Activate multi-currency accounting and use multipliers to convert currency. The system multiplies the foreign amount by the exchange rate to calculate the domestic amount. Z Activate multi-currency accounting and use divisors to convert currency. The system divides the foreign amount by the exchange rate to calculate the domestic amount.
mnCurrencyConversion	CDO	MATH_NUMERIC	NONE	NONE
This field represents the monthly volume of condensate for a well that does not fall under the predefined dispositions.

Related Functions

None

Related Tables

None