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
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.
Think I figured out the issue. The sub-account was blank. When I populate that field, it then lists the reconciliation status as Outstanding.
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.
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.
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.
Danah, if I recall correctly, that field is only enabled if Cash Manager is implemented.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (