I was recently assisting a customer who was getting the following error when trying to enter a quantity in the Sales Transaction Entry window for a specific item.

image

This message is because of an Selling Option setup which is defined for the specific item and unit of measurement in the Item Price List Maintenance window.

This is yet another option in GP, which goes unnoticed by many people. When you are on the Price List Maintenance window, you can click on the Options button to open the Item Price List Options Maintenance window.

image

In the options window, we can define the selling option for the various price list records defined for the specific item.

image

There are 3 options available for this.

  • Not Available – This indicates that the specific combination of Item, Price Level, Currency and U Of M cannot be entered in the Sales Transaction Entry.
  • Whole – This indicates that the quantity for the specific combination of Item, Price Level, Currency and U Of M can ONLY be entered in whole numbers (without decimal values) in the Sales Transaction Entry.
  • Whole and Fractional – This indicates that the quantity for the specific combination of Item, Price Level, Currency and U Of M can ONLY be entered in whole numbers and fractions in the Sales Transaction Entry.

In this case, the client had an item number defined with 2 decimal places, but had the Selling option for the specific combination as Whole, because of which the system did not allow the fractional quantity entered in the sales transaction.

With this said, there are a few more options on this window, which I would prefer to explain, so that it might benefit the community.

As you can see there are 3 more fields which are listed below.

  • Round Policy – This is used to define the direction of the rounding – whether Up, Down, Nearest or None.
  • Round Option – This defines the option of how the rounding value – whether it Ends in a specific number (or) if it rounds to the nearest multiple of the round amount specified.
  • Round Amount – This defines the number that will be used to determine the last number in the price.

These options are not available for an Item which has the Price Method as Currency Amount in the Price List Maintenance. There are enabled only if the Price Method is any of the ones mentioned below.

  • % of List Price
  • % Markup – Current Cost
  • % Markup – Standard Cost
  • % Margin – Current Cost
  • % Margin – Standard Cost

The round options are used to determine the price for an item when creating the price list record for the item as explained above.

Hope this helps the community…

Until next post!