My customer requested to have a tool to create journals with around 10,000 lines by using AX instead of typing these journals manually.
A user should be presented with a dialog. The dialog should have the following parameters:
- File name – a selection to an excel file
2 . General Journal Name selection – type daily
3 . Offset account check box
- On OK – the system should created the journal based on the excel file. The system should support all standard AX functionalities i.e.
Account Types
Dimensions
Voucher generation
VAT
All mandatory fields
Requirement
Excel template:
An Excel template should be used and should contain all the fields supported by the general journal form.
Framework
SysOperation framework or DIXF classes can be used to meet the requirement
Dialog
A dialog should be created and should contain the following parameters:
-
Excel path file name selection. The filename should be of type xls or xlsx
-
The general journal names available in the system. Only daily journals should be loaded
-
A tick box for the offset account – if ticked the system should create a journal with the offset account and offset account dimensions
General Journal
A journal header should be created based on the journal selected. The lines should be linked with this header
Journal Lines
The system should create the journal lines with all standard AX requirements. Important that all account types should be supported with all type of dimensions.
Voucher creation
The voucher number should be created based on the journal parameters. The system should support all standard AX voucher creation types.
Validate
The class should run the ‘Validate journal’ option after the journal lines are created. The validation should be successful.
Dimensions
Use contoso dimension setup. Dimensions supported
Business unit
Cost center
Department
Item group
Project
please help me on this. thanks in advance