Hi, in this training lesson, we will finalize the work with the sales order. The last step in the sales order processing is posting and printing a Sales order invoice.
We go through the main steps of the process, understand sales order financial posting, and analyze the results (include the shipping carrier charges).
The Sales Manager posts an Invoice to record in the system that the items are sold. During this process, an Invoice document is printed. The Invoice document is a guarantee that the items are sold to the Customer and the Customer must pay for them during a certain period. This document is sent via a fax or an e-mail to the Customer for sign.
The results of the invoice posting process are as follows:
The Sales Manager performs the following actions:
Let’s complicate the task. The Sales Manager wants to set up sales taxes for sales order lines. Let’s assume that the company is in California. So, the Sales Manager must set up 8.5% sales tax for the sales order.
Sales taxes of different kinds are applied in every country. Sales taxes have a lot of types (see here ). Each country (even a district) has a lot of different taxes; see for example sales taxes in the United States.
To set up a Sales tax for the Sales order, the Sales Manager takes the following steps:
Item sales tax group and sales tax group contain sales tax codes. Sales tax codes included into both groups are applied to the sales order line.
The Sales tax code contains the rules on how the tax will be included into an invoice.
Sales tax codes are set up under General ledger > Setup > Sales tax > Sales tax codes.
We don’t need to create a new sales tax code because our demo data already contains an appropriate one. It is the AV_CAST sales tax code. This code contains the following setup: 7.25 (Percentage/Amount field) percent will be calculated from the net invoice amount (Origin field) and must be paid as a sales tax to California Authorities in the end of the quarter (Settlement period field). We see that the sales tax code from our demo data contains 7.25%, but currently the sales tax for California is 8.25%. That is because California governor Arnold Schwarzenegger increased the sales tax by 1% in year 2009. You can read about California budget crisis in Wikipedia.
To set up 8.25%, click the Values button in the Sales tax codes form. In the Values form, enter 8.25 in the Value field. Close the form.
As you understand, each sales tax code belongs to the Settlement period which is set up under General ledger > Setup > Sales tax > Sales tax settlement periods.
The Settlement period form contains the information about the authority and the period.
Authorities are created and set up under General ledger > Setup > Sales tax > Sales tax authorities.
An authority contains different information but the major one is the Vendor account. The vendor account will be used to track amounts of money that must be paid and that were paid by the Company to the California authority.
In other words, the Authority is vendor. Our company buys nothing from this vendor and pays money =).
The AV_CAST sales tax code will be paid to the CAA authority which is 7001 Vendor.
When the invoice is posted, the vendor transaction is created.
Also, the general ledger transaction is created. Each sales tax code belongs to the ledger posting group (General ledger > Setup > Sales tax > Sales tax codes form > Overview tab > Ledger posting group field). This group contains the information about general ledger accounts that will be used for different types of sales tax during invoice posting.
Let’s find out what general ledger account will be used for tracking the authority (vendor) transactions:
We can see that it is the 220110 general ledger account. Remember this account because when we post an invoice, we make sure that 8.25% tax amount on net invoice amount is recorded onto this account.
We already know that in the sales order lines, only the sales tax group and the item sales tax group are set up. So, we should find or create a sales tax group that contains the AV_CAST sales tax code and find or create an item sales tax group that contains the AV_CAST sales tax code.
Sales tax groups are set up under General ledger > Setup > Sales tax > Sales tax groups. The Sales tax groups form already contains the CA (California) sales tax group. Click the Setup tab to make sure that the AV_CAST sales tax code belongs to this group.
We can see that the CA sales tax group contains three sales tax codes.
We have discussed earlier that sales tax codes included into both groups (sales tax and item sales tax) are applied to the sales order line. So, the Item sales tax group must exclude the HR_CAST and SP_CAST sales tax codes and include the AV_CAST sales tax code.
The item sales tax group is set up under General ledger > Setup > Sales tax > Item sales tax groups.
We don’t need to create new item sales tax groups, because our demo data already contains a relevant item sales tax group. This is the AU/VI item sales tax group. Let’s check that the AV_CAST sales tax code belongs to this group and HR_CAST and SP_CAST do not belong. In the Item sales tax groups form, go to the Setup tab.
We can see that this group contains the AV_CAST sales tax code and other sales tax codes, but they are not included into the CA sales tax group.
Good. Now, let’s set up the CA sales tax group and the AU/VI item sales tax group in the sales order line:
Perform the same steps for the second line.
We can now check the sales tax amount:
In the header of the Sales order form, click the Setup > Sales tax menu button.
The Temporary sales tax transactions form shows.
We cans see that the total sales tax amount is 940.5 (9000*8.25 + 2400*8.25 = 940.5).
In our case, the Sales Manager sets up the item sales tax group and sales tax group manually. In real life, they are filled in by default.
Item sales tax group is set up per item under the following path Inventory management > Common Forms > Item Details > References tab > Sales order field group > Item sales tax group field.
Sales tax group is set up per customer under Accounts receivable > Common Forms > Customer Details > Setup tab > Sales tax field group > Sales tax group field.
Let’s assume that the Sales Manager must receive a 10% commission for each sale.
The Sales Manager has an employee account. An employee account is set up per Microsoft Dynamics AX User under Administration > Common Forms > Users > User relations button > General tab > Internal user field group > Employee field.
So, when you log on to Microsoft Dynamics AX, the system finds your employee account.
Link your User to employee account 7210 by following the steps:
Let’s understand how commission is calculated. I have retyped a paragraph from the Microsoft Official Training Materials for Microsoft Dynamics: “Microsoft Dynamics® AX2009 calculates sales commissions at the sales line level upon invoicing a sales order. When calculating the commission of a sales line, Microsoft Dynamics AX 2009 searches for the related sales representative, item, and customer combination set up in the Commission calculation form. In this form, relationships are set up between the combinations of items, customers, and sales representatives to define the commission rate an employee is paid from a sale“. The sales representative is the Employee account that is associated with the User ID.
To open the Commission calculation form, go to Accounts receivable > Setup > Commission > Commission calculation.
Let’s analyze the form and find what commission will be calculated for our sales order.
We can see that the commission is set up only per a commission item group, because the item code = Group for all lines.
Find the commission group that the Bottle item belongs to:
The Commission group field for the Bottle (and Can) item is empty. So, the commission calculation for these items is not set up in the Commission calculation form, because this form contains the setup only for the item commission group.
Create a new commission calculation:
We assume that the Sales Manager must receive commission when he or she invoices only the 1000 (Natural Juice) Customer.
If the Sales Manager belongs to the sales team, the commission is received by each member of the team as it is divided between all members according to the percent parameter. The percent is set up in the Sales rep. form (click the Sales rep. button in the form).
Only two choices are available (All sales managers or sales team). We assume that only the sales team that our Sales manager belongs to must receive the commission. So let’s find the Sales commission group that includes employee 7210:
We can see that the Sales Manager belongs to sales teams 20 and 30. The Sales Manager receives 45% of all commission earned by sales team 20 and 20% of that earned by sales team 30.
Let’s assume that the Sales Managers included into sales commission group 20 can receive commission.
Our new record looks as follows:
Create the same record for the Can item.
During posting of an Invoice, the commission amount will be recorded to special general ledger accounts.
The Commission posting form is used to link General ledger accounts to a commission transaction. When a sales order is invoice-updated, the commission amount on the posted sales line is:
To access the Commission posting form, go to Accounts receivable > Setup > Commission > Commission posting.
Remember general ledger account 602140. This account belongs to the Expenses group. Also, remember general ledger account 211500. This account is used to store amounts of money that must be paid to Sales Managers. This account belongs to the Vendor group. So, from the Company’s point of view, the Sales Manager is the vendor who delivers order invoices.
We can’t see the commission amount on the sales order until we post an invoice.
If we want the commission to be taken into account during invoice posting, we must set up a commission sales group on the sales order line (in the line area of the Sales order form, go to the Setup tab and fill in the Sales group field group with 20. Make the same setup for the second line. (When we save the line, the “Delivery date control is disregarded because the receipt date 6/10/2010 is before today” message appears; just close it).
The Sales Manager sets up sales taxes and commission, reviews the charges for the carrier. Now, it is time to post the Invoice.
The Sales Manager goes to the Sales order form, finds an appropriate sales order, and clicks the Posting > Invoice menu button. The Posting invoice form opens. The Sales Manager selects Packing slip in the Quantity field of the Parameter field group. Go to the Lines tab and make sure that the quantities and other parameters are correct. Select the Print invoice check box. And finally, he or she clicks the OK button.
The result of the posting process is as follows:
In the Invoice document, we can find the information about the invoice total amount (12,875), sales tax amount (940.50), and carrier charges included in the misc. charges (535). The Invoice total amount is calculated as item price + misc charges + sales tax, i.e. 12,875 = 11,400 + 535 + 940.50.
Check the sales tax. In this training lesson, we have set up 8.25 % sales tax. The sales price is 11,400, so the sales tax is 11,400 * 0.0825 = 940.50. Good, it is just like in the invoice.
Check the carrier charges. Remember that in the previous training, we set up the following charges – core charges = 400, handling charges = 30, fuel surcharge = 270, and ancillary charges = 105. The total charge amount is 400 + 30 + 270 + 105 = 805. In the Invoice document, the misc. charges value is 535. Why is there such difference (805 – 535 = 270)? That is because we have forgotten to select the Charge fuel surcharge check box in the Sales order form (Sales order form > Header area > Delivery tab > Carrier information field group > Charge fuel surcharge check box). So, the fuel surcharge is not included in the Invoice total amount.
Commission amount is not printed in the Invoice document.
Before we check the general ledger transactions, let’s recall the sales tax, carrier charges, and commission amounts.
To find the posted sales tax amount, click the Posted sales tax button in the Invoice journal form. The Sales tax transactions form opens.
The total posted sales tax amount is 940.50.
To find the carrier charges included into the invoice, click the Misc. charges button in the Invoice journal form. The Misc. charges transactions form opens.
The total carrier charge is 400 + 105 + 30 = 535.
To find the commission amount, click the Commission > Commission transactions menu button. The Commission transactions form opens.
Since the commission is received by the sales team, we can see that our Sales Manager (employee account 7210) will receive the 405$ commission for selling Bottle items and the 108$ commission for selling the Can items. The total commission amount is (10% * 11,400) / 100% = 1,140. (If we sum all employee commissions, we receive the same amount – 1,140).
So, again (all amounts are in one place):
Let’s check the general ledger transactions. In the Invoice Journal form, click the Voucher button. The Voucher transactions form opens. This form contains general ledger transactions generated during the invoice positing process.
Analyze the voucher transactions (i.e. general ledger transactions):
The Natural Juice customer belongs to customer group 20 (Major Customers). So, only the last record is right one for our Customer. The summary account for this record is 130100.
The 220110 account is taken from the ledger posting group that is set up on the sales tax codes. We have already studied how a general ledger account is set up for the sales tax in the Sales taxes chapter of this training lesson.
In our demo data, for the Core or Freight charges, general ledger account 403500 is used, for the Handling charges, it is the 403150 general ledger account, for the Ancillary charges, it is also the 403500 general ledger account.
So, in the Voucher transactions form, we can see that 400 + 105 = 505$ is recorded to account 403500, and 30 is recorded to account 403150.
This general ledger account is taken from the item group. The Bottle and Can items belong to the Packaging item group.
Go to Inventory management > Setup > Item groups. The Item group form opens.
Go to the Sales order tab.
The Revenue field contains the general ledger account that will be used to track the revenue amount. We can see that this field contains general ledger account 401190.
Account 510190 is used to track the cost of goods sold. Account 141050 is used to track the inventory value (cost of items in the warehouse). These accounts are set up in the Item group form > Sales order tab > Invoice field group > Issue and Consumption fields (see the previous picture).
When we post the packing slip, general ledger transactions are generated for accounts 142300 and 130300. Find these transactions in this training lesson (the “Voucher transactions form, Packing slip transactions” image). During posting of an invoice, these general ledger transactions must be reversed.
Note: If you do not feel confident in finance I recommend that you go through this financial training. When I was learning finance in Microsoft Dynamics AX, it was an essential source of knowledge.
In this training lesson we have done the following:
This is the last lesson in the Trade and Logistics training. I hope this training will help you understand the Microsoft Dynamics AX Trade and Logistics module.
The following issues have been covered during the Trade and logistics training:
The following issues are not included into the training:
I am planning to create a video training to be paid for the Trade and Logistics module that will cover all these areas. You can follow me on Facebook or Twitter and be informed about the status and the progress of this training.
Thank you all for nice words. You really support me! 😉