Ax2009 Enus TL1 03
Ax2009 Enus TL1 03
Ax2009 Enus TL1 03
Introduction
Purchase Orders and Purchase Order Posting discusses basic and advanced
Purchase order functionality.
The Working with Purchase Orders lesson explains how to create a Purchase
order by using the Simple and Advanced views in the Purchase order form.
Additionally, you will investigate the different Purchase order types.
The course also examines parameter selections in Accounts payable and how
these affect creating Purchase orders.
The posting lessons describe how to post Purchase orders in four steps:
• Purchase order
• Receipts list
• Packing slip
• Purchase order invoice
Additionally, you will discover the more advanced Purchase order functionality
that is introduced in Microsoft Dynamics® AX 2009. Finally, the course reviews
the Multiple ship to functionality, which lets you specify delivery addresses for
Purchase orders.
6. In the Delivery address field group, the address defaults from base
data. You can override the delivery address by clicking the Alt.
address button and specifying an alternative address.
7. In the Administration field group, select the setting related to the
buyer group, and the person placing the order and the purchase pool
that the Purchase order belongs to. This is useful for filtering
Purchase orders.
• One-time supplier
• Delivery Address
• Invoice account
• Purchase type
• RMA number
• Currency
• Administration field group
EXAMPLE: A one-time supplier can be used when the demand for an item exceeds the
capacity of the company's usual supplier, or when the company has an order for an item
they do not usually carry.
The Invoice account is used if the account number of the vendor who you
receive the invoice from and where you must pay differs from the vendor with
whom you put the Purchase order.
Purchase Type
The Purchase type can be Purchase order or another type of Purchase order.
NOTE: You can change a Purchase order type at any time before items have been
received. The Purchase Type field is automatically filled with the default purchase type
specified in Purchase parameters.
RMA Number
The Create Purchase order form displays the Return Materials Authorization
(RMA) number when Returned order is selected in the Purchase type field. This
number is provided by your supplier and is used for tracking a return item. The
field is mandatory when the purchase type is Returned order.
NOTE: The RMA number is only visible on the Create purchase order form when the
Purchase order type is Returned order.
Currency
The currency code attached to the vendor is copied automatically when the
vendor is selected. The currency code is mandatory and you can change it when a
Purchase order line has been entered.
Example 1:
Example 2:
You can only have one Currency for each Purchase order. Select the currency by
clicking the square arrow in the Currency field. When the invoice for the current
Purchase order is updated, the invoice balance is posted in the selected currency
and company currency. The system compares the exchange rate at posting and
payment, and then automatically posts the differences to the exchange rate gain
and loss account.
BEST PRACTICE: In the parameters you can define a safety level for invoiced orders.
Set the parameter to locked so that the user cannot change an invoiced order.
EXAMPLE: Select an item in the Items form and then click Setup >
Language - Item description. Select a language and enter the translation text. Create a
new Purchase order and in the Language field group select the language for which you
created a translated text. Print, for example, a receipts list and the item's name is
printed out by using the foreign language text.
• Item number
• Site
• Inventory dimensions
• Quantity
• Unit
• Unit price
• Discount
• Disc.Pct.
• Net amount
Item Number
Enter the item number or select it by clicking the Item number field. Base data
is copied to the purchase line together with the item number and information
such as the item name, unit, from the Items form with vendor-specific prices and
line discounts from the Price Agreements table. Purchase markups are retrieved
from the Misc. Charges Code.
Inventory Dimensions
Quantity
Enter the quantity of the item in its purchase unit. If the standard purchase
quantity has been specified in the Default order setting or Site specific order
setting, this quantity will be proposed automatically. The proposed quantity is
rounded up to the nearest multiple of the Quantity field, if defined in the Default
order settings or Site specific order settings. You can also specify a minimum and
maximum purchase quantity in the Default order settings and Site specific order
settings. If the quantity entered does not fall within the defined limits, you are
warned before the quantity is approved.
Unit
The purchase unit is the purchased item's unit of measure. There is a close
relationship between the purchase unit and the inventory unit. For example, the
item may be purchased in kilos and stocked in grams. The Purchase unit reflects
the vendor's sales unit. The actual conversion factors for the units are set up
globally in the Basic module or specifically for each item through the Items
form.
Unit Price
You can transfer a proposal for the purchase price of the item from the Price
field on the Items form. Notice that if a purchase price agreement is set up, the
price on the agreement is always used.
Discount
A line discount amount can be entered in the Discount field. This is calculated as
a discount for each price unit. The amount is automatically transferred from the
line discount agreements set up in Trade agreements. To do this, Trade
agreements must be activated.
Disc. Pct.
A line discount percentage can be entered in the Disc.pct. field, or you can
generate one from the line discount agreements created in Trade agreements. To
do this, Trade agreements must be activated. The line discount is calculated from
the complete line amount, after deducting the discount amount and adding other
order markups. See also calculation of the line amount in the Net amount field.
When the invoice is updated for the purchase, the total discount are posted in
accordance with the posting profiles.
Net Amount
The Net amount is an expression of the total price of the purchase line after
deduction of discounts and addition of various expenses.
Procedure: Create Purchase Order Lines with the Create Lines Dialog Box
To create Purchase order lines by using the Create lines dialog box, follow these
steps:
4. Click either:
o Existing items - To list all items.
o New items - To create lines for items for which there are no
order transactions.
5. Enter the quantity to purchase for each line in the Create lines
dialog box, and then click Create. The form is then closed, and the
Purchase order lines are created. You can also click Apply which
will create the Purchase order lines and keep the Create line dialog
box open for creating more lines.
One of the principle differences between the two Purchase order views is the
many functions you can access by using the buttons in the Advanced view.
Button Description
Simple/Advanced Toggles between the two views.
Posting Print or post the available documents.
Pro forma Print a Pro forma Purchase order, receipt list, packing
slip, or invoice.
Trade agrmt. Maintain or view trade agreements, prices, and
discounts.
Calculation Calculate multiline and total discount or supplementary
items.
Inventory View inventory transactions and on-hand inventory.
You can also reserve and register items from this
submenu.
The Setup button on the Purchase order line is where you can specify:
In addition to the functions that are also available on the header, you can also
access the following by using the Functions button on the Purchase order line:
The Inquiries button on the Purchase order lines is where you can access the Net
requirements and Explosion functionality.
Functions Button
When you open the Functions button in the Purchase order header and the
Purchase order lines, you will find the following functionality.
This function helps when you create a new Purchase order that resembles one
created for a different vendor, or even for the same vendor for a different item or
quantity. Within this option, users can configure the copying of these variables in
the Quantity and Setup field groups:
• Quantity factor
• Invert sign
• Copy miscellaneous charges
• Recalculate price
• Copy precisely
• Delete purchase lines
• Copy order header
With the Copy from journal option, users can configure the copying of the same
variables in the Quantity and Setup field groups as they did for Copy from all
function.
Within the Create credit note option, the user can select or clear the Delete
purchase lines check box if purchase lines exist within the present Purchase
order.
1. Creates a new Purchase order and clicks Functions > Create based
on sales order.
2. Clicks Select and enters a query to find all sales order lines with the
same item attached to it.
3. Selects the Include all check box and then clicks OK to create one
Purchase order to cover all sales order requirements.
A Purchase order with lines to cover all the sales order requirements is created.
When the Purchase order is created, each line references the sales order
requirement. Additionally, the sales order and Purchase order are now marked
against one another.
NOTE: A vendor must be specified for the Purchase order that this defaulted from or
you must enter the Vendor account manually.
Deliver Remainder
The Deliver remainder function is available only on the Purchase order line. By
selecting this function, the user is prompted with a dialog box within which he or
she can request delivery of any of the open quantity on this Purchase order.
The user can also click the Cancel quantity button from this dialog box. This
sets the backorder quantity to zero and cancels the remaining order. This can help
when a user is receiving a partly delivered Purchase order, or from a blanket
order or subscription.
There are five Purchase order types to select from depending on the process or
action the user needs:
• Journal
• Subscription
• Purchase order
• Returned order
• Blanket order
Journal
The Purchase order type Journal is used as a draft. It does not affect stock
quantities and does not generate any item transactions and the quantity on the
order line will not be considered in the Master scheduler.
EXAMPLE: A Purchase order of the type Journal can be used when importing data by
batch; in this manner, the Purchase order can be reviewed and evaluated without
affecting inventory, on-order, or other numbers.
Subscription
The Subscription type of Purchase order is used for repeated purchases of the
same goods or services. When a packing slip is updated, Microsoft Dynamics AX
2009 generates a receipt. When the invoice is updated for the receipt, a new
packing slip or invoice entry can be updated for the same purchase line
immediately or at some future date. The order will never be at an Invoiced status
only Open or Received.
Purchase Order
The Purchase order type is used when you want to send a vendor a purchase
order and enter it in the system. When you create a new order, the type can be set
to default to Purchase order type in the Parameters form depending on the client's
business process.
Returned Order
The Returned order type is used when you return goods to the vendor. A Return
Merchandise Authorization (RMA) number supplied by the vendor is required
when you enter this kind of order.
EXAMPLE: Your supplier sent the incorrect size of screws. The purchaser contacts the
vendor, requests an RMA, and uses the Purchase type Returned order to track the
return. This purchase type can also be used to return damaged or otherwise defective
goods to the supplier.
Blanket Order
The Blanket order type of Purchase order is used if there is a contract with the
vendor for a bulk quantity and price and you want to order off that contract.
Typically, a company uses blanket orders to receive better pricing conditions
because the blanket order quantity is bigger than on single Purchase orders.
Create a Release order to release, order, and invoice items against the Blanket
order until the contract is fulfilled.
Blanket orders do not affect stock quantities, do not generate item transactions,
and are not included in Master scheduling.
3. In the Lines tab, specify the total quantity for the item.
4. To ensure that a quantity and lot is selected when you create a
release order, enter a quantity in the Receive now field.
Scenario
You are a new accounts payable clerk at Contoso Entertainment Systems. You
have been in training all day, and the trainer has left you with the following
Purchase orders to create.
• One Purchase order for 20 item number 1507, from Fog Projectors.
• One Purchase order for 500 item number 1701, to be purchased in
increments of 100, from Opal Electronics.
• One Purchase order from Topaz Electronics, to be paid to Ruby
Electronics, for 50 item number 1705.
Challenge Yourself!
Create the Purchase orders according to the specifications from the scenario.
STOP HERE: The remaining steps, in Challenge Yourself Part 2, of this lab requires
skills gained later in Purchase Order and Purchase Order Posting . The rest of the lab
is therefore instructor-led. The reason for having the additional steps is to show a whole
process flow from order creation to invoice updating.
You may want to revisit this lab later when you have completed Purchase Orders and
Purchase Order Posting, at which stage you can execute all the steps in the lab.
1. For the second Purchase order, create the release order for the first
lot of 100 pieces.
2. For the third Purchase order, register and invoice update the order
and ensure that the invoice is printed to screen.
2. Change the Invoice account to pay-to a different vendor for the third
Purchase order.
Step by Step
You have now set up the three orders as instructed in the first part of the lab. In
the next part of the lab, you will create a release order for the blanket order and
invoice update the Purchase order for which the vendor and invoice address are
different.
1. Click the Purchase order of type Blanket order and then click
Functions > Create release order.
2. Click OK and a Purchase order is created for the first release
quantity.
3. Click the third order you created.
4. Click Inventory > Registration and post the registration.
5. Click Posting > Invoice.
6. Select the Print invoice check box.
7. Click OK.
You will find the Accounts payable parameters in Accounts payable > Setup >
Parameters.
• Purchase Type
• Prompt When Specifying Vendor and Invoice Account
• Purchase Order Prices/Amount
• One-Time Vendor Account
Purchase Type
Select any one of the Purchase order types as the proposed default type when you
create a Purchase order. You can override the setting at order creation.
The Purchase type parameter setting is useful if you normally use a particular
Purchase order type in the Purchase order process. For example, if your company
always starts the Purchase order process with an order of type Journal before
continuing to make a confirmed Purchase order, you will specify Journal in this
field.
Status Description
Selected If you create a new Purchase order, or modify an existing one,
you are prompted to copy vendor information base data, for
example name and address for the vendor account number, or
terms, for terms of payment, from the vendor's master record.
Cleared Vendor information is copied to the Purchase order without a
warning.
EXAMPLE: Select the Prompt when specifying vendor and invoice account
parameter so that master data can be confirmed for each order. For example, as the
purchaser enters the vendor number, he or she can confirm that the address in the
system for that vendor is current.
Status Description
Selected Print the price of the items on the purchase lines on the Purchase
order.
Cleared No pricing information is printed on the Purchase order.
EXAMPLE: You may not want to display Purchase order prices for your vendor so that
you do not hinder the possibility that the vendor will come back to you with a price offer
lower than that printed on the Purchase order update.
EXAMPLE: In the One-time vendor account field, specify vendor B2. When you create
a new one-time vendor, details such as payment terms, mode of delivery, and other
settings for vendor B2 default to the one-time vendor you have just created.
Scenario
You are a Microsoft Dynamics AX 2009 implementer. You have been asked to
visit the purchasing team at Contoso Entertainment Systems to provide additional
training so that the team can take better advantage of their system. When arriving
on site, you ask the team what they find time-consuming or cumbersome in their
daily procedures.
After some discussion, you learn that the team's work is cyclical: the first week
of the month, they process Purchase orders; the second week of the month is
when they process returns, and so on. Because this is the second week of the
month, you will train them on how to set their system to default to creating
Returned orders, and to eliminate the check for transferring vendor information.
Because the Purchasing department wants to receive the best possible price offers
from vendors, it is a policy that no pre-determined prices are printed on Purchase
orders sent out to vendors.
The company must frequently purchase from one-off vendors to compensate for
the shortfall in supply from one of its regular vendors, vendor 8011. These
vendors work with similar terms of payment, discounts systems, methods of
delivery, and so on to vendor 8011. To facilitate the one-time vendor's setup in
the Vendors table ensure that the base data template for one-time vendors is the
same as for vendor 8011.
Challenge Yourself!
Set up the parameters to meet the requirements as outlined in the scenario.
Step by Step
1. From the Navigation pane, click Accounts payable > Setup >
Parameters.
2. On the General tab, select Returned order as the Purchase type.
3. On the General tab, clear the Prompt when specifying vendor and
invoice account check box.
4. On the General tab, clear the Purchase order/price amount check
box.
On creation, the default delivery address on the Purchase order line is the
delivery address from the Purchase order header.
NOTE: You can use the Copy address from order button to upload an updated delivery
address from the Purchase order line to the Address selection form for reuse later.
HINT: If you only use the alternative address one time, it may be quicker to enter the
address manually on the line.
Whenever you run a Purchase order update, documents are printed for each
alternative delivery address.
Scenario
You will be receiving an order of 2,000 pieces of 1701 to two warehouses 21 and
22 on Site 2.
The 1,000 pieces for each warehouse must be delivered to a different dock than
usual because they must be stored in a warehouse area for fragile goods.
Therefore, you must specify an alternative receipt address that is used for the
fragile goods area at each warehouse.
Challenge Yourself!
Step by Step
7. On the line with warehouse 22 you must enter the address manually
on the Address tab of the lines section.
8. Click Posting > Purchase order and print the Purchase order
documents.
In addition, posting profiles help you control which ledger accounts are used and
when they are used when purchasing and selling inventory.
When you post a Purchase order in Microsoft Dynamics AX 2009 update the
order according to the stage it has reached in the order cycle. These stages
include:
This lesson discusses the complete cycle of the Purchase order, explaining each
step and its effect on other modules, such as Inventory management and General
ledger. Notice that what is covered here is the most basic and simple cycle. More
advanced functionality is available by using the Microsoft Dynamics AX 2009
Warehouse Management System (WMS) module, for example, for receiving and
shipping orders.
• One item
• An item group
• All items at the same time
You do not have to perform each Purchase order update for a given Purchase
order. For example, the first two steps are optional. If you post the invoice
without posting the packing slip, Microsoft Dynamics AX 2009 still posts the
invoice and receives the item.
NOTE: Microsoft Dynamics AX 2009 also provides you with the option of using the
Pro-forma button in the Purchase order form to go directly to the Posting forms for all
posting updates, that will have the Posting check box inactivated by default.
BEYOND THE BASICS: When you use the Warehouse management functionality, the
processing of Purchase order changes and the registering of item arrivals and receipts
are performed in the Inventory management module journals. Refer to the Microsoft
Dynamics AX 2009 Warehouse Management course for more information.
After a Purchase order has been created, the next step is to perform Purchase
order posting update.
The Purchase order is posted to confirm the Purchase order details such as
delivery dates, quantities, prices, and other order details, and to communicate
them to the supplier by using fax or e-mail. All the default values for Purchase
orders are set up in Accounts payable > Setup > Parameters.
Purchase orders can be posted multiple times; in this case Microsoft Dynamics®
AX 2009 stores each version of the Purchase order in a journal, by using revision
numbers.
NOTE: Neither the Purchase order status nor the inventory transaction change when
you update the Purchase order.
You can also specify multiple Purchase orders for Purchase order update by
specifying criteria in the Select query window opened from a specific Purchase
order or from the Periodic folder. To perform this kind of multiple update:
In the upper panel of the Posting Purchase order form the Parameters tab has
two field groups:
• Parameters
• Print options
• Quantity
• Posting
• Late Selection
Quantity
The Quantity field allows users to decide which quantity to post. The following
table explains the options available in this field.
Posting
Select the Posting check box to record the Purchase order revision in the journal.
If you clear the check box, a pro forma Purchase order will be generated and this
revision of Purchase order is not stored.
Late Selection
Clear the Late selection check box unless you plan to process the order at a later
date or time by using a batch process. This is the only point in the Purchase order
posting process that you have this option.
EXAMPLE: Late selection helps when a company wants to perform the printing of the
purchase orders at a specific time in the day. They will create a regular batch job that
runs all Purchase orders and prints or emails them at one time.
Select the Print purchase order check box to print a copy of the Purchase order
update.
Print Management
By selecting the Use the print management destination parameter, you enable
the print management system in Microsoft Dynamics AX 2009. Print
management is used for purchase and sales order updating.
• Which printer that will print specific updates. For example, set up the
following:
o Print management on the form setup level to print the Purchase
order at the purchaser's printer.
o The receipts list, to be printed at the warehouse printer so that
the warehouse workers have a receipt list available for receiving
the goods.
o The packing slip, to be printed at the goods receipt dock and a
copy to be printed at the purchaser's own printer. The invoice
original and copy are printed at the purchaser's printer.
o You can also specify settings for the specific order.
The print management settings are set up in a hierarchy, with each level
overriding the one underneath. Therefore, in the following table, Form setup is
the lowest level and the print management for the module overrides the form
setup settings and so on up the hierarchy.
Level Path
Form setup Accounts payable Accounts payable > Setup > Forms >
Form setup > Print management
Vendor Accounts payable > Vendor details >
select a vendor > Setup > Print
management
Purchase Order Accounts payable > Purchase Order
Details > select a Purchase order > click
Setup > Print management
NOTE: An icon with a blue arrow indicates that the original or copy record is inherited
from the module level or account level of the hierarchy. This is the print management
information that is used for the vendor, unless you make changes at the account or
transaction level.
The Check credit limit parameter does not come into effect until the first
physical updates occur at Packing slip update. Therefore, this is documented in
the section on Packing slip updates.
Automatic Summary
Before you can summary update Purchase orders by using Automatic summary,
you must:
NOTE: The Fixed assets tab will not be covered in the Microsoft Dynamics AX 2009
Trade and Logistics courses.
The two Purchase orders were selected for update and the value in the Quantity
field was Receive now. Therefore, the Purchase order where the line had a
Receive now quantity was updated with a tick because there was a Receive now
quantity to update. The other Purchase order had no Receive now quantity and
there was nothing to update. Therefore, a caution triangle appeared.
EXAMPLE: The accounts payable clerk at Contoso Entertainment Systems was on sick
leave during month-end processing and returned to work on July 3. However, all the
invoices must have a posted date of some time in June. By using the Document date
field on the Setup tab, the clerk can post the invoices in June.
By clicking Inventory, you can access all the inventory views that can be
accessed from the Purchase order line such as item on-hand, transactions and
other information. Additionally, you can register item arrival from this sub menu.
• Price
• Update and deliver remainder quantities
• Miscellaneous charges information
• Applicable discounts.
• Delivery address information
NOTE: A more advanced process for generating a receipts list is available in WMS
functionality. See the Microsoft Dynamics AX 2009 Warehouse Management course for
more information about WMS functionality.
Scenario
For the past six weeks, all the shipments Contoso Entertainment Systems have
received from one of their suppliers have been incorrect: either items are missing,
or extra items have been added. To address this situation, the receiving staff has
decided to print a receipts list for all purchases from this supplier, and compare
the shipment to the list before accepting the shipment.
If you selected the Print receipts list check box, a receipt list that contains all the
ordered items to be received is printed.
The parameter and print options and the line details are the same as described in
Post a Purchase Order.
If all items on a given Purchase order are received, the Purchase order Status
changes to Received.
EXAMPLE: You order 60 pieces of an item. You receive and register 40 pieces and
packing slip update the order. The status in the Status field is Open order. You receive
the final 20 items and packing slip update the order with the remaining 20 items. The
Purchase order status now changes to Received.
• Parameters
• Other
The Posting check box determines whether posting must occur on updating. The
table provides a description of the selection statuses.
Specify settings in the Print options field group. The Print management option
works the same as for Purchase order updating.
• None
• Balance
• Balance + Packing slip
• Balance + All
Of these options, ‘Balance + All’ most likely offers the best obligations.
If you are posting a credit note, select the Credit remaining quantity check box
to keep the remaining quantity on order. If the check box is cleared, the
remaining quantity is set to zero.
• Overview
• Setup
• Lines
• Line details
• Purchases
These tabs are used to view the details of the purchase orders and lines that will
be posted.
Tab Descriptions
Overview Tab
In the Overview tab you can review the details of the Purchase order to ensure
that you are processing the correct Purchase order. When you perform a packing
slip update, enter the vendor's packing slip number on this tab in the Packing slip
field.
Setup Tab
On the Setup tab, enter dates in the Packing slip date and the Document date
fields if it differs from today's date.
Lines Tab
Select the Lines tab to ensure that the items and quantities to be posted are
correct. You can also specify whether a Purchase order line must be closed for
additional updates by using the Close parameter. You can only close a line if the
under delivery percentage for the line allows for closing.
View additional details such as miscellaneous charge, discount settings and other
details on each item by clicking the Line details tab.
If the quantities posted on the packing slip update equal the ordered quantities,
the Purchase order status will change to Received. If there is a back order on one
or more items, the value in the Purchase order Status field remains at Open
order.
Purchases Tab
1. Create a Purchase order for 100 pieces of 1701 for vendor 2001.
2. In the Purchase order line, on the Setup tab, in the Under delivery
field, specify “60”. This means that under delivery of 60% is
accepted by the system.
3. In the Receive now field on the Quantity tab enter “60”.
4. Click Inventory > Registration to register the 60 pieces.
5. Click Posting > Packing slip.
6. In the Quantity field, select Receive now.
7. In the Packing slip field, type “20”.
8. In the lower pane, click the Lines tab. In the line you want to close
for additional updates, select the Close parameter.
9. Click OK and notice that the purchase order has the status Invoiced.
The Quantity field has four options. These work similar to the options for
Packing slip update except for the Packing slip option. If you select Packing
slip, the quantity invoice updated is the quantity that has been packing slip
updated. Use this update if you only want to financially update the quantity
received.
EXAMPLE: You have created a Purchase order for 50 pieces. Your supplier has
delivered 20 pieces and you have packing slip updated the receipt of the 20 pieces. To
keep this order financially updated, run an invoice update and select Packing slip in the
Quantity field. Only the 20 received pieces are financially updated when you invoice
update the order.
Using the Packing slip option is an easy way to manage and invoice partial
shipments because only the quantities that were updated to the order through the
packing slip update will be picked up and brought into the posting.
Clear the Posting field to print a pro forma invoice or select the check box to
financially post the invoice.
Adjust the print options in the Print options field group. Print options are the
same as for the Purchase order update.
Specify the summary update setting for purchase invoices. The Summary update
function is especially useful, from a sales administration point of view, because it
enables you to summarize orders in the system according to the way that you
invoiced those orders.
EXAMPLE: A vendor sends you one invoice a month to cover for the multiple
deliveries and purchase orders. By using the summary update functionality, you can
update all Purchase orders at the same time instead of processing them individually.
Overview
On the lower panel, review the detail on the Overview tab to ensure that you are
processing the correct Purchase order. Also use this tab to enter the vendor
invoice number.
Setup
Enter information for use on the payment proposal generated by this update. The
payment proposal is used when you process payments.
The fields that are present on this tab are described in the following table.
• Posting Date: This is the transaction date for posting the invoice in
the Ledger. It is used to calculate both the Due date and the Cash
discount date, unless you fill in the Document date field.
• Approved: When selected, this means the invoice has been
approved. This field is copied to the Accounts payable transaction.
Only approved transactions are included in the calculation of the
payment proposal.
• Approved By: This indicates who approved the invoice, as
identified by their log on ID.
Specify the bank account on the vendor and the bank account details
are automatically transferred to the Purchase order.
• Document Date: Specify the date the invoice was received. If you
complete this field, the date entered will be used for calculating the
due date and cash discount date.
• Due Date: Enter a due date to delimit the transactions in the
proposal. Enter a different due date if the due date for payment
differs from that specified in the regular terms of payment with the
vendor for the Purchase order. This functionality helps if you want to
bypass the standard due date calculation that was set up.
EXAMPLE: The purchaser has negotiated a special payment date for 100 pieces of an
item with a vendor at the end of the next month. As this differs from the standard terms
of payment of Current month+ 15 days that Contoso Entertainment Systems has with
the vendor, the new due date must be entered in this field.
• Fixed Rate: Select this field to indicate that a fixed exchange rate
must be used.
• Exchange Rate: Specify an exchange rate for the invoice currency.
This is editable only if you are by using a Fixed exchange rate
instead of the system exchange rate.
NOTE: To delete Purchase orders or Purchase order lines, or both, after complete
invoicing in Accounts payable > Setup > Parameters > Updates tab, select one or both
of the following parameters:
When you post the invoice, the Invoice remainder quantity for each item is
updated with the total of the received quantities from the selected packing slips.
If both the Invoice remainder quantity and the Deliver remainder quantity for all
items on the Purchase order are zero, the status of the Purchase order changes to
Invoiced. If the Invoice remainder quantity is not zero, the status of the Purchase
order is unchanged and additional invoices can be entered for it.
Scenario
You are the new purchasing clerk for Contoso Entertainment Systems and you
are entering Purchase orders based on verbal requests. In five of the Purchase
orders, you notice that the orders are with two vendors. Because one of your
goals is to issue as few purchase invoices as possible, you summary update the
orders by vendor.
• Three Purchase orders with Vendor account 2001, each for five
pieces of item number 1701.
• Two Purchase orders with Vendor account 2002, each for five pieces
of item number 1701.
Challenge Yourself!
HINT: Remove the default order settings on item number 1701 if you want to avoid a
warning each time you enter “5” in the Quantity field of the purchase order line.
Step by Step
NOTE: If you have not removed the default order settings for item number 1701, you
will receive a warning. Click No to override the default order settings and approve an
order quantity of 5.
An invoice arrives for one thousand batteries at a price of 1.10 USD each. The
company policy allows a five percent price tolerance for this category of item. A
price of 1.05 USD may be acceptable, but 1.10 USD is not. When the invoice
information is entered, Microsoft Dynamics™ AX 2009 identifies that there is a
price matching discrepancy and the invoice can be saved until the difference is
resolved.
Price Tolerance
Price tolerance information can be set up for all items, for item price tolerance
groups, or for individual items.
1. Click Accounts payable > Setup > Price/Discount > Vendor price
tolerance groups.
2. Press CTRL+N to create a new vendor price tolerance group.
3. Enter an identifier for the vendor price tolerance group and a name.
The default company price tolerance is zero percent and is applied to all items
and all accounts (All, All). You cannot delete the default company price
tolerance record.
NOTE: You cannot enter a negative price tolerance percentage. By default, Microsoft
Dynamics AX 2009 enables negative price discrepancies. To track negative price
tolerance percentages, select “If line prices are greater than or less than allowed
tolerance” in the Display price match icon field in the Parameters form.
On the Overview tab, the columns shown in the following table are associated
with the Invoice matching feature.
Column Description
Packing slip The packing slip that is associated with the invoice. If
multiple packing slips are associated, an asterisk (*) is
displayed.
On hold If selected, indicates that the invoice can be saved but not
posted. For example, if there is a problem with the
invoice, you might put it on hold while you contact the
vendor and resolve the problem. When this check box is
selected, the status of the invoice changes to Pending.
Column Description
Match variance Displays a check mark if the variance between the
invoice net unit price and the Purchase order net unit
price is within allowed tolerances for lines on the invoice,
and if the invoice quantity and the packing slip quantity
is equal for all lines on the invoice.
Displays a warning icon if matching discrepancies exist;
that is, if the price variance exceeds the allowed
tolerance, or if the invoice quantity and packing slip
quantity are different for one or more lines on the
invoice. To view detailed information, click Matching
details.
This field is available only if the Use invoice matching
for this company check box is selected in the Accounts
payable parameters form.
On the Lines tab, the two fields shown in the table present information about the
difference between the packing slip and the invoice lines.
Fields Description
Packing slip Displays a check mark if the invoice quantity and the packing slip quantity
quantity match are equal for the selected line.
Displays a warning icon if the invoice quantity and packing slip quantity
are different for the selected line. To view detailed information, click
Matching details.
This field is blank if the invoice line quantity is positive, the Receiving
requirements check box for the item's inventory model group is cleared,
and the invoice line is not connected to any packing slips.
This field is blank if the invoice line quantity is negative, the Deduction
requirements check box for the item's inventory model group is cleared,
and the invoice line is not connected to any packing slips.
Price match Displays a check mark if the variance between the invoice net unit price
and the Purchase order net unit price is within allowed tolerances for the
selected line.
Displays a warning icon if the price variance exceeds the allowed tolerance
for the selected line. To view detailed information, click Matching details.
NOTE: Microsoft Dynamics® AX 2009 does not match packing slips automatically
unless Packing slip is selected in the Quantity field on the Posting invoice form.
The form displays all the lines items to the current invoice and from here you can
match packing slips to the invoice you are working with.
1. In the Match packing slips to invoice form, select the Match check
box for the packing slips to match with the invoice line items.
2. Or, click the Match all lines or Match all packing slips buttons to
match all packing slips to the invoice.
3. Click OK to save the changes and return to the Posting invoice
form.
Use the Posting invoice form to enter invoice information. If it is necessary, you
can use the Invoice matching details form to view, correct, and approve invoice
lines with matching differences for posting.
The Invoice matching details form is opened by clicking the Matching details
button on the Posting invoice form. The Invoice matching details form displays
all lines for the current invoice. For the line selected in the upper pane matching
information on Price, Quantity, and Invoice totals is available.
In the Posting invoice form, a check mark in the Variance approved column is
displayed. Therefore, the variance for the specific invoice line is approved. If the
column is blank, the variance for the line has not yet been approved.
NOTE: If the Matching details button is not available, you do not have access to the
Invoice matching details form. In the Posting invoice form, you can select the On hold
check box to save your work.
After identifying the discrepancy, you may have to contact your vendor if you
believe that the information on the invoice is incorrect. Depending on the
resulting agreement with your vendor, you can do any of the following tasks:
• Accept the price difference and post the invoice with matching
discrepancies
• Revise the invoice amount to the expected amount and post the
invoice
• Request a full credit from the vendor and a new corrected invoice
NOTE: If the Post invoice match discrepancies field in the Accounts payable
parameters form is set to Allow with warning, these fields are not available and you
must skip step 7.
NOTE: If the Receiving requirements check box is selected for the item's inventory
model group, and if the packing slip quantity is less than the invoice quantity, the
invoice cannot be posted even if it is approved.
Microsoft Dynamics AX 2009 lets you set up general posting rules for all items,
accounts, and sales tax codes. You can define primary posting in Accounts
payable Parameters for receipt and discounts.
You can specify a Vendor group in the Account relation field and add it to the
posting hierarchy.
Based on your type of business , you must decide which accounts must be set up.
This is a receipt scenario. When you packing slip update the Purchase order the
packing slip account is debited and the packing slip offset account is credited.
When the Purchase order is invoiced the last posting is reversed and the
inventory receipt account is debited and the accounts payable is credited.
If no account is specified for the line discount, the inventory receipt is posted
after the line discount is deducted, and the latter is not recorded directly in a
ledger account.
BEST PRACTICE: Clear the Post financial inventory and Post physical inventory
parameters for a Service item type to use the Consumption account.
Any tax is debited in the Tax code account and item purchases, including tax, are
credited to the Vendor summary account according to the setup in the supplier's
Posting profile.
Learn more about Costing methods in the Microsoft Dynamics AX 2009 Costing
and Inventory Valuation course.
Summary
Purchase Orders and Purchase Order Posting reviewed how to use the basic
Purchase order functionality and how to perform posting updates to Purchase
orders through all the posting updates. The following areas were covered:
Learning about Purchase orders and Purchase order posting helps you create
basic Purchase orders in Microsoft Dynamics AX 2009. Additionally, learning
about the more advanced purchase features helps to:
Additionally, learning about how posting integrates to the ledger helps you
determine how item transactions are posted, the account types that are used and
how the specific setup of accounts affects how the business records revenue and
costs.
1. In which module(s) are Sales and Purchase order posting profiles set up?
2. Sales order and Purchase order posting is set up based on what hierarchy?
4. Name five of the accounts you can set up in Purchase order posting profile
setup.
6. What must you select in the Quantity field of the Posting invoice form to
match packing slips automatically in Microsoft Dynamics® AX 2009?
( ) All
( ) Receive now
( ) Registered
( ) Packing slip
1.
2.
3.
Solutions
Test Your Knowledge
1. In which module(s) are Sales and Purchase order posting profiles set up?
2. Sales order and Purchase order posting is set up based on what hierarchy?
MODEL ANSWER - Item, Table Item group, Group All items, All
4. Name five of the accounts you can set up in Purchase order posting profile
setup.
price offset, Charge, Stock Variation, Packing Slip Purchase, Packing Slip
6. What must you select in the Quantity field of the Posting invoice form to
match packing slips automatically in Microsoft Dynamics® AX 2009?
( ) All
( ) Receive now
( ) Registered
(•) Packing slip