Tuesday 31 March 2015

A Pricing Tale: Old Joe


Last week, I had the pleasure of addressing the sales team of a fast growing distributor. The topic was sales process and aligning with major industry trends. The group numbered in the mid-twenties and included salespeople from local territories throughout the central portion of the U.S. Prior to launching into my talk, I asked the group to give me a quick introduction outlining their position and background. As we moved through the first few members of the group, it was clear this team had deep product knowledge and understood their customer-base well.

About half way around the room, we came to Joe. As Joe introduced himself, I could see the way the other members of the team deferred to him. Joe was the Senior Inside sales person and when he outlined his industry experience it was impressive to hear the side comments from the group. Joe was THE go-to guy for any tough application or technical question. He exuded customer service from every pore of his body. You could tell Joe was rough, tough and ready let you know if he disagreed with you.

The talk covered a variety of topics ranging from targeting accounts and building a data base of customer-centric information to best practices in bringing manufacturers into accounts. As I moved through the presentation, I made a mental note to gauge Joe’s reaction. Early on, I asked his opinion on a couple of topics and, well, I felt like Joe was falling under my spell. Carefully considering each of my major points and then slowly nodding in agreement, I was feeling pretty good about the outcome of the whole presentation. But things were about to change…

I talk about the power of a solid, scientific pricing process in every presentation I deliver. Why? Because a good pricing process delivers to the bottom line. My clients experience better return (ROI) from money spent on pricing than any other investment; but that’s not the story here.


As I talked about best in practice pricing strategies, I could see old Joe’s face get stiff. His body was rigid, he crossed his arms and this person, who was so friendly, went from receptive to closed. I would have been blind to not see it. Furthermore, I was 100 percent certain everyone else in the room was feeling the bad vibe as well.

Sensing I was about to “lose the room” I asked Joe his opinion on pricing strategy. Joe shrugged and said, “From where I sit, standardized pricing, or whatever you want to call it, is destined for failure in our business. Our customers are tight with their money. They don’t want to pay more, they want to pay less.”

Going around the room, the group largely agreed with Joe with a couple of notable exceptions. One salesperson noted that some customers are willing to pay more when the product is in stock. Another guy stated repair parts were not price sensitive; especially when the customer is trying to hold out on replacing a whole system. Within a few minutes, we had a dozen or so examples of times where a
“standard” price would work. Everyone was on board, but Old Joe looked shaky.
I knew we needed to talk.

One-on-One with Joe
Clearly this isn't us talking.
I charge a higher fee to wear a tie.
Shortly after my presentation, I had the chance to talk to Joe one-on-one. Seated in a cozy spot in the hotel lobby, Joe shared his story and laid out his concerns:

Joe has been in the distributor side of the business for well over 20 years and worked with tools in the industry prior to moving to distribution. He’s been around the block, seen everything once and can give recommendations on products not even listed in the catalog. Since moving into the inside sales role, he has developed a following of people he calls “his customers.” They know him, a bit about his family and he knows them just as well. Further, even though a good many of these customer contacts are called on by outside salespeople, they pick up the phone and call him with their orders.

So far, so good. But then the story headed down a typical path.

Joe reiterated, “My customers are cheap.” When I asked what that meant, he said they called him because he was willing to “work with them on the price.” Before I could ask, he went on to tell me how sometimes customers called him when they were not happy with a price given to them by another member of the team. He called this “saving the order.”

A few years ago his company made a failed attempt at building a pricing process. Basically, this approach put a set margin on all products based on customer type. This is an approach my friend David Bauders calls peanut butter pricing. According to Joe no attention was paid to “real market price” or customer price sensitivity. After a number of months of battling one price change after another, Joe convinced his management team to go back to the old way with price points based on salesperson input and a guideline of cost plus 18 percent.

Interrupting his story, I asked Joe if some customers deserved to pay higher prices. First off he replied yes, but then I asked if there were times he provided small customers with the same price as the largest of accounts. Joe answered to the affirmative, he often allowed small customers to take advantage of the “special pricing” offered by manufacturers to handle the very large guys. He felt like this was fair because they were loyal to him.

Joe, are you a bargain basement discount house or a quality service provider?
This wasn’t a trick question. I really wanted to understand Joe’s feelings about himself and the company in general. I sat back and listened. Joe let loose with a deluge of stories about “walking a customer through the repair process”, finding impossible to get parts, staying late to meet a customer who was in a down time situation and generally providing fabulous service to customers.

When I asked if he had ever lost a customer due to service, the answer was a resounding NO. And, he could relate tales of customers who left because of price who found their way back because of poor service. When asked how he responded, Old Joe said he offered to match the competitive price then strived to give even better service.

Clearly, Joe (and the rest of the team) were a high service organization. But along the way, he couldn’t escape from the fact that people continued to ask him if “he could do better” on price. His opinion that they worked in a price driven market was largely based on these constant requests for a deal. They begged and nice-guy Joe gave them a treat.

As we ended our conversation, I asked Joe if he had ever held firm on a price. Without hesitation he told me sticking to a firm price only happens when the customer hasn’t purchased an item in several years and wants the historic, maybe even ancient, price level. I asked what happens then. He tells the customer prices have gone up, but uses the same cost plus a percentage strategy. And, he always gets the order.
Pricing process and guys like Old Joe…
In my travels around the country, guys like Joe are common; great product skills, fabulous customer service and a skewed vision of how pricing impacts their employer. Over the years Joe has been conditioned to believe, everyone wants a deal. Why? Because he has conditioned his customers to always ask for a little better price.

How has Joe conditioned his customers? They ask once and he caves in. Next go around, they hint that the price is a little more than they thought, and the price drops again. After a couple of go-arounds with the Joes of the world, customers think it is part of the deal. Just like a trip to the flea market, except with top notch products and world class service.

After two decades in the business, Joe has conditioned his customers and convinced himself. But hope exists. Little by little, Joe’s company is setting limitations on precisely which product prices can be over ridden without management approval. For example, exclusive product lines are no longer negotiable. The same applies to products where the company carries deep stocks of repair parts.

Joe will continue to grumble. He will test his management team’s commitment to improving the price process. He will need training, coaching and management, but I believe his actions (if not his views) will change with time. And the result will be higher margins and greater results for his employer.

A couple of final thoughts…
The idea of improving distributor gross margins has been around for a very long time. One of the very first training sessions I attended as a fresh young branch manager 25 years ago covered “the power of one.” Remembering back, the half-day session included the massive impact one measly percent in gross margin had on a distributors bottom line. There was no how to except to cheerlead your team to higher margins but putting up posters and continually reminding everyone of “the power of one.” The plan flopped only to be replaced with a dozen more pricing fads.

In order to build a real pricing process, a distributor needs advanced analytics, solid documentation, training and a means to measure and manage their team. Very few distributors (read that almost none of them) have the expertise to do this alone. Joe’s company tried and missed the mark, and the road to pricing success is littered with other distributors in the same situation.

We recommend David Bauders and his Strategic Pricing Associates team to our clients (like Joe’s company) for five reasons:
1. They apply scientific analysis to data from the distributor’s own work. No assumptions, no national averages, just a scientific look at what’s happened in the past.

2. They have documentation to steer a company through the application of pricing recommendations. Everybody in distribution is busy. The SPA program involves only a couple of weeks of attention to bring it live.

3. SPA has the resources to help train the distributor’s people. This includes pricing people as well as guys like Joe.

4. The SPA system has the measures and management tools required to change behavior.

5. David Bauders has been doing this since 1993. With something like 400 distributor clients and over 20 years of experience, they can help anticipate and address issues.

Now allow me one more statement. I have seen the results up close. The Strategic Pricing Associates process works. Typically, distributors add two points to their gross margin. Two points that pass almost straight to the bottom line. For most distributors, this is like a 50% increase in profit.

Saturday 28 March 2015

purchase agreement

A purchase agreement is a contract that commits an organization to buy a specified quantity or amount by using multiple purchase orders over time. In exchange for this commitment, the buyer receives special prices and discounts. The purchase agreement can apply to a specific quantity of a product, a specific currency amount of a product, or a specific currency amount of the products in a procurement category. The prices and discounts of the purchase agreement override the prices and discounts that are specified in any trade agreements that exist.

In the Purchase agreements form, you can create, apply, and follow up on purchase agreements that exist between your organization and your vendors. For example, after you create a purchase agreement, you can order directly from it.

Every purchase agreement has a validity period that is defined by the person who creates the purchase agreement. The delivery date of a purchase must be in the effective dates of the validity period.

By default, a purchase agreement is on hold. You must change the status of the purchase agreement to Effective before you can create a purchase order for the purchase agreement.

Commitment types
Each line in a purchase agreement is a commitment to buy something. You can use lines from multiple purchase orders to fulfill the commitment. There are four types of commitments:

Product quantity commitment – You purchase a specific quantity of a product.
Product value commitment – You purchase a specific currency amount of a product.
Product category value commitment – You purchase a specific currency amount in a procurement category. The amount can be for a catalog item or a non-catalog item.
Value commitment– You purchase a specific currency amount of any product or in any procurement category.

ImportantImportant
The commitment type, which only specifies whether the purchase agreement is based on a value or a quantity, differs from the commitment document that is used by public sector entities in France. For more information about commitment documents, see (FRA) About commitments (Public sector).

Pricing terms for purchase agreements
Pricing terms can vary, depending on the type of commitment. The pricing terms from purchase agreements override any other pricing terms that are set up for trade agreements.
The following table describes the price-related fields that are affected by each commitment type. Fields that contain Yes can be updated on an order line.

Commitment type
Unit price
Price unit
Discount percent
Cash discount amount
Product quantity commitment
Yes
Yes
Yes
Yes
Product value commitment
Yes
Product category value commitment
Yes
Value commitment
Yes

Policies for purchase agreements
The following policies affect the way that the link between a purchase agreement commitment and the corresponding purchase order lines works:

Max is enforced – The total quantity or amount for all order lines cannot exceed the quantity or amount that is specified on the related commitment.

Price and discount is fixed – The price on an order line and the price on the related commitment cannot differ. If the price is changed on the order line, the link to the commitment is broken. If the link is broken, the order line does not contribute to the fulfillment of the commitment.

Minimum release amount and Maximum release amount – If an amount is specified, a message is displayed if you make any change to an order line that causes the order line to be different from the related commitment.

Fulfillment calculations for purchase agreements
The Fulfillment tab on the Line details FastTab in the Purchase agreements form displays fulfillment quantities and amounts.
In the Fulfillment area, you can view the total quantities and amounts for all order lines that are linked to the specified purchase agreement. You can also view the remaining amount or quantity that is required to fulfill the commitment.

In the Agreement area, you can view the quantities and amounts from the specified purchase agreement. These quantities and amounts are the total quantities and amounts that were committed.

Tuesday 24 March 2015

CHANGING CUSTOMER FROM ORGANIZATION TO PERSON IN AX 2012

When creating a customer in Microsoft Dynamics AX 2012, you can select a record type Organization or Person. When you forget to check this field, an error is made easily. So how can we correct this? This post will guide you to change the customer from Organization to Party or vice versa. It also applies to other entities like vendors.
Suppose a person created Ronald Trump as Organization by accident. Because this customer already has some transactions it is not possible to delete this record and create a new one.
ChangeParty1
How to change the record type?
Navigate the menu to Home/Area page. You can open the Global address book and create a new Party. Set the record type to Person.
ChangeParty2
Then go to the customer details form. Select the record which you want to change. In this case it is Ronald Trump. Click the button Change party association on the action strip you can find on the fast tab General.
In the New party record field, select the new Ronald Trump record.
ChangeParty3
You have to confirm this action.
ChangeParty4
Now Ronald Trump is associated with an Address book record with the type Person.
ChangeParty5
You can delete the old Global address book record if there are no other roles attached to it.

Friday 20 March 2015

Distributor Etiquette Hate Mail


It’s not often that I get real, honest to goodness “hate mail”.  Apparently, our thoughts on Distributor/Supplier Etiquette
have touched a nerve.  The strange part of the whole thing is this:  We are only posting on distributor/channel oriented groups.  These groups are focused on those who are either a) distributors or b) manufacturers who go to market through distribution.  They should be friends or at least tolerant of one another.
Yet in the past week, I have received emails and/or anonymous posts which contain things like this:

“Frank, you are a distributor apologist.  You claim to be open minded but your writing continues to indicate they can do no wrong.”

Taking excerpts from several other notes, we find a similar type of attitude.  Distributors are described as follows:
The remnants of a day gone by with no place in the modern age.

Lazy, to the point of not being willing to introduce new products or handle warranty claims…

Unwilling to carry inventory except on their biggest lines…

Slowly dropping their commitment to training new people…
Completely different to deal with then in my younger days…

Going even further, here is the entirety of one of the best (worst) posts on the state of distribution:
The problem is that MOST distributors today are going through the same LEAN supply chain consolidation as most industry. Other than their fast moving mfg, they are extremely and increasingly risk averse to carrying inventory. This creates a ton of pressure on the supply chain. In my opinion, most distributors create little value, even though they talk about it quite a bit. They add margin, drop ship a good lot, and do less and less of what they are supposed to do which is to have products in stock.”

For the record, I believe distributors are neither partners nor customers.  They are often an extremely efficient and effective “instrument” for getting product to market.   Many suppliers would struggle if they were suddenly charged with carrying the massive accounts receivables load for all of their customers.  A good many suppliers would struggle to get customer attention if their product was not packaged with the product of another manufacturer to create a solution. 
In the current model, power house supplier get preferential treatment.  Most of them command greater respect with their distributors.  Perhaps this person is upset because they are not a high power supplier. 


By the way, I love hate mail almost as much as I like emails of praise.  Drop me a line if you think I am getting prematurely senile.  

Thursday 19 March 2015

Allocation of Miscellaneous Charges By Purchase Order Line



Allocate miscellaneous charges is a scenario where an organization wants to add some extra fees to an item value without modifying the itempurchase price.
Microsoft Dynamics AX 2012 allows to allocate miscellaneous charges by line of a purchase order. For example, if some items on the purchase order were picked up at the vendor’s location and others were delivered, we can allocate the delivery charges only to the items that were delivered. This functionality was not available in Microsoft Dynamics AX 2009.
After we complete this exercise, we will be able to:
  • Allocate Charges to line items.
The following will demonstrate this functionality:
  1. From the Purchase Order form, we have a Purchase Order that has 3 line items.Screen Shot 2014-12-05 at 10.12.29 AM
    Figure 1 – Purchase Order Lines form
  2. From the Purchase action pane, click on Maintain charges to display the Charges transactions formScreen Shot 2014-12-05 at 10.12.53 AM
    Figure 2 – Purchase Tab
  3. In the Charges code field, select a code.
  4. In the Charges value field, type a value.
    Screen Shot 2014-12-05 at 10.13.01 AM
    Figure 3 – Charges Transaction Form
  5. Click Close to close the Charges transactions form.
  6. In the Purchase action pane, click on Allocate charges.
    Screen Shot 2014-12-05 at 10.13.09 AM
    Figure 4 – Purchase Tab
  7. Select Per Line in the Charges Allocation field also select the Allocate all checkbox.
  8. Select the Show selections and clear specific lines check box.
    Screen Shot 2014-12-05 at 10.13.18 AM
    Figure 5 – Allocate charges form
  9. Clear the check box of the first line item and then press Allocate.
  10. This will allocate the 250 USD across the second and third line evenly. Both items will receive a 125 USD charge for Installation.
  11. To view this charge on the line item, click Financials from the Purchase order lines fast tab and then click on Maintain charges.
    Screen Shot 2014-12-05 at 10.13.26 AM
    Figure 6 – Charges transactions form

Allocation of Miscellaneous Charges

Once you have setup Charges Codes, you can add manual charges to Sales Order (SO) or Purchase Order (PO). The question is why do we need to add charges manually to orders if we have the auto charges functionality? Typically we add manual charges to an order if it is not a regular one, which needs some eccentric charges to be addressed. An example could be expedited orders which need to be shipped before standard delivery times. In this case we may need to charge additional amount for freight. This is where Manual Charges come to play their role.

Manual Charges for Sales Order:

Manual charges can be added to either the SO header, individual line items or both the header and the line items. To setup the manual charges to:
1. SO header, navigate to Sell tab → Charges to open Charges Transactions Form.
2. SO lines, navigate to Financials → Maintain Charges to open Charges Transactions Form.
Untitled
The fields of Charges Transactions form are described below:
FieldDescription
Charges codesSelect Charge code. For more details read the full post Charges Codes
Transaction textText defined in the description of the charge code
CategoryDescribes how the charges are calculated:
  1. Fixed charges
  2. Charge for each unit
  3. Percentage of the line amount
  4. Intercompany (used for intercompany trade)
Charges valueEnter the amount for this charge. It can anyone of the following depending on the category selected:
  1. Fixed amount
  2. Percentage of the order or line total
  3. Fixed amount for each unit
CurrencyDefaulted from the currency of the selected charge code
KeepIndicates whether the charges transactions must be retained after partial invoicing or not

Manual Charges for Purchase Order:

Similarly, we can add charges manually to PO header or PO lines or both depending on the scenario. To setup the manual charges to:
1. PO header, navigate to Purchase tab → Manage Charges to open Charges Transactions Form.
2. PO lines, navigate to Financials → Maintain Charges to open Charges Transactions Form.
You can see the description of Charges Transactions Form above. In Purchase Order, we can also allocate header charges to lines. We determine how this allocations should be carried out by navigating to Purchase tab → Charges → Allocate charges.
Untitled
The fields of Allocate Charges form are described below:
FieldDescription
Charges allocationIf the header charge is fixed in nature then it can be divided using the following options:
  1. Net Amount: Allocated according to line’s net amount
  2. Quantity: Allocated according to line’s quantity of units
  3. Per line: Allocated equally among all the selected lines
Allocate charges to linesChoose lines for allocation:
  1. All lines: All lines selected
  2. Positive lines: Positive quantity lines selected
  3. Negative lines: Negative quantity lines selected
Allocate allSelect if you want to include all kinds of charges in the allocation process regardless of the Debit type specified in the Charges code setup. By default, charges with Debit type of Item are included in the allocation process
ReceivedSelect to only allocate charges to received order lines
StockedSelect to only allocate charges to inventoried order lines
Show selection and clear specific linesSelect to exclude specific lines from this allocation. This check box is not available if no charges are set up
AX 2012: Charges Codes
Before you plan to add manual or automatic charges when you create a sales or purchase order, you must setup Charges Codes. They are used to define the kind of charge and how the charge is going to be debited or credited. You can setup charges by navigating to Setup → Charges → Charges codes in the following 3 modules:
1. Accounts Receivable
2. Accounts Payable
3. Procurement and Sourcing
Untitled

Fields on the Charges codes form are described below:
1. Charges code: Unique code for the charge
2. Description: Brief description about the charge
3. Item sales tax group: An item sales tax group that can be used for calculating taxes on the charge
4. Maximum amount: Maximum amount allowed for the charge

Posting Fast Tab

Untitled
This is where the actual game happens. In this posting fastTab we define how to automatically debit and credit the charge. Both debit and credit sections have the following fields:
1. Type – Defines the entity which will be billed for the charge. Following are the available options:
  • Item – Charge is added to the item cost
  • Ledger Account – Charge is billed internally to the ledger account
  • Customer/Vendor – Charge is billed to the customer/vendor
2. Posting – Free text field to give the description which will be used while posting the charge to journals
3. Account – Defines the ledger account which must be debited/credited when Type is set to Ledger Account

So far we have understood what is the purpose of different parameters used to configure charges codes. Let us now create charges codes for sales and purchases. In both cases the parameters discussed will be set differently to cater to different needs of sales and purchases.

Charges Codes for Sales

For sales, you can configure charges in 2 different ways:
1. Customer
Charge is billed to the customer and is added to the sales order totals. Follow the steps below to achieve this functionality:
1. Open Accounts receivable > Setup > Charges > Charges code.
2. Click New to add a new code.
3. In the Charges code field, type a unique identifier for this charge.
4. In the Description field, type a short description of the charge.
5. Click the Item sales tax group arrow and select the sales tax group.
6. Click the Posting tab.
7. Setup the debit/credit fields as follows:
DebitTypeCustomer/Vender
PostingN/A
AccountN/A
CreditTypeLedger Account
PostingSpecify
AccountSpecify

2. Ledger Account (Internal)
Charge is billed to an internal ledger account and does not show up on sales transactions. Follow the steps below to achieve this functionality:
1. Open Accounts receivable > Setup > Charges > Charges code.
2. Click New to add a new code.
3. In the Charges code field, type a unique identifier for this charge.
4. In the Description field, type a short description of the charge.
5. Click the Item sales tax group arrow and select the sales tax group.
6. Click the Posting tab.
7. Setup the debit/credit fields as follows:
DebitTypeLedger Account
PostingSpecify
AccountSpecify
CreditTypeLedger Account
PostingSpecify
AccountSpecify

 Charges Codes for Purchases

For purchases you can configure charges in 4 different ways. Repeat the following basic steps for all of the 4 different configurations then we’ll see how to setup the Posting fastTab:
1. Open Accounts payable > Setup > Charges > Charges code.
2. Click New to add a new code.
3. In the Charges code field, type a unique identifier for this charge.
4. In the Description field, type a short description of the charge.
5. Click the Item sales tax group arrow and select the sales tax group.
6. Click the Posting tab.
Here are the 4 different configurations for the posting fastTab
1. Paying to Creditor – Billing to Item
Setup the debit/credit fields as follows:
DebitTypeItem
PostingN/A
AccountN/A
CreditTypeCustomer/Vendor
PostingN/A
AccountN/A

2. Paying Internally – Billing to Item
Setup the debit/credit fields as follows:
DebitTypeItem
PostingN/A
AccountN/A
CreditTypeLedger Account
PostingSpecify
AccountSpecify

3. Paying to Creditor – Billing Internally
DebitTypeLedger Account
PostingSpecify
AccountSpecify
CreditTypeCustomer/Vendor
PostingN/A
AccountN/A

4. Paying Internally – Billing Internally
DebitTypeLedger Account
PostingSpecify
AccountSpecify
CreditTypeLedger Account
PostingSpecify
AccountSpecify

Monday 16 March 2015

Commissions, setup and calculations in AX 2012

Commissions, setup and calculations in AX2012

Commissions in AX 2012 have been the Part of distribution and trade, commission is calculated for the sales person at every Sales order level based on the percentage of revenue or contribution Margin.
You need to do the following setups for commissions to calculate.
 When the sales order is being invoiced, AX 2012 searches for the related sales representative, item, and customer combination set up in the Commission calculation form. You can setup the Commission Customer group and the commission Item group, the reasons for the setup is because in a business you can sometimes base commissions on Customer sales and sometimes on Items sold. So you have the Customer Group commissions and Item Group commission setup form under the sales and marketing setup Commissions node.
Commissions in AX2012
The commission calculation form set up relationships between the combinations of items, customers, and sales representatives to define the commission rate an employee is paid from a sale, and for groups of sales representatives, items and customers. In this form you can also setup if the commission is before or after the line discount or total discount. The basis of calculation if it should be on the total revenue or just the margin. You can also give validity period from when to when the commission calculation is active.Microsoft Dynamics AX 2012
Commission posting is a form where you can setup the posting accounts. When a sales order is
Invoice-updated, the commission amount on the voucher is debited to the main account specified on the Commission account, and then it is credited to the main account specified on the Commission offset.ERP Solutions
Sales group is the most important of all the setups, The Commission sales group (CSG) specifies those employees that are eligible to receive a commission when a customer associated with the relevant sales group buys certain items. 
 You assign the Customer group and the sales group to the customer master, AX 2012 calculates sales commissions at the sales line level when a sales order is invoiced.
When the sales order is being invoiced, Microsoft Dynamics AX 2012 searches for the related sales representative, item, and customer combination set up in the Commission calculation form. The header View of the sales order will default the Sales group and the customer commission group. We can also assign the sales group at each sales order line also, if you want the sales group different in each line.
Commission sales group
Once the sales order in Invoiced in the Invoice Journal action pane you can click on the commission and view the commission split between the Sales representatives, also you can view the commission voucher generated for that sales orders by viewing the vouchers.

Saturday 14 March 2015

Over/Under Delivery

                                                  Over/Under Delivery
X Entertainment Systems has run low on its stock of 6001, Box –
corrugated, 16X18X40. The purchasing agent puts in an order with the vendor
for 1000 pieces. Typically, there is a 1 to 2 percent variance on the number of
lamp projectors received when ordering from this vendor. However, they offer
the best price. Because of the variance, Contoso Entertainment Systems and the
vendor have agreed to set up an over/under delivery variance to allow for a
difference of 10 percent because it is not cost-effective for either company to
create new orders or credit memos.

When the order arrives, there are 1018 pieces in the order. The order is accepted
because it is in the range that is specified in the over/under delivery setup.
Six months later, the stock is down to 500 so another order is made for 500 from
the same vendor. This time, the order contains 492 pieces. Again, the order is
accepted because it is in the range of over/under delivery setup.

Over/Under Delivery Setup

Set up an item to accept over/under delivery by using a two-step process:

1. Set up Accounts receivable and Procurement and sourcing
parameters to accept over/under delivery.
2. Define the acceptable tolerance percentage for over/under delivery

on the item.

Parameters
To perform the first step in the over/under delivery setup, you must set up the
appropriate parameter for both the Accounts receivable and Accounts payable
modules. These settings are global and affect all sales orders and purchase orders.
• To set up the parameters for sales orders, open Accounts receivable
> Setup > Accounts receivable parameters.
• To set up the parameters for purchase orders, open Procurement

and sourcing> Setup > Procurement and sourcing parameters.

Accept Over/Under Delivery

For both setup areas, on the Updates tab, under the General field group, set the
global parameter to allow for over delivery, under delivery, or both.
• If you select Accept overdelivery, you can receive or sell more
products through the packing slip / product receipt or invoice update
than the quantity ordered in the purchase or sales line.
• If you select Accept underdelivery, you can close out the backorder
if you receive or sell fewer products through the packing slip /
product receipt or invoice update than the quantity ordered in the

purchase line or sales line.


                      Under Delivery with a Purchase  Order

X Entertainment Systems needs 7000 pieces of item number 5012, 4-40
zinc nuts, in the production. To make sure that the items can go into production
immediately, the purchasing agent orders a quantity of 9000 in case any of the
items are defective.
1. Open Procurement and sourcing > Common > Purchase orders >
All purchase orders and then create a new purchase order for 9000
4-40 zinc nuts from vendor 4101, Fabrikam Supplier. Confirm the
order.
The vendor can deliver 8000 pieces. However, because this meets
the current needs, you tell the vendor not to deliver the backorder for
the 1000 pieces. Now you want to receive the 8000 pieces and close
the order so no backorders remain.
2. When the order line is highlighted in the purchase order, enter the
8000 pieces in the Receive now field.

3. Click Product receipt in the Receive tab of the Action Pane.
4. In the Posting product receipt form, make sure that Receive now
quantity is selected in the Quantity field under the Parameters field
group.

5. Type a product receipt number in the Product receipt field.

6. On the Lines tab, select the Close for receipt check box to close the

order and then click OK.Notice that the error provides you the calculated percent of the quantity that you
are trying to post. To manually override the default item tolerance settings and
close this order, you must return to the purchase order.

8. Highlight the purchase order line and then click the Delivery tab in
the Line details FastTab. Specify the value from the error 12.00 in
the Underdelivery field. Remember that the number in this field
represents a percent, not pieces. The Receive now quantity must still
be 8000 pieces.

9. Click Confirm on the Purchase tab of the Action Pane.

10. Click Product receipt in the Receive tab of the Action Pane.

11. Type a product receipt number in the Product receipt field.

12. On the Lines tab, select the Close for receipt check box to close the
order and then click OK.
This time, the order is posted and the order status changes to Received and there
is no backorder.

To view the transactions on the purchase order, follow these steps:

1. Click Product receipt in the Journal group on the Receive tab of
the Action Pane.
2. Click the Lines tab and notice that 9,000 are ordered and 8,000 have

are received. Also, there is no


                                       Over Delivery with a Sales Order

Customer 2021, Graphic Design Training Center, orders 90 pieces of item
number 1301, with configuration 01. A long-standing relationship with this
customer is established and this is a typical order for them.
During a production of 90 pieces, you sometimes have scrap and nonconforming
parts. To accommodate this, you always do a production run of 100 pieces. The
customer recognizes this and accepts that you can ship a bit less or more and has
decided on a 5 percent tolerance, over or under, on an order of 90 pieces.

1. Open Product information management > Common > Released
products and locate item number 1301.

2. Click Edit in the Maintain group on the Action Pane.

3. On the Sell FastTab, set up an over delivery tolerance of five percent
and an under delivery tolerance of five percent for sales orders so
that, order lines can be closed when the quantity falls within five
percent of what is ordered.

4. Close the Released product details form.

5. Open Sales and marketing > Common > Sales orders > All sales
orders.

6. Click Sales order in the New group to create a new sales order for
customer 2021, Graphic Design Training Center.

7. Add an order line for 90 pieces of the item number 1301,
configuration 01 (black) for customer 2021. Click No to override the

suggested order quantity.

8. Click Sales order confirmation in the Generate group on the Sell
FastTab of the Action Pane.

9. Click OK to confirm the sales order.


After a production run, you can ship all 100 pieces of item number 1301 –black,
to the customer Graphic Design Center. Ship these pieces and close the order.

1. Highlight the sales order line and then type "100" in the Deliver now
field.

2. Click Packing slip in the Generate group of the Pick and Pack tab
of the Action Pane to packing slip update the order.

3. In the Packing slip posting form, make sure Deliver now is selected
in the Quantity field under the Parameters field group.

4. On the Lines tab, select the Close check box to close the order and
then click OK.

The posting is rejected and gives the error Overdelivery of line is 11.11 percent,
but the allowed overdelivery is only 5.00 percent. Update has been canceled.
Notice that the error gives the calculated percent of the quantity you are trying to
post.
Knowing that the customer will not accept this order, you will reduce the number
of product to send to the customer. Now try to packing slip update the order to
ship the customer 92 pieces.

1. Highlight the sales order line and type "92" in the Deliver now field.

2. Click Packing slip in the Generate group of the Pick and Pack tab
of the Action Pane to packing slip update the order.

3. Select Deliver now in the Quantity field.


4. On the Lines tab, select The order is posted, the 92 pieces are shipped to the customer, and the order
status changes to Delivered.


To view the transactions on the sales order, follow these steps:

1. Click Packing slip in the Journal group on the Pick and pack tab.
2. Click the Lines tab and notice that 90 are ordered and 92 are
delivered.