You’re offline. This is a read only version of the page.
935
I have a client that has used their IM bank transaction import for several years. Today they imported 4 transactions then they got the error "field 'checkbook ID' does not have a default. I have checked and they are using the correct ID and that checkbook is set up like all the rest. I selected it as the default in bank reconciliation but it still will not import. Again, using the same file it imports all other batches.
Any ideas? GP techknowledge is zero help. Thank you for any help with this.
*This post is locked for comments
No one has made any changes. I checked the mapping of both files it pulls from. I have checked the setup in options to make sure it's looking at the correct data and I checked the mapping of the checkbook id-all look correct. Not sure what else to do. Am I missing something that would make it look elsewhere for the files? It says 97 entries and there are only 13-how can I find where it's looking? Thank you for any help.
I have checked the mapping and the files and all are pointing to her current file, but it seems to be pulling from somewhere else as her batch only has 13 entries and it says there are 97 in the file it's pulling from. I have asked other users to see if they have changed the mapping on their machines.
That's the difficult thing-it has been used many times and has always worked-and worked for several other batches-they just overwrite the data. The checkbook ID is correct and the mapping is correct-I've checked them both several times. I just can't figure out why this batch won't go. She may have to enter it manually.
The error precisely occurs in one of two cases, the checkbook id is either blank or not mapped correctly. The IM behavior is identical to the behavior conducted when entering a transaction directly form the GP windows.
Check them out.
1. May be Checkbook ID was blank or not mapped to the correct field, you need to check your mapping and validate the data.
2. Before running integration, preview the source file to check whether any rows showing for this batch as blank row. If yes, correct the input file and try again.
Hope this helps!!!
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 (