G How to Adjust Inventory for Stock Items

This appendix contains the topic:

• Section G.1, "Adjusting Inventory for Stock Items."

G.1 Adjusting Inventory for Stock Items

If the purchase card transaction is for a stock inventory item, you can directly update inventory items in the Inventory Management system (41) for purchases processed through the PCard system (01P). This feature allows you to update (adjust) your inventory stock as purchases are approved and processed, instead of having to coordinate this activity separately.

Updating Inventory Items from the Purchase Card Management system includes the following tasks:

• Setting up the system

• Understanding Inventory Adjustments for PCard transactions

• Processing PCard transactions for Inventory Items

• Processing an Inventory Adjustment Among Multiple Branch/Plants

G.1.1 Setting Up the System

Before you adjust inventory for PCard purchases, you should review the processing options for the version of the Inventory Adjustment program (P4114) that you want to use, specify that version in the DREAM Writer Versions processing option for Transaction Workbench (P01P200), and review the Distribution Manufacturing Automatic Accounting Instructions.

Understanding the Summary Mode Processing Option for Inventory Adjustments (P4114)

Because the PCard system requires inventory adjustments to be processed in detail, the program ignores the setting of this processing option and always processes the inventory adjustment in detail.

Setting the DREAM Writer Version Processing Option of Transaction Workbench (P01P200)

After you set up the version that you want to use for inventory adjustments, you must enter it in the DREAM Writer Versions processing option (Stock Inventory Items) for the Transaction Workbench program (P01P200). If you do not specify a version, the system uses version ZJDE0001.

Setting up Distribution/Manufacturing Automatic Accounting Instructions (DM AAIs)

The system retrieves the accounts to process inventory adjustments from the 4122 and 4124 DM AAI tables:

• The system uses accounts in the 4122 table to record the adjustment to the inventory account.

  The account that the system retrieves from this AAI is synonymous to the account that the system uses to record the PCard expense, which you can review from Purchase Card Transaction Details (P01P111).

• The system uses accounts in the 4124 table to record the offset to the inventory account.

  The account that the system retrieves from this AAI is synonymous to the offset account that the system retrieves from the AAI item CCP. If you set up a CCP AAI using this same account, when you generate the voucher, the net effect is zero for this account. Otherwise, you must manually reconcile these offset accounts.

See Also:

• Setting Up Automatic Accounting Instructions in the JD Edwards World Inventory Management Guide for additional information.

G.1.2 Understanding Inventory Adjustments for PCard Transactions

You use the Purchase Card Transaction Detail program (P01P111) to assign the inventory item number to the PCard transaction. The system validates the item number you enter against the Item Master file (F4101) to ensure that it is for a stock item. If the item number is for a non-stock item, the system does not display the Inventory Adjustments program when you use the function to access it.

Because the PCard receipt might include items that are not stock, the system allows you process both stock and non-stock purchases.

Processing for Multiple Branch/Plants

If your inventory item purchase applies to multiple branch/plants, you must segregate those transactions within the Purchase Card Transaction Detail program (P01P111) prior to accessing the Inventory Adjustment program. When you access Inventory Adjustments, the system automatically transfers the detail from the PCard system and does not allow revisions. For example, you have an inventory purchase of 40 units at $200, but 40% of the units are for branch S10 and 60% are for branch LT5. On the Purchase Card Transaction Detail, you must separate the units and amounts into two separate detail lines, such as 16 units at $80 and 24 units at $120. This allows you to enter the appropriate branch/plant for that portion of the inventory purchase.

Understanding Accounting

The following table includes the T-accounts that the system writes when you process inventory adjustments and vouchers. As previously mentioned, the system generates the journal entry for the inventory adjustment as soon as you add it and does not generate a journal entry from the PCard system; however, if you generate vouchers from the PCard system you can set up the CCP AAI to relieve the account used as an offset account from the inventory system.

Figure G-1 T-Accounts from Processing Inventory Adjustments and Vouchers

Description of "Figure G-1 T-Accounts from Processing Inventory Adjustments and Vouchers"

When you enter the inventory adjustment, the system creates a journal entry for both the debit and credit amounts to balance to zero. When the system generates the voucher, it generates a journal entry for the expense. When you post the voucher, the system generates the offsetting entry.

G.1.2.1 Entering the Inventory Adjustment

Access the Inventory Adjustments program (P4114). The PCard transaction must be approved to access this program.

Figure G-2 Inventory Adjustments screen

Description of "Figure G-2 Inventory Adjustments screen"

On Inventory Adjustments, complete the following fields and click Enter:

• G/L Date

• Branch Plant

• Explanation

Note:

Depending on the processing option settings of P4114, the program might require you to complete additional fields. Refer to the Adjust Inventory chapter in the JD Edwards World Inventory Management guide for additional information.

When you create an inventory adjustment, the system creates a journal entry (batch type N) in the Account Ledger file (F0911) and updates the Address Number field (AN8) with either the address book number of the merchant (if you track merchants) or the address book number of the bank. The program also updates the Purchase Card Flag field (CFF1) to 1.

You must post this transaction from the Inventory system.

The system creates the journal entry for the adjustment to the proper accounts and displays the JE document information in the detail area of the PCard transaction:

Figure G-3 Journal Entry screen

Description of "Figure G-3 Journal Entry screen"

Figure G-4 Purchase Card Transaction Details screen

Description of "Figure G-4 Purchase Card Transaction Details screen"

The system also:

• Creates a record in the Item Ledger file (F4111) for each adjustment.

• Creates a record in the Stock Inventory Items file (F01P41) to record the journal entry document information for the adjustment. The system uses the Unique Key ID (UKID) from the record in the Transaction Distribution File (F01P111) to create a relationship between the two records.

• Updates the Create Journal Entry Date field (CRTJ) in the Transaction File (F01P11).

  The system does not update this field until all lines of detail have been processed by either the Inventory Adjustment (P4114) or the Create Journal Entries (P01P520) programs. For example, you have a PCard transaction that has multiple detail lines that are mixed with inventory items and non-inventory items. If you first run the Create JE program to record the non-inventory expenses to the GL, the system does not update CRTJ because there are still unprocessed journal entry detail lines. When those stock items are processed through P4114, the system updates CRTJ on all PCard transactions.

Note:

The system requires that CRTJ be populated to purge PCard transactions.