Microsoft Dynamics AX 2012 R3 is an Enterprise Resource Planning (ERP) application. Use this tag for questions relating to this final update to the 2012 version, being replaced by Microsoft Dynamics AX 7. Do not use this tag regarding earlier versions or other ERP applications.
Questions tagged [dynamics-ax-2012-r3]
229 questions
0
votes
1 answer
InvokeClrInstanceMethod - "Length cannot be less than zero"
I try to import data from .csv file, but get an error.
When i try to copy data from .csv to staging table it crashes with the following message:
NAME:
ex
VALUE:
System.Reflection.TargetInvocationException: Exception has been thrown by the target…
1gentlemann
- 164
- 1
- 3
- 14
0
votes
2 answers
How Do I Know What AOT Class I Need to Change to Modify the Behavior of Canceling PO Lines
Despite knowing AX enough to get around, it's still thoroughly confusing to me. I have a background in Visual Studio C#, and I could always figure out where a particular segment of code was performing the unexpected behavior, but after a year and a…
Eternal Learner
- 121
- 4
- 19
0
votes
1 answer
ax2012 ssrs grouping condition based on a parameter
I've to print SalesPackingSlip report and only if SalesOrder has a specific value on a custom field I've to Group by itemId, else I shouldn't Group on ITEM ID even if I've twice the same item.
I've used a boolean parameter on the contract that is…
0
votes
1 answer
Standard Customer DIXF entity updating address with wrong city because we have same zipcodes for Different cities . Ax 2012R2
We have same zipcode for different cities
zipcode1 city1
zipcode1 city2
zipcode1 city3
When i am loading address with city as City2, DIXF is loading address with City as City1.
Its picking first record in that list.
How can i fix this??? Any help…
Raas
- 261
- 8
- 25
0
votes
2 answers
A SQL query to find all wmsLocations that have zero stock in AX 2012 R3
I have been trying this for a day now, and I can't seem to find the correct way to do this. I need a SQL query that returns me all locations with zero physical stock ( inventSum.PostedQty + inventSum.Received - inventSum.Deducted +…
user2184523
- 41
- 1
- 8
0
votes
0 answers
No metadata class defined for data contract object
I am trying to create a Batch job. For that initially, i have created a class and added a method. Now I am attaching this class to the Action Menu item. and generated Incremented CIL. But when I open the menu item I am Getting the error. bellow is…
venkat pasumarti
- 138
- 1
- 1
- 12
0
votes
2 answers
ax 2012 - direct SQL querying alternatives
I am using a direct SQL query as a data source of my SSRS report:
SELECT
emp.EmployeeNumber, FirstName, LastName, MiddleName
, amts.AmountCode, amts.amt, amts.AmountType
from EmployeeMaster emp
LEFT OUTER JOIN
(
SELECT 'Earning' as…
friency
- 1
- 1
0
votes
0 answers
SSRS PDF Export AX 2012 R3
We are using Microsoft Dynamics AX 2012 R3.
Where can I found the code in exporting PDF file in SSRS Report Viewer?
Is it possible to alter the standard exporting of PDF file from SSRS?
Clients requirements is to export the generated report in SSRS…
Bryan
- 1,245
- 5
- 22
- 37
0
votes
1 answer
How to force AX 2012 create primary keys and foreign keys in underlining SQL tables?
I store my sales bills in two tables (simplified): BillHeader (BillId, Date, Salesman) and BillDetail (BillId, LineId, ItemId, Quantity...) I would like to make BillId as a primary key of table BillHeader; (BillId, LineId) as primary key of table…
Tuan Le PN
- 364
- 1
- 12
0
votes
0 answers
Import CSV-FILE to AX2012
I am trying to Import a csv-FILE in AX 2012
(Fields: FirstName, LastName, Birthdate, Jerseynumber)
class SYCImportData_Roster
{
}
public static void main(Args _args)
{
SYCImportData_Roster importData_Roster;
;
importData_Roster =…
Khashayar
- 47
- 2
- 15
0
votes
0 answers
Application explorer shows "Default (cus) [CUS Model]"
Background: I'm trying to edit an AX Report in Visual Studio. I have previously been able to create reports in VS and integrate them into AX. But I haven't used this in several weeks. Now, suddenly it doesn't work anymore.
Symptoms: When I open…
Kempeth
- 1,856
- 2
- 22
- 37
0
votes
0 answers
Error occurred while doing bulk copy from temp table to entity table-Conversion overflows. DIXF AX 2012 R3
I am getting below error for one of my entities when i am copying from Source to Staging table.
Error occurred while doing bulk copy from temp table to entity table-Conversion overflows.
When I am checking in debugger when executing below line its…
Raj
- 85
- 14
0
votes
1 answer
What is the best way to migrate data from oracle to dynamics AX?
In order to migrate data form oracle to Dynamics AX, master data and open transnational data should be migrated to the system like General ledger, vendors, customer, open payments, open invoice, PO...
However, there are several methodology to use in…
khaled alomar
- 673
- 4
- 25
0
votes
1 answer
Migrate Ax2012 R3 CU12 model to Dynamics 365 error: no metadata to upgrade
I’m upgrading a custom product/model from AX2012 R3 CU12 to Dynamics365 using the Lifecycle Services code upgrade service.
At the point where uploading the compressed model store, I hit the following error:
“Customer models contain no metadata to…
Celeste
- 106
- 1
- 13
0
votes
2 answers
No symbols have been loaded for this document. Debugging .NET code for Dynamics AX
I'm trying to learn how to debug between Dynamics (AX 2012 R3) and Visual Studio. But for some reason I am unable to trigger any breakpoints in Visual Studio.
I've searched far and wide for more than a day and tried at least the following things…
Kempeth
- 1,856
- 2
- 22
- 37