Group Data Not Working
renjanmv asked 8 years ago
Hi,
I am trying to import SOP Transactions using SmartConnect. I have only one source file which has both header and line details. The source file contains four lines which is for one document, i.e., one header and four lines. After setting up the source file, I have setup the key field as 'Document Number' and also setup the header node to group the data by 'Document Number'. I have not setup any grouping for the line node. However, when importing, SmartConnect is only importing one record which one header, no line items.
Am I missing anything?
Please help.
Best Regards,
Renjan
I am trying to import SOP Transactions using SmartConnect. I have only one source file which has both header and line details. The source file contains four lines which is for one document, i.e., one header and four lines. After setting up the source file, I have setup the key field as 'Document Number' and also setup the header node to group the data by 'Document Number'. I have not setup any grouping for the line node. However, when importing, SmartConnect is only importing one record which one header, no line items.
Am I missing anything?
Please help.
Best Regards,
Renjan
Hi,
This has been rectified now. But, the automatic creation of distributions, tax and tax schedules are not working.
Please help.
Best Regards,
Renjan