AX 2012: Packing Slips

Business Purpose When a sales order is ready to be picked, a picking list is created. Warehouse employees pick items from the inventory and prepare them for shipment. When the order has been shipped, a packing slip is sent from the warehouse to get it posted in Dynamics AX against that particular sales order which... Continue Reading →

AX 2012: Price charges

A price charge is an amount that is added to the unit price of the item. This charge is usually used to cover Overhead costs incurred by the item unlike Direct Material or Direct Labor costs which are covered by the unit price of the item. Examples of the overhead costs could be setup, packaging,... Continue Reading →

*Charges (in former releases called “Miscellaneous charges”) in sales and purchase orders are available to cover expenses, which are not included in the price shown in the order for example costs for freight, transport, postage, insurance, recycling and packaging. You can set up charges so that they are included in sales and purchase transactions automatically... Continue Reading →

AX 2012: Batch Server Configuration

To configure an AOS instance as a batch server go to System Administration > Setup > System and open Server Configuration form. Select the AOS instance to configure from the grid on the left. Check Is batch server to specify this instance as a batch server. Expand the fast tab Batch Server Schedule. Mention the Maximum... Continue Reading →

AX 2012: crossCompany delete_from

Although we cannot use crossCompany keyword with delete_from command, we can still achieve the same functionality with some performance overhead as follows: static void JobCCDel( Args _args ) { Table21 tab21a, tab21b; ttsBegin; while select crossCompany minof(ratingNum), dataAreaId from tab21a group by dataAreaId { changeCompany(tab21a.dataAreaId) { tab21b = null; delete_from tab21b where tab21b.ratingNum == tab21a.ratingNum;... Continue Reading →

AX 2012: crossCompany update_recordset

Although we cannot use crossCompany keyword with update_recordset command, we can still acheive the same functionality with some performance overhead as follows: static void JobCCForUpdMethod(Args _args) { Table21 tab21; ttsBegin; while select forUpdate crossCompany countOfReviews from tab21 { changeCompany(tab21.dataAreaId) { tab21.countOfReviews = tab21.countOfReviews + 2; tab21.update(); } } ttsCommit; }

AX 2012: crossCompany insert_recordset

Although we cannot use crossCompany keyword with insert_recordset command, we can still achieve the same functionality with some performance overhead as follows: static void JobCCIns(Args _args) { Table21 tab21; Table22 tab22; ttsBegin; while select crossCompany actionDate, name, dataAreaId from tab21 where tab21.actionDate > str2Date('1998-01-22', 321) { changeCompany(tab21.dataAreaId) { tab22 = null; tab22.actionDate = tab21.actionDate; tab22.name... Continue Reading →

Blog at WordPress.com.

Up ↑