Table of Contents

1. The Item Journal can be accessed from Departments à Warehouse à Inventory à Tasks.

2. If using multiple Item Journal Templates, select your template from the Item Journal Template List and click OK:

3. If using Item Journal Batches, select your Batch from the “Batch Name” field at the top of the Item Journal form and click OK.

4. Fill in the “Posting Date” field with the date you wish to show the adjustments as being made.

5. Fill in the “Entry Type” field with either ‘Positive Adjustment’ or ‘Negative Adjustment’, depending on whether you wish to increase or decrease the quantity on hand.

a. When doing a reclassification from ‘unsorted salvage’ to inventory, the first line is a Negative Adjustment to the Salvage item no. and then followed by as many positive adjustment lines is needed to separate into actual items. Be sure to take into consideration adjustments for pound to Case items.

6. If desired, enter a “Reason Code” to describe why the adjustment is being made. This field is may be required if Ceres has been configured to require reason codes. Regardless of whether Ceres is configured to require a reason code it is recommended that you use reason codes whenever possible. Accurate recording of transactions will allow you to run reports by Reason Code later to help better track your inventory adjustments.

a. For example, if you are negatively adjusting an item due to a TRASH adjustment, you should select a Reason Code that corresponds to the type of Trash adjustment you are making. If you have defaulted a Reason Code for the Journal, this value will populate for you. When you run the Receipts and Distribution report, you will select the transactions with your Trash reason code for FA reporting.

7. Enter the Document No. If you have assigned a document number series for your journal template or batch, the value will populate for you.

8. Enter the Item No. you wish to adjust or hit F4 to get a list of your items.

9. Enter the Location that the adjustment will take product from (negative adjustment) or put product into (positive adjustment).

a. If you are unsure of the Location in which the product is located, simply click in the Item No. field and while highlighted on that item, click ‘Advanced.’ Make sure your item is highlighted, then click Navigate à Item Bin Contents to see what Location or Locations the product is currently located in.

10.  Enter the quantity to be adjusted in the ‘Quantity’ field.

i. In this case, select the Lot No. you are adjusting. The Bin Code will not auto-fill in this case, so you will need to select the Bin Code from which you wish to adjust the quantity (the bins in which the product are currently stored can be viewed from the same place described in 9b.

12.  If the “Entry Type” is ‘Positive Adjustment’, enter or select the Pallet (or Lot if not using Pallets) for which you wish to increase the quantity OR enter Tiers and Height information to facilitate creating a new Pallet and Lot.

a. If selecting an existing Pallet/Lot, the other information associated with that original pallet/lot will auto-fill on the line.

b. If creating a new Pallet / Lot, be sure to fill in the Bin Code where the product is to be stored, Lot Consume By Date, Lot Expiration Date, Lot Ship by Date, FBC Product Source, FBC Product Category and any other pertinent information.

c. Finally, enter the Tiers and Height to determine how many pallets need to be created for this entry.

d. Click Actions à Assign Lots to create the lot for the positive adjustment line.

e. When yes is selected, the Lot Nos. will be generated and a confirmation prompt will display that the assignment is complete.

f. If the items on the positive adjustment lines are palletized, you will need to create pallets for those lines. First make sure Tier and Height values are entered on those lines, then click Actions à Create Pallets to create pallets.

13.  If posting a journal to reclassify product from ‘unsorted salvage’ to sorted inventory items, be sure to adjust the quantity on your negative adjustment line to make sure your negative and positive adjustments are balanced, paying careful attention to the Ext. Gross Weight Column.