Error SQL Server Reporting Service :
...
Featured Post 1 with Small Thumbnail
Featured Post 2 with Small Thumbnail
Featured Post 3 with Small Thumbnail
Featured Post 4 with Small Thumbnail
Dynamics 365
Dynamics 365...More
Dynamics AX 2012
Dynamics 2012...More
Title Featured Post 3
Etiam augue pede, molestie eget, rhoncus at, convallis ut, eros...More
Title Featured Post 4
Aliquam sit amet felis. Mauris semper, velit semper laoreet dictum, quam diam dictum urna, nec placerat elit nisl in quam...More
Thursday, November 23, 2017
Wednesday, November 22, 2017
Export Import data model AXutiL
Export Import data model AXutiL :
cd C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin => letak folder untuk eksport
axutil export /model:"USR Model" /db:MicrosoftDynamicsAX_Model /file:JTC2012MOdel.axmodel
...
controller in SSRS
controller in SSRS :
protected void prePromptModifyContract()
{
#ISOCountryRegionCodes
DeliveryOrderContract contract;
TECDeliveryOrderTable TECDeliveryOrderTable;
FormDataSource fds;
str range;
;
contract = this parmReportContrat().parmRDPContract() as TECDeliveryOrderTable;
TECDeliveryOrderTable = args.record();
fds = args.record().datasource();
contract
}
How does your class look like?
Just to be sure, I'll show you a step by step
1. You create a class which extends from SrsReportRunController. Then you define a macro with the report name and the Data Contract class.
class...
element Args() in x++
element Args() in x++
public class ReportRun extends ObjetRun
{
PurchTable tmpPurchTable
}
Public void init()
{
super();
tmpPurchTable = element.args().record();...
Format dates in SSRS reports
Format dates in SSRS reports :
Untuk PrintDate (kalo kasih tanggal sekarang di report)
=Today()
=Format(Fields!myDate.Value, “M/d/yy”) - 2/11/08
=Format(Fields!myDate.Value, “MM/dd/yyyy”) - 02/11/2008
=Format(Fields!myDate.Value, “d-MMMM-yy”) - 11-December-08
=Format(Fields!myDate.Value, “d-MMM-yyyy”) - 11-Dec-2008 =Format(Fields!myDate.Value, “M/d/yyyy H:mm”) - 2/11/2008 13:50
=Format(Fields!myDate.Value, “MMM-dd-yyyy”) - Feb-11-2008&nbs...
Melihat sesion DB SQL 2008
Untuk melihat sesion AOS di DB SQL Server 2008
dbo.SYSSERVERSESSIO...
Running Number in SSRS
Running Number in SSRS :
=RunningValue(Fields!ItemId.Value, CountDistinct, Nothing)
...
update_recordSet in x++
update_recordSet in x++ :
TECDOWithdrawalList DOWithdrawalList;
TECCustInOutClaimTable CustInOutClaimTable, CustInOutClaimTable2;
update_recordSet CustInOutClaimTable2
setting TECRefDOWithdrawalRecId = DOWithdrawalList.RecId,
TECRefWithdrawalId = DOWithdrawalList.TECWithdrawalId
where CustInOutClaimTable2.RecId == CustInOutClaimTable.RecI...
Disable Date in VirtualBox
Disable Date in VirtualBox :
Open CMD, type:
1. Cd C:\Program Files\Oracle\VirtualBox
2. vboxmanage setextradata [VMname] "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" "1"
contoh :
C:\Program Files\Oracle\VirtualBox>vboxmanage setextradata "MS AX 2012R2 Contoso
" "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" "1"
or if you want to Turn it back on:
3. vboxmanage setextradata [VMname] "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" "0"
...
Fixing throw error datbase dynamics AX
Fixing throw error datbase dynamics AX :
• Right click on data Dictionary and synchronize the data Dictionary.
• Right click on AOT and compile it, it step take longer time. In the case of any error in any class, fix the issue and compiled.
• Generate full CI...
init using x++
init using x++ :
public void init()
{
super();
if(element.args().record().TableId == tableNum(VendPackingSlipJour))
{
_AmbilRecordVendPackingSlipJour = element.args().record();
}
else if(element.args().record().TableId == tableNum(InventTransferParmTable))
{
_InventTransferParmTable = element.args().record();
}...
Get record args with menuitem in x++
Get record args with menuitem in x++ :
Lihat Callernya !!!!
protected void afterOperationEnd()
{
//
start-dxl-ESLOG010TransferOrder-2013-05-29-01-58-pm
PurchLine purchLine;
TECTransferOrderTable
TECTransferOrderTable;
boolean ...
Only 1 layer in Dynamics AX
Only 1 layer in Dynamics AX :
Cara narik 1 layer VAR, USR
1. Buat Project baru, lalu Open
2. Pilih tombol Filter
Klik OK
...
Cara melihat siapa aja yg panggil kelas itu dengan x++
Cara melihat siapa aja yg panggil kelas itu dengan x++ :
...
More Than 2 Remote Desktop Sessions
More
Than 2 Remote Desktop Sessions :
Pada server ketik command
promtgpedit.msc> computer configuration > Administrative Template >
Windows Component > Remote Desktop Service > Remote Desktop Session Host
> Connection.
ganti jadi
Disable
Buka Remote Desktop Session Host Configuration
Klik kanan RDP-Tcp> Network Adapter, kemudian ganti
maximum connection sesuai kebutuhan.
Buka server manager, kemudian tambah role untuk remote desktop
Add role >tambahkan role remote desktop
Next…next kemudian restart
...
Relation Custtable and CustInvoiceJour in x++
Relation Custtable and CustInvoiceJour in x++ :
select _CustTable where _CustTable.AccountNum == CustInvoiceJour.SalesId;
.:: Atau methode ini sudah disediakan di table CustInvoiceJour ::.
CustInvoiceJour.custTable_OrderAccount(...
Cara Enable Remote untuk Report SSRS
Cara Enable Remote untuk Report SSRS :
Kalo
muncul error pas buka report ssrs : "cannot remote ........"
Masuk
ke Sql, buka database report, buka table ConfigurationInfo field
EnableRemoteErrors diganti True.
...
Calling report using menu item (args.record(namatable)) in x++
Calling report using menu item (args.record(namatable)) in x++ :
void clicked()
{
InventJournalTable inventJournalTable;
InventJournalTrans inventJournalTrans;
InventDim localInventDim;
CustInvoiceTrans custInvoiceTrans;
TECCustInOutClaimTable localTECCustInOutClaimTable;
TECCustInOutClaimLine localTECCustInOutClaimLine, CustInOutClaimLine;
RetailTransactionSalesTrans retailTransactionSalesTrans;
...
Container and unbounded string fields are not allowed in ax WHERE expression
Container and unbounded string fields are not allowed in ax WHERE expression :
Kalo muncul error karena -> str di public static
boolean TIDCheckingKTP(str NomorKTP) -> tidak boleh str, harusnya EDT.
...
Print Barcode Code using x++
Print Barcode Code using x++ :
void clicked()
{
//AIFD_PrintBarcode
AI_PrintBarcodeController aiBarcode = new AI_PrintBarcodeController();
AI_PrintBarcodeContract aiContract = new AI_PrintBarcodeContract();
ProdJournalProd prodJournalProdLoc;
SRSPrintDestinationSettings printSettings = new SRSPrintDestinationSettings();
PrintJobSettings printJobSettings = new PrintJobSettings();
Dialog ...
What is the difference between AmountCur and AmountMst in Dynamics AX
What is the difference between AmountCur and AmountMst in Dynamics AX :
What is the difference between AmountCur and AmountMst in Dynamics AX?
AmountCur is the amount in the entered currency
and AmountMST is the amount in the base currency for the company
...
Kalau ada error di Presyncronize maka masuk ke System administrator Enterprise Portal
Kalau ada error di Presyncronize maka masuk ke System administrator Enterprise Portal :
Kalau ada error
di Presyncronize maka masuk ke System administrator > Setup > Batch Group
>
pindahkan
semuanya ke Selected Server...
Jika EP AX2012R3 tidak bisa dibuka di dalam VM itu sendiri
Jika EP AX2012R3 tidak bisa dibuka di dalam VM itu sendiri :
Jika VM AX2012R3 tidak bisa membuka web portal AX, maka kita
perlu mendaftarkan alamat Enterprise portal yang ada di AX (System
Administrator -> Setup -> Enterprise Portal -> Website), ke dalam
folder hosts (Windows -> System32 -> drivers -> etc).
...
Untuk ambil data dengan methode menggunakan find dengan x++
Untuk ambil data dengan methode menggunakan find dengan x++ :
_BuyBackGuaranteeTMP.CustomerId
= SalesTable::find(_TECBuyBGuaranteeTable.SalesId).CustAccount;
contoh
:
Saya
mau ambil CustAccount dari table SalesTable
1. _BuyBackGuaranteeTMP
adalah Table Temporary
2. CustomerId
adalah variabel yang ingin dimunculkan di Dataset
3. SalesTable
adalah tabel...
SystemdateGet Print date regarding server or Today
SystemdateGet Print date regarding server or Today :
display str TglCetak()
{
//return strFmt('Tgl. Cetak : %1', DateTimeUtil::getSystemDateTime());
return strFmt('Tgl. Cetak : %1', systemDateGet());
//return strFmt('Tgl. Cetak :%1', today...
Change automatic change next page using x++
Change automatic change next page using x++ :
if(nourut == 10)
{
element.newPage();
}...
find phone using x++
Find phone using x++ :
static void Job10(Args _args)
{
VendTable vnd;
;
vnd = VendTable::find("V-00000");
info(vnd.phone());
info(vnd.telefax());...
Public Void with parameter using x++
Public Void with parameter using x++ :
public void addData(TransDate fromDate, TransDate
toDate,
InventLocationId warehouse,
RefRecId planVersionId)
{
TIDBOB BOB, BOB2;
TIDBOBTmp BOBTmp;
InventDim inventDim;
ItemId tmpItemId;
TransDate date1, date2;
str ...
Subscribe to:
Posts (Atom)
A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record
SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account : and Delete the Bank Account FINISH
Facebook
