Create Report with Column and Row Grid lines

Hi, This is a little bit about creating report with column and row grid line. So many users and company that use a report with column and row grid, I in the
first time when I obligated to create a document that use grid line it was challenged me, i try to find out the similar report at standard axapta reports and
I found nothing... and I ask to uncle 'google' I found many links that not fit my objective (it was year 2005 and I used to MBS Axapta 3.0). I just have idea
From my experience that used to VB 6.0 and VBA at Ms. Access which is use 'Manipulation' of control tools.. Something like labels, text box, rectangle, line,
Shape or other control. The idea is 'Manipulation', so i try out to use axapta standard control to create column and row grid line...and it was done with
excellent result. This trick is more have a long time to create because we need to describe line of column and row by define position of control. Please pay
attention to the example below:

we need to create report/document (invoice) as picture above, and we just use manipulation of control by set the properties and some coding to insert. The
properties that always to use are : Line Below, Line Above, Line Left, Line Right, Left, Top, Width, Height, Top Margin, Bottom Margin, Left Margin, Right
Margin, Model Field Name, show label, Alignment, background Color, Foreground Color, Font, Thickness.
Pls Look at picture below that describes the information of creating the document above.














have a nice day to try out this trick !

Optimize Design Caption on Report

Caption of report is very helpful when we open the same report more then one and we need to compare the value of each report. This tips is using design caption to show parameters that very important to display at report caption. Even we use “print range“ at report parameter but it not helpfully when we open more then one of report.

Here the way to solve the problem. In report “fetch” override caption design of report by redefine again.

Create and Setup Item Master

Sebelum membuat sebuah item yang perlu dipikirkan adalah tipe item, kombinasi dimensinya (bentuk dan sifat dari item tsb / entiti dan properti), cara penjurnalannya secara akuntansi, model inventorinya, unit utamanya, pengelompokan barangnya, perlakuannya dalam transaksi.Untuk memulai membuat sebuah ite dalam DAX dilakukan di menu IM (Inventory Management) di main menunya terdapat “Item” Lalu klik dan selanjutnya tekan “CTRL + N” atau klik menu icon “New” di toolbar. Secara Default axapta akan mewajibkan (Mandatory) untuk mengisi Item Number, Item Type, Item Group, Inventory Model Group, Dimension Group. Saya akan menambahakan selain default yg ada diatas yang perlu di isi adalah Unit yg ada di tab “Quantity” terutama di colom inventory (Unit Inventory) hal ini untuk menghindari jika terjadi transaksi maka secara default unitnya blank jika kita memilih unit yg ada DAX akan meminta unitconversionnya

Beberapa field/kolom yang perlu diisi (berdasarkan pengalaman pribadi dan untuk Standard Setup) beserta penjelasan singkatnya adalah sebagai berikut :

C3

C4




C5
C6