You’re offline. This is a read only version of the page.
295
I'm want to use Integratin Manager V10 to import cash receipts but I'm having trouble. I want to import the cash receipt record and I want to import the transaction(s) that it needs to be applied too. I do NOT want it to automatcally apply to any transaction.
The import job does import the cash receipt but with the following warning:
1 DOC 1 WARNING: Apply-To Document INV00000000000016/SLS is either missing or voided. .. 12/29/2009 8:05:47 AM
Because of this warning, the cash receipt is not applied to this document even though this document does exist.
I can go into GP and retrieve the imported cash receipt, click the APPLY button to get a list of transactions to apply it too, and see the same transaction (INV00000000000016) I attempted to apply it to during the import. I can select this transaction and post the cash receipt manually without any issues.
So why can't Integration Manager find this transction during import?
Thanks
*This post is locked for comments
Bruce,
Glad to know your problem solved.
Thanks
Sandip
Wow, this was basically the issue, and I can't believe it.
My data source is not CSV file but ODBC so an SQL qry retreives the data. I can't believe that any spaces could be present in the selected customer id field. I know there is no spaces in the source database field itself.
Just for fun I put TRIM functions ( ltrim(rtrim(custid)) ) around the customer id field in the SQL and it worked.
Would not have found this in a million years.
Thanks.
Bruce,
I face this type of problem one time- Did you have any space before or after in Customer No in CSV file ?
Please let me know problem solve or not.
Thanks
Sandip
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (