Saturday, November 29, 2014

Broker Contract Management for Dynamics AX2012 R3


I'm going to explain the Dynamics AX 2012 R3 Broker Contract Management that  how to set up a broker contract that specifies the commission that a broker vendor receives for the sale of items or groups of items. For example, you might have a contract with a broker that states that every time a specific model of television is sold, the broker receives a percentage of the sales price. Commissions can be calculated based on a fixed amount, a percentage, or an amount per unit.  
This functionality will help in managing payment of fees to brokers for the service of facilitating sales with broker contract management. This will reduce the administrative burden of broker payments. 

Let start with the parameter settings, Navigate to Accounts Payable > Setup > Accounts payable parameters
  • In the Accounts payable parameters form, in the left pane, click Broker and royalty.   
  • Enter the Journal name used to create the vendor liability in the Invoice journal name field.  
  • In the Differential journal name field enter the journal name used to post the Cancelled brokerage amount.  
  • In the Expense journal name field, enter the journal name used to post to the broker expense account.  
  • Select the account which will be used for expenses related to brokerage in the Expense Account field.  
  • You can check or uncheck the Manual Posting checkbox to define whether the journal should be posted automatically or manually.  
  • In the Accounts Payable Parameters form in the Number Sequences select the number sequence in the Broker Claim Invoice field.
After the parameters are setup, we need to perform the following two setups:
1- Create the differential Reason Code and attach accounts for posting the differentials, in case of any differential exists for Broker commission.
Navigate to Accounts Payable > Setup > Broker > Differential reasons
  • Click on new button 
  • Enter the differential code 
  • Enter the description 
  • Select the ledger account for differential posting
2- Create the Charges Code for broker contracts and its posting. Select the Prorate check-box on this form and select the options for posting under the Debit and Credit on Charges Code form.
Navigate to Accounts Receivables > Setup > Charges > Charges Code
  • Click on new button 
  • Enter the differential code 
  • Enter the description 
  • Select the ledger account for differential posting
Once all these setups are done now we can create Broker Contracts now. To setup broker contracts use the following procedure. 
Navigate to Accounts Payable > Common > Broker > Broker Contracts

  • In the Broker Contracts form click New to create new Broker Contract in the upper pane. 
  • In the Status field select the status as Planning and enter the id in the Broker Contract ID field for the broker transaction. 
  • Select the vendor account number for the broker in the Broker Account Number field. 
  • Select the dates in the From Date and To Date fields. Select the charges code in the Charges Code field. 
  • In the Category field select one of the options (pcs, percent, fixed) to determine how the value will be used to calculate the broker fee and enter the value accordingly in the Charges Value field and also select the currency in the  Charges Currency Code field.
In the lower pane of the Broker Contracts form we can enter the contract details applicable to the contract and specify the Item code, Item relation and customers or customer groups to which this contract is applicable.
  • To enter the contract details go to Accounts Payable > Common > Broker > Broker Contracts. 
  • In the Broker Contracts form, in the lower pane click Add Line to add line to specify the contract details created in the upper pane. 
  • In the Item Code field select Table, Group or All for the contract. 
  • In the Item relation field select the item number, item group or item discount group as per the selection in the item code field. 
  • Select Table, Group or All in the Account Code field to select to which customer this statement applies. 
  • Select the Account Number or Customer Group in the Account Selection field. 
  • In the Break type field select either quantity or amount which determines the basis for evaluation of brokerage amount. 
  • In the Break field, we can specify the break value for the quantity or amount as selected in the Break Type field. 
  • Other fields such as Category, Charges Code, Charges Value, and Charges Currency Code it will automatically populate from the Broker Contract line.
 
We can set the status of the broker contract to the following stage's: 
  • Planning: Default Status of the Contract when created. The contract line and the contract details can be edited only when the status of the contract is ‘Planning’.  
  • Approved: Unless the status of the contract changes to Approved, the contract terms and broker fees are not applicable on the sales transactions. 
  • Cancelled: The status of the broker contract should be changed to Cancelled to cancel the contract terms. 
  • Closed: The status of the contract is Closed when the broker contract is closed.
Note: We cannot use the broker contract on the sales order Until the Status of the contract processing in the Broker Contract form is changed to Approved from Planning, the contract terms are not applied on the sales orders. 
 
Now once the contract status is changed to Approved in the Broker Contract form, we can see the broker commission is generated as per the terms in the broker contract on the sales order line. To view the broker fee generated for the sales order transactions, create a sales order for the item and the customer as specified in the broker contract.
Navigate to Accounts Receivable Common Sales Order > All Sales order
  • Create a New sale order 
  • Select item and its relevant information on sale order fast tab 
  • Click on the Sales Order Line button 
  • Click on the broker commissions in the view group.  
In the Broker Commission form we can see the broker vendor account, broker contract id for the transaction and the applied value for the contract.
In the above example as you can see we have the broker contract for the customer US-003 with item T0020 at 5 % on the net amount of the sales order. The results are 
Net Amount25,000 
Broker Commission:  25,000 * 5 % = 1,250 
 
After the sales order is invoiced, we can see the lines created for the Broker payments in the Broker Claims form with open status where we can view all the broker claims filtered based on different parameters and also Approve or Close the broker claims and make the broker payments.
Navigate to Accounts Payable Common > Broker > Broker Claim
Once the claim is reviewed, we can approve or close the Claim. In order to approve the broker commission claim, enter the approving amount in broker lines under 'Approving' field.
Click on 'Approve' button to approve the claim, system will automatically post the claim and expense journals in General journal GL module.
Note: If the Manual check-box is not marked in the Accounts Payable Parameters > Broker and Royalty the journals will be posted automatically to post the amount in the respective accounts as mentioned in the initial setup.
We can process the Vendor through the Accounts payable module using the payment journal under the Journal section as standard Dynamics AX vendor payment works.
 
We can also 'Close' the broker claim after approving it using the following procedure:
Navigate to Accounts Payable Common > Broker > Broker Claim
Select the Claim 
Click on Close button
Note: Once the status is Closed you cannot edit the Broker Claim.

Enjoy the DAXING !!!!

17 comments:

  1. Association Evaluation who buys a condo receives a set of the covenants, conditions and restrictions (CC&Rs). Before they sign the contract, the selling agent must disclose what the rules and regulations of the association are. There could be restrictions about pets roaming free, overnight guest parking, or types of landscaping the owners can put on their patios or balconies. Federal, state and local laws dictate what can be included in the rules and regulations.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Hi Fawad,

    Thank you for this post. It's really helpful to understand the new functionality in AX 2012 R3.

    I have one small query. Could you please elaborate / give any example so that I can check when the GL code 602150 will be used for Broker expenses ? I just want to see the usage of this GL in AX, that's it.

    ReplyDelete
  4. This website is remarkable information and facts it's really excellent Construction Cost Consultancy services

    ReplyDelete
  5. I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. south african trading account

    ReplyDelete
  6. Your blog is filled with unique good articles! I was impressed how well you express your thoughts
    Get best contract management software for healthcare.

    ReplyDelete
  7. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. Pepperstone review australia

    ReplyDelete
  8. Halo,I'm Helena Julio from Ecuador,I want to talk good about Le_Meridian Funding Investors on this topic.Le_Meridian Funding Investors gives me financial support when all bank in my city turned down my request to grant me a loan of 500,000.00 USD, I tried all i could to get a loan from my banks here in Ecuador but they all turned me down because my credit was low but with god grace I came to know about Le_Meridian so I decided to give a try to apply for the loan. with God willing they grant me  loan of 500,000.00 USD the loan request that my banks here in Ecuador has turned me down for, it was really awesome doing business with them and my business is going well now. Here is Le_Meridian Funding Investment Email/WhatsApp Contact if you wish to apply loan from them.Email:lfdsloans@lemeridianfds.com / lfdsloans@outlook.comWhatsApp Contact:+1-989-394-3740.

    ReplyDelete
  9. The need for contract management software becomes inevitable to streamline the lifecycle process of the contract. The professionals like sales executives or account reps, who are especially involved in negotiating, contracting, will have the need to certainly define the terms and services agreements. This is mainly done to ensure the compliance, monitor risk, amend agreements and execute the contract.

    Contract Management Software

    ReplyDelete
  10. The Litecoin Foundation has actually partnered with MeconCash in order to add assistance for Litecoin (LTC) to the M.Pay payments platform. The assistance would certainly see crypto users take out LTC using Korean Won (KRW) at greater than 13,000 Atm Machines in South Korea. The assistance will also make it possible for users to have accessibility to quick cash in enhancement to being able to send money from overseas to South Korea. Bitcoin bot

    ReplyDelete
  11. I appreciate you for giving such an informative portal. Are you looking for
    business central support

    ReplyDelete
  12. It has been great to know that there is sincere loan lender out there that knows about helping loan with a low rate of 2% . We always stay humble and never give up on my project finance, and for The Loan offer pedro granted me, we are truly grateful for the help and push we have received my loan as discussedContact   pedroloanss@gmail.com for more information about his loan offer.”

    ReplyDelete
  13. We provide the highest level of quality software products and cms contract management system, services globally that meet the needs of our customers by maintaining our staff as our principal asset and being responsive to market expectations. Any progressive business demands the right tools to guide innovation and achieve strategic superiority. Having worked with more than 200 finance and leasing companies in over 30 countries, NETSOL Technologies understands the unique operational challenges of todays leasing and finance companies and empowers these organizations to achieve business excellence. Our customized approach and commitment to providing superior quality IT solutions has enabled us to help our clients streamline their business operations and optimize efficiency.

    ReplyDelete
  14. Hello to all, how is the whole thing, I think every one is getting more from this web page, and your views are nice for new people.

    Love Spells,
    Top Astrologers List,
    Best Vastu Shastra Experts,
    Famous Vashikaran Specialist,
    Best Love Marriage Specialist,
    Talk To Astrologer in India,

    ReplyDelete