Welcome to AlignBooks. We are happy to have you on board. In this help studio tutorial, we will explore the Purchase Price List option.
Before we begin, let us understand about the need of Purchase Price List and the usage of this particular activity.
As you begin the process to source the material, you need remain aware of the prices offered by different vendors for a particular product. When you finally make a purchase order, you need to mention the rate of the products to be procured. If your vendor(s) have standard price list or you have negotiated a fixed price for materials to be procured, you can enter the relevant data in your system to automatically fetch the prices in different set of documents related to material procurement.
In Purchase Price List setup, we submit the prices of different products for different Vendors with all the available data at hand. This library of data is extensively used to capture, generate and auto generate the required documents e.g. Purchase Order, Purchase Bill creation etc.
You can change the price list any number of times with its “effective from” feature. Moreover, you can maintain the multiple price list for the same period for different category of vendors.
You can also edit and delete an already created set of information with required authorization.
The key functions of a Purchase Price List Module are:
· Creation of a New Price List;
· Modification of an existing Price List;
· Deletion of an existing Price List.
We will be going through the each of these set of information in detail.
New Price List
If you are in Purchase Drop Down you need to select
and the screen which appears looks like this;
You can see the
option at top right of the screen. Click on this option and you will be directed to the relevant Price List creation screen.
Description: Enter a Description for your identification e.g. If you are creating a price list for one brand of product you can name it with that brand to easily identify the same in future.
|
|
Price Category : If you are having different price categories, Select a price Category from the Drop Down menu. If your desired Category does not Figure in the menu, you can create a New Category from here. Click on in the dropdown menu or click on Icon to create a Category. You can also Edit or Delete a Category from Here. Select a Category to be edited/Deleted and then click on . The Category will be Opened in Edit mode and you can Edit it and save by click on . You can Delete it by click on .
|
|
Effective From: Enter the Date from which this price list will be effective from. You can pick the date from the calendar function.
|
|
Get Latest Price : Click here to get latest price of items available in the System. This feature will help you to update the price list where price of most of the items has remained same and there are changes in the prices of only few items. With this process the system would fetch the prices of items from the last updated price list and thereafter you can simply modify the items of your choice only.
|
|
A list Showing Item Group, Item Code and Item Name is shown along with a Column to fill the Item Rate. The Rate column is editable field and you can put the new rate against each item.
If at the time of Company Configuration (Purchase Setup - Billing Set up - Item Level) you have selected any additional column for User defined Item wise Extra Charges, then defined number of columns would appear to enter Rates for those extra charges. You can enter the relevant rate of Extra Charges against items in those columns.
This is to ascertain that If you have not yet created any Item in your item master, you have to first create your item master then only you would be able to create a price list for that item master. To create a new Item use Module “Item Master” under Inventory.
Click on
to save the values.
Click on

to save and print the values.
Click on
to clear all values.
Click on
to Import Data and select a file from which Data is to be imported. Click here “Import Utility”, to know more about this utility.
Click on
or
to Exit from the New Purchase Price List Form.
Edit Exiting Price List
A list Showing Price List Description, category and Date from which the Price list will be effective from is shown along with option to edit and delete against each Purchase Price List.
Click on
to edit a Purchase Price List. You can make the required changes and Save it.
Delete Exiting Price List
Click
if you want to delete a Price List.
It is advisable not to delete a Price List if some data are already entered using that Price List.
Export : Click on
to Export the data as visible in the list to an Excel Sheet.
Search : Type a text to search a Price List you are looking for.
Group : If you want to Group your display on any particular field, hold that field and drag a little up outside the Grid, your display will be grouped on that field. To remove the grouping, drag the field back into the Grid column.
Sort : If you want to sort data on a particular field, click on the label of that field, your data will be sorted on that field. You can reverse the order of sorting by just Double click on the label of that particular field.
Click on
to Exit from the Price List master.
We hope you enjoyed this tutorial. Please give us a call for further help. Happy Aligning!