Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, August 9, 2015

Update sales order line amount through X++

Hi,

Static void AlfasithUpdateSalesId(Args _args)
{
SalesLine  salesLine;
;
ttsbegin;
while select forupdate salesline where salesline.salesid == 'SO-00215'
{
salesline.calcLineAmount();
salesline.update();
}
info(strfmt("1% Sales id - sales amount was updated",salesline.salesid ));
}

Regards,

DMF Issue - "Could not load file or assemble.The system cannot find the file specified"

Hi,

DMF Issue - "Could not load file or assemble.The system cannot find the file specified".


There are list objects and files should be available in certain folders on installing the DMF.

A. Installation procedure.

1. Data Import / Export Framework (DIXF) service should be installed on a SQL Server machine.
2. AOS component should be installed on AOS server machine.
3. Client can be installed any machine.

B. Verify the existence of files and objects in the directory.

1. AOS server:
Dir: 'C:\Program Files\Microsoft Dynamics AX\60\'

Microsoft.Dynamics.AX.Framework.Tools.DMF.DriverHelper
Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper
Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService
Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe

2. Client system.
Dir: 'C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin\'

Microsoft.Dynamics.AX.Framework.Tools.DMF.DriverHelper.dll
Microsoft.Dynamics.AX.Framework.Tools.DMF.Mapper.dll
Microsoft.Dynamics.AX.Framework.Tools.DMF.PreviewGrid.dll
Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.dll

C. Add the users in to Microsoft Dynamics AX Data Import Export Framework Service Users. 
D. Activate the DMF inbound services in AX client.
E. Restart the AOS.

Regards,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...