web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Journal Transaction Im...
Microsoft Dynamics SL (Archived)

Journal Transaction Import

(0) ShareShare
ReportReport
Posted on by Community Member

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!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Journal Transaction Import

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

  • Community Member Profile Picture
    Community Member 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 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 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 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 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans