PA Billing Source Record duplicate
Jothikrishnan Narasimmaraj asked 5 years ago
Hi,
We have an inter-company transaction map. From company A reading from Project Billing (timesheet) tables and posting to Company B POP Receipt entry. Using PADocument20 field from PA23100 as Key field and grouped by the same field on “Create Receipt” node. On line level, grouped on PADocument20, CostDocNo, CostDocSeqNo. But always it duplicates each record….for eg: 20 documents from a batch is duplicated showing 40 records and then alternative records fails saying document number should be unique. Can you please help.
Thanks,
We have an inter-company transaction map. From company A reading from Project Billing (timesheet) tables and posting to Company B POP Receipt entry. Using PADocument20 field from PA23100 as Key field and grouped by the same field on “Create Receipt” node. On line level, grouped on PADocument20, CostDocNo, CostDocSeqNo. But always it duplicates each record….for eg: 20 documents from a batch is duplicated showing 40 records and then alternative records fails saying document number should be unique. Can you please help.
Thanks,
Answers
Ethan Sorenson Staff answered 4 years ago
Jothikrishnan,
When SmartConnect is creating duplicates it is usually because the destination company is selected more than once.
You can check this in your map by checking Your Map > Destination > Companies
Make sure your company is only selected once.
Click the define button of the Companies window and verify it says:
return string.empty
When SmartConnect is creating duplicates it is usually because the destination company is selected more than once.
You can check this in your map by checking Your Map > Destination > Companies
Make sure your company is only selected once.
Click the define button of the Companies window and verify it says:
return string.empty
Hi,
Any suggestions?
Thanks,