Agenda

1. Introduction
2. How to post an Invoice
3. Sales Taxes
4. Commissions
5. Post an invoice
6. Summary

Introduction

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:

1. The Invoice document is printed.
2. General ledger transactions are generated: inventory account is decreased, cost of goods sold is increased, Customer account is increased, Sales account is decreased.
3. Inventory transactions issue status is changed from Deducted to Sold

How to post an Invoice

The Sales Manager performs the following actions:

1. Open the Sales order form and find an appropriate sales order.
2. Click the Posting > Invoice menu button. The Posting invoice form opens.
   

   Posting invoice form

3. The Sales Manager verifies the line quantities and prices.
4. Select the Print invoice check box.
5. Click the OK button (don’t do this right now).

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

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:

1. Open the Sales order form.
2. Find an appropriate sales order.
3. In the lines area, go to the Setup tab.
4. Under the Sales tax field group, fill in the Item sales tax group and Sales tax group fields.

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.

Sales tax codes form

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.

Sales tax settlement periods form

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.

Authority form

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:

1. Go to General ledger > Setup > Sales tax > Ledger posting groups. The Account group form opens.
2. Find the CAST ledger posting group (the AV_CAST sales tax code belongs to it).
   

   Account group form

3. The Sales tax payable field contains the general ledger account that will be used during invoice posting.

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.

Sales tax groups form

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.

Item sales tax groups form

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:

1. Open the Sale order form. Find an appropriate sales order.
2. In the sales order line area, go to the Setup tab.
3. Fill in AU/VI in the Item sales tax group field.
4. Fill in CA in the Sales tax group field.
5. Save the line. The “Delivery date control is disregarded because the receipt date 6/10/2010 is before today” message will be shown. Ignore it.

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.

Temporary sales tax transactions form

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.

Commissions

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:

1. Go to Administration > Common Forms > Users.
2. Find you account in the Users form (You can get the information about you account under Administration > Common Forms > Online users).
3. Click the User relations button. The User relations form opens.
4. Go to the General tab.
5. Fill in 7210 in the Employee field.
   

   User relations form

6. Close the form.

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.

Commission calculation form

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:

1. Go to Inventory management > Common Forms > Item details. The Item form opens.
2. Find the Bottle item.
3. Go to the General tab > Groups field group > Commission group field.

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:

1. Create a new line in the Commission calculation form.
2. Select Table in the Item code field.
3. Fill in 1 (Bottle) in the Item relation code field.
4. Setup Customer:
   • If we want the Sales Manager to receive commission when invoicing any customer, select All in the Customer code field.
   • It is possible to set up specific customer commission group. In this case, select Group in the Customer code field. The Customer commission group is created under Accounts receivable > Setup > Commission > Customer groups for commission. A Customer is assigned to a Customer commission group under Accounts receivable > Common Forms > Customer details > Sales order tab > Sales order field group > Commission customer group field.
   • It is possible to set up specific Customer. In this case, select Table in the Customer code field.

   We assume that the Sales Manager must receive commission when he or she invoices only the 1000 (Natural Juice) Customer.

5. Select Table in the Customer code field.
6. Fill in 1000 (Natural Juice) in the Customer relation field.
7. Perform settings for the Sales Manager:
   • If we want all Sales Managers to receive commission when invoicing the Natural Juice Customer buying the Bottle item, we must select All in the Sales rep. code field.
   • If only a certain sales team must receive commission, we must select Group in the Sales rep. code field and fill in the necessary group in the Sales rep. relation field. The Sales team belongs to the sales commission group. The sales commission group is set up under Accounts receivable > Setup > Commission > Sales groups. (The Commission sales group form opens.) We can assign a new Sales Manager to the sales team in the Commission sales group form > Sales rep. button > create new record. Or under Basic > Common Forms > Employee details > Commission menu button > Sales groups button> create new record.

     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).

   

   Sales rep. 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:

   1. Go to Basic > Common Forms > Employee details. The Employee form opens.
   2. Find the employee account that is associated with our User ID (It is employee account 7210).
   3. Click the Commission > Sales groups menu button. The Commission shares form opens.
   

   Commission shares form

   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.

8. Select Group in the Sales rep. code field.
9. Fill in 20 in the Sales rep. relation field.
10. Fill in 10 in the Origin field. Note: all sales team will receive 10% commission; our Sales manager will receive 45% of this commission (4.5%). So, it is less that we assume.

Our new record looks as follows:

Commission calculation form

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:

• Debited to the Commission account.
• Credited to the Commission offset account.

To access the Commission posting form, go to Accounts receivable > Setup > Commission > Commission posting.

Commission posting form

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).

Post an Invoice

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:

1. The Invoice document is printed.
   

   Invoice document

   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.

2. Issue status on inventory transactions is changed from Deduct to Sold. To check this, in the lines area of the Sales order form, click the Inventory > Transactions menu button. The Transactions
   form opens.
   

   Transactions form. Sold status.

3. General ledger transactions are generated. Let’s check the general ledger transactions that are created during posting of an invoice document. All information about the invoice can be viewed under Sales order form > Header area > Inquiry button > Invoice menu button. The Invoice journal form opens.
   

   Invoice journal form

   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.

   

   Sales tax transactions form

   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.

   

   Misc. charges transactions form

   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.

   

   Commission transactions form

   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):

   • Total invoice amount is 12,875.50.
   • Sales tax is 940.50.
   • Carrier charges amount is 535 (Core charges = 400, Ancillary charges = 105, Handling charges = 30).
   • Commission is 1,140.
   • Items sales price is 11,400.

   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.

   

   Voucher transactions form

   Analyze the voucher transactions (i.e. general ledger transactions):

   • Total invoice amount is 12,875.50. This amount is recorded to account 130100. So, this account is used to track Customers’ balances (the amount of money that must be paid to our Company from customers).
     This general ledger account is taken from the default posting profile that is set up in the Account receivable parameters form located under Accounts receivable > Setup > Parameters > Ledger and sales tax tab > Posting field group > Posting profile field. Our demo data contains GEN in the Posting profile field. To find the posting profile setup, go to Accounts receivable > Setup > Posting profiles > find GEN posting profile > Setup tab.
     

     Customer posting profile form

     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.

   • Sales tax is 940.50. This amount is recorded to general ledger account 220110. So this account is used to track the Authority balance (the amount of money that must be paid to the Authority).

     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.

   • Carrier charge is 535. In the previous training lesson, we analyzed that the carrier charges are taken from the Customer and stored in special general ledger accounts. This is set up in the Misc. charges code form located under Accounts receivable > Setup > Misc. charges > Misc. charges code > Posting tab > Credit account field.

     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.

   • Commission is 1,140$. This amount is recorded to accounts 211500 and 602140. Account 211500 is used to track commission (the amount of money that must be paid to sales persons). Since the commission is included into the invoice amount, we must record that the commission is an expense (net profit must exclude the commission). This amount is recorded to account 602140. These general ledger accounts are taken from the Commission posting form located under Accounts receivable > Setup > Commission > Commission posting.

     We have already studied how general ledger accounts are set up for the commission in the Commissions chapter of this training lesson.

   • Item sales price (or revenue) is 11,400. This amount is recorded to account 401190. So, this account is used to track the revenue (the amount of money that must be paid for sales items).

     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.

     

     Item group form

     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.

   • Inventory transaction. Inventory transaction is also reflected in the general ledger accounts. When the items are sold, the cost amount must be excluded from inventory value and included as cost of goods sold. Remember that in this training lesson, we set up the Bottle item cost to be 5 and the Can item cost to be 7. So, the total cost amount is 1000*5 + 200*7 = 6,400$. This amount is recorded to accounts 510190, 142300, 141050, and 130300.

     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.

   • Penny difference. Sometimes it happens that the amount in the general ledger account and the amount in the offset account(s) are not equal because of rounding. If we sum all general ledger amounts, we must receive zero. Because nothing disappears but only changes its form. In our case, if we sum all amounts in the secondary currency (the Amount secondary currency fields), we receive -0.01. So, Microsoft Dynamics AX generates additional general ledger transactions for amount 0.01. This amount is recorded to account 999999. This general ledger account is set up under General ledger > Setup > Posting > System accounts.
     

     System accounts form

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.

Summary

In this training lesson we have done the following:

1. Set up sales tax.
2. Set up commission.
3. Post an invoice.
4. Analyze results of invoice posting process (invoice document, inventory transactions, and general ledger transactions).

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:

1. How to create an Item
2. What an item group, an inventory model group, and an inventory dimension group are
3. Purchase business process
4. How to create a Vendor
5. Warehouses, aisles, racks, shelves, bins, store zones, store areas, and locations
6. Forklifts and pallet types
7. How to create a Purchase order
8. Item arrival and registration process in Microsoft Dynamics AX
9. Print management system
10. Purchase order posting: Packing slip and Invoice
11. Sales business process
12. How to create a Sales order
13. Available to promise
14. Shipment process in Microsoft Dynamics AX
15. Shipping carrier interface
16. Miscellaneous charges, sales tax, and commissions
17. Sales order posting: Packing slip and Invoice

The following issues are not included into the training:

1. Serial and batch numbers
2. Quarantine management
3. Vendor returns
4. Customer returns
5. Over/Under Delivery
6. Customer and Vendor Trade Agreements
7. Request For Quote
8. Purchase Requisitions
9. Sales Quotation
10. Quality Management
11. Transfer Orders
12. Inventory Journals
13. Inventory Reporting and Statistics

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! 😉