January release – Dynamics AX 2012 R3


Microsoft Dynamics AX In-Market team has recently added a new method to release code defects, design change requests, feature requests and proactive fixes for Dynamics AX 2012 R3. The new approach is to release these types of fixes in a predictable monthly cadence.

The January release for Dynamics AX 2012 R3 version is now available in LCS on the updates tile inside your R3 project. This update represents a typical collection of smaller functional improvements and technical fixes.  Bugs were fixed in all areas with enhancements found in Warehouse Management, Financials, Production and Retail. Please see the full list of hotfixes below to search for your specific issue newly included in this release. This release is a cumulative package including all other fixes released in the prior CU12 update.

Here are a few details related to this release:

  • Primary Build: 6.3.5000.1468
  • Number of Application hotfixes: 56
  • Number of Binary hotfixes: 5

Details of the install process can be found here: https://technet.microsoft.com/en-us/library/hh538446.aspx#PackageR3

Below is screenshot of the Dynamic R3 update installer and the select form to pick the most recent updates from this month’s release:

lcsdownloadlatest

 

What is included in this month’s release

Design Change Requests & Feature Requests

KB Details Description of issue or change request Description of enhancement
KB3205038 Voucher gets created with two different dates, which is not correct per French accounting rules Now it will check whether having a un-realized Gain/Loss backing at time of settlement. If yes, then it will check whether the date having as posting of exchadj isn’t equal to transaction date for the settlement posting. If it is, then it will get a new voucher number for the posting else the same voucher number will be kept.

 

KB3208173

 

Post-sync channel DB clean up to reduce data volume.

 

To enable Post-sync channel DB clean up to reduce data volume feature:

1.      Client side must be upgraded on these components:

a.       Async Client

b.      Channel database (upgrade by Channel database utility)

2.      AOS must be upgraded to introduce a new configuration in Retail scheduler parameters form: “Strip irrelevant master data from channel database”

3.      the configuration must be turned on, then synced to channel database by 1110 scheduler job.

4.      If there is customization that changes/adds new tables, the channel database stored procedure must also be customized to purge data properly.

KB3207458 Retail offline sync doesn’t remove old records from the _TRACKING tables from channel databases or offline databases.

 

Now it uses Microsoft sync framework provided feature to cleanup metadata in the change tracking tables on both store database and offline database. The cleanup retention day is configurable in offline sync service configuration file.

 

KB3208218 Retaining the original Registered Voucher and Transdate on VendTrans after the posting of Approval Journal/Pool Invoice Now the following high-level changes are done

1)        When defaulting the posted invoice register into either the Vendor invoices form or the Invoice approval journal, the voucher number and voucher date of the invoice register will be defaulted, unless that period is closed or on hold.

a.       If the period is closed or on hold, the system will advance the date to the first day of the next open period and a new voucher number will be set.

2)     The voucher date on the invoice approval journal and the vendor invoices form will remain editable. The change is that if the user changes the date, the following message pop up “If you change the date, the voucher number will be updated. Are you sure you want to change the date?” if we click Yes will change the date and voucher number. No will revert the date and put the cursor back in the date field. The users option at that point is to Cancel the pool entry, re-register the invoice with the corrected date and approve the corrected date, if they want to only use a single voucher.

3)    When an approval journal or the vendor invoice that was created from the pool is posted, the system will not update the Vendor transaction or the Invoice journal’s voucher number or voucher date.

4)     It makes the approval process’ visibility better:

a.     From Vendor transactions>Voucher and the posted invoice journal>Voucher, show both the approval voucher and the invoice register voucher when launching the form by default. (Even if they are using different dates and different voucher numbers.) The related vouchers button/all related vouchers button will still be enabled and available just as they are today.

b.    From the posted invoice journal, the user will be able to view the Vendor transactions record.

5)     Issue where the approval date is not getting set with the approval date from the invoice approval journal or Vendor invoice is also fixed through this

 

KB3199141 Sales invoice operation should be supported in MPOS With the new implementation, if we invoice a sales order at HQ side without prepayment and then try to invoice the payment at store side it should be processed successfully as Sales invoice operation is now supported in MPOS

 

KB3208541 When you run any CDX download job, there is an insert into tempdb query that executes 100 times for each CDX job if having around 100 data groups. This causes huge performance implications, especially for large jobs such as pricing changes.

 

Now a new feature is implemented to allow optimization by grouping the change tracking queries across multiple data groups together, if certain requirement can be met.

 

KB3209155 When you split quarantine orders after pressing the Start button, you see that no quality orders are generated even if the status changed to “Reported as finished”.

 

Now it will make sure that after you split the started quarantine order, you still can generate the quality order when the quarantine order is reported as finished.

 

KB3205507 Add support for user to pick the item from another location in short picking scenarios. Now, user will be able to pick the item from another location when short picking scenario is experienced in order to be able to proceed to ship goods as fast as possible.

 

 

Fixes released

 

KB Number Complete Feature path Title
3209773 AX Retail\Solution\Call Center Call center RMA does not allow Percent based charges
3204765 AX Retail\Solution\CDX and Data management CDX perf – SQL change tracking query: when number of columns is greater than 10, do not track column level changes for updates.
3209529 AX Retail\Solution\Merchandising\Pricing and Discounts Price simulator shows incorrect price for specific unit and date.
3199964 AX Retail\Solution\Merchandising\Product Management Deleted attribute from attribute group still displays on released products in a retail product hierarchy
3205096 AX Retail\Solution\Store operations and POS\UX – MPOS  Media Server URL in channel profiles requires a forward-slash at the end.
3204124 AX Retail\Solution\Workspaces\Channel Operations Transfer orders with status ‘Created’ are visible in POS
3207737 AX Retail\Solution\Workspaces\Channel Operations mPOS: Set quantity – If attempting to return more than the number of items purchased, an application error is thrown
3205152 AXL\APAC localizations\China CN-Cannot run the Chinese Voucher continuity check
3187956 AXL\APAC localizations\India IN-Previous year transactions are considered while calculating TDS on vendor invoice.
3189981 AXL\APAC localizations\India IN-TDS is not calculated correctly with multiple withholding tax code
3194494 AXL\APAC localizations\India Error is displayed while invoicing purchase order after applying prepayment
3201716 AXL\APAC localizations\India Transaction amount mismatch in LedgerTransVoucher form after performing relative transactions
3195118 AXL\APAC localizations\Singapore Malaysia and Thailand TH – Realized sales tax is not matching unrealized tax when posted with multiple withholding tax codes
3200300 AXL\APAC localizations\Singapore Malaysia and Thailand TH-Modified amount in “Updated base for withholding tax in invoice currency” is not displayed.
3094602 AXL\Europe Localizations Related Voucher Transactions are missing in the voucher transaction form for Redraw Promissory note journal
3159634 AXL\Europe Localizations Mexico Unable to post hour journal with Item Sales Tax Group as GRAL and Sales tax group as IVA15%
3182679 AXL\Europe Localizations [Italy] AX2012R2 PA E-Invoice: IdPaese is wrong when transmitter is not for the same legal entity
3187149 AXL\Europe Localizations [Italy] AX2012R3 PA E-Invoice: “AliquotaIVA” field with negative sign for credit note created by project fee invoice
3187707 AXL\Europe Localizations [Italy] AX2012R2 PA E-Invoice: “Importo” field is wrong in case of discount
3182388 AXL\Europe Localizations\Austria Austrian Sales tax calculation incorrect for correction transactions using reporting code 063
3201675 AXL\Europe Localizations\Eastern Europe Cash order report stack trace error when converting number to word into German (DE) language
3196856 AXL\Europe Localizations\France [France] Intrastat delivery department (county) not reported
3184039 AXL\Europe Localizations\Germany German sales tax payment report Preview and xml displays incorrect amounts for 100% and partly exempt use tax codes
3179883 AXL\LATAM Localizations\Brazil NF-e: for a Transfer order receipt (Order type = Fiscal establishment transfer), Document date (receipt) = Posted date (receipt)
3196586 AXL\LATAM Localizations\Mexico ‘Electronic ledger accounting statement’ report with doubled balance amount IF Fiscal Year Close does not create closing transactions
3179119 GFM\Accounts Payable 1099 amounts are overstated when using vendor retention from project
3184999 GFM\Accounts Payable\Invoicing Possible to post invoice after matching partial invoice against the full product receipt for non-stocked item
3201278 GFM\Accounts Payable\Invoicing invoice voucher missing Accrue reverse transactions
3192083 GFM\Accounts Payable\Reports Vendor ledger reconciliation report shows incorrect Journal Number
3205719  GFM\Accounts Receivable\Collections\Collection Letter  Collection letter print: The length of the registration number in the OCR-line may not exceed 8 characters
3182163  GFM\Accounts Receivable\Free Text Invoice  Reverse transactions can still be created/posted on Free text invoice transactions that were posted on a fiscal year that have already been fiscal year closed
3182280 GFM\Cash Management\Vendor\Payments and Settlement Stack trace error occurs when user opens multiple vendor payment proposal forms
3187693 GFM\Cash Management\Vendor\Payments and Settlement Incorrect Payment Amount displayed in Invoices paid by Check form
3202663 GFM\Fixed Assets\Journals Voucher transactions is incorrectly displayed on payment journal form
3203219 GFM\Fixed Assets\Setup Fixed asset number sequence gets broken
3198369  GFM\General Ledger\Allocations  Incorrect Dimensions on the Voucher when running Allocations for an Intercompany Journal
3200678 GFM\Tax Error in Sales tax specification report while running in batch
3210144 GFM\Tax\Tax Calculation Performance SalesTax payment still slow after installing KB 3192872
2983839 SCM\Inventory\Quality Management Reserved physical status on sales order with production item
3050053 SCM\Planning\Master Planning  Continuation of DAXSE 3776577 – Incorrect Req. quantity in planned orders when using Min/Max coverage type
3206080  SCM\Planning\Master Planning  MRP – Track process tack duration is only logging info from 1 thread instead of all threads used
3174478 SCM\Procurement\Intercompany Multi inter-company direct delivery
3206456 SCM\Procurement\Purchase Pricing Modifying an existing trade agreement will not get picked up on subsequent PO lines
3202895 SCM\Production and Shop Floor\Batch Orders Inconsistent reference for pegged supply – reference lot missing
3197325 SCM\Production and Shop Floor\Shop Floor Control\Time and Attendance After calculation on approve form we get shorter absence time even if break is not paid break
3181315 SCM\Sales\Sales Orders Sales lead time is not calculated correctly if order entry deadline has passed and tomorrow is a closed day in the calendar.
3202268 SCM\Sales\Sales Orders Perf : 1 extra SQL call by “MCRSALESTABLE” after  clicking “OK” button on “SalesCreateOrder” form is regressed due to DAXSE#3769105
3196208 SCM\Sourcing\Requisition Policies not working in Business Portal
3198951 SCM\Warehouse and Transportation\Warehouse Management\Pallets (WMSII) Over picking changes ordered quantity
3196838 SCM\Warehouse and Transportation\Warehouse Management\Shipment Management If a Picking location is assigned on a PO line and a Sales order is reserved against that PO line, you can incorrectly activate picking for the output order tied to the Sales order line even though no inventory exists
3209851 Server Continuous dead locks in batch tables
3208240 SI\Project Accounting\FIM Integration The sum of the Cost Prices of project transaction costs does not match the transaction-level cost price for project transactions in a foreign currency on a project contract with split funding rules
3201474 SI\Project Management\SCM Integration Shipment Records not being created after installing KB 2917852
Comments (18)

  1. bruce says:

    May I ask whether AX 2012 R3 supports sql server 2016 SP1 now? Thank you very much.

    Bruce

    1. Hi Bruce,
      The answer to that sort of supportability question is usually found the in the System Requirements documentation, which we update on a regular basis: https://www.microsoft.com/en-gb/download/details.aspx?id=11094
      Kind regards,
      Claes

  2. Hi,

    when do we get CU13? April 2017?

    Regards
    Murat

    1. If we release CU13, it will be after April timeframe. Decisions to release a CU13 is still pending. Feedback is appreciated.

      1. Rob Cilissen says:

        Any news on if and when R3CU13 will be released?
        To plan the upgrade of our solutions it would be great to know what to expect.

        BR,
        Rob

        1. we also need the realease of a CU instead of monthly release

  3. Rob Cilissen says:

    Does this mean there won’t be a R3CU13 release?

  4. Sebastian says:

    Does it mean that from now on there will be no “CU”s but only Monthly updates?

    1. The decision to release additional CU’s for AX2012 R3 is pending. The monthly releases is not intended to replace CU’s. Please let us know your feedback. Thanks.

      1. Rob Cilissen says:

        My feedback regarding the issue whether or not to release a CU:
        From an ISV perspective we really need CU’s. We have to deliver our solutions to customers on a specific CU level. If there are no CU’s and we have to follow monthly updates (12 AX versions a year to deliver on per ISV solution), it is too time consuming and costly.

  5. Darren Bradbury says:

    Is there a slipstream version available and a stand alone update, don’t see anything on LCS, using axupdate with a saved package is all good and well but very time consuming when you need to update a 16 AOS system and it seems to lock the Package.axupdate file when in use meaning I can only run one instance of it at a time.

    1. There is no slipstream process for this monthly release of fixes. I will relay feedback about the lock on the Package.axupdate file.

  6. Sunil Dharmani says:

    Hi, Code in class SRSReportRun in AX which has remarks “that this method currently runs on the client. This will be fixed when the server batch scenarios that render SSRS Reports are fully implemented.” Does the Microsoft have released any update/hotfix for this.?

    1. No change for this behavior as of now.

  7. Martin Walker says:

    Is there also a slipstream version of this update available? It doesn’t show up like the other CUs on the LCS update tile, and a slipstream would be useful for any subsequent installations.

    1. Martin Walker says:

      Another note from my experience of applying this update is that the application version in Help->About will still be 6.3.5000.133. This is because the ApplicationVersion::applBuildNo() method still belongs to the KB3199741 (CU12) model. I did also spot check in my model manifest that several of the models for the KBs listed above did indeed get installed. I guess there just isn’t a model provided in this update to indicate in Help-About that it has been applied.

      1. Correct, it is just a build with the latest fixes available to choose from. It does not replace applying a CU.

    2. There is no slipstream package available.

Skip to main content