1. Inventory Management Implementation Guide
  2. Process

Process

1. Cost Entry

Specify whether to display the Unit Cost and Extended Amount fields on the Inventory Adjustments form and whether they can be updated. Values are:

Blank: Display the fields.

1: Display the fields with default values from the F4105 table but do not enable them to be updated.

2: Do not display the fields.

2. Journal Entries

Specify whether detailed or summarized journal entries are created for the general ledger. For summarized journal entries, the system creates a summarized debit total and a summarized credit total by account number for each line in an adjustment. For detailed journal entries, the system creates one journal entry (debit and credit) for each line in an adjustment.

The Inventory Adjustments (P4114) program creates batch type N. This processing option affects journal entries for the F0911 table only. The AAIs that are most commonly used are 4122 (inventory valuation account) and 4124 (expense or cost of goods sold account). If you use standard costs, the system might create journal entries for the variance, based on AAI 4141. The F4111 table contains entries for each detail line in each adjustment regardless of how you set this processing option. Values are:

Blank: Create one journal entry (debit and credit) for each detail line in an adjustment.

1: Create journal entries that are summarized by account number.

3. Lot and Layering Fields

Specify whether to display the lot information fields on the forms and whether they can be updated. Values are:

Blank: Do not display the lot information fields.

1: Display all lot information fields and enable changes.

2: Display all lot information fields but do not enable changes.

4. Adjustment Quantity

Specify the way the system validates a transaction that results in a negative quantity. Values are:

Blank: Do not enable negative quantity available.

1: Enable negative quantity available.

2: Do not enable negative quantity on-hand.

Caution: You cannot enable a negative available quantity while using the weighted average cost function.
5. Lots on Hold

Specify whether to enable adjustments to lots that are on hold. If the Lot Status Code field on the Item/Branch Plant Information form is non-approved, the lot is not on hold. Values are:

Blank: Do not allow adjustments to lots on hold.

1:Allow adjustments to lots on hold.

When NBLOTSTS is set to No or NBLOTSTS is not present in the EnterpriseOne Control System program (P99410), an approved lot or location does not have a status code. All non-blank codes indicate that the lot is on hold or unapproved.

When NBLOTSTS is set to Yes, the lot status is validated by a special handling code in UDC 41/L. All codes containing the special handling code 1 indicate that the lot is approved. All codes containing special handling codes other than 1 indicate that the lot is on hold or unapproved.

6. Enter Allowed Lot Status Group to Validate

Lot Group is the name of a user defined list of allowed non-approved lot status codes. Entry of a Lot Group name in the Processing Option will allow this Application to process lots whose lot status code is defined within the specified Lot Group Name.

When NBLOTSTS is set to No or NBLOTSTS is not present in the EnterpriseOne Control System program (P99410), an approved lot or location does not have a status code. All non-blank codes indicate that the lot is on hold or unapproved.

When NBLOTSTS is set to Yes, the lot status is validated by a special handling code in UDC 41/L. All codes containing the special handling code 1 indicate that the lot is approved. All codes containing special handling codes other than 1 indicate that the lot is on hold or unapproved.

7. Production Number On Hand Consumption

Specify how the Inventory Adjustments program (P4114) selects production number on hand quantity from the Item Location Tag File table (F41021T).

Production number on hand is consumed whenever on hand quantity is not available to continue the transaction.

If you process inventory selection blindly, then the system consumes production number on hand quantity in the following order:

  1. Generic inventory.

  2. Inactive production numbers.

  3. Orphaned production numbers.

  4. Production number with the farthest end item demand date.

If you process inventory selection interactively, then you can select the production number from the options available on the Select Inventory for Consumption form (W42054A). Valid values are:

Blank: The program performs blind selection of inventory.

1: The program enables interactive selection of inventory.