Wednesday, December 5, 2012

Dynamics GP - EOne Smartconnect - GL Journal Integration

How to setup a GL journal integration


  1. Create one large data file with header and details together
  2. Unbalanced journals will not integrate
  3. Select the correct company
  4. Your data file will need
    1. Date
    2. JournalNumber
    3. Reference
    4. Account Number (with dashes)
    5. JournalDescription
    6. Debit
    7. Credit
    8. Batch
  5. Set your journalnumber as the key
  6. Setup: Create Journal
    1. Update existing
    2. Group on Journalnumber
  7. Setup: Add Distribution
    1. Update Existing
  8. Run integration

No comments:

Post a Comment