|
Price and Value Books Setup |
|
|
|
|
Page 1 of 3 Price and Value Books are set up in the same way. The stages are:
1. Setting up the Book
2. Setting up the Pages of the Book
3. Setting up the Lines of the Page
4. Setting up the Price Book Hierarchy
5. Using Customer and Supplier Analysis with Price Books
Setting up the Book
To define the book use Price/Value Book Setup. Select Price Book Setup (SPBS) or Value Book Setup (VBS). Purchase Price Book Setup (PPBS) follows the same logic and contains the same fields to setup. This displays the Price/Value Book Setup form which contains the following fields:
Click here to see the screenshot
Price Book Code
Code to identify the setup.
Status
A status is assigned to each static reference record, for example to every account, asset, customer and supplier. It determines the current processing status of the record.
Open - this status is set automatically when you add a new record e.g. if you create a new account. Open items are available for input, inquiry, processing and reporting.
Hidden - a record with a hidden status does not appear on any inquiries but is available for input, processing and reporting.
Suspended/Held - a suspended record.
Closed/Completed - a closed record cannot be used for input or processing. For example, you cannot post transactions to a closed account or analysis code.
You can alter the status of a record at any time. You must use the options on the Action menu to change the status.
Short Heading
The Short Heading is a shortened version of the Description to be used instead where space is limited. If you leave this blank it defaults to the first characters of the Description.
Description
The full name or description of the data item or record. This is used to identify it on reports and inquiries.
Lookup Code
A Lookup Code can be used to find a record, as an alternative to the record code. It is often set to a shortened version of the description. It is particularly useful if a record is often referred to using different codes.
For example:
the Chart of Accounts code for Fuel Expenses is 75201 and the Lookup code is set to FUELEXP.
the Customer code for WHSmith is set to WHSmith and the Lookup code is set to SMITHWH.
Price Book Type
This field is available if you have selected Purchase Price Book Setup (PPBS) or Sales Price Book Setup (SPBS). Options are:
Cumulative - this option is used when purchasing or selling items over a specified time period, and the purchases or sales are tracked by the system. For example, you can set up a Price Book so that the item price is reduced the more a specific customer buys.
Note: Cumulative Price Books are only effective if they are included in the Price Book hierarchy. See the section Setting up the Price Book Hierarchy, later in this topic. Cumulative Price Books can also be referenced directly in a formula in the same way as Standard Price Books. However, if you want to run more than one accumulation simultaneously, then they should be placed in the hierarchy. Only Promotion Price Books have to be in the hierarchy.
Promotion - see Setting up Promotions for more information.
Note: Promotional Price Books only generate promotional lines if they are included in the Price Book hierarchy. See the section Setting up the Price Book Hierarchy, later in this topic.
Standard Price Book.
Price Book Sequence Type
This field is available if you have selected Value Book Setup (VBS). Options are:
Inventory
Sales
Purchasing
All.
You can define a sequence of up to five analysis directories for the book using the following fields:
Sequence Number
The number in the sequence 1 to 5 when this analysis dimension is used.
Analysis Tab
Click here to see the screenshot
Analysis Directory
Identifier for the analysis directory.
Analysis Directory Description
This field is automatically populated once the Analysis Directory has been entered.
Analysis Dimension
Identifier for this Analysis Dimension.
Analysis Hierarchy Label
Code to identify the analysis hierarchy label within the analysis dimension.
|
Sun Documentation 
