APPX Software Library

1Transaction Processing

Option 3Product Transfers

This function allows you to transfer a product from one product number, warehouse number, or unit of measure to another.

If a product is transferred, on hand quantities in Products By Warehouse records for both the new and the old warehouses are updated. Any difference in cost is entered in the Additional Unit Cost field and posted to the General Ledger account entered on the transaction.

When you enter product transfers, you see only one of the two possible screens for Product Transfers Control Groups. Which screen you see depends on how you answered two questions on your Parameters file. These are the “Ask Operator ID?” question, and the “Use Transaction Control?” question.

If you answered ‘Y’ to both questions, you see the first screen and can enter control and hash totals for your product transfers. In addition, a record is written to the Transaction Control file for each group posted.

If you answered ‘Y’ to “Ask Operator ID?”, and ‘N’ to “Use Transaction Control?”, you see the second screen, which displays only the Operator ID and the Control Number.

If you answered ‘N’ to both questions, you see the second screen, but you are not allowed to edit the Operator ID.

On the following pages, the screens displayed by this function are shown.

The following screen presents information on Product Transfers Control Groups.

Product Transfers Control Groups screen

The Product Transfers Control Groups Screen
Figure 10

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press RETURN; the record will be displayed for editing.

Data items for the preceding screen are described below:

Operator ID

Letters and numbers only Required Carries forward in ADD mode

Enter an uppercase alphanumeric field, up to 3 characters in length.

The operator ID you entered at log-on is displayed. The default may be changed in order to edit transactions for another operator. All control groups are separated by operator.

Control No

Positive number, up to 4 digits

A sequential number is supplied to identify this group of product transfers. This number is printed on the journal, tracked on the Transaction control file, and if General Ledger is part of your system it is posted to General Ledger for detail accounts. Although this number need not be exactly sequential, the number itself is important as a part of your audit trail.

Operator Exclusive?

Y or N Default N Required

Indicate whether or not you are reserving exclusive rights to this group of product transfers.

Y
Yes, access is restricted to the original operator. N: No, access is not restricted.
Description

Alphanumeric, up to 30 characters Required

Describe this group of product transfers. This description will appear on the Transaction Control report and inquiry.

Quantity Control Total

Number, up to 9 digits and 2 decimals

Enter the adding machine total of all product transfer quantities to be entered. This entry is balanced against the running total kept by the system as product transfer entries are made.

The system displays the running total of quantities entered in the “Current” field, and the balance remaining is shown in the “Remaining” field.

This field is optional.

Product Hash Total

Positive number, up to 12 digits

Enter the total of all product numbers to be entered in this control group. The system will keep a running total of product numbers and balance it against this entry.

This field is optional.

Print Journal?

Y or N Default Y Required

‘Y’ is displayed to indicate that this group is ready for journal printing. If you want to delay journal printing for any reason, enter ‘N’.

Journal OK?

Y or N Display only Default N

The system displays ‘Y’ or ‘N’ to indicate whether or not this group has been verified (the journal printed and no errors are present) and is correct.

Post Now?

Y or N Default Y Required

‘Y’ is displayed to indicate that this group is ready for posting. If you want to delay posting for any reason, enter ‘N’.

The entered data is validated. Press RETURN to save the information on this screen.

Select the Next Record option to go to the next Product Transfers Control Groups record.

At this screen, the use of the MODE keys—ADD, DEL, CHG, or INQ—pertain to those records in the Product Transfers Control Groups file.

This screen may optionally be used to display information about Product Transfers Control Groups.

Product Transfers Operator ID screen

The Product Transfers Operator ID Screen
Figure 11

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press RETURN; the record will be displayed for editing.

Data items for the preceding screen are described below:

Operator ID

Letters and numbers only Carries forward in ADD mode

Enter an uppercase alphanumeric field, up to 3 characters in length. This field required.

The operator ID you entered at log-on is displayed. The default may be changed in order to edit transactions for another operator. All control groups are separated by operator.

Control No

Positive number, up to 4 digits

A sequential number is supplied to identify this group of product transfers. This number is printed on the journal, tracked on the Transaction Control file, and if General Ledger is part of your system it is posted to General Ledger for detail accounts. Although this number need not be exactly sequential, the number itself is important as a part of your audit trail.

Press RETURN to save the information on this screen.

Select the Next Record option to go to the next Product Transfers Control Groups record.

At this screen, use of the MODE keys — ADD, DEL, CHG, or INQ — pertain to those records in the Product Transfers Control Groups file.

The screen shown below presents information about Product Transfers.

Product Transfers screen

The Product Transfers Screen
Figure 12

Certain entries on this screen will be automatically displayed. In most cases, the displayed entry can be changed. If an asterisk (*) appears next to one of the fields listed below, it indicates a “display only” field, which cannot be changed.

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press RETURN; the record will be displayed for editing.

Data items for the preceding screen are described below:

Transaction No

The system automatically assigns a transaction number, beginning with ‘1’.

Reference

Enter up to 6 characters to further describe and reference the product transfer.

Date

The system displays today’s date. You may override the display.

Post Mo/Yr

Enter up to 2 characters each for the month and year to identify the calendar month and year to which this transaction is to be posted. Valid entries are:

1
13: Calendar period EY: End-of-year
Product Out

Enter the number of the product being transferred from inventory. You can use the Scan option to find an appropriate entry. This product number must be on file in the Products file.

The system displays the corresponding description from the Products file so that you may verify your entry.

Inventory Acct Out*

The system displays the inventory account identified on the product’s Product Classes record.

If General Ledger is part of your system, the system displays the corresponding description from the Chart of Accounts file.

Warehouse Out

Enter the number of the warehouse from which the product is being transferred. You can use the Scan option to find an appropriate entry. This number must be on file in the Warehouses file; the combination of this number and the “Product Out” number must be on file in the Products By Warehouse file.

The system displays the corresponding description from the Warehouses file so that you may verify your entry.

Quantity

Enter up to 5 digits and 2 decimals for the number of stockkeeping units of the Product Out being transferred from the inventory at the “out” warehouse.

U/M*

The system displays the unit of measure for the Product Out from the Products file.

Product In

Enter the number of the product being transferred to inventory. This product number must be on file in the Products file.

The system displays the corresponding description from the Products file so that you may verify your entry.

Inventory Acct In*

The system displays the inventory account identified on the new product’s Product Classes record.

If General Ledger is part of your system, the system displays the corresponding description from the Chart of Accounts file.

Warehouse In

Enter the number of the warehouse to which the new product is being transferred. You can use the Scan option to find an appropriate entry. This number must be on file in the Warehouses file; the combination of this number and the “Product In” number must be on file in the Products By Warehouse record.

The system displays the corresponding description from the Warehouses file so that you may verify your entry.

Quantity

Enter up to 5 digits and 2 decimals for the number of stockkeeping units of the Product In being transferred to inventory at the “in” warehouse.

U/M*

The system displays the stockkeeping unit of measure identified for the Product In from the Products file.

Addl Unit Cost

Enter up to 6 digits and 3 decimals for the cost per unit that you wish to add to the cost of Product Out in calculating the cost of Product In. This figure is used in the following formula:

Cost Inventory In = Cost Inventory Out + (Quantity In x Addl Unit Cost)

GL Account

Enter the General Ledger account number to which additional unit cost is posted. You can use the Scan option to find an appropriate entry. If the General Ledger application is part of your system, this account number must be on file in the Chart of Accounts file. The corresponding description is displayed so that you may verify your entry.

This entered data is validated. Press RETURN to display system-supplied information and then press RETURN again to save the information on this screen.

Select the Previous Image option to go back to the Product Transfers Control Groups screen. Select the Next Record option to go to the next Product Transfers record. Select the END option to go to the next Product Transfers screen.

At this screen the use of the MODE keys—ADD, DEL, CHG, or INQ—pertain to those records in the Product Transfers file.