Publication Date: 11/12/2024 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

CLOSEBAL - Inventory Balance Costing

Inventory Balance Closing

Affected window: w_inventory_costing

CLOSEBAL1

When the Inventory Balance is closed out, the month/year of the last closing will be stamped in the Config Date field. The Config Date field is used:

In the G/L Interface/ Print/ Inventory Costing when the user runs the Inventory Balance report it will close out the Inventory values and time stamp it.

Note: The Configuration Date field is updated automatically every time the Inventory Balance is closed monthly.

 

G/L Date:

If Switch J/E had a date that is older than the date specified in Switch CLOSEBAL, the system will pull the date from Switch CLOSEBAL.

 

Setup:

The Config Date is set for Switch J/E.

The Config Date is set for Switch CLOSEBAL at a later date.

 

The following PO was received at a date later than that set for both switches.

From the Journal Entry Detail Query window, the user can see that the G/L Date was pulled from the date populated in Switch CLOSEBAL.

 

If Switch J/E has a date that is more current than the date specified in Switch CLOSEBAL, the system will pull the date from Switch J/E.

Setup:

The Config Date is set for Switch J/E.

The Config Date is set for Switch CLOSEBAL at a later date.

The following PO was received later than the configuration of the switches.

From the Journal Entry Detail Query window, the user can see that the G/L Date was pulled from the date populated in Switch J/E.

See Also

G/L Interface Switches

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

GLFIFO - Use FIFO Instead Of LIFO

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