Purchase ➔ Price management ➔ Price lists
In Exact Globe, you can generate or update price lists on purchase prices and price agreement for a specific supplier and currency in Microsoft Excel using the price lists functionality.
The information in this document is based on product update 401. If you have versions lower than this, certain features explained here will not be applicable.
Print
Select this to generate the price list in the Microsoft Excel spreadsheet. This price list is not updated to Exact Globe.
Maintain
Select this to generate price list in the Microsoft Excel spreadsheet. This updates the price list with a new price to Exact Globe.
Range section
Currency
Select the currency to print or maintain price list for the selected currency. This information is mandatory.
Supplier
Select the supplier to print or maintain the price list for the selected supplier. This information is mandatory.
Date
Select a range of dates to print or maintain the price list for the selected dates. Select the All check box to generate price list for all date range.
Item
Select an item or a range of items to print or maintain the price list for the selected item(s). Select the All check box to print or maintain the price list for any items.
Item group
Select an item group or a range of item groups to print or maintain the price list for items with the selected item group(s). Select the All check box to print or maintain the price list for items with any item group.
Price agreement
Select this check box to print or maintain the price list for price agreements for the selected supplier.
Purchase price
Select this check box to print or maintain the price list for purchase prices.
Assortments
Click this to print or maintain the price list for items linked to the selected assortment(s). After an assortment is selected, “In use” is displayed.
Show section
Columns
Select All to display all columns (the quantities and discounts) of the price agreements or purchase prices. Select the numbered check boxes to display the number of columns to be shown for the price agreements or purchase prices.
Extra section
Group by
Select None to not group the price lists. Select Item group to group price lists of purchase prices or price agreements by item group.
Show
Select the information to be displayed in the price lists. Select one of the following options:
Standard sales price
Show: Supplier’s item code
Select this check box to display the supplier’s item code in the price lists being generated.
Generate: Price agreement
Select the Generate: Price agreement check box to generate price agreement for the price lists being displayed. This option is available if you select Maintain in generating the price lists.
Quantity
Type the quantity to generate the price agreement for the entered quantity.
Note: This option is available if you have selected Maintain when generating the price lists. Also, it is enabled only if you have selected the Generate: Price agreement check box.
Purchase price: Discount %
Type the discount percentage for the purchase price of the items being displayed in the price lists.
Note: This option is available only if you have selected Maintain when generating the price lists. Also, it is enabled only if you have selected the Generate: Price agreement check box.
Start
Click this to generate the price lists based on the specified criteria.
Close
Click this to exit.