Browsing posts in: AX 2012 R3

Pharmatec: Integrated Functions and Improved Operations Through Dynamics AX 2012

The chemical/pharmaceutical industry has some typical challenges that it looks to be addressed especially when in the midst of choosing a technology and software solution. Some key pain areas include management of production particularly with respect to ingredient potency and formulae; as well as expiry and quality control. Depending on the extent and business of the company, integrated, real time information and secondary solutions towards relationship management (such as secondary sales, customers, vendors, etc.) all form key parts of the challenge within this industry.

We have solved these challenges for one of our pharmaceutical clients, Pharmatec Pakistan Private Limited. Our vertical solution caters to their multitude of challenges and focuses on bringing key benefits that Dynamics AX 2012 inherently has to offer.

Read through our case study here:

Pharmatec-Pakistan-Private-Limited-Casestudy_0


FIXED ASSETS DISPOSAL IN MICROSOFT DYNAMICS AX 2012

Introduction

1

Fixed Assets during their entire life undergo four phases, of Acquisition, Depreciation, Value Adjustment and Disposal; we can call it Fixed Asset Life Cycle.

Microsoft Dynamics offer several ways to “Acquire”, “Depreciate”, “Adjust” and “Dispose” the assets. The Acquisition can be rotated through Fixed Asset Journal, Vendor Invoice, Inventory to Fixed Asset Journal, and proposals. The same can be done for depreciation and value adjustments.

In today’s’ post, we will go through the process of disposal and discuss the parameters for accounting. We can use “Disposal Sale” and “Disposal Scrap” to dispose the assets; it will lead the net book value of asset to “zero” and lock the asset for future transactions.

Fixed Assets Disposal

The fixed assets which are not in use or outdated or which cannot be repaired or for some other reasons, require being disposed. It is the process whereby organizations write-off the asset from their accounting book by transferring all relative values to a profit and loss account. On the other side, the sales proceeds are also parked to the same account to drive up to profit or loss on sales of fixed asset.

Out of different ways, the following two are commonly used to map the transaction in Dynamics AX 2012.

  • Disposal sale
  • Disposal scrap

Sale is an external disposal, whereas “Disposal Scrap” is considered an internal transaction.

Disposal Sale

Most of the times, fixed assets during their useful life are sold for a one of few reasons, they are no more usable, or the entity has had a change in requirements. Hence, the asset in its useful life can be sold in the market and it brings some sales proceeds as well. In this case the Difference between Cost, Accumulated Depreciation and the sales proceeds is the loss or profit on disposal.

Disposal Scrap

It is the situation where the asset is expired or outdated and has no market value or it cannot be sold in market. In this case the difference between Cost and Accumulated Depreciation is the Loss or Profit on disposal of asset.

 

Disposal of Fixed Assets in Microsoft Dynamics AX 2012

The challenge is to set-up the accounting codes in the parameters so that Microsoft Dynamics AX 2012, uses the appropriate accounts to set-off transactions. The situation becomes more complicated for the organizations where separate main accounts are used for each fixed asset group’s acquisition, depreciation and adjustments.

Fixed Assets Posting Profile holds up the accounts for sales or scrap of fixed assets, as shown in below screen shot.

2 Now, we need to give the “Disposal – Sale” Account, the main account for profit and loss on sales. Appropriate account for profit and loss on scrap of fixed asset can be provided in the particular tab.

3

After giving the Disposal – Sale and Scrap accounts click on “Disposals” button at header of this form and select the appropriate type i.e. sale or scrap.

4

5

For every asset group we have to give main accounts for various transactions i.e.:-

  • Net Book Value
    • In the main account field select the asset (cost) account. (to be credited)
    • In the offset account field select the profit and loss account. (to be debited)
  • Depreciation (This Year)
    • In the main account field select the asset (cost) account. (to be credited)
    • In the offset account field select the accumulated depreciation account (to be debited)
  • Depreciation (Prior Years)
    • In case there is separate accounts for prior years accumulation and current accumulation, give prior years accounts here.

In case various accounts are used to park various amounts related to fixed assets, then more lines are required to be added accordingly.

Accounts Codes Used in Screen Shots

Account Type Account Codes
Furniture and Fixture – Cost 3-1-1-1-003
Furniture and Fixture – Accumulated Depreciation 3-1-1-2-001
Gain/Loss on Sales of Fixed Assets 4-2-2-1-001
Accounts Receivable 1-2-1-2-009

 

6

Now we process a transaction, through Free Text Invoice for the sale of Fixed Asset. 

7

Create a new free text invoice.

8

Provide customer name and date at header level of free text invoice.

9

Give the fixed asset number in the line details, the value model field will auto populate.

10

The main account will also populate as it was given in fixed assets posting profile.

11

Proceed to post the invoice.

12

Now, go to fixed asset module, select the fixed asset and click the “Value Model” button, this will show the status of asset as “sold”.

13

The following is the extract of voucher posted by system for disposal of asset.

14

Hope this blog post helps you with fixed asset disposals in AX 2012!

 


Managing Royalties with Microsoft Dynamics AX 2012 R3

Microsoft Dynamics AX 2012 R3, provides functionality to manage royalty agreements and claim amounts, book their accruals and manage payments. In today’s post I will try to explain the procedure of Royalty Management.

What is a Royalty?

Royalties can be defined as paying certain amount to the owner of a property or a brand for the usage of property or brand. Normally, the original owner of a product sells their product against a certain share of future revenues.

The common practice is the usage of Brand names by third party, in this case, a company use a brand owned by another company and pay a specific percentage of sales to the brand owner.

Microsoft Dynamics AX2012 R3 provides complete solution of Royalty Management, whereby, organization can manage royalty agreements, claims and their payments. In the following lines, the solution is illustrated to help consultants and users:-

Royalties Management with Microsoft Dynamics AX 2012 R3

1

Parameters – Accounts Payable

In the accounts payable parameters, select the “Broker and Royalty” tab as shown in the following screen shot.

2

  1. Starting day of week would be required in case of royalty calculated on weekly basis.
  2. The accrual account is the liability account in which the royalty liabilities would be credited
  3. The expense account is the charge account where the royalties would be charged.
  4. Procurement category is used for vendor invoice creation to pay the royalty liabilities.

 Royalty Agreements

After setting up parameters, the next step is to define the Royalty Agreement, for this purpose, in accounts payable module click common click royalties and then click royalty agreements, as shown in below screen shot.

3

The following is the royalty agreement form which has two important parts i.e. Header and Line.

4

Royalty Agreement – Header

In the header section of Royalty Agreement, provide the information of vendor to which the Royalty is payable and then provide the basics of calculations.

Field Description
Royalty contract Enter the identifier for the royalty agreement; the identifier is used to determine the royalty type and default ledger accounts for this agreement.
Vendor account Select the vendor for the royalty contract.
Description Enter a description of the agreement.
Unit Enter the unit of measure for the royalty quantity.
Unit type Select or view the royalty agreement unit type. The values are Inventory unit and Catch weight unit.
Unit of measure royalty option Select the unit of measure royalty option for the royalty agreement. This option identifies the unit of measure for the royalty line. If you use the Exact match option, the unit of measure for the royalty line must exactly match the unit of measure specified in the sales order. If not, the royalty does not qualify. If you use the Convert option, the unit of measure for the royalty line is the same as the unit of measure for the royalty agreement. The royalty unit of measure is converted to the sales order unit of measure, or the catch weight unit of measure, based on the option selected in the Unit type field.
Calculation date type Select the date type, which is used for royalty calculation. The values are:

  • Created: The date when the sales order was created
  • Requested receipt date: The requested receipt date of the sales order
  • Requested ship date: The requested ship date of the sales order
Start date Enter the date on which royalty management begins to create accruals based on the agreement. If the agreement is effective immediately, leave the field blank.
End date Enter the date on which royalty will no longer be created based on this agreement. If the agreement does not end, leave the field blank.
Cumulate sales by Select the period during which invoiced lines will be added and compared against the agreement. The options to select from include Invoice, Week, Month, Year or Customized period.
Period type When Cumulate sales by is Customized period, you have to select the period type to cumulate the sales.
Taken from Select whether the royalty value is based on the gross or net of the sales order line.
Accrual account Enter the ledger account to be used for interim liability postings.
Expense account Enter the ledger account to be used for interim expense postings.
Currency The currency type determines the currency in which royalty is remitted. You can specify a generic currency, which is converted on the order, or you can specify a specific currency for the royalty.
Approval required Select if royalties created from this royalty agreement require approval before they are processed to the ledger accounts.
Calculate by Select if the royalty break is based on quantity or amount.
Validated Shows whether the royalty program is validated.
Validated by Shows whether the royalty program is validated.
Item number Select the items which qualify for this royalty agreement.
Product name Shows the product name of the item.
Unit Shows the sales unit of the item.
Site Shows the default sales site of the item.
Warehouse Shows the default sales warehouse of the item.
Location Shows the default issue location at the default sales warehouse.
Note You can enter specific notes for the royalty agreement.

 

Royalty Agreement – Lines

At the line level of Royalty Agreement, provide the information on the basis of which the royalty amounts would be calculated, in also contains the specific items on which royalty has to be calculated. However the item on which the royalties are calculated can be defined at the header level but in case, the royalty is payable to one vendors on all sales and to one another vendor on sales of a specific item, the specific item will be described at the line level.

Field Description
Royalty code Enter the identifier for the royalty agreement; the identifier is used to determine the royalty type and default ledger accounts for this agreement.
Description Enter a description of the agreement.
Vendor account Select the vendor for the royalty contract.
Calculation date type Select the date type, which is used for royalty calculation. The values are:

  • Created: The date when the sales order was created
  • Requested receipt date: The requested receipt date of the sales order
  • Requested ship date: The requested ship date of the sales order
Currency The currency type determines the currency in which royalty is remitted. You can specify a generic currency, which is converted on the order, or you can specify a specific currency for the royalty.
Unit Enter the unit of measure for the royalty quantity.
Amount type Select the amount type of the agreement:

  • Amount per unit: A certain amount per sold unit.
  • Fixed amount: A fixed amount for a range of quantities sold.
  • Percentage: A certain percentage of the net amount sold.
Start date Enter the date on which royalty management begins to create accruals based on the agreement. If the agreement is effective immediately, leave the field blank.
End date Enter the date on which royalty will no longer be created based on this agreement. If the agreement does not end, leave the field blank.

 

Royalty Agreement – Lines – General Tab

 

Field Description
Royalty code Enter the identifier for the royalty agreement; the identifier is used to determine the royalty type and default ledger accounts for this agreement.
Note Enter a comment or note for the agreement.
Description Enter a description of the agreement.
Vendor account Select the vendor for the royalty contract.
Currency The currency type determines the currency in which royalty is remitted. You can specify a generic currency, which is converted on the order, or you can specify a specific currency for the royalty.
Unit Enter the unit of measure for the royalty quantity.
Calculation date type Select the date type, which is used for royalty calculation. The values are:

  • Created: the date when the sales order was created
  • Requested receipt date: the requested receipt date of the sales order
  • Requested ship date: the requested ship date of the sales order
Start date Enter the date on which royalty management begins to create accruals based on the agreement. If the agreement is effective immediately, leave the field blank.
End date Enter the date on which royalty will no longer be created based on this agreement. If the agreement does not end, leave the field blank.

 

Royalty Agreement Lines – Selection Tab

Field Description
Item number Select the items, which qualify for this royalty agreement.
Product name Shows the product name of the item.
Unit Shows the sales unit of the item.
Site Shows the default sales site of the item.
Warehouse Shows the default sales warehouse of the default warehouse.
Location Shows the default issue location of the item.

Royalty Agreement Lines  – Royalty Amount Tab

Field Description
From value From quantity/amount in which a royalty has to be calculated.
To value To quantity/amount in which a royalty has to be calculated.
Value Enter the value of the royalty.

 

Following is the basic process flow for royalty claims, when items which are associated with royalty agreements are invoiced through sales order, the royalty claims are created. The royalty amount can be viewed in sales order line>Price Details>:

5

Royalty Claims

Click Accounts Payable>”Royalties”>”Royalty Claims”, to cumulate and process royalty claims.

6

In case approval is required on royalties, the royalties can only be cumulated after approval.

The status column on royalty claim provide following information about the claim:-

  • To calculate: The final royalty amount is pending completion of the cumulate royalties run. This status applies to royalty claims that are generated from weekly, monthly or yearly agreements.
  • Calculated: The claim was cumulated and is pending approval.
  • Approved: The claim had been approved if approval is required.
  • Mark: The claim is available for processing.
  • Processed: The claim was processed and a vendor invoice was posted.

Cumulate Royalty Claims

After invoicing the sales order, user has to cumulate royalty claims. This will sum up royalty claims amounts. The royalty amounts can be cumulate on each invoice, week, month, year or a customized period.

7

Once the royalties are cumulated and processed, the status of royalty claim will be set as “completed” and the vendor invoice will be posted, which can be paid.

8

Your valuable comments and suggestions would be highly helpful to me for my next posts.

 

 


Exploring Drill-down SSRS Reports in Dynamics Ax 2012 R3

Drill drown reports in Dynamics Ax 2012 R3 are very vasy. For this purpose, I have to create a new AOT/Static Query AOT. This query is a join between CustTable and SalesTable. I created an Inner Join so only those Customer were selected who have associated Sales Orders. Consider following steps to create a new report:
Create a new Query with Name “DyWorldCustSales”
Drop or add Data Source with CustTable
6-21-2014 9-02-30 PM

Right click on Fields and add following fields from Customer table.

CustomerFileds

Expand Data Source inside Custtable, Add or Create DataSource with SalesTable and fields

SalesOrder

Right Click on  SalesTables Data Source and set its join properties as follows:

DataSetProperties

Expand Relationship node of SalesTable_1

Add following relationship:

Relations

Set it properties as follows:

RelationshipDetail

Now, create a new report In existing or New DataModel Report in Visual Studio project:

NewReport Project

Add New report with DyCustSalesOrderList

Add Dataset with Name DSCustomer and Point to Query which we created in above steps:

PointToQueryQueryDataSet

Now drag and drop the dataset on designer to create a designer

And Update, rename it to  DyCustSalesOrderList

Set DataTable’s Propeties visible to set false

DataTable

Add a List and set its name to CustList

Create two groups, one for CustomerGroup and second for AccountNum:

Groups

Now drop the fields from dataset which you want to display on report

Fields

Right click on CustList and set Data Navigation Style to DrillDown from properties window

DrillDownProperties

Now right click add report to aot and then deploy to Report Server

When you run the report,  from meu Item you will find following

CustomerGroupClick

Click on Customer group this will open:

reportCustomerLevel

Click on Customer account it will drill down report on Detail level:

Details

This post was originally published on http://tech.alirazazaidi.com/exploring-drill-down-ssrs-reports-in-dynamics-ax-2012-r3/

Ali Raza Zaidi is MVP, one of the only 6 people qualified from Pakistan! He is our top notch technical consultants and works in the capacity of Advisory Software Engineer for Dynamics AX 2012 in Systems Limited.

original article


Exploring Drill through Reports in Dynamics Ax 2012 R3.

Creating basic drill through reports in Dynamics Ax 2012 R3 is really simple. Consider following scenario where we have to show the list of customer and their sales Orders in particular legal Entity.  In this report when User clicks on customer account, a new report opens, which contains list of all possible sales Orders. For this purpose I created two Static/AOT queries. First for Customer, and second for Sales Order. Customer Query:

  • Create a new AOT query with Name DyWorldCustomerList.
  • In DataSource add CustTable table.
  • In fields dynamic to true.

CustListTable Similarly, Create another Query “DyWorldSalesTable” for SalesTable. With Name DyWorldSalesTable   SalesTable Now Open Visual studio and create a new Dynamics AX Report Project   Report Project Add a new report with name

  • DynamicCustomerList

Add New dataset with Name

  • DynamicCustomerList set its properties as follow

CustomerDataSet

  • Select Following fields
    •   AccountNum
    •    CustGroup
    •    Party
  •  Drag this DSCustomerList data set on Report Designer to create an AutoDesign.
  • Change the AutoDesign1 properties as follow

o   Name to DesignCustomerList

o   LayoutStyle to ReportLayoutStyleTemplate

 ReportDesinger2

 Now create another report inside same Dynamics Ax Model Project, this report will be called from customer Report SalesOrderReport Create and DataSet with DSSaleOrder with query  “DyWorldSalesTable” SalesOrderDataSet Drag this dataset on Report Designer and update newly Designer as follow. SalesOrderDesignerProperties     Now open the parameter Section of report and add new parameter as “CustId” of string type CustIdParameter Now expand report designer and expand Table and add filter with following Properties NewParameter Set following Properties of filter o   From  Expression select “=Fields!CustAccount.Value” o   Name= Customer o   Operator =Equals o   Value “=Parameters!CustId.Value” Properties   Save the report.   Now Open the first report “DynamicCustomerList”. And expend the reports design, “DSCustomerListTable” and then Data and select AccountNum. Right click on AccountNum and select “Report Drill Through Action” AddDrillThrough   Now Double click and Select the report designer which will open against the click on field ActionProperties Select SalesOrderReport and its Desinger form dialog ReportSelectionSalesOrderList It will create number of parameters, all belonging to  DynamicSalesOrderList Report as follows: DrillThroughParameters   Delete all parameters except AX_CompanyName and CustId. If any other parameter remains, you definitely got following error when you called Sales Order report form drill through option.

“The Microsoft Dynamic AX parameter ID should be a RECID. The exception is System.FormatException: Input string was not in a correct format.”

AfterDeleteParameters   Please Select following Values for these Properties AX_CompanyName Select its value “=Parameters!AX_CompanyName.Value CompanyNameValue Please select the following value for CustId as “=Field!AccountNum.Value” SaleIdValue Now saves the reports and right click on Report Project to Add to AOT and then deploy on Report Server   AOT and Deploy Now Go to AOT, and refresh the Select the Visual Studio Model Project and SSRS reports into Dynamics Ax project so it will easy to edit or locate easily Menu2 Now create a Menu Item of Display type and set its following Properties Menu Now run the report as follow   CusttomerList As click on first Customer “CNMF-000001” To its salesOrderList , The second report successfully open as follow SaleOrderList   This post has been excerpted from http://tech.alirazazaidi.com/exploring-drill-through-reports-in-dynamics-ax-2012-r3/ Ali Raza Zaidi is MVP, one of the only 6 people qualified from Pakistan! He is our top notch technical consultants and works in the capacity of Advisory Software Engineer for Dynamics AX 2012 in Systems Limited.