Periodic Journals

Step 1: Make sure you are in the General Ledger Module.
Select Periodic, and Periodic journals.
Step 2 : Click control “n” to create a new record. Select the journal name you require to be a periodic journal and enter a detailed description. This is the journal name you will be using to retrieve you monthly journal for posting. Once complete, close the form.
Step 3 : Go to General ledger, and under Journals, select General journal.
Step 4 : In the “Show” drop-down list, select Posted journals. Find the journal you wish to save as a periodic journal. Once selected, click “Lines”.
Step 5 : Click the “Periodic journal” button and select “Save journal”.
Step 6 : Select the Periodic journal that you want to save this journal as.
Once done, close the form.
Step 7 : Go back to Periodic journals. Note this only has to be done once. All the following months’ postings of this monthly journal will take place as explained from Step 10.
Step 8 : Find and select the journal (number) you have just saved. Go to “Lines”.
Note the date is 29/02/2012 – This is the date when you posted the original entry.
Step 9 : Change the Unit to months and the Number of units to 1.
The unit is the frequency of this journal i.e. once a month. The system will not process the journal again in that month.
Note this must be done for each line. Please be careful – all lines have to be checked. If set up wrong, the journal will not retrieve correctly.
Be sure to change the date of this periodic journal to the month when you wish to run it next. In this example we want to run our first periodic journal at the end of March.
Once complete, close the form.
Step 10 : Under Journals, select General journal.


Step 11 : Create a new record and click “Lines”.
Step 12 : Click the Periodic journal button, and select Retrieve journal.
Step 13 : Enter the selected date for posting in “To date” – i.e. 31/03/2012.
Enter the selected date for posting in “Empty Date” – i.e. 31/03/2012.
Select the periodic journal you wish to post again.Once done, click OK.
Step 14 : The journal has now been created on the date you requested for posting.
Review lines and change if required.

Comments

Post a Comment

Popular posts from this blog

Table Methods in Ax 2012

Table Methods in Ax 2012 Methods are used for adding X++ code to your application. The code in methods is also referred to as business logic. Whenever records are changed, inserted or deleted from a table various default methods are executed. We can change the default methods and by doing so we are overriding the default methods.To override a method go to the  Methods  node of a table, right click and choose  Override Method . Below are few examples of Overriding commonly used Table methods: initValue(): If we create a new record from the table browser or a form the table method initValue() is executed. It is used to set a default value for the fields.  Example (1): Let’s override intiValue for MyFirstTable and set default value for custGroupId public void initValue() { super(); this.custGroupId = "10"; } After adding this method, open table MyFirstTable  through Table browser and press ctrl+n to create a new record. The field custGroupId wil
Read more

Write/ Read to Excel Sheet

File exists in a Directory:  static void FileExists(Args _args) { str filePath = @”C:\\vani.pdf”; ; if(WinAPI::fileExists(filePath)) { WinAPI::copyFile(filePath,”C:\\1.pdf”); } } Dynamics AX X++ code to Read/Write data to excel Writing Data to Excel file   How it works 1. Use SysExcelApplication class to create excel file. 2. Use SysExcelWorkbooks and SysExcelWorkbook to create a blank workbook(by default 3 worksheets will be available). 3. Use SysExcelWorkSheets to select worksheet for writing data. 4. SysExcelCells to select the cells in the excel for writing the data. 5. SysExcelCell to write the data in the selected cells. 6. Once you done with write operation use SysExcelApplication.visible to open file. static void Write2ExcelFile(Args _args) { InventTable inventTable; SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelC
Read more

Financial Dimensions in AX 2012

Image
Today we will be exploring the new changes  related  to Financial dimensions in AX 2012. Earlier versions AX 2009, 4.0 : Ø   In older version System use to limit the creation of dimensions up to 10.  Ø   By default 3 dimensions were available in the system namely Department, CostCenter and Purpose. Ø   Technically these dimensions were controlled by Enum SysDimension and an array EDT Dimension. Ø   So If we have 3 enum elements in SysDimension, then its corresponding array elements are stored in    dimension EDT and can be referred as Dimension[0], Dimension[1]..... Ø   If you would like to store these dimension values against customized table, then simply we were adding the EDT Dimension to that Table. At  Form  level simply drag and drop field on Group then system use to  show all the array elements as string control. New version AX 2012 (6.0) :   Ø   In AX 2012(6.0), there is no limit to dimension creations. One can create n number of dimensions as per orga
Read more