On Order Posting-Adjustments (INDE001)

On Order Posting/Adjustments is found on the Inventory Data Entry menu, 1-1.

 

The on order amount is the amount that is on order to your vendors.  There are two ways to add to the on order quantities of items.  On Order is updated automatically when a purchase order is created through the Purchase Order module.  The other is to use the On Order Posting/Adjustment program.  For systems not using the Purchase Order module, the only way to enter on order quantities is to post them through the On Order Posting/Adjustment program.

Obviously if on order is being added to, it needs to be reduced when the items are received into inventory.  When items on purchase orders are received into inventory, through P.O. Receipts, the on order is automatically reduced.  Inventory Receipts also reduces the on order amount if it is greater than zero based on the setup of the Global File.  For those systems that use the Purchase Order module, having Inventory Receipts reduce the on order amount may be incorrect as the item may also be on a purchase order and will then be adjusted incorrectly unless only non-P.O. items are posted through On Order Posting.  For the systems not using Purchase Order that are posting on orders through the On Order Posting/Adjustment program, you want it reduced by the receipt.  Thus, how on order is posted depends on the proper setting of the Global File to reduce on order.

 

The other use of On Order Posting/Adjustments is to correct any errors in the quantity that is on order in a specific warehouse.  The amount may be added or subtracted.

 

Using On Order Posting/Adjustments results in the following functions.

 

On Order 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 On Order Posting/Adjustments.  Any item entered 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 Order Posting/Adjustment program.  The report includes the on order amounts before and after the entry.

On Order Posting/Adjustments  (Contd)

 

 

Introduction  (Contd)

 

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.

 

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 is removed and the screen scrolls up rather than clearing the screen and beginning a new screen.  Therefore, 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 order amount.  Once the adjustment has been made, the on order 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 an option to go directly to the item record and make changes.

On Order Posting/Adjustments  (Contd)

 

 

Enter Data

 

Transaction Date

 

The transaction date that is input after selecting the program becomes the date the on order 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 Order Posting 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 order amount of the item is to be adjusted.  Warehouse can only be numbers 1 to 9999.  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 Order Posting/Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items

The next prompt allows entry of the item number that is having the on order 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 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 Order Posting/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 Order Posting/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 N for next or carriage return to accept the default of N for next.

 

When a N for next is entered, 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 appear.  The cursor returns for reinput.  An existing line number from a previous screen can be entered.

On Order Posting/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 order 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 Order Posting/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 order quantity is being adjusted in.

 

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

 

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 items average cost must correspond with the UM and PM.  All four decimal places are displayed.  Average cost is not adjusted by On Order Posting.

On Order Posting/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 ^ to go back one space returns you 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 order amount.  To subtract from the current on order 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 order by a broken pack or unit quantity, 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 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.  Therefore, it 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 Order Posting/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 ^ to go back one space 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 and calculates to the four decimal positions.

 

 

On Order Posting/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 is 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 Order Posting/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 Warehouse prompt on line 9.  After an item is entered for line 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 and 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 Order Posting 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 order before and after and allow changing of the transaction.  You can only have one record per item per same warehouse on an individual On Order Posting/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 Order Posting transaction run, the following prompt appears.

On Order Posting/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 order record for that item and warehouse.  You 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 to allow a change of information.  For operating instructions in the change mode, see page 32. 

 

On Order Posting/Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

Entering the Items  (Contd)

 

Item Number

 

When END is input at the Item Number prompt or a duplicate on 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 On Order Posting.  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:

 

 

On Order Posting/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 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 essentially back in the original Add mode.  Operation is the same as described beginning on page 20.  Entering an END at the Item Number prompt accesses one of the above prompts.

On Order Posting/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 order record to be changed.  The following prompt appears.  Note:  The item does not have to be displayed on the screen to be selected for a change.

 

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

On Order Posting/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 order quantity is to be adjusted.  If an invalid warehouse 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 order 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 have 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 Order Posting transaction.  The carriage return redisplays the Add, Change, Delete prompt allowing selection of that line for a change for that item and warehouse.

On Order Posting/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 order amount is updated for the item in the warehouse.  Enter a N for no not to 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 Order Posting/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 order quantity prior to the adding of this record.  An up arrow ^ to go back one space 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 order adjustment amount for the quantity on order.  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 to 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 Order Posting/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 ^ to go back one space 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 order amount including this transaction so reflects the after on order quantity.  In the example of the change, Part9 was changed from an on order adjustment quantity of 2 to 3.  The on order amount prior to the On Order Posting transaction was 3.  The after on order amount is 6.

 

 

On Order Posting/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 order posting to be deleted.  The following prompt appears.  Note:  The item does not have to be displayed on the screen to be selected for a delete.

 

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 Order Posting/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 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.

On Order Posting/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.  You have one chance to print an On Order Posting Transaction Report.  If you enter a N for no, you are not be able to print this 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.

On Order Posting/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 Order Posting/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 appear: 

 

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 Order Posting/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 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 On Order Posting.  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 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.

 

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

 

ON ORD AFTER  The on order 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 and includes four decimal points.  If an E for each was entered, the unit or each cost is printed.  Cost is printed with the four decimal positions.

 

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

 

DOCUMENT  The entered document number.

On Order Posting/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 order 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 order transactions that were used during this documentation.

 

 

 

On Order Posting/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 item adjustments have been entered, the following prompt appears.  A message No Adjustments Made appears on the screen.

 

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 Order Posting/Adjustments  (Contd)

 

 

Enter Data  (Contd)

 

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

Item and Item Warehouse Files

The existing on order amounts are either added to or subtracted from 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 Order Posting/Adjustments.  Included on the report for items adjusted through On Order Posting 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 Order Posting 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 Order Posting/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 the operator 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 INDE001.  The following message also 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.