Task 04 - Adjust Prices and Costs

Prices can be adjusted, copied and set

Upon entering this task, there is a subtask menu screen. Listed below are all the functions/sub-tasks that are performed in this task, then following the list is a detailed explanation of each sub-task:

#1: Adjust prices by item # (Entry/Edit/Post)

#2: Adjust prices by code/class/pick seq/item# (Immediate update)

#3: Adjust item cost by supplier and effective date

#4: Reset prices over variance by item range (Immediate update)

#5: Set costs/prices by `price code' (end of description)

#6: Copy last cost and/or prices 1-9 from another company

#7: Set costs/prices by supplier (Immediate update)

#8: Copy items from another company (To build new items)

#9: Copy 1 price level to another (within an item)

#10: Change prices by percentage. Product code/item # (Immediate update)

#11: Copy item descriptions from another company (Update descriptions)

#12: Set supplier cost based on discount from price (Immediate update)

#13: Copy supplier data to new vendor #'s

#14: Copy warehouse data to new warehouse #'s

Below are the instructions on how each Sub-task works.

SUBTASK #1: ADJUST PRICES BY ITEM # (ENTRY/EDIT/POST)

What the Sub-task does: Replace, Increase or Decrease an item's price in the Item Master (Task 17). (One item at a time.)

There is an entry and editing in this Subtask. After the changes are made, print an edit list, check the edit list carefully, make any corrections and when everything is correct, post.
The new prices will not be in effect until the post process is completed.

Listed below are the field names, along with the number of characters that each field can have in the parenthesis

Item # : (18) Type in the item # that the price change is to made on (must be a valid item #).

The item's average and last cost will appear on the screen.
Also, the current prices and the profit will appear on the screen.

02. Action : (1) R=Replace, I=Increase, D=Decrease, or P=Percent Discount from retail price (Price1)

R=Replace: NOTE: if using this option, any field left blank will cause the corresponding field in the Inventory file to be reset to zero.

03. Price1 adj : (8) Type in the dollar amount that price level 1 is going to be. The new price and the new profit will appear on the screen.

04. through 11. : (8) Repeat the same for all of the price levels.

SUBTASK #2: ADJUST PRICES BY CODE/CLASS/PICK SEQ/ITEM# (IMMED. UPDATE):

What the sub-task does: It changes the selling prices in the item file.

Allows for a change to the profit by a given percent, or actually replace the current profit level assigned to the items.
This is an automatic update. There is no entry and edit function. As soon as the update is made, the prices are immediately changed.
Selectable ranges are Product Code, Report Class, Change/Replace, Calculation Basis, Picking Sequence and Item #.

Listed below are the system prompts:

Enter Product Code: Enter one, a range or all of the nine product codes

Enter Report Class: Enter up to ten report classes

Change or Replace? (C/R)

Change - Increases profit by the % specified. Use a minus sign (-) to lower.
- Type in the % to increase the profit margin for each of the price levels. Enter 500 for 5%, etc.
- Press the Enter key to make no change to a price level.
- Press the Z key for zero profit margin.
Replace - Replace profit with the % specified. Type in the % of the new profit margin.

Please enter item number: Enter one item number, a range of item numbers or All item numbers.

A report will print (or viewed to the screen) listing all of the item numbers that were changed.

SUBTASK 3. ADJUST ITEM COST BY SUPPLIER AND EFFECTIVE DATE.

What the sub-task does: Can preset future cost changes by vendor, the changes will not be posted into the supplier file until the effective date.

Important: An automatic update may be run at night to pick up the price changes on the date that they are effective. The first time you decide to run this Subtask you must contact us.
Important: Your system will be programmed to look for the date that was specified as the effective date.
If a vendor sends a cost increase notice before the prices are due to go into effect, this Subtask can be used to preset the costs.
This Sub-task has an entry and editing function. Make the changes, print an edit list, check the edit list carefully, make any corrections that may be needed, and when everything is correct, post.
This task uses vendors stock #, not item #.

Listed below are the field names, along with the number of characters that each field can have in the parenthesis

Note: Press the TAB key when first entering this Sub-task; this sets the supplier #, effective date, reset prices, and key mode.

01.Sup stock # : (18) Type in the supplier's stock #. The supplier file must be built for this item already.

Reset Prices:
- N -Net cost only, no price change
- D -New cost and price level 1 with prices 2 - 9 reset
- C - Price 1 only with prices 2 - 9 and Cost reset
- P - New cost with prices 1 - 9 reset using a requested Gross Profit Margin

02.New cost: (8) Type in the new cost.

03.Price 1: (8) Price level 1

SUBTASK #4: RESET PRICES OVER VARIANCE BY ITEM RANGE (IMMEDIATE UPDATE)

What this Sub-task does: It will INSTANTLY change prices if the percent difference between Actual and Requested profit margins in the item master file exceeds a specified number. This is an immediate update. There are no entry, edit, or post functions.

Example: Update prices if margin difference exceeds 5%. Item XX: Current cost: $100.00, Current price: $125.00 Actual profit: 20.00%, Requested profit: 33.33% Since in this example the difference between actual profit and requested profit (13.33%) is greater than 5%, the program would change the price to $150.00, to increase the actual profit back to the requested 33.33%.
There is also an option to skip PRICE 1, if Price 1 & cost are OK and only want to reset Prices 2-9.

Listed below are the system prompts:

Profit variance (ie 5% enter 500): 500___

Enter plus, minus, or both (P,M, or B): P

Plus will change prices only if last cost has increased
Minus will change prices only if last cost has decreased
Both will change prices if last cost has decreased or increased

Please enter - starting item number/ending item number:

Skip Price 1 (Y/N): N - Skip resetting Price 1 if it is a "List Price" with no set profit percent.

Please enter base price level (1-9) - The Price Level the system will look at when testing for the difference between the actual and the required profit.

When the process is complete, on the screen the system states how many records were checked and modified.

SUBTASK #5: Set Costs/Prices by "Price Code" (end of description)

What this Sub-task does: This task can change selling prices and/or purchase costs in the item and supplier files.

Change average cost, last cost, supplier quote price, and the nine standard item selling prices for groups of items.
Choose up to 15 separate price-code groups at a time.
There is also an option to change price codes.
Selectable ranges are product code, report class, item #, price code (end of description), and vendor # (for supplier file information). NOTE: Vendor # does not restrict the updating of item file information; only supplier file records.

Listed below are the system prompts:

Enter Product Code: Enter one, a range or all nine product codes

Enter Report Class: Enter one, a range or all report classes

Enter Item Numbers: Enter one, a range or all item numbers

Screen appears with:

Starting price code/ending price code:
New price code:
New average cost and last cost:
Vendor quote price and Vendor #:
Price 1 thru 9

When the process is complete, on the screen the system states how many items and supplier records were modified.

SUBTASK #6: Copy Last Cost and/or Prices 1-9 from Another Company

What this Sub-task does: Some customers have more than one corporation on their computer system - noted by a Company List in addition to the regular Module List. This Subtask is for copying costs and/or prices from one company to another. (This would only be used if the separate companies sold the same items.)

This is an immediate update program.
Selectable ranges are item #, product code, and report class.

Listed below are the system prompts: Note: must be in the company that the prices/costs will be copied INTO. I.e. if prices are to be copied from Company 1 into Company 3, you MUST run this task while in Company 3

Enter company # to copy prices from:

Enter - starting item number/ending item number:

Enter - starting product code/ending product code:

Enter - starting report class/ending report class:

The next screen shows the selections for the above four questions, then proceeds to prompt for which cost and price fields should be updated. Answer prompts with Y or N (default is N).

When the process is complete, on the screen the system states how many items have been modified

SUBTASK 7: Set Costs/Prices by Supplier (Immediate update)

What this Sub-task does: It changes the last cost and prices in the item master, and the last cost in the supplier master, immediately. NOTE: DO NOT change prices if your pricing is based on list price and discount percentages. ONLY consider if selling prices are based on last cost and requested gross profit.

This is an automatic update. There is no entry and edit function. As soon as the update is made, the prices and costs are immediately changed.

Changes the last cost in the supplier file and the last cost in the item file and optionally resets item prices based on original profit margins & new cost.
Selectable ranges are vendor #, stock #, item #, product code, report class, picking sequence (with choice of warehouse), type of cost change (new $ or % change), and new cost/change amount.

Listed below are the system prompts:

Vendor number:

Enter - starting/ending Stock Number: The number that vendor refers to, it's field # 4 in the Supplier Master- Task 18

Enter - starting/ending Item Number:

Enter Product Code: Enter one or ALL for the nine Product Codes.

Enter Report Class: Enter up to 10 Report Classes

Enter - starting/ending Picking Sequence: The sequence # is in field #7 in the Warehouse Master - Task 19

Enter type of cost change: $ for new dollar cost, or % to specify a percent change

$ - enter the actual cost. If the new cost will be $25.75, enter 2575
% - enter the actual increase or decrease percent. Use 500 for 5% increase and -475 for 4.75% decrease.

When the process is complete, on the screen the system states how many records have been checked and modified

SUB-TASK 8: Copy Items from Another Company (to build new items)

What this Sub-task does: This Subtask is for copying items from one company to another.

The inventory items will be copied into the Inventory (Task 17) and Supplier (Task 18) Files exactly the same.

The Warehouse File (Task 19) will be copied with the quantity fields set at zero.

Listed below are the system prompts: Note: must be in the company that the items will be copied INTO. I.e. if items are to be copied from Company 1 into Company 3, you MUST run this task while in Company 3

Enter company # to copy items from:

Enter - starting item number/ending item number:

When the process is complete, on the screen the system states how many items have been added to the inventory, supplier and warehouse files.

SUB-TASK 9: Copy 1 Price Level to Another (within an item)

What this Sub-task does: It will copy one price level to another, with the option of copying the corresponding discount table setups. NOTE: The original information will not be recoverable.

Selectable ranges are item #, product code, and report class.

System prompts are as follows:

Price Level to Copy from: choices are price levels 1 - 9, Last or Average cost.

Price Level to Copy to: choices are price levels 1 - 9, Last or Average cost

Enter starting/ending Item numbers:

Enter starting/ending Product Code numbers:

Enter starting/ending Report Class numbers:

Copy Quantity Table Y/N

SUB-TASK 10: Change Prices by Percentage. Product Code/Item# (Imm update)

What this Sub-task does: It allows changes to the selling prices in the item file by the percent of change specified.

This is an immediate update, no edit or posting is required
NOTE: If price level 1 is changed, but the other levels aren't changed, the discount percent will change because the selling prices will remain the same. Example: if there is a 5% increase, increase ALL the prices by 5% to maintain the same discount.

Selectable ranges are product code, picking sequence, and item number.

System prompts are as follows:

Increase or Decrease (use - sign) selling price for all 9 levels. Enter 300 for 3%.

Are you ABSOLUTELY sure you want to do this: Y/N

Option of print the changes or view the changes to the screen.

Enter Product Code: Enter all the product code numbers that will be changed.

Enter starting/ending Picking Sequence: The sequence # is in field #7 in the Warehouse Master - Task 19

Enter starting/ending Item numbers:

SUB-TASK 11: Copy Item Descriptions from Another Company (Update descrs)

What this sub-task does: This resets item descriptions by company number.

Only company numbers from 1-7 can be used.

System prompts are as follows:

Enter company number to copy descriptions from:

Enter starting/ending item numbers:

When the process is complete, on the screen the system states how many items have been modified

SUB-TASK 12: Set Supplier Cost Based on Discount from Price (Imm update)

What this sub-task does: An immediate change to the "Last Cost" in the Supplier Master File (Task 18) based on a discount percentage of a selected price level from Item Master File (Task 17)

Option to also update the Last Cost in the Item Master File
The Supplier quote price will not be changed.
This is an immediate update, no report or edit is available
Selectable ranges are vendor number, item number, price level, and discount percent.

System prompts are as follows:

Enter starting/ending Vendor number:

Enter starting/ending Item number

Use which Price Level: Enter 1 thru 9

Discount %: Use 1000 for 10%

Update Item Master File "Last Cost" also: Y/N

SUB-TASK 13: Copy Supplier Data to New Vendor #'s

What this Sub-task does: It copies a Vendor's Supplier data (Task 18) to the Supplier File of new Vendors.

System prompts are as follows:

Item Number:

Enter Vendor number to copy FROM:

List with up to 15 vendors that the Supplier data will be copied TO:

When the process is complete, on the screen the system states the number of new item/supplier records were created.

SUB-TASK 14: Copy Warehouse Data to New Warehouse #'s

What this Sub-task does: It copies the Warehouse data (Task 19) to the Warehouse Files of a new division.

System prompts are as follows:

Enter starting/ending item numbers:

Enter Warehouse Number to copy FROM:

List up to 15 new warehouses that Warehouse data will be copied TO:

When the process is complete, on the screen the system states the number of new warehouse records were created.