Publication Date: 11/12/2024 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

system config

When Set to FIFO:

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

FIFO config

Location 'MIA' has five P/N '1101''.

Inventory Transaction FIFO

P/N '1101' has a Fixed Asset Number '76976'.

fixed asset registry

The following P/N '1101' S/N '04' is scrapped.

FIFO Scrap

The Transaction number in the Inventory Detail Transaction History is '12593602'.

Inventory transactions detail

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

Fixed Asset FIFO

The oldest Fixed Asset record for the P/N '1101' the following S/N '1'. The system deleted the latest fixed asset record due to the FIFO configuration switch setting.

 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 config

In location 'ATL', P/N '1101' has three parts available.

Inventory transaction LIFO

A P/N '1101' S/N '08' has the oldest fixed asset record for the part.

LIFO fixed asset

The P/N '1101' S/N '08' is scrapped.

LIFO Scarp

The Transaction number in the Inventory Detail Transaction History is '12593619'.

LIFO Transaction no

The latest Fixed Asset record for the P/N '1101' is the following S/N '07'. The system deleted the latest fixed asset record due to the LIFO configuration switch setting.

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

Inventory Transaction result LIFO

  

When Set to Actual:

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

Actual config

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 a 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 performed against the Fixed Asset table.

In the Inventory Transaction window, Location 'MIA' has three P/N '11-0136-00-01'.

Inventory Transaction actual

The fixed asset record for a P/N '11-0136-00-0-1' S/N '02' is displayed.

Actual fixed asset registry

The same P/N '11-0136-00-0-1' S/N '02' is scrapped.

actual scrap

The Transaction number in the Inventory Detail Transaction History is '12593625'.

actual scrap transction record

The system deleted the fixed asset record for the indicated scrapped P/N S/N.

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

actual final screenshot

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.

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

Actual config

The following assembly will be used for this example.

PN  Explorer

The Fixed Asset for this NHA is 76992.

NHA

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

NLA

The following NLA S/N '010' will be removed from the assembly.

PN NLA Installation and Removal

The S/N '010' was removed from the assembly.

PN install

The S/N '010' 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 and the NLA that was removed are both highlighted before the S/N is installed on the assembly.

PN NLA Installation and Removal

The new NLA is installed.

New NLA

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

Final fixed asset registry GLFIFO

See Also

G/L Interface Switches

CLOSEBAL - Inventory Balance Costing

COMPANYMULTI - Multi Company Setup

COMPANYMULTIEX - Validate 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 - Order Invoice Transfer Configuration

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

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: 11/12/2024 Share Print