Use the Manual Cost Change Update program to change the manual cost stored in the vendor/item file for selected items of a vendor.
You have the option to:
Select the vendor for the cost change update.
Select the beginning and ending item numbers for the cost change update for the selected vendor.
Select the item class for the cost change update.
Update the manual cost using last vendor, standard, average, last or manual costs, or by percent.
Select the warehouse the cost change update.
The manual cost field may also be accessed through the Vendor/Item F/M program. This update program provides a quick way to update large groups of records.
Access this program by choosing Purchase Orders -->File Maintenances -->Manual Cost Change Update.
1. Vendor
Enter the number of the vendor for whom manual costs are to be updated. The entry must be a valid vendor number. Press F2 or select the icon to perform a search.
2. Beginning Item
Enter the beginning item to update. Press Enter to default to the first item on file in the vendor/item file for this vendor. Press F2 or select the icon to perform a search. Select the icon to start with the first code on file for the last item on file in the vendor/item file for this vendor.
3. Ending Item
Enter the ending item to update. Press Enter to default to the last item on file in the vendor/item file for this vendor. Press F2 or select the icon to perform a search. Select the icon to end with the last item on file in the vendor/item file for this vendor.
4. Item Class
Enter the item class to which an item must belong to be updated. The entry must be a valid item class code. Press F2 or select the icon to perform a search. Press Enter or the icon to process all item classes.
5. Change
Enter P, V, S, L, A or M to determine how the manual cost is updated.
P |
Percent. Enter the percent to change by. For example, to increase the manual cost by five percent, enter 5. To decrease the manual cost by two percent, enter -2. |
V |
Vendor last. The manual cost is set equal to the last cost stored in the vendor/item file. |
S |
Standard. The manual cost is set equal to the standard cost stored with the item in the inventory control item file. |
L |
Last. The manual cost is set equal to last cost stored with the item in the inventory item file. |
A |
Average. The manual cost is set equal to the average cost stored with the item in the inventory item file. |
M |
Manual. The manual cost is set equal to manual cost stored with the item in the inventory item file. |
6. Warehouse
If manual costs for only those items stored in a specific warehouse are needed, enter the warehouse code. Records are updated only for items located in the vendor/item file for the selected warehouse. Press F2 or select the icon to perform a search. Press Enter or the icon to process all warehouses.
For more detailed information on file maintenance programs, consult the following topics.