Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Journal Transaction Import

Posted on by Microsoft Employee

Hello-

I'm trying to do an import using Journal Transactions and need to adjust the Reconciliation Status (reconstatus) field, it's importing everything as Cleared (C). Accounting wants the Cash Account rows to show as Outstanding (O) until they post the batch.

When I adjust the import file to have a value of O for that field, it says the field is not enabled. 

How do I enable the field so that we can import the value we specify?

Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Import

    Glad you figured it out, Danah! My next suggestion was going to be to compare the acct/sub setup in Cash Manager to what you had in your data file.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Import

    Think I figured out the issue. The sub-account was blank. When I populate that field, it then lists the reconciliation status as Outstanding.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Import

    We've got Cash Manager set up, we've got Accept Updates from GL Transactions checked. Is it something related to importing a file? If I put O in the import file, it errors out and adds C. If I leave it blank, the file imports C. If I put in C, it keeps that info.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Import

    I just ran a quick test on my sample database and the transaction for the cash accounts setup in Cash Manager automatically were set to Outstanding. I didn't have to put a value into the data file for that field.  Make sure that in Cash Manager, the accounts are setup to Accept Updates from GL Transactions. It's a checkbox at the end of the grid line.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Import

    Thanks for the quick reply. We do have Cash Manager implemented. Any other thoughts? Hoping it's just a setting somewhere that I'm missing.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Journal Transaction Import

    Danah, if I recall correctly, that field is only enabled if Cash Manager is implemented.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans