On Hand Adjustments (INDE003)

 

On Hand Adjustments is found on the Inventory Data Entry menu, 1-3.

 

On hand means the quantity is physically in the warehouse.  Therefore, this is the inventory count of an item.  This is not necessarily the available amount as the available amount equals on hand minus allocated and back ordered amounts.  The quantity that is on hand is automatically adjusted by numerous programs in the LMS system.  They are Billing Invoice Entry, Credit Memo Entry, Invoice Credit Memo Void, Order Release, Service Ticket Entry for billable and no charge parts entry, Void Service Invoices, P.O. Receipts, and Inventory Receipts.  P.O. File Maintenance also adjusts on hand when a P.O. Receipt is reversed out.  Thus, the on hand quantities of items are constantly getting adjusted within the LMS modules.

 

The main purpose of the program, On Hand Adjustments, is to correct any errors in the on hand quantity of an item in a specific warehouse.  The amount may be added or subtracted.  Correction of an error may occur after the taking of a physical inventory or just to correct an entry made by an operator.  For example, if an inventory receipt was entered incorrectly, an on hand adjustment should be made to back the error out.

 

Using On Hand Adjustments results in the following functions.

 

On Hand inventory quantities is increased or decreased in the inputted warehouse.

 

The Stock Activity Inventory Report, which is found in the LMS Inventory module, is updated by On Hand Adjustments.  Any item entered in is reflected on the report in the proper warehouse.  The report uses the Imwactd File.

 

An Inventory Transaction Report may also be printed upon exiting the On Hand Adjustments program.  The report includes the on hand amounts before and after the entry.

 

Total adjusted cost for all items combined is provided on the screen and on the Inventory Transaction Report.

On Hand Adjustments  (Contd)

 

 

Introduction  (Contd)

 

If the adjusted warehouse is overridden and the item is not stocked in this warehouse, the option to stock the item is available.  The Item Warehouse File is then created.

 

Items may be entered using the actual item number through an item alpha or description search or use of an association item created from an item merge or conversion.

 

While entering items when the current input screen is full, the display of the first two items on the screen are removed and the screen scrolls up rather than clearing the screen and beginning a new screen.  The operator can always view on the current input screen, the last 3 items that were entered.  After an initial end command, the ability to page back and forward by entering next and previous allows viewing of all of the items that were adjusted.

 

Various information is displayed when entering an item.  This includes the pack multiple, current average cost, and the current on hand amount.  Once the adjustment has been made, the on hand is redisplayed including the entered amount.  All displayed quantities include any broken pack quantities.

 

Once an item has been entered, the item can be selected for a change or can be deleted from the transaction.  After the initial end command, additional items can be entered.  Because of the ability to change and delete, the program does no file updating until the final end command is entered.

 

The program does not allow an adjustment of an item into the same warehouse more than once during the transaction.  If an attempt is made, the program provides a warning and also an option to go directly to the item record and make changes.

 

Total adjusted cost for all items combined is provided on the screen and on the Inventory Transaction Report.

On Hand Adjustments  (Contd)

 

Enter Data

 

Transaction Date

 

The transaction date that is input after selecting the program becomes the date the on hand entry is made.  This appears on the Stock Activity Inventory Report and Inventory Transaction Report.

 

Initials:

 

Whatever initials are accepted at the menu prompt are written to the Imwactd File and are included on the Stock Activity Inventory Report.  They are also printed on the Inventory Transaction Report that can be generated from the On Hand Adjustment program.  This is the only indicator as to who entered the adjustments.

 

Warehouse

 

 

On the very first entry a zero appears in reference to no warehouse.  A carriage return produces the prompt Invalid Warehouse.  The cursor returns for reinput.  Enter the warehouse that the on hand amount of the item is to be adjusted.  If an invalid warehouse is entered, the prompt Invalid Warehouse displays.  The cursor returns for reinput.  Once a valid warehouse is entered, that warehouse number becomes the default at the Warehouse prompt for the next item.  Every time warehouse is changed, that warehouse number becomes the new default.  The default can be overridden to any valid warehouse number between 1 and 9999.  (1-9999)

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

The next prompt allows entry of the item number that is having the on hand quantity adjusted.

 

Item Number

 

 

Next to the Item Number prompt is a computer assigned line number.  This is used to select an individual item on hand adjustment for a change or deletion.  A slash / or up arrow key ^ at Item Number returns the cursor to the Warehouse prompt.  There are four ways to access the desired item numbers.  They are input the item number, item alpha search, item description search and item association search. 

 

Input The Item Number

 

Enter the item number that is desired.  If the item number that is entered is not found in the Item File, the item alpha search is accessed.

 

Item Association Search

If an item record has been converted to another item number through the Item Conversion or Merge program, an input of the old item number automatically displays the new item number.  After the input of the old item number, a prompt Association Item Number displays.  The new item number appears and the program continues on.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Item Alpha Search

To access an item number by an item alpha search, input the beginning numbers or letters at the Item Number prompt.  Item number is an 18 character field.  Any item record that matches exactly what was input appears.  A computer assigned line number corresponds with each selection.  The full item number, item description, amount available, and product class prints per selection.  The amount available is the amount in whatever warehouse is the default warehouse.  Thirteen selections per page appear.

 

 

Item Description Search

To activate the item description search at the Item Number prompt input a \ left pointing slash followed by the desired description.  It is the \ slash that activates the description search.  Description may be 32 Alphanumeric characters.  Any item record with a description exactly matching the input displays.  For each item, a computer assigned line number appears.  Also printing is the full item description, amount available from the default warehouse, and product class.  Thirteen selections per page appear.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

When the item alpha or description search is activated at the Item Number prompt, one of the following two prompts appear.

 

Select Item Choice, Or E'nd:

Display N'ext, Select Item Choice, Or E'nd: N

 

The first prompt appears when there is only one screen of item selections.  The second prompt appears when there is more than thirteen item selections.  Enter an E to exit the item selections.  The cursor returns to the Item Number prompt.  Enter the computer assigned line number that corresponds with the desired item selection.  To view the next screen of items enter a N for next or carriage return to accept the default of a N for next.

 

When entering a N for next, the next screen of possible items displays.  One of the following two prompts appear.

 

Display N'ext, P'revious, Select Item Choice, Or E'nd: N

Display P'revious, Select Item Choice, Or E'nd:

 

The first prompt appears until the last screen is reached.  The second prompt appears on the last screen of selections.  Enter a N for next to view the next screen.  Enter an E to exit the item selections. The cursor returns to the Item Number prompt.  Enter the computer assigned line number that corresponds with the desired item selection.  Enter a P to go back one screen of items.  You may go back and forward as many screens as exist.

 

If a line number is entered that does not exist, the prompt Selection Is Out Of Range appears.  The cursor returns for reinput.  An existing line number from a previous screen can be entered.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Item Number

 

The item must be stocked in the warehouse that was entered.  If the item is not stocked the following prompt appears.

Item Not Stocked In This Warehouse

Do You Wish To Stock This Item In This Warehouse (Y/N)

 

 

Enter a Y for yes to create an Item Warehouse record for the item in the indicated warehouse.  The item is now stocked in the warehouse and the on hand amount is updated for the item in the warehouse.  Enter a N for no to not stock the item in the inputted warehouse.  The cursor returns to the Warehouse prompt.  When a yes is input to stock the item, the prompt  Enter A Y For Yes This Is A Non-Stock Item Or A N For No This Is Not A Non-Stock Item appears.  Enter a Y to set the non-stock indicator to yes or a N to set the non-stock indicator to no for the item in the inputted warehouse.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

After the input of an item, the following information is displayed on the screen.

 

 

Warehouse  The warehouse the items on hand quantity is being adjusted in.

 

Bal  This is the current on hand quantity of the item in the inputted warehouse prior to this transaction.  On hand is the amount that is physically in the warehouse.  Any broken pack units are included and are followed by the word Units.  In the above example, 56 is the whole pack quantity and there are 4 broken pack units on hand.

 

PM  The items pack multiple from the Item File.

 

Description  Twenty nine characters of the items description from the Item File.

 

Avg. Cost  The items average cost from the Item File.  The four decimal cost is displayed.  The items average cost must correspond with the UM and PM.  Average cost is not adjusted by On Hand Adjustments.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

The cursor is at the following prompt.

 

Qty

 

A slash / returns the cursor to the Warehouse prompt.  An up arrow ^ returns to the Item Number prompt.  Enter the adjustment quantity.  To add an amount, enter the quantity that is to be added to the current on hand amount.  To subtract from the current on hand amount, enter a negative sign - and the quantity to be subtracted.  The quantity entered should correspond to the displayed pack multiple.  The only exception to this is if the pack multiple is greater than 1 and an adjustment of a broken pack or unit is desired.  To adjust on hand by a broken pack or unit quantity, enter an E for each before the entered quantity.  For example, with a pack multiple of 4 and unit of measure of CT, entering E1 adds 1 unit not 1 carton of 4 units.  Entering an E-1 subtracts 1 unit not 1 carton of 4 units.  Note:  If an E for each and the quantity that is input is greater than the pack multiple, the program divides the entered amount by the pack multiple and converts to whole packs and any remaining to units.  A zero is accepted and no adjustment is made.  The record appears on the Inventory Transaction Report but does not write into the Imwactd File so does not appear on the Stock Activity Inventory Report.  (6 Alphanumeric)

 

If a quantity is input that is greater than 9999, the following prompt appears.

 

Quantity Is Very Large.  Please Check And Correct If Necessary

Is Entered Quantity Correct  (Y/N)

 

The prompt is to warn the operator that possibly they made a keying error as the inputted quantity is rather large.  Enter a Y to accept the input.  Enter a N to cancel the input.  The cursor returns for reinput.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Document #

 

 

Document number should be used to store a reference number for the transaction.  This could be a purchase order number or any other internal verification code or number.  On the first transaction there is no default.  After that the default document # is whatever was entered on the last entry added.  A carriage return accepts the default document number.  This can be overridden or left as blank if desired.  An up arrow key ^ returns the cursor to the Qty prompt.  A slash / to cancel returns the cursor to the Warehouse prompt.  Whatever is input is written to the Imwactd File and prints on the Stock Activity Inventory Report.  Document number is also printed on the Inventory Transaction Report.  (12 Alphanumeric)

 

After the document number is input, the entry for that item and warehouse is completed.  The quantity displayed in Bal includes the entered quantity.  This is now the after balance.  Also note that when an E for each is entered at Qty, the displayed average cost is changed to the each cost.  This is average cost divided by pack multiple.  The calculation uses all four decimal positions.

 

 

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

While adding items when the current input screen is full, the display of the first two items on the screen are removed and the screen scrolls up rather than clearing the screen and beginning a new screen.  The operator can always view on the current input screen the last 3 transactions that were entered.  To illustrate this, see the following examples.

 

The first example shows the screen as it looked at the time the eighth item on the screen is being added.

 

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

The next example shows the screen as it looked after completing the adding of the entry of the eighth item, 78 1000.

 

 

Notice that the items on line 1 and 2 no longer appear on the screen.  The cursor is at the Item Number prompt on line 9.  After an item is entered for lines 9 and 10 lines 3 and 4 scroll off the screen.  This continues until END is entered at the Item Number prompt.  At that time the next, previous prompts appear and the ability to page back and forth on the screens is activated.

 

The program does not allow input of an item in the same warehouse more than once.  You may enter multiple transactions for the same item in different warehouses but not in the same warehouse.  You would have to totally exit On Hand Adjustments and re-enter the program to enter another adjustment for the same item and warehouse.  The reason for this is to display the correct on hand before and after and allow changing of the transaction.  You can only have one record per item per same warehouse on an individual On Hand Adjustment transaction run.  During the adding of an item if an attempt is made to enter an item and warehouse that has already been entered during the On Hand Adjustment transaction run, the following prompt appears.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Quantities For This Item And Warehouse Were Already Entered On Line No.  ##

Do You Wish To Continue (Y/N)                                            

 

 

The line number that the item was already entered on is displayed.  Entering a N for no cancels the input.  The cursor returns to the Warehouse prompt.  Entering a Y for yes automatically accesses the on hand record for that item and warehouse.  You actually are in the change mode and are allowed to change the adjustment quantity, warehouse, or document number of the record that was already input.  Even though you cannot enter the same warehouse and item more than once, the program alerts you to this and brings you directly to the record and allows a change of information.  For operating instructions in the change mode, see page 132.

 

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Item Number

 

When END is input at the Item Number prompt or a duplicate on hand record is entered and the change mode is accessed, the add/change/delete feature is activated.  Entering END is just an initial ending command.  This is not the final exit of On Hand Adjustments.  When END is entered, one of the two following prompts appear:

 

Enter A'dd, C'hange, D'elete, Or E'nd: 

Display P'revious, A'dd, C'hange, D'elete, Or E'nd:

 

 

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Enter A'dd, C'hange, D'elete, Or E'nd: 

Display P'revious, A'dd, C'hange, D'elete, Or E'nd:

 

The first prompt appears when there is only one screen of items entered.  The second prompt appears when there is more than one screen of items entered.  Entering a P for previous moves back one screen.  If the items entered fill more than 2 screens, going back produces the following prompt.

 

Display Next, Previous, Add, Change, Delete, Or End: N

 

Entering a N for next accesses the next screen of items.  You may go back and forward as many screens as exist. 

 

Enter A'dd, C'hange, D'elete, Or E'nd: 

Display P'revious, A'dd, C'hange, D'elete, Or E'nd:

Display Next, Previous, Add, Change, Delete, Or End: N

 

You may add additional items  Enter an A for Add.  The cursor is at the Warehouse prompt.  The line number is incremented.  No matter which screen you are on when the Add command is given, the cursor goes to the last screen to add the item.  Once the Add command is given, you are basically back in the original Add mode.  Operation is the same as described beginning on page 119.  Entering an END at the Item Number prompt accesses one of the above prompts.

On Hand Adjustments  (Contd)

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Changing an Item

Enter A'dd, C'hange, D'elete, Or E'nd: 

Display P'revious, A'dd, C'hange, D'elete, Or E'nd:

Display Next, Previous, Add, Change, Delete, Or End: N

 

Entering a C for change allows an entered on hand record to be changed.  The item does not have to be displayed on the screen to be selected for a change.  The following prompt appears.

 

Enter Line Number To Change Or C'ancel

 

 

To cancel the change command, enter a C.  The cursor returns to the Add, Change, Delete prompt.  Enter the corresponding line number of the item record that is to be changed.  If a line number is entered that does not exist, the prompt Invalid Line Number appears.  The cursor returns for reinput.  An up arrow key ^ returns the cursor to the Add, Change, Delete prompt.  Once a valid line number is input, the item is displayed at the top of the screen and the cursor is at the first field that can be changed.  The heading Bal is changed to A-Bal to reflect the after on hand quantity, which includes the amount entered on the Add or prior changes.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Changing an Item  (Contd)

 

Wh

 

 

The original adjusted warehouse is displayed.  A carriage return accepts the displayed warehouse.  This can be changed to a valid warehouse.  Enter the warehouse that the on hand quantity is to be adjusted.  Warehouse can only be numbers 1 to 9999.  If an invalid warehouse number is input, the prompt Invalid Warehouse displays.  The cursor returns for reinput.  (1-9999)

 

If the warehouse number is changed to a warehouse that has already been entered for that item on another line on the on hand transactions, the following prompt appears.

 

Quantities For This Item And Warehouse Were Already Entered. Change Not Allowed.  You May Change Line Number  # .  Press 'CR' To Continue                    

 

 

The line number that the item and warehouse has already been entered on displays.  The change to this item is not allowed as the same item and warehouse cannot be entered more than once on the same On Hand Adjustments transaction.  The carriage return redisplays the Add, Change, Delete prompt allowing selection of that line for a change for that item and warehouse.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Changing an Item  (Contd)

Wh

 

When the warehouse is changed, the item must be stocked in the warehouse that is entered.  If the item is not stocked, the following prompt appears.

 

Item Not Stocked In This Warehouse

Do You Wish To Stock This Item In This Warehouse (Y/N)

 

 

Enter a Y for yes to create an Item Warehouse record for the item in the indicated warehouse.  The item is now stocked in the warehouse and the on hand amount is updated for the item in the warehouse.  Enter a N for no to not stock the item in the inputted warehouse.  The cursor returns to the Warehouse prompt.  When a yes is input to stock the item, the prompt  Enter A Y For Yes This Is A Non-Stock Item Or A N For No This Is Not A Non-Stock Item appears.  Enter a Y to set the non-stock indicator to yes or a N to set the non-stock indicator to no for the item in the inputted warehouse.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Changing an Item  (Contd)

 

Qty

 

When the cursor reaches the Qty prompt, the heading for A-Bal changes to B-Bal.  At this time, the balance reflected is the on hand quantity prior to the adding of this record.  An up arrow ^ returns to the Warehouse prompt.  The quantity that was entered on the Add displays as the default.  A carriage return accepts this.  If an E to enter a broken pack was input on the add, carriage returning at the E leaves the quantity as an each.  If the displayed quantity is incorrect, enter the correct on hand adjustment amount for the quantity on hand.  Overriding the amount replaces what was entered on the add.  It does not add or subtract from it.  To enter a broken pack or unit, enter an E for each before the entered quantity.  For example, with a pack multiple of 4 and unit of measure of CT, entering E1 or E-1 adjusts 1 unit not 1 carton of 4 units.  Note:  If an E for each and the quantity that is input is greater than the pack multiple, the program divides the entered amount by the pack multiple and converts to whole packs and any remaining to units.  Note:  Entering an E for each changes the displayed average cost to the unit cost which is average cost divided by pack multiple.  A zero is accepted and no adjustment is made.  The record appears on the Inventory Transaction Report but does not write into the Imwactd File so does not appear on the Stock Activity Inventory Report.  (6 Alphanumeric)

 

If a quantity is input that is greater than 9999, the following prompt appears.

 

Quantity Is Very Large.  Please Check And Correct If Necessary

Is Entered Quantity Correct  (Y/N)

 

The prompt is to warn the operator that possibly they made a keying error as the inputted quantity is rather large.  Enter a Y to accept the input.  Enter a N to cancel the input.  The cursor returns for reinput.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Changing an Item  (Contd)

 

Document #

 

 

The document # entered on the Add displays as the default.  A carriage return accepts the default document number.  This can be overridden, if desired.  An up arrow key ^ returns the cursor to the Qty prompt.  Whatever is input is written to the Imwactd File and prints on the Stock Activity Inventory Report.  Document number is also printed on the Inventory Transaction Report.  (12 Alphanumeric)

 

After a change is completed, the screen the item was accessed from is redisplayed.  The quantity reflected on the changed item under Bal returns to the on hand amount including this transaction so reflects the after on hand quantity.  In the example of the change, Part9 was changed from an on hand adjustment quantity of 3 to 5.  The on hand amount prior to the On Hand Adjustment transaction was 0.  The after on hand amount is 5.

 

 

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Deleting an Item

Enter A'dd, C'hange, D'elete, Or E'nd:  

Display P'revious, A'dd, C'hange, D'elete, Or E'nd:

Display Next, Previous, Add, Change, Delete, Or End: N

 

Entering a D for delete allows an entered on hand posting to be deleted.  The item does not have to be displayed on the screen to be selected for a delete.  The following prompt appears.

 

Enter Line Number To Delete Or C'ancel   

 

 

To cancel the delete command, enter a C.  The cursor returns to the Add, Change, Delete prompt.  Enter the corresponding line number of the item record that is to be deleted.  If a line number is entered that does not exist, the prompt Invalid Line Number appears  The cursor returns for reinput.  An up arrow key ^ returns the cursor to the Add, Change, Delete prompt.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

Deleting an Item  (Contd)

 

Once a valid line number is input, the item is displayed at the bottom of the screen.  The cursor is at the following prompt.

 

Verify Delete Cancel

 

 

Enter a C to cancel the delete.  The cursor returns to the Add, Change, Delete prompt.  The item is not deleted.  Enter a D to delete the on hand posting record.  The item is removed from the screen.  Any items that came after the deleted record have their assigned line numbers automatically renumbered.  The cursor returns to the Add, Change, Delete prompt.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Enter A'dd, C'hange, D'elete, Or E'nd: 

Display P'revious, A'dd, C'hange, D'elete, Or E'nd:

Display Next, Previous, Add, Change, Delete, Or End: N

 

When you have entered all of the items and made any changes or deletions, you are ready to exit the program.  To command the final exit of entering the items, enter an E to end.  No more modifications can be made to the items that were entered.  The following prompt appears.

Do You Wish To Print The Inventory Transaction Report  (Y/N)  

 

 

Enter a N for no to not print the report.  Enter a Y for yes to print the report.  The printer selection screen appears to allow selection of a printer.  Note:  If the printer that is selected is busy, you do not get the normal ability to cancel.  You either have to wait or change the printer.  You have one chance to print an On Hand Posting Transaction Report.  If you enter a N for no, you are not able to print this report.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Inventory Transaction Report

 

When a yes is entered to print the Inventory Transaction Report, the following prompt appears.

 

Use Average Cost Or Last Cost In The Value Calculation

 

 

The Inventory Transaction Report prints the total adjusted value for each item and a grand total.  This prompt allows the operator to choose whether average or last cost should be used for the cost on the report.  Enter an A to use average cost from the Item File.  Enter a L to use last cost from the Item File.  An up arrow key ^ returns the cursor to the Do You Wish To Print The Inventory Transaction Report  (Y/N) prompt.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Inventory Transaction Report  (Contd)

 

During the printing of the report or after entering no not to print the report, the actual updating of all of the files occurs.  This includes the Item File, Item Warehouse File, and Imwactd File.  During the updating of the files if the Item or Item Warehouse File is being accessed on another terminal for the item and warehouse that is being updated, one of the following prompts appears: 

 

Item ####### Warehouse ## Record In Use On Another Task!

Item ####### In Use On Another Task!

 

 

The first prompt occurs when the item that is being updated is being accessed on another task in the Item Warehouse File Maintenance program in the same warehouse.  This would be a warehouse of 2 to 9999.  The item number and warehouse is displayed.  The second prompt occurs when the item that is being updated is being adjusted in warehouse 1 and is being accessed in Item File Maintenance.  The item number is displayed.  The messages remain and the program does not continue on until the other task exits that record.  This is to protect the integrity of your data so that all the proper updating occurs.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Inventory Transaction Report  (Contd)

The Inventory Transaction Report includes all of the items that were entered since entering the program and typing the END command.  On hand postings that were deleted during the transaction are not included.  The report includes the following information per item entered.  The items are printed in the order they were entered in On Hand Adjustments.  They correspond with the line number order of the entries.  In the heading of the report is the initials that were accepted at the menu prompt when entering the program.  This is to identify the operator who entered the transactions.

 

WH  The warehouse the items on hand was adjusted in.

 

P.C.  The product class of the item from the Item File.

 

ITEM DESCRIPTION  The items full description from the Item File.

 

QTY  The quantity entered.  If a broken pack (E for each) was entered an E is printed before the quantity.

 

PM  The pack multiple from the Item File.

 

ON HAND BEFORE  The on hand quantity before entering the adjustment.  Any broken pack units are included with the letters EA following the broken pack quantity.

 

ON HAND AFTER  The on hand quantity after entering the adjustment.  Any broken pack units are included with the letters EA following the broken pack quantity.

 

AVG or LAST COST  The average or last cost from the Item File.  Which prints depends upon the response to the prompt Use Average or Last Cost.  This is for a quantity of 1.  If an E for each was entered, the unit or each cost is printed.  The four decimal cost is printed.

 

EXT. COST  The extended last or average cost (Average or Last Cost Times Quantity).

 

DOCUMENT  The entered document number.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Inventory Transaction Report  (Contd)

 

The report includes the combined total of all of the items extended costs after the heading REPORT TOTAL.  This is the total on hand adjusted cost.  Note:  Costs with more than 2 decimal points are rounded up or down to two decimals for the total.  As an example a cost of 9.075 is rounded to 9.08.

Following is a sample report of the on hand transactions that were used during this documentation.

 

 

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

After the response to the printing of the Inventory Transaction Report or the report is completed, the screen displays the total adjusted cost after the heading Value.  This is always average cost.  Also included is the total number of transactions, Count.  This is not the total quantity adjusted but the number of items that had an entry.  This would correspond with the number of line numbers.  The cursor is at the following prompt.

 

Enter Y To Return To Menu

 

 

Enter a Y to return to the Inventory Data Entry menu.

 

If END is input at Item Number and no items adjustments have been entered, a message No Adjustments Made appears on the screen and the following prompt displays.

 

Enter Add, Or End:

 

Enter an A to return to the Add mode and enter items.  Enter an E to exit the program.  The prompt Enter Y To Return To Menu appears.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

Following is a recap of what is updated per item adjusted.

 

Item and Item Warehouse Files

The on hand amounts are either added or subtracted in the proper warehouses by the quantity entered.  When an item is stocked in a warehouse an item warehouse record is created.  The current system date is written as date added.  Whatever is stored in the Item File in the negative stock indicator is written and also automatic calculation of min and max.

 

Inventory Stocking Files

This is the Imwactd File.  This file is used by the Stock Activity Inventory Report.  The report prints what transactions have been made in On Hand Adjustments.  Included on the report for items adjusted through On Hand Adjustments is the warehouse, item number and description, quantity entered, document number, transaction date (date entered at menu prompt when entering the program), and the operators initials entered at the menu prompt. 

 

Prior to exiting the On Hand Adjustments program you may also print all of the items entered by printing the Inventory Transaction Report.  Once the program is exited, this report is not available.

On Hand Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

During the updating of the Imwactd File, it is possible that an end of file stop may occur.  This may occur if you are entering a large amount of transactions at one time.  Because the way the program allows input of all transactions and does not update until you complete the transactions, an end of file stop could cause a lot of transactions to not be updated.  The operator could potentially have to re-enter a lot of work.  To prevent this, if an end of file stop occurs, the program does not go to a greater than prompt.  The error message displays.  An example of a possible error message is End Of File at stmt 6074 and the program name INDE003.  The following message appears.

 

Call LMS To Have Inventory Transaction File (IMWACTD,X,2X) Enlarged.  The Program Can Not Continue Updating Files Until This Is Resolved.  If This Stop Occurs Outside Of LMS Regular Support Hours, Log Everyone Else Off The System And Run The File Checking Report On Another Task.  Enter C To Continue Program After The Problem Is Resolved.

 

Always call LMS support during the regular support hours with this error.  However, if this occurs on a weekend or late at night, you could try running the file enlarging.  Be sure everyone is logged off the system with the exception of the terminals that have the above error.  After the file is enlarged, entering a C continues the program on.  Note:  If the file checking does not enlarge the file enough, the stop reoccurs.  You could then run the file checking again.  Caution:  If there is an error on the file checking, the first time it is run, DO NOT rerun it.  You have to wait until LMS support is contacted.