TRAX MANUALS > Settings > Settings Module > Settings, Update Menu > P/N (Part Number) > P/N Master, Costing Tab > P/N Average Cost Movement

The Average Cost field in the Costing tab of the P/N Master window refers to the average cost of a part in local currency. This figure reacts to several Inventory Transactions. Through the transaction types listed below, the Average Cost field is recalculated.

The transaction types that adjust the Average Cost are the following:

_____________________________________________________________________________________

EX/RECEIVING

When an Exchange Order where the P/N being sent is not both way interchangeable with the P/N being received, the Average Cost for the part will be recalculated.

INITIAL RECEIVING

The first time a P/N is received in the system if the P/N is INITIAL/LOAD with the Receiving Inspection performed.

INTMAIN

This takes place when an Interchangeable P/N is swapped with the Main P/N and the Fixed Assets are also swapped between the two. For this functionality to take place, G/L Interface Switch FAMAIN must be set to Yes. For more information refer to the G/L Interface Switches Manual and the Interchange Swap Main Button via the Settings Training Manual.

Note: This transaction now references the average cost increase or decrease resulting from the conversion of a both-way interchangeable to a new main part number.

INVOICE

A P/N that has different order and invoice prices. (For more information refer to the topic PO/INVOICE via the G/L Interface manual.

FA-CRT

Indicates that a Fixed Asset record was created for the part without being linked to an order or an initial load. This transaction will appear in the Average Cost Movement Print with a value of 0.00, but note that this value does not affect the part's average cost.

P/N/S/N-CHG

A component that's P/N or Serial Number has been changed via Inventory/Update/Inventory Transactions/Inventory Detail P/N S/N Change button.

P/N MASTER

If there is manual change to the Average Cost via Settings/Update/P/N, Costing tab.

PO/RECEIVING

A Purchase Order that has been received.

Note: When an Average Cost P/N is made interchangeable to another part via the Change P/N to Interchangeable button of the P/N Master window, the average cost of the main part is recalculated. When this takes place a 'PNMSTADJ' order transaction is created against the PO/RECEIVING transaction. For more information refer to the Change P/N to Interchangeable Button via the Setting Training Manual.

R/I

A P/N or the quantity received has been changed via Receiving/Update/Receiving Inspection.

RETURN/TO/VENDOR

A P/N that is returned to the vendor.

RMVINS

If there is a remove/install transaction via Technical Records/Update/A/C P/N Transactions where a Interchangeable P/N has been installed with the G/L Interface Switch FARMVINS configured to 'Yes' then an Average Cost recalculation will be recorded. Additionally, if the parts being installed and removed do not have Fixed Asset records, the recalculation of the cost does not occur.

Note: These P/Ns cannot be both way interchangeable for average cost recalculation to occur.

RTS

A P/N that has been returned to stock with the 'Removed from A/C or Known Inventory' Transaction radio button selected.

SR/RECEIVING

A Sales Order Return that has been received.

SUP/UPDATE

A P/N that is changed via Inventory/Update/Inventory Supervisor.

WO/PROD

When a 'Modified to P/N' P/N Engineering Control with the 'Modify to in Production/ Shop' checkbox selected is completed against a Production Work Order, the new P/N Average Cost will recalculate upon the Post-Completion or Closing of that Work Order.

_____________________________________________________________________________________

Note: When G/L Interface Switch COMPANYMULTI is set to 'Yes', the Average Cost for a company's part is impacted by all of the above transactions via the P/N Master, Costing tab. For more information refer to Switch COMPANYMULTI via the G/L Interface Switches Manual.