PeachPro sets you free
|
|
|
|
PeachPro sets you free
|
| IAP Advanced Price Changing Options |
Control Your Costs and Your Profits! Fluctuating costs can be time consuming and profit draining. With this great new enhancement, you get high speed price entry that lets you set prices with minimum keystrokes and formulas so flexible you can easily calculate new prices as discounts from list or markups from cost and much more. You get profit grabbing rounding options including the 5/9 roundup rule. Comprehensive "What-If" reports can be printed before actually changing the prices.
With IAP - Advanced Price Changing Options you can calculate each price level individually or use improved range selections to select and adjust items for any combination of departments, item numbers, vendors and/or vendor item numbers. If you have enhancement IAC - Adjust Current/Last Cost, Last Cost and Current Cost can be also be changed with this powerful tool, as well as Quantity Prices and Levels if you own IQP - Ten Quantity Price Levels!
IAP - Advanced Price Changing Options allows you to base your calculations on existing prices, last cost, current cost, a base price entered in the formula, an amount entered at the keyboard or a newly calculated price. You can optionally add a fixed amount to the calculated price, choose the number of decimal places to use, and round up to the next 5 or 9, instantly adding 2% to your gross profit margin! Special Hot Keys automatically set gross profit margins for you and allow you to save your settings for future sessions. Each new price can be reviewed as it is calculated for each item, then approved or overwritten, or you can use automatic mode for high speed changes.
Detail, Summary, or Errors Only control reports can be printed, or you can print comprehensive "What If" reports that show you the result of calculated price changes, before any changes are made to your files.
QUICK START:
Before using IAP - Advanced Price Changing Options, MAKE A BACKUP OF YOUR INVENTORY DATA FILES. The new program is designed to make many changes quickly. If you make a mistake entering a price change, a backup will allow you to easily correct your mistake. If you don't make a backup, a mistake could be very time-consuming to correct.
To use Advanced Price Changing Options, select "Change Inventory Item Prices" from the Inventory Maintenance menu. The following menu option will display:
+======== Price Change Options =========+ | S - Standard Price Change Options | | E - Enhanced Price Change Options | +=======================================+
If you want to use the regular price changing options that come with Peachtree Complete Accounting, select "Standard Price Changing Options". If you want to use IAP - Advanced Price Changing Options, select "Enhanced Price Changing Options".
After selecting Enhanced Price Changing Options, you will see the following screen:
+-------------------------------------------------------------------------+ |+=======================================================================+| ||INMAINT2 Change Inventory Item Prices COMPANY ID: SP || ||12/28/92 Software Professionals, Inc GENERATION #: 12 || |+=======================================================================+| |+========== Options ===========+ Currently Selected Options: | || T - Select Item Type | Type : All | || D - Select Department Range | Dept : All | || I - Select Item Number Range | Item : All | || V - Select Vendor Range | Vendor: All | || C - Select Costing Type | Costing Types: A, S, L, F, U | || R - Select Report Options | Report: Errors Only | || F - Enter Formulas | | |+==============================+ Formulas: | |Calc Use Base Price Multiply By Add Rnd 5/9 New Price | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | F1-Help F5-Calculate F7-Import/Export F10-Menu Shft F10-Home | +-------------------------------------------------------------------------+
Use the first five selections on the Options menu to select the items you wish to change. Use "R" to select report options and "F" to enter or change formulas. Press F1 for help at any field.
To save and later retrieve your options and formulas use "F7-Import/ Export". This can save you considerable time since you won't have to retype your formulas every time. You can also use "F7" to move formulas between different companies.
When you are ready to calculate new prices, push "F5-Calculate". The first item that matches your options, and the new calculated price, will be displayed. You can review these prices to make sure that your formulas are correct before the new prices are saved. If they are correct, you have the option of manually reviewing each price or using automatic mode, which quickly calculates and saves each price, without prompting you to save.
If they are not correct, you can return to the options menu.
You can change the prices for All Item Types, Products Only or Services Only.
You can change all departments or a range of departments. If you have selected Range of Departments, you must enter both the first and last departments in the range. If you are unsure of which departments to enter, you can push F2-Lookup.
+========== Options ===========+ | T - Select Item Type | | D - Select Department Range | | I - Select Item Number Range | | V - Select Vendor Range | | C - Select Costing Type | | R - Select Report Options | | F - Enter Formulas | +==============================+
You can change all items or a range of items. You can change the same items in multiple departments by selecting range of items and either all departments or a range of departments. If you choose Range Of Items, you will be asked for the first and last item in the range.
To allow you to change the same range of items in multiple departments, selecting an item range does not affect your Type or Dept selections.
You can push F2 to see a list of items, but unless you have enhanced lookup options, the display in the lookup box might include items from multiple departments and is only sorted in item sequence within each department. When you select an item from the lookup box, you will only affect the item range. You will not be able to change your Type or Dept selections even though both type and department are displayed in the lookup box.
You can change prices for items of all vendors or a range of vendors. When you use "Standard Price Change Options" and select Range of Vendors, items are processed in vendor sequence. But in "Enhanced Price Change Options" (this program) selecting a vendor range does not change the processing sequence. The processing sequence is still Item Type, Department and Item. This is because here you select items by four additional criteria at the same time you select a vendor range.
If you have selected the Range of Vendors option, you must enter both the first and last vendors in the range. If you are unsure of which vendors to enter, you can push F2-Lookup.
You can select items to change by the costing type. You can change all items, or only those with specific costing types (Lifo, Fifo, Average, Standard or Specific Unit). You must choose at least one costing type.
You have three report options: Errors Only, Summary or Detail.
Errors Only Report - Nothing will print if all calculations result in valid prices. If a calculation results in a price that is larger than 9999999.99, a cost that is larger than 99999.99 or a negative price or cost, and you are calculating in Automatic mode, then that item will be printed on the report.
Summary Report - Includes everything on the Errors Only report. Plus, even if no errors occur, the options, formulas and number of items changed will print.
Detail Report - Includes everything on the Summary report plus the items and prices changed. Both the old price and the new prices are printed.
Hint-> What-If Report: If you calculate prices with the calc column empty, new prices will be displayed on your screen but no prices will be saved EVEN IF YOU ANSWER "Y" to SAVE NEW PRICES. This might be useful if you just want to see what will calculate without actually saving anything.
Leaving the "Calc" column blank and choosing "Detail" Report will print a comprehensive "What-If" report without actually changing prices.
Press "F" from the Options menu to enter formulas. You can base price changes on any price or cost. The new price is calculated based on the formula you enter. First the base price is taken from the field in the "Use" column. The base price is multiplied by the number in the "Multiply By" column and then the number in the "Add" column is added. This result is then rounded to the number of decimal places in the "Rnd" column and if there is a "Y" in the "5/9" column, the rounded digit is then raised to the next "5" or "9".
+-------------------------------------------------------------------------+ |Calc Use Base Price Multiply By Add Rnd 5/9 New Price | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | 1.0000000 0.0000 4 N | | F1-Help F5-Calculate F7-Import/Export F10-Menu Shft F10-Home | +-------------------------------------------------------------------------+
Calc Column - The Calc column specifies which prices to save. Enter the code of the field that you wish to change. Press F2 to see a list of available codes. Most of the codes are obvious --like Price A which is the first price in the first screen of Maintain Inventory Items. A few require additional explanation.
If you have enhancement IQP - Ten Quantity Prices then you will have available price codes P0, P1, P2 ... P9. P0 is the default price and will be used if the customer does not order a large enough quantity to qualify for the first price break. P1 thru P9 represent the prices when the customer orders the required minimum quantities. Price codes Q1 thru Q9 are not actually prices, but are the minimum quantity required to get the corresponding "P" price.
For example, if a customer's order is at least the amount in Q1, they get price P1. Codes Q1 thru Q9 give you an easy way to establish the minimum quantity to qualify for a price break. You can also use the "ZE" code in the "Use" column to set the same quantity breaks for a group of items. If you own IAC - Adjust Current Cost, you may also change Current Cost or Last Cost.
The Calc column can be blank. If it is not blank, it must contain a valid code. Available codes are displayed when you push F2-Lookup from a line in this column. Additional information is available by pushing F1-Help after you push F2-Lookup. If the "Calc" column of a line is blank, no prices for that line will be saved -- even if you answer "Y" to the Save Prices prompt.
Hint-> What-If Preview - If you calculate prices with the calc column empty, new prices will be displayed on your screen but no prices will be saved EVEN IF YOU ANSWER "Y" to SAVE NEW PRICES. This might be useful if you just want to see what will calculate without actually saving anything.
Use Column - Enter the code of the field that you wish to use as the basis for calculating the new price. You may base your prices on price A, B, C, D, E, Last Cost, Current Cost or Quantity Price Levels. Push F2 to select from a list of available codes.
Code "IN" allows the new price to be entered from the keyboard for each item. This allows new prices to be entered much faster than using Maintain Inventory Items. It is also great when you need to enter one price and then use that new price as the basis for the other prices.
Code "ZE" will ignore the current price and allow you to enter a new price in the "Add" column. This code is useful when you want to set the same price for a group of items, since you only have to enter the price once and it is used for all the items you calculate.
You must enter at least one field in the use column before you can exit "Enter Formulas". If you change your mind, or select Enter Formulas by mistake, you can enter ZE in the use column and press F10 to exit. Prices will not be changed unless you press F5-Calculate.
Advanced Topic-> Chained Calculations - If you put the same code in the "Use" column that you entered into a previous line in the "Calc" column, the newly calculated value is used instead of the original. This allows you to "Chain" calculation so that you can add and multiply by more than one value to arrive at a new price.
Multiply By - Enter the number to multiply by in order to calculate the new price. The multiplication function is calculated before the addition in the "Add" column. If you don't want to multiply, enter a "1" in this column.
You can enter a negative or positive percent change, then push "F5-Convert % Chg" and the percent change will be converted to a multiplier. For example, if you enter "-10" and push "F5" the number will change to ".9" and if you enter "15" and push "F5" the number will change to "1.15".
You can also enter a desired gross profit and push "F6-Convert GP%". This is most useful when you are basing a new price on cost. When the use column is based on cost, you can push "F6" and the number in the multiply column is converted so that the final price will result in the desired gross profit percentage. For example, if you enter "33.333333" and push "F6" the number will change to "1.5". You can only use "F6" if the number you enter is less than 99.
Add Column - Enter the number to add in order to calculate a new price. This addition is done after the multiplication. If you don't want to add, enter a "0" in this column. To subtract, enter a negative number. If you use a negative number, you need to make sure that the calculation will not result in a negative price which will cause an error.
Rnd Column - Enter the number of decimal places to round the final price. If you want the price rounded to cents, enter a "2". If you want it rounded to 10th of a cent, enter a "3". Valid entries are -4,-3,-2,-1, 0, 1, 2, 3, and 4. Use a negative number if you want rounding to the left of the decimal point. For example, if you wanted the price to be in even 100's of dollars, you could enter a "-2".
For example, with "2" in the "Rnd" column, a price of "1.5432" would be changed to "1.54" and a price of "1.5471" would be changed to "1.55". With a "4" in the "Rnd" column to previous two prices would not be changed. With a "-2" in the "Rnd" column a price of "101542" would be changed to "101500" and a price of "101561" would be changed to "101600". The number you enter here also specifies the digit to adjust if you answer "Y" in the "5/9" column.
5/9 Column - Enter "Y" if you want all your prices to end in either a "5" or a "9". If you enter "N", no special adjusting of your prices is done.
When you enter "Y", prices are rounded up. The digit specified in the "Rnd" column is adjusted. If this digit is a "0" thru "4", it is changed to a "5". If it is a "6" thru "8" it is changed to a 9.
For example, with "2" in the "Rnd" column, a price of "1.56" would be changed to "1.59" and a price of "1.50" would be changed to "1.55". With "0" in the "Rnd" column, a price of "1547" would be changed to "1549". This upward adjusting of a price is often not noticed by the customer, but results in additional profits.
You can save the current Options and Formulas and later retrieve them. This will save you considerable time when updating your prices since you will not have to re-enter all the formulas and options.
You also have the option of updating the default options and formulas. The defaults are automatically selected when you start this program.
Import Options and Formulas from a File - Select this option when you want to retrieve options and formulas from a file you have previously exported. You will be asked to enter the name of a file to which you have previously exported. You can precede the file name with a path using the standard DOS format. If you don't enter a path, the directory where the Peachtree programs are loaded will be used.
Export Options and Formulas to a File - Select this option when you want to save your options and formulas so you can import them later. You will be asked for the name of a file to save your options in. Enter a valid DOS file name. If you are unfamiliar with the requirements of DOS files, you should enter a name that has eight characters or less and contains only letters and numbers. Use names like PRICE1 or FORM25. If you are familiar with DOS files, you can enter any path and file name using the standard DOS format. The file name that you enter is passed directly to DOS for processing.
Save Current Options and Formulas as Defaults - Select this option to save your current options and formulas as the defaults for future sessions.
Use this option to save your most common options and formulas. They will be loaded automatically each time you use this program.
Reload Default Formulas and Options - Select this option when you want to set the current options equal to the defaults -- perhaps after you have imported or otherwise changed the options and formulas.
Press F5 - Calculate after you have selected your Item Options and entered the appropriate formulas, when you are ready to calculate new prices.
The first item matching your range selections will be displayed on your screen. The base prices (from the "Use" column) will be displayed along with your formulas and the newly calculated prices. You will be asked the following question:
Y - Answer "Y" to save the new prices and go to the next item (if the "Calc" column is blank, prices won't be saved even if you answer "Y").
N - Answer "N" to go to the next item without saving the new prices.
A - Answer "A" to calculate and save prices for all selected items, automatically without stopping after each item and asking whether you want to save.
R - Answer "R" to re-calculate prices. This choice is only useful when you have code "IN" in the "Use" column. In this case, it allows you to re-enter your base prices.
O - Answer "O" to override the calculated prices and manually enter different prices.
X - Answer "X" to stop calculating. You can also push F10-Done. This will return you to the Options Menu. All prices you have saved to this point will still be changed and prices that you have not yet saved will not be changed.
Base Price - If the "Use" column contains "IN", you will be asked to enter a base price for each item. Enter a positive number to use as the basis for the price calculation on this line. To calculate the New Price, the number you enter here will be multiplied by the number in the "Multiply By" column and then the number in the "Add" column will be added. After that, rounding will be done based on the "Rnd" and the "5/9" columns. The number you enter for base price cannot be negative.
|
