You can import cost accounting transactions directly from a Microsoft Excel spreadsheet to Microsoft Dynamics AX. To import transactions from Excel, the following conditions must be met:
-
The Excel worksheet must be named COSJournalTransCost for cost transactions and COSJournalTransWork for quantity transactions.
-
The transactions in the Excel worksheet must have the same settings in the cost category and journal name.
-
The following table describes column headings that you must use in the worksheet.
|
Column heading |
Description |
Mandatory for cost transactions |
Mandatory for service transactions |
|---|---|---|---|
|
Voucher |
Enter the number of the voucher. If this field is blank, the number is created automatically during the import. |
No |
No |
|
TransDate |
Posting date |
Yes |
Yes |
|
AccountNumber |
Number of the cost category |
Yes |
No |
|
COSUnitID |
Number of the service category |
No |
Yes |
|
Txt |
Transaction text |
No |
No |
|
Amount |
Amount of the transaction |
Yes |
No |
|
Quantity |
Quantity of the transaction |
No |
Yes |
|
RateVar |
Cost rate, variable |
No |
No |
|
RateFix |
Cost rate, fixed |
No |
No |
|
OffsetAccount |
Offset account number |
No |
No |
|
Dimension[1] |
Department |
No |
No |
|
Dimension[2] |
Cost center |
No |
No |
|
Dimension[3] |
Purpose |
No |
No |
|
OffsetDimension[1] |
Offset department |
No |
No |
|
OffsetDimension[2] |
Offset cost center |
No |
No |
|
OffsetDimension[3] |
Offset purpose |
No |
No |
|
DebitCode |
Controls whether the transaction is posted as debit or credit. If you select Debit, the entries in the AccountNum, Dimension[1], Dimension[2] and Dimension[3] fields are debits. If you select Credit, the entries are credits. |
Yes |
Yes |
Import cost
transactions from Excel
-
Create and save the Excel worksheet with your transactions.
-
Press CTRL+N in to create a new journal.
-
Click and follow the wizard instructions.
-
When the wizard is complete, click .
-
Verify and post the transactions.
Import
service transactions from Excel
-
Create and save the Excel worksheet with your transactions.
-
Press CTRL+N in to create a new journal.
-
Click and follow the wizard instructions.
-
When the wizard is complete, click .
-
Verify and post the transactions.
