Wonder what the prefixes mean in Cost Adjustment batches? Well, wonder no more! The following is a list of the prefixes you would see
in the Reference field of a transaction in a cost adjustment (GLTRX) batch and
a description of why that prefix would be used. The Reference field can be
found in the Transaction Entry, Detail Inquiry, and Journal Entry Inquiry
windows.
a. BOM – This comes from a Bill of Materials transaction. For example if
a BOM Assembly transaction consumed an item from inventory and the cost was
later changed due to a POP purchase price variance (PPV) or an average cost
ripple, you would see this reference.
b. INV – This comes from an Invoice transaction created from the
Invoicing module. For example if an Invoice transaction (in Invoicing) consumed
an item from inventory and the cost was later changed due to a Purchase Order
Processing PPV or an average cost ripple you would see this reference.
c. IVT – This comes from an Inventory Transfer Transaction. For example
if an item was consumed via the Item Transfer and the costs were later changed
due to a PPV or an average cost ripple you would see this reference.
d. IVA – This comes from an Inventory Adjustment transaction. For
example if a decrease Inventory Adjustment transaction consumed an item from
inventory and the cost was later changed due to a PPV on an invoice match or an
average cost ripple you would see this reference.
e. IVV – This comes from an Inventory Variance transaction. For example
if a decrease Inventory Variance transaction consumed an item from inventory
and the cost was later changed due to a PPV on an invoice match or an average
cost ripple you would see this reference.
f. SALES – This comes from a Sales Order Processing Invoice transaction.
For example if a Sales Invoice consumed an item from inventory and the cost was
later changed due to a PPV on an invoice match or an average cost ripple you
would see this reference.
g. PRTN – This comes from a Purchase Order Processing return transaction
where doing the return changes the cost of the item.
h. MCTE – This comes from a Manufacturing Component Transaction. For
example if an item was issued (consumed) in the Component Transaction Entry
window and the cost was later changed due to a PPV or an average cost ripple
you would see this reference.
i. MRCT – This comes from a Manufacturing Receipt Transaction. For
example if an item was backflushed and consumed in the Manufacturing Receipt
Entry window and the cost was later changed due to a PPV or an average cost
ripple you would see this reference.
j. MCLS –This comes from Closing a Manufacturing order via the Close
process or during a Quick MO (quick MOs are automatically closed). For example
if a user closes an MO and there are items that are set to backflush (consumed)
and the cost was later changed due to a PPV or an average cost ripple you would
see this reference.
k. STCK – This comes from Item Stock Count Variance transaction. For
example if a Stock count adjustment consumed an item from inventory and the
cost was later changed due to a PPV or an average cost ripple, you would see this
reference.
l. FSSC – This comes from selling a Part on a Service Call. For example,
an Item was Received into Inventory at one cost and the cost was later changed
due to an Invoice Match you would see this reference.
m. FSRMA – This comes from an RMA. For example, you have a quantity of
an item at one cost. You create a Credit RMA and receive the item in. You then
Scrap the item ( which removes the one already in your inventory ) and later
the cost of that item changed due to an Invoice Match you would see this
reference.
n. FSRTV – This comes from an RTV. For example, you create a Credit RTV.
You Ship an item at one cost and the cost was later changed due to an Invoice
Match you would see this reference.
o. FSWO – This comes from using a Part on a Depot Work Order. For
example, you create a WO and Use an item from the Parts Information window at
one cost and the cost was later changed due to an Invoice Match you would see
this reference.
p. PA – This comes from a Project Accounting transaction. For example if
a PA Inventory Transfer consumed an item from inventory and the cost was later
changed due to a PPV on an invoice match or an average cost ripple, you would
see this reference.
q. POP –- This comes from a Purchase Order Processing shipment receipt.
For example if an item was consumed through an override in any module and later
the shipment was brought in at a different cost than it was when it was
consumed (overrode), you would see this reference
r. RECON – You would see this reference if the outflow being revalued
was created by the Inventory Reconcile Utility. One reason IV Reconcile would
need to create an outflow record is if there are not enough quantities in the
IV10201 to support the quantity sold in the IV10200.
s. CONV – You would see this reference if the outflow being revalued was
created by the upgrade. The upgrade from an older version of Microsoft Dynamics
GP to 9, 10 or GP2010 may need to create an outflow if a receipt record was
partially sold at the time of the conversion.
t. PRCT- You would see this reference if the item was overridden on an
In-Transit Transfer transaction and then later brought in at a different cost.
