Hello,
Here is a walkthough for creating a general journal in Excel via the Dynamics AX 2012 Office Add-in. Is it possible you didn't drag all required fields into the worksheet. This should show you the steps to successfully get the records into the system.
1. Deploy the service: Microsoft Dynamics AX 2012 includes a general journal service which enables creation but not updates of journal entries for GL, Customer, and Vendor accounts. Project and Fixed Asset journal entries are not supported in the out-of the box service.
a. Ensure that the service is registered, which occurs when users perform the Initialize AIF action in the initialization checklist. If it is not registered, use the AOT to navigate to Services, click LedgerGeneralJournalService, click Add-ins, and then click Register service from the right click menu.
b. Open the Inbound Ports Screen. Go to System Administration, click Setup, click Services and Application Integration Framework, and then click Inbound Ports to activate the LedgerServices port. Users may wish to set up document logging if they wish to track the document changes that are sent over the port. Alternatively, users may create a new Enhanced Port, and add the service operations to that support.
2. Expose to Office Add-ins: Navigate to Organization Administration, click Setup, click Document Management, click Document Data Sources and add the LedgerGeneralJournalService to the list as shown in figure 75. This will enable the service to show up in the Add Data dialog from the office add-in. Note that the name is different here than the service group name which was used in step 1.
3. Choose the service: In the Dynamics AX Contextual tab in Excel, choose the service that has been exposed in step 2:
4. Insert fields: This is a very simple example with no default dimensions or offset accounts, but will give an idea of how to proceed. Insert the fields in two separate lists by positioning the cursor appropriately and double click on the fields.
a. Header: Journal Batch Number, Description, Name
b. Lines: Journal Batch Number, Date, Company Accounts, Account type, Description, LedgerDimension.MainAccount, Debit, Credit
5. Close the field chooser: When the field chooser is open, users may delete or add columns. To read or create data, users must close the field chooser.
6. Refresh Data: To ensure things are working, if the user has journal entries, refresh the data to see what entries exist.
7. Set filter: Set the filter to narrow down the number of entries that are shown. For instance, if the highest entry is 000420_010, users may enter a filter as shown below so that only a few header line combinations are shown in the sheet. More about this in the Notes and restrictions section following the walkthrough.
8. Refresh Data: To have the new filter impact the data on the worksheet, press Refresh Data.
9. Create new entry(s): Create a new header and line. Use a temporary value for the Journal Batch Number, say New_1, and make sure it matches in both header and line. Note that once these identity fields are typed in, they cannot be changed. Users would need to delete that line and re-enter it. Users may enter multiple headers and multiple lines for each header.
10. Publish Data: Press the publish data button, which will send the new records to the server. If there are errors, they will be displayed in the status sheet and you may make adjustments and re-submit the erroneous records.
11. Create new header: Create a new header by filling out appropriate values. Users may use the Field Lookup button to choose new account numbers provided that all of the segments in the account structure are on.
Notes and restrictions:
· No Update: The service, as shipped only supports create. This means users cannot read and then update existing journal entries. This also means users cannot add a single line to the existing journal entry. A specific service or customization can address this.
· Fixed asset and project: There is no support for Fixed Asset or Project entries using the out of the box service, and there are challenges in building one due to the more complex nature of those journal entries, though it is possible and we will likely provide an example of such in the future.
· Customer and Vendor: For customer and vendor account types there are no lookups so users must know the proper account numbers rather than using the Field lookup form. To specify the customer or vendor account, users must place it in the MainAccount segment. When data is read using the office add-in the customer or vendor number will not show up in the MainAccount segment.
· Single Document: Because there is not update, it is desirable to do this a single journal entry at a time. Ideally, this would enable field layout where header fields are in single cells and the line fields are in a tabular structure. Although this binding mechanism is supported for read only structures, it is not enabled for services in this release
· Refresh All: The Office Add-in publishes data and subsequently refreshes the data to reflect any changes that may have resulted from sending the data to the server. For instance, services may provide defaulting and calculations that affect the information in the worksheet, and so data are re-read after being published. When working with a single journal entry, it is cumbersome to enter a filter and see only the data that has been sent. Users will expect to see just the data they entered. One trick around this is to put a filter in that matches something unique in the single entry or set of entries that the user is uploading, or set the filter to be greater than the latest transaction number
· Main Account Picking: In scenarios where users do not need to specify all segments of the account structure, they still may want to add them to the template as the add-in requires them to be added in order for the field lookup button to work.
　
Best Regards,
Bill Thompson
Dynamics AX - Dynamics Sure Step - Online Support Engineer
============================================================
When responding to posts, please 'Reply to Group' via your newsreader so that
others may learn and benefit from your issue.
============================================================
This posting is provided 'AS IS' with no warranties, and confers no rights.
============================================================
