Publication Date: 8/17/2026 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

GLFIFO - Use FIFO Instead Of LIFO

Use FIFO Instead Of LIFO.

Affected windows: w_inventory_transaction_picklist_issue, w_inventory_transaction_return_non_eu, w_inventory_transaction_return_to_vendor, w_inventory_transaction_scrap, w_pn_initial_eu, w_po_order_header_eu, w_po_receiving_eu, w_po_receiving_eu_auto, w_sv_order_header_eu, w_pn_master_category_change

GLFIFO 1

 

When Set to FIFO:

When set to FIFO (First In First Out), the system will delete the oldest fixed asset record for that part.

System Tran Config

Location 'MIA' has four P/N ''GL5KG8'.

Inventory Transaction

P/N 'GL5KG8' "S/N has a Fixed Asset Number '19006'.

Fixed Asset Registry

P/N 'GL5KG8' S/N '04' is scrapped.

The Scrap Form is displayed below.

Scrap form

The Fixed Asset for P/N 'GL5KG8' S/N '04' is still in the system and was not deleted.

Fixed asset Registry Scrap

The oldest Fixed Asset record for P/N 'GL5KG8' is S/N '01'.

The system deleted the latest fixed asset record due to the FIFO configuration switch setting.

Not found

 

When Set to LIFO:

When set to LIFO (Last In First Out), the system will delete the latest fixed asset record for that part.

LIFO System Config

In location 'ATL', P/N 'GL511-3105-1' has three parts available.

LIFO Inventory Transaction

P/N 'GL-511-3105-1' S/N '01' has the oldest fixed asset record for the part.

Fixed Asset LIFO

P/N 'GL511-3105-1' S/N '01' is scrapped.

The following Scrap Form is displayed.

Scrap form 2

The latest Fixed Asset record for P/N 'GL511-3105-1' is S/N '04'.

The system deleted the latest fixed asset record due to the LIFO configuration switch setting.

Not foud Lifo

In the Inventory Transaction window, P/N S/N '01' is successfully scrapped from inventory.

Inventory LIFO

 

When Set to Actual:

When set to Actual, the system will delete the fixed asset of the actual part that is scrapped.

Note: Please contact Trax to assess the existing data when going from FIFO/LIFO to Actuals. A script may be required to update existing data.

Note: Switch FAMAINREPORT must be set to Yes and Switch FAMAIN must be set to No for this switch setting to function correctly.

Note: When this switch is set to 'Actual,' if the Batch of the P/N S/N is not matched to a Fixed Asset record, when the P/N S/N is scrapped there will be no financial movement against the Fixed Asset table.

In the Inventory Transaction window, Location 'MIA' has three P/N 'G1L123-77'.

Actual Inventory Transaction

The fixed asset record for P/N 'G1L123-77' S/N '02' is displayed.

Fixed Asset Registry Actual

`The same P/N 'G1L123-77' S/N '02' is scrapped.

The Scrap Form is displayed.

Scrap form actual

The system deleted the fixed asset record for the indicated scrapped P/N 'G1L123-77' S/N '02'.

Not foud Lifo

In the Inventory Transaction window, P/N 'G1L123-77' S/N '02' is successfully scrapped from inventory.

Inventory Transaction actual

 

logo_11_small switch edited Swap Fixed Asset From Installed to Removed Components:

When an NLA is removed from an assembly and a new NLA is installed onto the same assembly, the system will swap the Fixed Asset from the new NLA and apply it to the component that was removed and returned to inventory.

Note: This functionality also works for Third Party Work Order.

Note: Removed parts will be placed on the pending table until the removed item is replaced by a interchangeable or One Way Forward part.

Switch GLFIFO must be set to 'Actual' in order for the Fixed Asset to be swapped from the installed component to the removed component.

The following assembly will be used for this example.

The Fixed Asset for this NHA 19043.

FHA replacement fixed asset registry

The following NLA was purchased to be installed on the NHA. The fixed asset reference is 19040.

FHA replacement fixed asset registry 17739

NLA (S/N TBD-6541) will be removed from the assembly.

PN  installation and removal

S/N 'TBD-6541' was removed from the assembly.

pn nla capture

S/N 'TBD-6541' is Returned To Stock.

Return to stock

The newly purchased NLA is issued to the Work Order.

Manual issue

In order to swap the Fixed Asset, the new NLA (S/N 1212) and the NLA that was removed (S/N TBD-6541) are both highlighted before S/N 1212 is installed on the assembly.

Install and removal swap

The new NLA is installed.

PN NLA install final

The Fixed Asset is correctly swapped from the newly installed NLA to the NLA that was removed.

Fixed Asset Registry NLA final

See Also

G/L Interface Switches

CLOSEBAL - Inventory Balance Closing

COMPANYMULTI - Multi Company Setup

COMPANYMULTIEX - Validates Company of P/N used for Exchange Issue

COMPANYMULTIFR - Multi Company Form Revision

COMPANYMULTIPL - Multi Company For Picklist

COMPANYMULTIREQ - Multi Company Override for Requisition

COMPANYMULTIRO - Multi Company Override J/E for R/O

COMPANYMULTISOPL - Multi Company for S/O Picklist

CURRENC2 - Secondary Currency

CURRENCY - Company Default Currency

F/A - Fixed Asset Information

FACREDITNEW - New Fixed Asset creates J/E and triggers Average Cost Recalculation

FAINVCOSTBALADJ - Automatically Run F/A Depreciation and Inventory Costing Balance Adjustment

FAMAIN - Use Main P/N for Fixed Asset

FAMAINREPORT - Reflect Actual Serial Number In Fixed Asset Tables

FAMANRMV - Manual Fixed Asset Removal

FARMVINS - Fixed Asset Swap at Removal and Installation of Part

FAVALUEZERO - Load Fixed Asset Below This Amount Zero

FAZERO - Do Not Allow Scrap / Sale / E/X Issue / RTV / P/N Change without Fixed Asset

GLACCC - W/O G/L Cost Center Uses A/C Tail Number

GLBUDADD - Add Remove Transaction Amounts From Budget

GLCRDATE - Current Date As G/L Date

GLCSTCNTAC - Default G/L Cost Center From A/C Master Cost Center

GLELODIE - Order Invoice Transfer Configuration

GLJEZERO - Write Zero Value for an Order's Journal Entry

INVBALPERIOD - Inventory Balance and Costing by Period

INVCOSTINGADJ - Inventory Costing and Balance Adjustment on Oracle Database

INVCOSTINGBAL - Inventory Costing and Balance Adjustment on Oracle Database

INVTRANS - Batch Number and Path

J/E - J/E Closing Date

JECRDRSQ - Credit Debit Next Sequence Number

JECRT - Journal Entry Create

JEDEL - Journal Entries Delete

JETPWSAL - Accounts Receivable account NOT charged at Third Party W/O Closing

MISSING/FOUND/LOST - Create Value/Adjustment for the Missing Part During Inventory Costing Process

PNMAINTOINTER - P/N Interchangeable to Main Inventory and Journal Entries Creation

REASCII128255 - Allow ASCII Characters 128-255 from JE XML

Top of Page Publication Date: 8/17/2026 Share Print