CalculateTransferCost

Minor Business Rule

Object Name: B4200710

Parent DLL: CDIST

Location: Client/Server

Language: C

This function will calculate Transfer Cost for stock transfer between branches. Markup Percentage
will be retrieved from Branch Relationship File (F3403) Original cost will be saved in the Transfer
Cost field (SDTCST) in the Sales Detail File (F4211) in the branch's domestic currency.
^

Data Structure

D4200710 - Calculate Transfer Cost

Parameter Name Data Item Data Type Req/Opt I/O/Both

cInterbranchSales SO01 char NONE NONE

A value of 1 indicates that this sales detail line contains an inter branch item. Interbranch sales orders allow the user to record the
transactions of transferring inventory from one branch/plant to another and the subsequent sale of the transferred inventory all in one sales order.  In
the sales order,the user will enter the ship-from location in the order detail line and the ship-to location is the branch/plant in the sales order
header. During sales update, the system creates journal entries that record the transfers and stores the entries in an interbranch batch, indicated
by batch type ST. The sales update program will also create the normal A/R and G/L transactions in the I batch. To activate interbranch
processing in sales order entry and sales update, the user will have to specify the order type of an interbranch sales order in the processing
options.

cStockingType STKT char NONE NONE

A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
types are hard-coded and you should not change them:    0   Phantom item    B Bulk floor stock    C Configured item    E Emergency/corrective
maintenance    F Feature    K Kit parent item    N Nonstock The first character of Description 2 in the user defined code table indicates if the item
is purchased (P) or manufactured (M).

cInventoryInterface IVI char NONE NONE

A code that identifies the type of interface to the Inventory Management system. Valid values are:    Y The dollar or unit value of any activity
containing this line type will be reflected in inventory. The system also edits the item that you enter to ensure that it is a valid item. Y is the
default.    A The system recognizes the number that you enter as a G/L account number. The system uses this code in purchasing only.    B The
system performs edits when using format 4 in purchase order entry.        The system retrieves price data from the inventory tables, but does not
update the quantity on the purchase order. This code is valid only when you have set the G/L Interface field to Y (yes). Budget checking is
fully functional when you use this interface code.    D The item in this line is an inventory item that will not affect availability or quantities.    N The
item is not an inventory item. To verify whether the item exists in the Item Master file, use Inventory Interface N in conjunction with the flag, Edit
the Item Master for Non-Stock Items.

szFromBranch MMCU char NONE NONE

A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

mnItemNumber ITM MATH_NUMERIC NONE NONE

An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

szCategoryCode1 SRP1 char NONE NONE

One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use.

jdEffectiveDate DRQJ JDEDATE NONE NONE

The date that an item is scheduled to arrive or that an action is scheduled for completion.

cCurrencyControl 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.

szXchgRateMultiplier CCR char NONE NONE

A code that identifies a component cost rate table to use for this entry in the Billing Rate / Mark up Table (F48096). The component table
identifies the components and their calculation rules. These component amounts are applied as overhead to the original cost. You set up
component tables on the Component Table Revisions form.

mnXchgRateDivisor CRRD MATH_NUMERIC NONE NONE

A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

mnUnitCost UNCS MATH_NUMERIC NONE NONE

The amount per unit, derived by dividing the total cost by the unit quantity.

mnTransferCost TCST MATH_NUMERIC NONE NONE

This is the cost of transferring inventory from one branch to another.  The method of calculating this transfer cost is maintained in the Inter
Branch Sales Markup Revisions (P3403).

mnPercentageMarkup PCMU MATH_NUMERIC NONE NONE

The percent markup is the percent the cost is to be marked up when the item is transfered from one branch to another.

cErrorFlag EV01 char NONE NONE

An option that specifies the type of processing for an event.

szToBranch CMCU char NONE NONE

A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows:
Branch/Plant - (MMCU)       Dept A - (MCU)       Dept B - (MCU)       Job 123 - (MCU)

mnTriangulationRate1 TRR1 MATH_NUMERIC OPT NONE

The triangulation currency rate used to convert the From currency code to the Triangulation currency code.

mnTriangulationRate2 TRR2 MATH_NUMERIC OPT NONE

The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code.

cSupressErrormessages SUPPS char OPT NONE

A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.        0 = allow
runtime error message handling.        1 = suppress runtime error message handling.

szFromBranchCurrencyCode BCRC char OPT NONE

A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
domestic side of the transaction.

szUnitOfMeasureAsInput UOM char OPT NONE

A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).

szUnitOfMeasurePrimary UOM1 char OPT NONE

A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
(each) or KG (kilogram).

cPriceLevel PLEV char OPT NONE

A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or
different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes
are:    1   Item level    2   Item/Branch level    3   Item/Branch/Location level

cPotencyPricing PRPO char OPT NONE

A user defined code (41/05) that groups several items that contain the same requirements for the Stock Valuation system. Valuation
methods are set up by item or pool. The items assigned to the pool use the pool's designated valuation methods for extracting and valuing the
inventory. Enter a valid user defined code (41/05) if you want this item to be valued within a pool rather than as an individual item.

mnFromPotency FRMP MATH_NUMERIC OPT NONE

A number that indicates the minimum potency or percentage of active ingredients acceptable for an item. The system displays a warning
message if you try to purchase or issue items that do not meet the minimum acceptable potency. The system does not allow you to sell items
that do not meet the minimum acceptable potency.

mnThruPotency THRP MATH_NUMERIC OPT NONE

A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item. The system displays a
warning message if you try to purchase or issue items that have a potency that exceeds the maximum potency acceptable. The system does
not allow you to sell items that have a potency that exceeds the maximum potency acceptable.

szFromGrade FRGD char OPT NONE

A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item. The system displays a warning message if
you try to purchase or issue items with grades that do not meet the minimum grade acceptable. The system does not allow you to sell items
with grades that do not meet the minimum acceptable level.

szThruGrade THGD char OPT NONE

A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item. The system displays a warning message if
you try to purchase or issue items with grades that exceed the maximum grade acceptable. The system does not allow you to sell items with
grades that exceed the maximum grade acceptable.

idF4102RowPtr GENLNG ID OPT NONE

General purpose ID variable.

szToBranchCurrencyCode CRDC char OPT NONE

A code that identifies the domestic (base) currency of the company on a transaction.

szUnitOfMeasurePricing UOM4 char OPT NONE

A user defined code (00/UM) that indicates the unit of measure in which you usually price the item.

szLot LOTN char OPT NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

szLocation LOCN char OPT NONE

The storage location from which goods will be moved.

Related Functions

B4200720 RetrieveMarkupPercentage

Related Tables

F0015 Currency Exchange Rates

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cInterbranchSales	SO01	char	NONE	NONE
A value of 1 indicates that this sales detail line contains an inter branch item. Interbranch sales orders allow the user to record the transactions of transferring inventory from one branch/plant to another and the subsequent sale of the transferred inventory all in one sales order. In the sales order,the user will enter the ship-from location in the order detail line and the ship-to location is the branch/plant in the sales order header. During sales update, the system creates journal entries that record the transfers and stores the entries in an interbranch batch, indicated by batch type ST. The sales update program will also create the normal A/R and G/L transactions in the I batch. To activate interbranch processing in sales order entry and sales update, the user will have to specify the order type of an interbranch sales order in the processing options.
cStockingType	STKT	char	NONE	NONE
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking types are hard-coded and you should not change them: 0 Phantom item B Bulk floor stock C Configured item E Emergency/corrective maintenance F Feature K Kit parent item N Nonstock The first character of Description 2 in the user defined code table indicates if the item is purchased (P) or manufactured (M).
cInventoryInterface	IVI	char	NONE	NONE
A code that identifies the type of interface to the Inventory Management system. Valid values are: Y The dollar or unit value of any activity containing this line type will be reflected in inventory. The system also edits the item that you enter to ensure that it is a valid item. Y is the default. A The system recognizes the number that you enter as a G/L account number. The system uses this code in purchasing only. B The system performs edits when using format 4 in purchase order entry. The system retrieves price data from the inventory tables, but does not update the quantity on the purchase order. This code is valid only when you have set the G/L Interface field to Y (yes). Budget checking is fully functional when you use this interface code. D The item in this line is an inventory item that will not affect availability or quantities. N The item is not an inventory item. To verify whether the item exists in the Item Master file, use Inventory Interface N in conjunction with the flag, Edit the Item Master for Non-Stock Items.
szFromBranch	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
mnItemNumber	ITM	MATH_NUMERIC	NONE	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szCategoryCode1	SRP1	char	NONE	NONE
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use.
jdEffectiveDate	DRQJ	JDEDATE	NONE	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
cCurrencyControl	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.
szXchgRateMultiplier	CCR	char	NONE	NONE
A code that identifies a component cost rate table to use for this entry in the Billing Rate / Mark up Table (F48096). The component table identifies the components and their calculation rules. These component amounts are applied as overhead to the original cost. You set up component tables on the Component Table Revisions form.
mnXchgRateDivisor	CRRD	MATH_NUMERIC	NONE	NONE
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
mnUnitCost	UNCS	MATH_NUMERIC	NONE	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
mnTransferCost	TCST	MATH_NUMERIC	NONE	NONE
This is the cost of transferring inventory from one branch to another. The method of calculating this transfer cost is maintained in the Inter Branch Sales Markup Revisions (P3403).
mnPercentageMarkup	PCMU	MATH_NUMERIC	NONE	NONE
The percent markup is the percent the cost is to be marked up when the item is transfered from one branch to another.
cErrorFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szToBranch	CMCU	char	NONE	NONE
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows: Branch/Plant - (MMCU) Dept A - (MCU) Dept B - (MCU) Job 123 - (MCU)
mnTriangulationRate1	TRR1	MATH_NUMERIC	OPT	NONE
The triangulation currency rate used to convert the From currency code to the Triangulation currency code.
mnTriangulationRate2	TRR2	MATH_NUMERIC	OPT	NONE
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code.
cSupressErrormessages	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szFromBranchCurrencyCode	BCRC	char	OPT	NONE
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the domestic side of the transaction.
szUnitOfMeasureAsInput	UOM	char	OPT	NONE
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).
szUnitOfMeasurePrimary	UOM1	char	OPT	NONE
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA (each) or KG (kilogram).
cPriceLevel	PLEV	char	OPT	NONE
A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level
cPotencyPricing	PRPO	char	OPT	NONE
A user defined code (41/05) that groups several items that contain the same requirements for the Stock Valuation system. Valuation methods are set up by item or pool. The items assigned to the pool use the pool's designated valuation methods for extracting and valuing the inventory. Enter a valid user defined code (41/05) if you want this item to be valued within a pool rather than as an individual item.
mnFromPotency	FRMP	MATH_NUMERIC	OPT	NONE
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item. The system displays a warning message if you try to purchase or issue items that do not meet the minimum acceptable potency. The system does not allow you to sell items that do not meet the minimum acceptable potency.
mnThruPotency	THRP	MATH_NUMERIC	OPT	NONE
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item. The system displays a warning message if you try to purchase or issue items that have a potency that exceeds the maximum potency acceptable. The system does not allow you to sell items that have a potency that exceeds the maximum potency acceptable.
szFromGrade	FRGD	char	OPT	NONE
A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item. The system displays a warning message if you try to purchase or issue items with grades that do not meet the minimum grade acceptable. The system does not allow you to sell items with grades that do not meet the minimum acceptable level.
szThruGrade	THGD	char	OPT	NONE
A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item. The system displays a warning message if you try to purchase or issue items with grades that exceed the maximum grade acceptable. The system does not allow you to sell items with grades that exceed the maximum grade acceptable.
idF4102RowPtr	GENLNG	ID	OPT	NONE
General purpose ID variable.
szToBranchCurrencyCode	CRDC	char	OPT	NONE
A code that identifies the domestic (base) currency of the company on a transaction.
szUnitOfMeasurePricing	UOM4	char	OPT	NONE
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item.
szLot	LOTN	char	OPT	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
szLocation	LOCN	char	OPT	NONE
The storage location from which goods will be moved.