You’re offline. This is a read only version of the page.
750
HI-
I am trying to import payables and receiving a duplicate error.
Duplicate account number with DIFFERENT amounts are working fine.
Duplicate account AND Duplicate amounts are removed from batch.
Here is an image. Green is successful. Yellow - Only first transaction imports. Remaining is removed.
Any insight would be appreciated!
*This post is locked for comments
Hi Nicole
Sorry - I hadn't spotted this response - it has been a bit crazy / busy in the office.
If you don't see it in the preview, then some how your grouping options are removing the lines.
If you double-click the source file and go to the sorting tab - have you got fields selected in the Group by area? If so, it groups all the items that match based on those settings. So e.g. Account Number, Amount - if the account number is the same and the amount is the same - that will result in a single record.
Usually, you would use grouping for the Header record but leave the lines as ungrouped.
Cheers
Heather
Hi
Question: Do both lines appear if you do a preview of the distributions source file? That would help establish whether it is the process of integration that is doing it, or the grouping/sorting of the data.
Cheers
Heather
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 (