Is it possible to create a single integration where some of the cash receipts are applied to specific documents and others are not? I've tried a few different ways, but I can't get around an error that the Apply-To-Document cannot be blank and has no default for the ones I want added unapplied.
*This post is locked for comments
Thank you very much. I didn't even know Integration Groups was a thing! I got this to work using a single file that I created 2 sources from. The first was grouped on the header cash receipt fields. The second was for the apply details and I added a filter to exclude the ones where apply-to-document was blank. This made it so when I run the integration, the ones without apply don't even attempt to go into the apply window anymore.
The issue is, for the Cash Apply sub-collection options, you would be specifying the rule as "Use Source Recordset" to be able to import the apply portion. When you do this, Integration Manager will be expecting records for that will be used to be applied by the Cash Receipt, even if the table relationship type is set to 0..M.
Couple things to try:
1. You could tell IM to Use Default if the Apply-To Document Number in the Cash Apply sub-collection is null. You would also need to set the 'Use Default' property for every other mapped field within that collection when the imported value is null.
2. You could effectively create two integrations, one for Cash Receipts with Apply info and one for Cash Receipts without apply info. You could then choose to create an Integration Group to run them both as one integration.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (