Skip to main content

Dynamics Ax 2009 Financials : Year-End process

Please find the Year-end closing process below:
Step 1: Create a new fiscal year
Path: Dynamics Ax > General Ledger > Setup > Periods > Periods
Click button 'Create new fiscal year'
Click 'OK'
12 monthly lines get created with open status.
Step 2: Control transactions in a closing period
Path: Dynamics Ax > General Ledger > Setup > Periods > Periods
A closed period cannot be reopened. Therefore, permission to close periods and years should be highly restricted.
Select 'Stop' from list and this prevents transactions posting in the system for that period, perfom same operation for 12 monthly periods.
Step 3: Change module status
Select the appropriate module and set the user group required access by selecting from list view in the above screen.
Step 4: Create Closing sheet
Path: Dynamics Ax > General Ledger > Periodic > Fiscal year close > Closing sheet
Set field 'Closing sheet' = 06/30/2011
Set field 'Name' = Closing Sheet as on 06/30/2011
Set value 'Posting layer' = Current
Set value 'Period code' = Closing
Note: Only 'Normal' and 'Closing' options can be used in closing sheet. 'Opening' option can be used for beginning balance transaction.
Click button 'Closing accounts'
Click button 'Load balances'
Notice the accounts and balances got updated in the screen.
Step 5: Make adjustments or transfers between accounts
Select an account line from the loaded balances and click button 'Transfer'
Note: For system reconciled accounts 'transfer' button would be disabled.
Set field 'Transaction text' = Closing transfer
Set field 'Amount' = -1500 (difference amount which needs to be transferred)
Select field 'Offset account' = 999999 (The offset account could be any relevant account, here I took example of 'Error account - 999999')
Click 'Save'
Close form 'Transfers'
Form 'Closing accounts' becomes active
After the necessary transfers or adjustments are complete, click the Post button from the Closing accounts form to post the closing sheet. The closing sheet only posts to the closing period.
At this time, also run reports and verify results before you close the period and transferring ending balances into the new year as opening balances.
Note: To post the closing sheet, you must open the closing period in the Periods form. After you post the closing sheet, ensure that you change the period back to Stopped.
Click button 'Close'
Step 6: Transfer Opening Balances & Setup Fiscal year close parameters
Enable GL Parameters:
Path: Dynamics Ax > General Ledger > Setup > Parameters > Ledger tab

Fiscal year close:
Delete close-of-year transactions during transfer : If this check box is selected, opening transactions and system-generated closing transactions that exist for the year to be closed are deleted when the transfer is processed again.
Create closing transactions during transfer : By enabling this option, have the system create closing transactions when running the opening transactions job.
Set period status to year closed : Select this check box to display a status of Year closed for all fiscal periods for the year that is being closed.
Voucher number must be filled in : If this check box is selected, a voucher number must be entered when opening transactions are created for a new fiscal year.
Note: If a period is closed, adjustments, which may be required by the auditor, are not possible.
Transfer opening balances procedure:
Path: Dynamics Ax > General Ledger > Periodic > Fiscal year close > Opening transactions
Click tab 'Dimension'
Dimension selection can be done here to transfer opening balances
Click button 'OK'
Please find the report of Closing transactions & Opening transactions
This completes the Year-End Closing process.

Popular posts from this blog

What does this mean: "The form datasource query object does not support changing its AllowCrossCompany property after the form has executed the query."?

I have made a form with datasources vendtable and vendtrans. Inside vendtable_ds.executequery() looks like this: QueryBuildDataSource queryBuildDatasource ,queryBDS_VendTrans_Invoice; ; queryBuildDatasource = this.query().dataSourceTable(tablenum(vendtable)); queryBDS_VendTrans_Invoice = this.query().dataSourceTable(tablenum(vendtrans)); if (curext() == "MASTERCOMP") { this.query().allowCrossCompany(true); } else { this.query().allowCrossCompany(false); } //FilterVendorName = stringedit control on form if (FilterVendorName.text()) { queryBuildDatasource.addRange(fieldNum(VendTable,Name)).value(strfmt("*%1*", FilterVendorName.text())); } else { queryBuildDatasource.clearRange(fieldNum(VendTable,Name)); } //FilterInvoiceNumber = stringedit control on form if (FilterInvoiceNumber.valueStr() == "") { queryBDS_VendTrans_Invoice.enabled(false); } else { queryBDS_VendTrans_Invoice.enabled(true); queryBDS_VendTrans_In...

Credit Note [Dynamics AX] using X++

This post will help to create credit note for a sales order based on the invent lot id. All the invoices raised for a particular sales line – Lot Id will be raised back as a credit note. Information on Credit Note: A credit note or credit memorandum (memo) is a commercial document issued by a seller to a buyer. The seller usually issues a Credit Memo for the same or lower amount than the invoice, and then repays the money to the buyer or sets it off against a balance due from other transactions Below Code will help to create credit note for all the invoices raised against the sales line -lot id. Please note: This code can be customized as per your requirements. This is just a template to help creating credit note using X++ code. Please test the code before use. static void SR_CreateCreditNote_Sales(Args _args) { // Coded by Sreenath Reddy CustInvoiceTrans custInvoiceTrans; Dialog dialog = new Dialog(“Create credit note – for sales.”); DialogField dfInv...