Back Order Adjustments (INDE004)

 

Back Order Adjustments is found on the Inventory Data Entry menu, 1-4.

 

The back ordered amount is the quantity that is on back order to your customers.  This is not a back ordered amount from your vendor.  Back order is automatically updated through the program Order Release in the Order Entry module.  When an order is released and an item cannot be shipped, the back ordered quantity is added to the back ordered amount of the item.  When the item is finally shipped through Order Release, the back order amount is reduced and the on hand amount is also reduced.  Order Void, Order File Maintenance, and Invoice Void also adjust the back ordered amount if an item is on back order.

 

The main purpose of the program, Back Order Adjustments, is to correct any errors in the back ordered quantity of an item in a specific warehouse.  The amount may be added or subtracted.  Correction of an error may occur after running the open order reports that reflect back ordered amounts and the reports do not match the back ordered quantities in the Item and Item Warehouse Files.

 

Using Back Ordered Adjustments results in the following functions.

 

Back ordered inventory quantities are increased or decreased in the inputted warehouse.

 

The Stock Activity Inventory Report, which is found in the LMS Inventory module, is updated by Back Ordered 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 Back Ordered Adjustments program.  The report includes the back ordered amounts before and after the entry.

 

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

 

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.

Back Order Adjustments  (Contd)

 

 

Introduction  (Contd)

 

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 back ordered amount.  Once the adjustment has been made, the back ordered amount 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.

Back Order Adjustments  (Contd)

 

 

Enter Data

Transaction Date

 

The transaction date that is input after selecting the program becomes the date the back ordered 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 Back Ordered 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 number is input, 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)

Back Order Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

The next prompt allows entry of the item number that is having the back ordered quantity adjusted.

 

Item Number

 

 

Next to the Item Number prompt is a computer assigned line number.  This is used to select an individual item back order 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.

Back Order 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.

Back Order 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 display.  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.

Back Order 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 back ordered 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.

Back Order 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 back ordered quantity is being adjusted in.

 

Bal  This is the current back ordered quantity of the item in the inputted warehouse prior to this transaction.  This is the back ordered amount generated from Order Release in the Order Entry module.  Any broken pack units are included and are followed by the word Units.  In the above example, 1 is the whole pack quantity and there are no broken pack units back ordered.

 

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 displays.  The items average cost must correspond with the UM and PM.  Average cost is not adjusted by Back Ordered Adjustments.

Back Order 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 back ordered amount.  To subtract from the current back ordered 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 back order 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.

Back Order 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 an 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.

 

 

Back Order 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.

 

Back Order 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 Back Ordered Adjustments and re-enter the program to enter another adjustment for the same item and warehouse.  The reason for this is in order to display the correct back ordered amount before and after and allow changing of the transaction you can only have one record per item per same warehouse on an individual Back Ordered 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 Back Ordered Adjustment transaction run, the following prompt appears.

Back Order 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 back order 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 163.

 

Back Order Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Item Number

 

When END is input at the Item Number prompt or a duplicate back order 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 Back Ordered Adjustments.  When END is entered, one of the two following prompts appears: 

 

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

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

 

 

Back Order 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 goes back one screen.  If the items entered fill more than two 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 150.  Entering an END at the Item Number prompt accesses one of the above prompts.

 

Back Order 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 back ordered 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 back ordered quantity which includes the amount entered on the Add or prior changes.

Back Order 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 back ordered quantity is to be adjusted.  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 back ordered 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 Back Ordered Adjustments transaction.  The carriage return redisplays the Add, Change, Delete prompt allowing selection of that line for a change for that item and warehouse.

Back Order 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 back ordered 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.

Back Order 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 back ordered 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 back ordered adjustment amount for the item.  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.  As an 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.

Back Order 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 back ordered amount including this transaction so reflects the after back ordered quantity.  In the example of the change, Supply was changed from a back ordered adjustment quantity of 1 to 4.  The back ordered amount prior to the Back Ordered Adjustment transaction was 0.  The after back ordered amount is 4.

 

 

 

Back Order 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 back order 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.

Back Order 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 back order 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.

Back Order 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 not to 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 a Back Ordered Adjustments Transaction Report.  If you enter a N for no, you are not be able to print this report.

Back Order 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.

Back Order 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 continues on until the other task exits that record.  This is to protect the integrity of your data so that all the proper updating occurs.

Back Order 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.  Back order 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 Back Order 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 back order 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.

 

BACK ORD BEFORE  The back ordered quantity before entering the adjustment.  Any broken pack units are included with the letters EA following the broken pack quantity.

 

BACK ORD AFTER  The back ordered 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.  The four decimal cost is printed.  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.

 

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

 

DOCUMENT  The entered document number.

Back Order 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 back ordered adjusted cost.  Note:  Costs with more than 2 decimal points are rounded up or down to two decimals for the total.  For example, a cost of 9.075 is rounded to 9.08.

 

Following is a sample report of the back ordered transactions that were used during this documentation.

 

 

Back Order 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

 

 

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

 

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.

Back Order Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

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

Item and Item Warehouse Files

 

The back ordered 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 Back Ordered Adjustments.  Included on the report for items adjusted through Back Ordered 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 Back Ordered 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.

Back Ordered 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 not to 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 INDE004.  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.