Adjustment Entry (ICE210) field descriptions

How to

Use these fields to create adjustments.

1. Warehouse

Specify the warehouse code for the item(s) to be adjusted. The entry must be a valid warehouse code. The system displays the warehouse name and description. Press Enter to default to the warehouse assigned to the terminal.

2. Item

Specify the item number to be adjusted. The entry must be a valid item number. The system displays the description and current on hand quantity for this item and stocking unit of measure. Press Enter to default to the item previously adjusted.

If an item does not update inventory (as set by the IC Control flag), the system displays the following message: "This is an uninventoried item. Cannot Adjust. CR-Continue".

If the item is inventoried, but does not exist in the specified warehouse, the system displays the message: "Item not in this warehouse. CR-Continue".

Serial/Lot Items

If the item number is a serial/lot item, the system displays fields #3-6.

3. Serial/Lot #

Specify the serial or lot number of the item(s) adjusted.

4. Number not found. Do you wish to receive?

If the serial/lot number entered does not exist in the warehouse, indicate whether to receive in a new serial/lot number. Press Enter to default to N and returns to field #3. If the item exists, the program proceeds to field #7.

5. Vendor

Specify the vendor to receive goods from. The entry must be a valid vendor. The system displays the vendor name. Press Enter to default to the primary vendor assigned to the item.

6. PO Number

Specify the purchase order number being received (1-999999).

7. Adjustment

Specify the adjustment quantity (+/-) of the item. This displays the new on-hand quantity (current on hand plus the adjustment amount). Zero quantities are not accepted. If you set up multiple units of measure on the Item F/M screen for the item entered, you can press F2 to change the unit of measure.

8. Adjustment Code

Specify the adjustment code. The entry must be a valid adjustment code. An S-sales type is only accepted if the adjustment was a negative adjustment. A R-receipt type is only accepted if the adjustment was a positive adjustment. An A-adjustment is accepted for negative and positive adjustments.

9. Cost

If the adjustment type entered was not R-receipt or A positive adjustment, this field is skipped. Specify the unit cost for this item receipt. Zero costs are not accepted. Press Enter to default to the current cost of the item.

10. Sales Dollars

If the adjustment type entered in field #4, was not S-sales, this field is skipped. Specify the dollar amount of the sale. The amount entered will be updated to the warehouse/item file for month-to-date and year-to-date history.

11. Post To Usage

If the adjustment code type is "S" for sale, you can select the check box to post the number of units to the actual usage in the warehouse/ item file. If the adjustment type entered in field #4, was not S-sales, this field is skipped.

Based on this
setting, usage is given to the warehouse that is being adjusted. The system checks the value of the Replenish setting on the Main screen of Warehouse/Item F/M (ICF920) to determine whether to display the Post to Usage prompt. If the item’s replenishment flag is not Y, the system skips this prompt and does not update usage. If the replenishment flag is Y, the system updates usage based on your response here.

12. Adjustment Memo

Specify the optional memo regarding the adjustment (up to 25 characters). This memo overrides the adjustments code description that prints on the Adjustment Register. Press Enter to default to no memo and the adjustment code description prints on the register. Press to F2 default to the memo previously used.

The system displays the message: Job Number message box and asks: "Enter job number?" Yes/ No

If you select Yes, the system displays the Job Posting Entry dialog box, which contains fields 13-20. If you select No, the system accepts the line and displays it in the browser in the lower portion of the screen.

13. J-Job #, F4-Backup

You can: Press F4 to back up to the adjustment memo. Press Enter to accept the line, clear the user fields for this adjustment, scroll the transactions down to the bottom of the screen, and print the last transaction at the top of the list. The program then proceeds to the item field to await further adjustments in this warehouse. You can enter J to enter job-costing information.

Job Costing Information

If the Use Job Cost flag is set to N or the type for the adjustment code entered is not an A-adjustment then this field does not appear and the program proceeds to field #21. Specify J to enter job costing information.

14. Job Number

Specify the valid job number to post this entry against. Specifying a valid job number displays the job name, customer number and name, and billing type. Press Enter to default to the last job number entered (if any). Press F2 to search.

15. Price Message

If the billing type for the job entered is fixed, contract or time and material, this field is skipped. If the billing type is cost + (plus) or no charge, the program displays the price (bill rate) that will be used to calculate the extension. If the job is no charge, then the markup method can be changed if the Allow Billing Override flag for the cost code is set to selected and neither the bill rate nor extension will be affected. Press Enter to continue.

16. Cost Code

Specify a valid cost code (up to 4 characters). Entering a valid cost code displays the cost code description and the cost type. If the cost code is not set up to use units (unit of measure field is blank in Cost Code F/M), the program displays a message displaying this information. The cost code sets the defaults for markup method (for all jobs that are not billed as cost plus) and the billing rate for jobs that are billed as a fixed contract or as time and material. If the billing type is not cost plus, the cost code also determines whether the user is able to override the markup method and or bill rate. Press F2 to search.

The item entry determines the units, unit of measure and cost rate/extension.

17. Markup

This field is initially skipped and set to the markup assigned to the cost code. This may only be entered for jobs which are time and materials or fixed contracts and the Allow Override Of Billing flag is set to Y in the cost code record. This may also be changed for no charge jobs but the bill rate is not affected.

Specify the markup method to use for this posting entry. The user has the following options:

# - Specify the markup amount (0-9999999.99%). Entering a number tells the system to mark up the cost by a dollar amount. The system marks up the cost rate by the dollar amount and calculates the bill extension.

 

#+% - Specify the percentage (0-9999999.99%) to mark up the cost. To enter a percentage, the user must enter an amount and then the percentage sign. If no percentage sign is present, the system assumes the entered amount is a dollar amount. The system marks up the cost rate by the percentage amount and calculates the bill extension.

 

M - Specify the bill rate manually. Entering M displays the word MANUAL and the program proceeds to the bill rate field (#18).

The fixed markup method is unavailable for selection, but can be used. To utilize the fixed method, select a cost code whose markup method is fixed.

Press Enter to initially default to the markup method (amount/percentage) from the cost code record.

18. Bill Rate

This field is unavailable if the Allow Billing Override flag is set to unselected in the cost code record. This field is initially skipped unless the markup method of the cost code is manual. Specify the price per displayed unit of measure. The bill extension is calculated and displayed. Press Enter to initially default to 0.

19. Memo

Specify the memo to post for this job cost transaction and to print on the job cost invoice (if applicable - see next field). Press Enter to initially default to blanks.

20. Print Memo on Job Cost Invoice?

This field is initially skipped and set to unselected. Indicate whether to print the memo (entered in the previous field) on the job cost invoice. The field may only be set to Y if the Billing Detail for the cost type (that the cost code is assigned to) is set to A for all transactions in the Job Entry program. Press Enter to initially default to unselected.

When you have added all the adjustment line, save your entries.

You can stop entering adjustment lines. You can Add additional items for adjustment.

On the left side of the line item browser, you access Note Entry (SME710) for the item highlighted in line item browser.

Click Exit to return to the main IC menu.

See also

Manually adjusting on-hand quantities