When using CSVEXPORT to create an Excel file the pipe items are being duplicated.
| Item No | Qty | Name | Description | Specification | Connector |
| 3 | 127.659 (inch) | Pipe-A53-CS-(B)-SCH80-BLK(PE) | 20'' | | GRC_Tube_Plain End |
| 3 | 127.659 (inch) | Pipe-A53-CS-(B)-SCH80-BLK(PE) | 20'' | | GRC_Tube_Plain End |
I am filtering out all the other parts( by CID) to leave just the pipe. I only need the one line so the quantity fields will total up correctly.
