Hi, X++ code to generate check (cheque) from Vendor payment journal (generate payments). Note: In the Method of payment field, select a method of payment that uses the Check export file format. //*********************************** /*To print check 1) PaymMode - must be filled in LedgerJournalTrans (in paymMode = export format to be check) 2) OffsetAccountType = Bank in LedgerJournalTrans 3) Generate Payment dialog, bank account = Offset Bank account in LedgerJournalTrans*/ //************************************* static void GenerateCheque_VendorPayment(Args _args) { LedgerJournalTrans LedgerJournalTrans = LedgerJournalTrans::findRecId(5637186584, true); VendSumForPaym vendSumForPaym; boolean ...
Hi, The below job is used to copy the favorites from one user to another user. static void CopyFavoritesJob(Args _args) { SysPersonalization FromSysPersonalization; SysPersonalization ToSysPersonalization; UserId FromUserId= 'user01' ; UserId ToUserId= 'user03' ; ; ttsbegin ; // step 1 - delete current favorites menu from user while select forupdate ToSysPersonalization where ToSysPersonalization.ElementType==UtilElementType::UserMenu && ToSysPersonalization.UserId==ToUserId { ToSysPersonalization.doDelete(); } // step 2 - duplicate from user01 while select FromSysPersonalization where FromSysPersonalization.UserId==FromUserId && FromSysPersonalization.ElementType==UtilElementType::UserMenu { ToSysPersonalization.data(FromSysPersonalization); ToSysPersonalization.UserId=ToUserId; ToSysPersonalization.doInsert(); } ttscommit...
Hi, The below code is used to connect the external DB to access tables from ax. (In this approach we eliminated the standard ODBC DSN configuration. which is time consuming process. because we have to setup the ODBC DSN in all client machine) static void GetCustomerInfoFromExternalDB(Args _args) { System.Data.SqlClient.SqlConnectionStringBuilder CSB; System.Data.SqlClient.SqlConnection con; System.Data.SqlClient.SqlCommand cmd; System.Data.SqlClient.SqlParameterCollection parmColl; System.Data.SqlClient.SqlDataReader ...
Comments
Post a Comment