Interview Questions

Tuesday, December 22, 2015

Sales Process

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

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

Post Dated Checks in Microsoft Dynamics AX 2012

I wanted to introduce functionality of AX 2012 to your knowledge , and I am sure this is a a widely accepted and used practice in business.
Post-dated checks are checks which are delivered now with a date in the future, so that it cannot be cashed until that date.
Checks are one of the primary ways to make and receive payments and issuing of PDC is a very widely used practice across many businesses today. A post dated check is one which has a future date on it Microsoft dynamics AX 2012 brings the PDC functionality in both AR and AP modules with the financial dimensions, check printing, banking functionality and the settlements functionality.
In today’s post, we will take a look at the setup and processing of the PDC in AX 2012.
  1. First step is Enable PDC in Cash and Bank management parameter form.
pdc 001
Post journal entries for postdated checks: If this check box is marked, then financial transactions will be posted to the clearing accounts for vendor/customer using the account.
General journal for clearing entries: Select the journal which will be used to settle postdated transactions.
Transfer postdated checks to this payment journal: This vendor payment journal will be used to record the postdated transactions.
Now that we have done the required setups to enable PDC  in AX 2012, let us take a examine  at the transactions and other impacts by a PDC from a vendor.
Step 1:  Create a new method of payment under AP module and Mark the Bridging posting  for thismetg
Note**  when you select the Postdated check clearing posting checkbox, the bridge posting gets automatically checked and the bridging account defaults from the cash and bank Management > Setup > Clearing account for issued checks
Step 2: Create an AP payment journal and select the PDC method of payment
pdc1
Notice that when you select PDC as the method of payment, the offset account automatically defaults which is the clearing account for issued checks.
Also see that the postdated check tab is enabled, when you click on it, you can enter other additional information related to the Check such as the maturity date, received date, check number, issuing bank and branch
PDC-02
After you post this journal, below is the financial voucher.
pdc-0005
Users can view and track all the Vendor Post dated checks  in the AP > Common > Post Dated Checks form. When the check maturity date reaches, you can click Settle clearing entries button, and system automatically posts the general journal for this clearing entry. Screenshot below.
pdc-03
Note * – You can also click the Checks to send to bank button and system will automatically filter all the checks which have reached the maturity dates and needs to be sent to the bank.

Reconcile a bank account [AX 2012]

When you receive a bank statement, you should periodically reconcile legal entity bank transactions with the transactions on the bank statement.
You cannot reconcile a bank statement with a bank account if any of the checks or deposit slip payments that are listed on the statement currently have a status of Pending cancellation. After a reviewer posts or rejects a check reversal or deposit slip payment cancellation, the status is no longer Pending cancellation, and you can reconcile the bank account. For more information, see Reverse a posted check or Cancel a deposit slip payment.
  1. Click Cash and bank management > Common > Bank accounts. Double-click the bank account to reconcile with the bank statement.
  2. On the Action Pane, click Account reconciliation, and then enter information as appropriate.
    You must enter information in the Bank statement date and Bank statement fields. In the Ending balance field, you can enter the balance of the bank account as it appears on the bank statement. For more information, see Bank statement (form).
  3. Click Transactions to open the Account reconciliation form. The upper pane displays the bank account transactions that have not yet been reconciled with a bank statement.
    NoteNote
    To maintain an overview of transactions as you continue, limit or expand the view of the account transactions by changing the value in the Show transactions list.
  4. For each transaction that is included on the bank statement, select the Cleared check box if the amount in Microsoft Dynamics AX corresponds to the amount on the bank statement. You can also enter or modify the value in the Bank transaction type field. This field value is important for bank transaction statistics and for some reports.
    NoteNote
    Do not select the Cleared check box for transactions that are not on the bank statement. These transactions will continue to be displayed in this form until they are reconciled with a future bank statement.
    The Cleared check box is not available if the transaction has a status of Pending cancellation. Transactions might have this status if Microsoft Dynamics AX is set up to require that reversals or cancellations be sent to review before they are posted. After a reviewer posts or rejects the reversal or cancellation, the status is no longer Pending cancellation, and you can reconcile the bank account with the bank statement. For more information, see Set up a review process for reversals and cancellations.
    To select the Cleared check box for an interval of checks that all are displayed on the bank statement, click Mark check interval, and then indicate the interval.
  5. If the amount for a bank account transaction does not correspond to the amount for the transaction on the bank statement, enter the amount of the correction in the Correction amount field, enter an offset main account for the correction amount in the Main account field, and then enter explanatory information in the Description field.
    NoteNote
    If the fiscal period of the transaction to be corrected is closed, the Correction amount field cannot be used. Instead, create a line that has a transaction date that is in an open fiscal period for the correction. In this case, you must add the financial dimensions that were used on the original transaction, and also the offset main account and the description.
  6. Create transactions for entries, such as fees and interest, that are on the bank statement, but that are not recorded in Microsoft Dynamics AX. Enter the offset main account, description, and appropriate financial dimensions.
  7. As the transactions on the bank statement are marked as Cleared, the amount in the Unreconciled field, which is recalculated continuously as you make changes, approaches zero. When it reaches zero, click Reconcile account to post the reconciliation, and the transactions and corrections that you have created.
    After the reconciliation is posted, the transactions that have been included cannot be modified or corrected, and they are not displayed for future account reconciliation.
  8. To view bank transactions that have not yet been reconciled, use the Unreconciled bank transactions report. To view the bank statement for a bank account, use the Bank statement report.

How to Void/Cancel/Reverse an Accounts Payable Payment that does not a have check number such as ACH, Wire or Electronic Payments in Microsoft Dynamics AX 2012.

This post is to assist with voiding/canceling/reversing Vendor Payments that do not have check numbers that you cannot revers going through Bank and Cash Management.
1. Go to the All Vendors list page - Accounts Payable | Common | Vendors | All Vendors
2. In the All Vendors list page select the vendor that you would like to apply the cancel payment against.
3. Once the vendor is selected click on the Closed Transaction Editing button in the Settle group of the Invoice tab to open the Closed Transaction Editing form

4. In the Closed Transaction Editing form find the payment that you would like to cancel and check the Mark checkbox. This will mark the Payment Voucher and the corresponding Invoice Voucher.

5. Click on the Reverse button on the top toolbar. The Marked payment and invoice vouchers will disappear from the Closed Transaction Editing form.

6. Close the Closed Transaction Editing form
7. In the All Vendors list page click the Settle Open Transactions button in the Settle group of the Invoice tab to open the Settle Open Transactions form

8. In the Settle Open Transactions form, you will see the invoice and payment vouchers that we previously reversed signifying that the link between the vouchers has been severed.

9. Close the Settle Open Transactions form
10. In the All vendors list page click on the Payment Journal button in the New group of the Invoice tab to open the Payment Journal form

11. In the Payment Journal form there will be a new line created. Select the payment journal name from the Name dropdown field
12. Click on the Lines button to open the Journal Voucher form
13. In the Journal Voucher form enter the Vendor Account in the Account field

14. Click on the Functions button select Settlement Settle Open Transactions form
15. In the Settle Open Transactions form mark the Mark checkbox for the Payment Voucher that you are cancelling.

16. Close the Settle Open Transactions form. You will see a credit amount added to the Journal voucher form with a bank account offset.

17. Post the journal voucher and close the Journal Voucher form
18. Next go back to the All Vendors list page and click on the Transactions button in the Transactions group of the Vendor tab to open the Vendor Transactions form
19. In the Vendor Transactions from note that there is a debit amount from the original payment and a new credit payment voucher for the same amount

20. Close the Vendor Transactions form
21. In the All Vendors click the Closed Transaction Editing button in the Settle group of the Invoice tab to open the Closed Transaction Editing form
22. In the Closed Transaction Editing form you will see the original payment voucher and the credit payment voucher. If you click on the original payment voucher the corresponding credit voucher will also mark signifying they are linked together.
 
 23. The original Invoice will be available to pay again if needed

Reverse a posted check [AX 2012]

This topic describes how to reverse a check and how to review the reversal.
There are two methods available for reversing posted checks. In one, reversals are posted immediately when you click Payment reversal in the Check form. In the other, when you click Payment reversal in the Check form, the reversal first is sent to the Check reversals journal in Cash and bank management, where a reviewer can then post or reject the reversal.
You might reverse a check if you have to reissue a payment that you made to a vendor. You can reverse only posted checks that have a status of Paid. Reversing differs from deleting or voiding checks because you can delete only checks that have a status of Created, and you can void only unposted checks.
You can tell which method your organization uses by viewing the Cash and bank management parameters form. If the Use review process for payment reversals check box is selected, reversals are sent to the Check reversals journal for review.
The following table describes how the check reversal methods differ.
If your organization does not review check reversals before posting:
If your organization reviews check reversals before posting:
The check is reversed when you click OK in the Check form.
The check is not immediately reversed. A check reversal journal is created for review. If the check reversal journal is deleted, the check can be reversed again.
The accounting entries for the original check are reversed.
The financial dimensions from the original check’s journal are the default financial dimensions in the check reversal journal. You can change these default values. If any posting profiles were updated after the check was posted, the check reversal journal uses the main accounts.
The accounting structures that were used when the original check was posted are used to reverse the check, even if the account structure has been changed. The account combination is not validated.
If an account structure changed after the original check was posted, a new financial dimension might be required for the reversal of the check. This dimension value from the original check is not the default value. The account combination is validated when the check reversal is posted.
Fixed dimensions are not applied to the reversal.
Fixed dimensions are applied to the check reversal journal during posting. The financial dimension value might not exist in the accounting entry for the original check, depending on when the fixed dimension was defined.

If your organization wants to post check reversals immediately when you click Payment reversal in the Check form, follow these steps:
  1. Click Cash and bank management > Common > Checks.
  2. Select the check to reverse.
  3. Click Payment reversal.
  4. Enter the date and select a reason for the reversal.
  5. Click OK to post the reversal.

If your organization wants to review check reversals before posting them, follow these steps:

  1. Click Cash and bank management > Common > Checks.
  2. Select the check to reverse.
  3. Click Payment reversal.
  4. Enter the date and select a reason for the reversal. You must also select a journal name to create a journal in the Check reversals journal.
  5. Click OK to send the reversal for review.

If you are a user who must review reversals, follow these steps. You can either approve and post the journal, or reject the reversal.
  1. Click Cash and bank management > Journals > Check reversals.
  2. Select the reversal journal to review, and then click Lines.
  3. Review the reversal and select one of the following approval options:
    • To approve and post the reversal journal, click Post or Post and transfer.
    • To reject the reversal, click Delete journal lines. Close the form and then click Delete journal lines again to delete the journal header. Close the form.
NoteNote
If you delete the journal, the reversal is removed from the system, but the original check remains in the Check form. The status of the check is no longer Pending cancellation.

When you post a check reversal, the following occurs:
  • The check status is updated to a status of Cancellation.
  • If the Reconcile check box was selected in the reversal form during the reversal, the check is reconciled (the Reconciled check box is selected), and is not displayed in the Account reconciliation form.
  • The reversal voucher is posted against the bank account that the check was issued from, to increase the bank account balance.
  • The voucher is posted to General ledger.
  • The modification details are updated in the History field group in the Check form.
Note Note
When you reverse a check that was issued for an intercompany trade transaction, the offsetting entries come from the accounting setup for intercompany trade, not from the original transaction.
If the check that was reversed was issued for a vendor payment, the following also occurs:
  • The original payment from the invoice that the payment was settled against is unapplied (the settlement is reversed).
  • A transaction is posted against the vendor account for the payment reversal, and the reversed payment is settled against the original payment. The Last settlement voucher field in the Vendor transactions form for the original vendor disbursement is updated to reflect the voucher number of the reversed transaction.
If the check that was reversed was issued for a customer payment, the following also occurs:
  • A transaction is posted against the customer account for the payment reversal, and the settlement between the original payment and the document that the payment was originally settled against is reversed (a negative payment is created).
  • A payment reversal is applied to the original payment. The Last settlement voucher field in the Customer transactions form for the original customer payment is updated to reflect the voucher number of the reversed transaction.

    Reference: https://technet.microsoft.com/en-us/library/gg243217.aspx

Wednesday, December 9, 2015

Add a new method in Wave Process

Warehouse management -> Setup -> Waves -> Wave process
if  its needed to add custom method to wave processing, following steps can be carried.
Proceed to following path
  • AOT\Classes\WHSPostEngineBase
  • Add new custom method
  1. public boolean smc1()
  2. {
  3. boolean ret;
  4. //ANY PROCESSING
  5.  
  6. return ret;
  7. }
  • Proceed to following path
AOT\Data Dictionary\Base Enums\WHSPostMethodsBase
  • Add a new Element in BaseEnum; The name must be same as name of method which you added recently in class WHSPostEngineBase. you may keep any label for this Element. But name should be same.
  • Save your BaseEnum, after making change

  • Now Proceed to following Path
Warehouse management -> Setup -> Waves -> Wave process Methods
  • Click on Regenerate Methods

  • Proceed back to same path, given below
Warehouse management -> Setup -> Waves -> Wave process
here you can see your custom method.

That's all for now.