Páginas filhas
  • Price Lists - OMSA010 - Billing - P12

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelPrice List Maintenance

Find the area specified for price list maintenance at the top of the screen.

Click the down arrow to view and/or select from the options:

  • Display All;
  • Active Price Lists;
  • Inactive Price Lists;

When you select one of the options above, the system updates the data registered onscreen.

The following options are also available, which depend on settings upon activation.

  • Create View;
  • Manage Views.

On this page, click F12 to set the following parameters:

  • Display by? Select between List or Product;
  • Product? Use the magnifying glass next to the field or the F3 key to access the default query and select the product;
  • Save list by? Enter whether the list should be saved by product code or by grid reference, when lists are displayed by product (MV_PAR01=2);
Card
defaulttrue
id2
labelAdd

Note that when you access the routine, all registered items are displayed.

When you select this option at the top of the main screen, the system displays the branch selection screen.

Select the branch and click OK to continue.

Fill out the data in accordance with the instructions described in Main Fields.

The system will not let you duplicate the list code.

See also the features available in Other Actions.  

Nota
titleImportant:

For each Register export, a control sequence is generated in field Exp. Seq. and saved in Field Exp Dt (the date of the last export).

Only follow this procedure to register price lists not of types Standard and Promotional.

Card
defaulttrue
id3
labelEdit

Press the [F12] key to perform maintenance in Price Lists.

Set parameters in accordance with completion instructions:

  • Display by? - The options are Product, or List.

   When you choose List, all the data on the list selected for editing is displayed (default option).

   When you choose Product, all the lists containing this product are displayed.

  • Product? If the option is Display Product, enter the code of the product you wish to view when editing.

Confirm parameter settings and click Edit to continue.

A window is displayed for editing, in accordance with parameter settings.

Configure and confirm the changes.

Adjust the information according to the instructions described in Main Fields.

See also the features available in Other Actions.

Card
defaulttrue
id4
labelSearch

Other Actions / Search

Allows the use of filters to order data based on the index selected, considering, for example, branch+code.

Card
defaulttrue
id5
labelView

Other Actions / View

Place the cursor in the item, then click View to continue.

See also the features available in Other Actions.

Card
defaulttrue
id6
labelDelete

Other Actions / Delete

To delete a registered item, place the cursor to continue and access Other Actions / Delete.

View the screen with the message on top saying Are you sure you want to delete the item below?

You cannot reverse the confirmation for this action.

To complete the deletion, click Confirm.

Card
defaulttrue
id7
labelCopy

Other Actions / Copy

Use this option to create new price lists that have items in common, as well as to register lists with similar characteristics, such as items in common, to avoid retyping them.

The system displays all fields in accordance with the settings of a given list, already selected in the maintenance window, so you can copy it.

When you activate this option, the system automatically fills out the field List Code with the next numbering available, only duplicating the items on the list, so you need to adjust the header at each duplication.

In the search window, enter the item to be copied and confirm it.

The system displays the addition screen showing all the fields filled in the same manner as in the list selected.

Enter the code and description of the new list and edit/fill out any fields if needed.

Check the data and confirm the addition.

Card
defaulttrue
id8
labelGenerate

Other Actions / Generate

Use this option to create a price list based on the Product Register.

Select the branch and confirm it.

Select the Products, the Groups and also the Types.

In the price list items, the system fetches all the data on products already entered; however, you must also enter the list header items.

In the Validity parameter you can set the date from which the item on the list is valid, though this field is not required.

For price list validity purposes, the system always takes into account the data found in fields Start Date and End Date; however, the list items may have later validity dates.

Check and confirm the data.

Card
defaulttrue
id9
labelAdjustment

Other Actions / Adjustment

Use this option to apply a multiplication factor to adjust the prices of products from lists specified in parameters.

Access the option, view the message from the system and click Parameters.

Although setting this option's parameters is self-explanatory, you should pay attention to the following data:

  • Initial Product and Final Product. Use the magnifying glass next to the field or the F3 key to access the default query and define the products.
  • Initial Group and Final Group. Likewise, access default query and select the groups.
  • Initial Type and Final Type. Access default query and select the types.
  • Initial List and Final List. Access default query and select the lists.
  • Adjustment Factor? In this field, enter the adjustment factor to be applied.
  • Number of decimal places? Enter how many decimal places will be used when saving the new price.

Example:

If you enter 0 and the calculation of the new value is 46.74, the system saves 46,00 disregarding the cents.

  • Orders in Portfolio? Select between Maintain or Update (option Update lets you update all pending Sales Orders).
  • Reapply Factor? Define between Base Price or List Price, given that:

   In base price, the following formula is applied: Base Price x Multiplication Factor x Factor (base price multiplied by the multiplication factor and multiplied by the factor).

   In list price, the following formula is applied: Sales Price x Multiplication Factor (sales price multiplied by the multiplication factor).

  • Update Base Price (product)? Select between Yes or No.
  • Initial Grid Reference and Final Grid Reference? Define the initial and final grids to be considered.

Check the data and confirm the list adjustment.

The system adjusts the lists in accordance with parameter settings.

Use of Price Spreadsheet in Adjustment:

  • Price list products to be adjusted (Initial Product / Final Product);
  • Price list product groups to be adjusted (Initial Group / Final Group);
  • Price list product types to be adjusted (Initial Type / Final Type);
  • Price Lists to be adjusted (Initial List / Final List);
  • Adjustment Factor to be used (Adjustment Factor). - Adjustment to be applied
  • Number of decimal places for rounding of adjustment calculation (Number of Decimal Places);
  • Your orders already saved must be adjusted (Orders in Portfolio);
  • If the adjustment is applied to the base list (Product Register) or the Price List (Reapply Factor).
  • Name of pricing spreadsheet in which the adjustment takes place (Spreadsheet).
  • Whether the base price of the product register is updated or not (Update Base Price (product))
  • Product Grids of the price list to be adjusted (Initial Grid Reference / Final Grid Reference).

In parameter "Spreadsheet" you need to enter the code of the Pricing Spreadsheet you want to use.

If you need to adjust prices in the list, you can make the Automatic Adjustment from a Pricing Spreadsheet (MATC010) by executing the following process:


PRICING SPREADSHEET (MATC010)

In the Pricing Spreadsheet (MATC010), there must be a line referencing the code and description of the Price List (OMSA010) to be adjusted:


You also need to add the formula to set the price to be moved to the Price List (OMSA010):

*The Description field of the Pricing line must contain:   #code, space and the name of the pricelist.

05.PNG

NOTE: If you need Help to register the Pricing Spreadsheet (MATC010), contact the TOTVS Stock/Costs Support.



PRICELIST (OMSA010)

Access the routine Price List (OMSA010), select the Price List you want to adjust and access "Other Actions" "Adjustment":

01.png

After clicking "Adjustment", select the option "Parameters" to configure the adjustment:


Among the parameters, you can select:

  • Price list products to be adjusted (Initial Product / Final Product);
  • Price list product groups to be adjusted (Initial Group / Final Group);
  • Price list product types to be adjusted (Initial Type / Final Type);
  • Price Lists to be adjusted (Initial List / Final List);
  • Adjustment Factor to be used (Adjustment Factor). - If you do not enter the adjustment value, the system will only update the sales price of the price list in case the values found between the price list and the price spreadsheet are different, and parameter (Reapply Factor) is set to List Price. If parameter (Reapply Factor) is set to Base Price, the system does not make any adjustment, also disregarding the parameter (Update Base Price (product)).
  • in accordance with the value found in the Spreadsheet if they are different. 
  • Number of decimal places for rounding of adjustment calculation (Number of Decimal Places);
  • Your orders already saved must be adjusted (Orders in Portfolio);
  • If the adjustment is applied to the base list (Product Register) or the Price List (Reapply Factor).
  • Name of pricing spreadsheet in which the adjustment takes place (Spreadsheet).
  • Whether the base price of the product register is updated or not (Update Base Price (product))
  • Product Grids of the price list to be adjusted (Initial Grid Reference / Final Grid Reference).

In parameter "Spreadsheet", enter the code of the Pricing Spreadsheet you want to use. In this example, we use the code "STANDARD":

03.PNG


After entering the data, click "OK". The system will make the adjustment and fill out the adjusted price:

06.PNG


Card
defaulttrue
id10
labelSpecifications

Other Actions / Specifications

When you access this option, the system displays the specifications registered.

The options at the top of the screen are:

  • View

   Click this option and view the screen.

   The grids are: Specifications and Entities (in this area, the structure is displayed in tree format).

    This option does not allow editing.

  • Other Actions
  • Search
Card
defaulttrue
id11
labelConnections

Other Actions / Connections

Use this feature to identify the relationship between the records created in CRM, which are suspect, prospect, customer, contacts, competitors, suppliers, partners, opportunities, proposals, sales orders, invoices, products, price lists, sales process, sales representatives, business unit, sales team, promotions and events.

The connection centralizes data on the relationship between an entity and another, making it easier to query them.

Once you activate this option in Other Actions / Connections, you can view the options onscreen, as follows:

  • Add, when you choose to add a new connection, the system first displays the screen for you to select the branch.

Select the branch and confirm it to continue.

The next screen pertains the Connections Register, with data on entity, code and name of the connector, which are loaded automatically.

 In the grid Connect To, enter:

Field

Description

Entity

Use the magnifying glass next to the field or the F3 key to access the default query and select the item.

Example:

AC3 - Competitors

Code

Use the magnifying glass next to the field or the F3 key to access the default query and select the item.

Enter the code of the entity Connected.

Function

Use the magnifying glass next to the field or the F3 key to access the default query and select the item.

Status

Use the down arrow next to the field to view the options available, which are:

1-Inactive or 2-Active.


In the grid Connect From, enter:

Field

Description

Function

Use this option to link data from one customer to another, entering the function of the connection.

Example:

Partner, Associate, Influencer, etc.

When you cannot find a feature that best represents your needs, register other connection features and associate them with the corresponding features; that is, when you register the feature Uncle/Aunt, the corresponding feature will be Nephew/Niece.

Initial Date

Use the calendar option next to the field or enter the date in DDMMYYYY format.

Final Date

Use the calendar option next to the field or enter the date in DDMMYYYY format.

  • Edit
  • View
  • Other Actions
    • Disconnect
Card
id12
labelNotes

Other Actions / Notes

Use this register to add, edit and delete comments or notes related to records of the following CRM entities: Suspects, Customers, Prospects, Contacts, Competitors, Sales Representatives, Opportunities, Proposals, Orders, Suppliers, Partners, Products, Price List, Sales Process, Business Unit, Sales Team, Promotion and Events.

The note is comprised of its title, contents, and you can attach files to it.

The menu offers these options:

  • Add. Click this option to select and confirm the branch before viewing the add screen.

Then fill out the following fields:

Field

Description

Owner

Use the magnifying glass next to the field or the F3 key to access the default query and select the owner of the record.

Title

Enter a title for the note at issue.

Status

Use the down arrow next to the field and select between: 1-Inactive or 2-Active.

Contents

In this field, enter information pertaining the note.

  • Edit,
  • Search, and
  • Other Actions.
    • View;
    • Delete;
    • Copy;
    • Attach;
    • View Attachment.
Card
defaulttrue
id13
labelConnect

Other Actions / Connect

The next screen pertains the Connections Register, with data on entity, code and name of the connector, which are loaded automatically.

In the grid Connect To, enter:


Field

Description

Entity

Use the magnifying glass next to the field or the F3 key to access the default query and select the item.

Example:

AC3 - Competitors

Code

Use the magnifying glass next to the field or the F3 key to access the default query and select the item.

Enter the code of the entity Connected.

Function

Use the magnifying glass next to the field or the F3 key to access the default query and select the item.

Status

Use the down arrow next to the field to view the options available, which are:

1-Inactive or 2-Active.

In the grid Connect From, enter:

Field

Description

Function

Use this option to link data from one customer to another, entering the function of the connection.

Example:

Partner, Associate, Influencer, etc.

When you cannot find a feature that best represents your needs, register other connection features and associate them with the corresponding features; that is, when you register the feature Uncle/Aunt, the corresponding feature will be Nephew/Niece.

Initial Date

Use the calendar option next to the field or enter the date in DDMMYYYY format.

Final Date

Use the calendar option next to the field or enter the date in DDMMYYYY format.

Click Save to confirm it.

Card
defaulttrue
id14
labelCreate Views

This option is available in the access screen of the routine in Price List Maintenance. Click the down arrow to select this option.

To the left

  • Configurations. This screen is divided by the grids described below
    • Name of View - Name the view you are creating.
    • Order of Records - Select between the indexes:

List Code

Active List + Start Date + End Date

  • Visibility

Double-click to make the view public.

Click Confirm to continue or Close to exit and/or return to the previous screen.

  • Fields. View two frames called thus:

Fields available for your view - to the left

Place the cursor in the fields you wish to display in the view being configured and use arrow > to move it to the right.

Use arrows < and > to move the fields from one side of the frames to the other.

Fields currently in use - to the right

When moving fields, viewing takes place in this frame.

Click Confirm to continue or Close to exit and/or return to the previous screen.

  • Filters

Select filters to apply to the list.

To create a new filter, click the option Create Filter.

Access Other Actions to view and/or select from the options:

      • Copy
      • Expression
      • Link

In the same screen, you can Delete and/or Copy an existing field.

To continue, click Confirm; or, to exit without adjustments, click Close.

Card
defaulttrue
id15
labelManage Views

This option is available in the access screen of the routine in Price List Maintenance. Click the down arrow to select this option.

At the lower area of the screen displayed by the system, view the options:

Other Actions /

Restore Default View

Configure

Edit -  use this option to edit an existing view.

Delete -  use this option to delete an existing view.

Add -  use this option to add a new view. Follow the instructions described in Create Views.

Set to Default - use this option to set a view to default. Select one from the existing views and confirm it.

To exit without saving, click Close; or, to keep this configuration, click Confirm.

Card
defaulttrue
id16
labelRegistration of Flash Sales

The routines involved in flash sales registration are: Bonus and Discount Rules.

Nota
titleImportant:

When you open a sale, the system checks all currently active Price Lists, so you do not need to query active Lists every time a new product is launched. The system will only check again for the existence of other active Price Lists after you open a new sale.

This is why parameter MV_LJRETVL is an index in List DA0.

This new parameter is configured only with values 1 or 2, value 1 being intended for capturing the lowest price of a product among the active Price Lists, and value 2 for the highest price.

The price list can register the following data:

DA0 – Header

  • Start Date and Time / End date and Time of Validity
  • Time Type - Single / Recurring
  • List Active - Yes / No

DA1 – Items

  • Product or Product Group
  • Base Price (automatically returns the value used in field Sales Price)
  • Sales Price (value to be effectively used in sale)
  • Discount / Factor (to be applied in field Sales Price)
  • Active (if this product is active in grid)
  • State
  • Type of Operation (State / Interstate, etc.)
  • Range / Currency
  • Validity

As the payment method and terms are only set at the end of the concomitant sales process, in modules Store Control and Point of Sales, only price lists that lack definitions for these data are taken into account.

The fields for payment method and terms become hidden in the Store Control module on the Price List registration screen.

In Assisted Sales and Point of Sales, only the State operation type is handled.


Possible Scenarios

Description

Action

A single price list with product entered at sale.

The rule set in the price list is used and applied to the value of the product item.

The product exists in more than one active price list.

It is set by the parameter that defines whether the product value must be selected by the criterion of highest or of lowest value found in the search and applied to the value of the product item.

No active price list is found for the product.

The sale value of the product is the one registered in the product (field Sale Price).

There is no price list available for the product and the sale price registered in the product is ZERO.

The application notifies that this product cannot be registered, because it lacks a set sale value.

 

Card
defaulttrue
id17
labelProduct Grid Interface

The grid resource speeds up the registration of products that vary only in a few aspects, keeping their main characteristics.

Thus, you do not need to register the same product multiple time only because the product has various characteristics; that is, you only need to register the main product and all its variants, such as: color, model, etc. This enables Protheus to automatically register all product variants.

Nota
titleImportant:

To use the Product Grid resource, you need to set parameter MV_GRADE to T, thus activating the use of the product grid.

Card
defaulttrue
id18
labelProduct Grid in Sales Price List

Select the option Price List and add a price list for a grid reference product.

To check the application of the price list, select the option Sales Orders and add a sales order to a product (full code) of the related grid family.

Enter the list code in the header of the order.

Card
defaulttrue
id19
labelCaption

Place the cursor on one of the registered Price Lists and double-click the colored sphere to the left for the system to display a frame with the meaning of the caption, as follows:

Inactive Price List;

Active Price List;

Special Active Price List.

Main Fields 

...

Field:

Description

List Code

Alphanumeric field for specifying a code for the Price List being added.

When the option is Copy using the option by Others Actions, the system assumes the next available code for the copy.

Example:

A12

Description

Descriptive field that identifies the list added and/or yet to be added.

Example:

Default list for the month.

Start Date / End Date

In these fields, set the start and end dates of price list validity.

Example:

1/1/2016 to

Start Time/End Time

In these fields, enter validity schedule of the Price List registered. This information is often used by companies that practice Flash Sales.

Example:

A given company has decided on a promotion valid on 9/20/2003, from 9:00 AM to 10:00 AM, must set field Start Time to 09:00 and field End Time to 10:00. Sales made from 10:01 AM forward would no longer use this Price List.

Paymt Term

Enter the payment term valid for applying this price list. Thus, when adding the Sales Order, the system only checks the payment terms entered in the Price List; otherwise, it notifies that the terms are not valid for the List selected.

Use the magnifying glass next to the field or the F3 key to access the default query and thus select the payment term.

Example:

Prompt payment.

Group

Use this field to control the price list by product or by product group.

To control it by group, in the Product register, enter the group to which the product belongs. If you enter, in the list, the price of the product as well as the price for the group to which it belongs, the system assumes the price of the product, not that of the group.

Be mindful that the field has a trigger. If you fill out the group, the product is erased. You must enter either one or the other.

Type of Schedule

Use the down arrow beside the field to select between:

1-Single - The Price List is valid from the start date (start time) to the end date (end time). In this case, if you register the Price List to be valid from 10:00 AM on 9/17 to 8PM on 9/20, then all sales orders entered in this period can use this list.

2-Recurring - The list is valid between the two dates only between the start time and the end time. Using the previous example, the orders can only use the list during the days of the period, within the time entered; that is, from 10:00 AM on 9/17 to 8:00 PM on 9/20.  If the order is issued for 9/18 at 9:00 PM, the system does not accept it for this Price List.

Active List

Use the down arrow to select between:

  • 1-Yes or
  • 2-No.
Nota
titleTip

The system lets you apply the factor or the discount value, but never one atop the other.

Base Price

The base sale price of a product is defined in its register, through field Sales Price.

When you add a Price List, the system offers the base price entered, and fields Sales Price and Discount Value always use the base price of the product as reference. However, if it has not been registered, enter it directly in field Sales Price.

Sales Price

Enter the sales price used for a product in the Price List, from the applied factors and discounts.

Example:

A price list is registered in the following situation:

Product Computer; Base Price $1,000.00 and Discount Value $100.00. In this situation the Sales Price is $900.00 (Base Price - Discount Value)

Discount Value

Enter the discount value to be applied to the Base Price of the product. When you fill out this field, the system automatically calculates the Sales Price field.

Nota
titleTip

The system lets you apply the factor or the discount value, but never one atop the other.

Example:

A price list is registered in the following situation: Product Computer; Base Price $1,000.00; Discount Value $100.00; Factor 0.90 (10% discount on the base price); Sales Price $900.00 (Base Price - Discount Value)

The discount value determines the sales price, because it is calculated on the Base Price of the product.

Factor

This field determines the factor on the Base Price of the product. The system enters or calculates it when you fill out the field Discount Value. When entered, the system calculates the sales price based on the factor. When the factor is entered, the sales price is calculated.

State

Enter the State in which the Price List registered is valid.

Nota
titleTip

For fields State and Operation Tp., a priority rule exists. When you enter the State, the system disregards field Operation Tp., regardless of its contents.

Therefore, for the data found in field Operation Tp. to have value, leave field State blank.

Type of Operation

In this field, select the type of operation performed:

1-State - Determines that the Price List is only valid for customers inside the State defined in parameter MV_ESTADO.

2-Interstate - Determines that the Price List is valid for all States, except the State set in parameter MV_ESTADO.

3-North and Northeast Indicates that the Price List is valid only for regions North and Northeast.

4-All - Indicates that the Price List is valid for all States of table 12 - Federative Unit.

Nota
titleTip

For fields State and Operation Tp., a priority rule exists. When you enter the State, the system disregards field Operation Tp., regardless of its contents.

Therefore, for the data found in field Operation Tp. to have value, leave field State blank.

Range

Enter the maximum quantity of products for a given price list. This information is useful to link the price to a given sales quantity.

Example:

The higher the number of products sold, the lower the price.

Activation and Deactivation of Records

The purpose of the reserved field called Status is to allow the activation or deactivation of records, preventing the application from using the inactive ones.

1. Field initialization is always as Active and shows the options Active and Inactive.

2.  When the content of the field is set to Inactive, it means the record is blocked, and it is shown in the browser with a different color.

E-commerce

The option to send multiple price lists to CiaShop E-commerce, is implemented by marking the field e-commerce

Nota
titleTip

The header registration, in which the rules for using the list in the sale are set, is made in the Cia Shop E-Commerce.

The integration sends products related to the list as well as their respective prices.

Use this feature to have a price list differentiated by rule.

The procedures for registering the Promotional and Default Price list remain the same.

Product Code

Use the magnifying glass or the F3 key to view the default query and set the product code.

Example:

Default Product

Group

Use the magnifying glass or the F3 key to view the default query and set the product code.

Example:

0002

Be mindful that the field has a trigger. If you fill out the group, the product is erased. You must enter either one or the other.

Grid Ref./CFG

The Grid Reference family code lets you use the routine practically, reducing the need to repeatedly register products with the same Grid Reference / Configurator.

Validity Use the calendar next to the field or enter the date in format DD/MM/YYYY with the validity date of the pricelist in use.
Maximum Price Enter the maximum price for the specified price list.

...

Informações
titleIMPORTANT!
For further details, access: Product Grids (MATA550 - SIGAEST).

Configuring the Note

  1. In Related Features, click Notes.
  2. On the upper menu, you can Filter, Search, Print and Configure.
  3. The lower menu displays five options: Edit, Add, View, Environment and Related Features.
  4. When you view a registered note, the data displayed are: Code of Note, Code of User who created the note, User Name, Note Edit Date, Note Addition Date, Title, Contents and Attachments.

...

Informações
titleIMPORTANT!
See also Product Grids (MATA550 - SIGAEST)

Activating/Deactivating Records

...