Forum Discussion
ltroutne
Dec 09, 2022Copper Contributor
Insert part number next to the qty
Good morning, please help me to figure out how to put the part number next to a qty. I have file with over 100,000 records and I need to summarize it by part number by month. Thank you
| D11111111-DF | Stocking Unit: |
| Location: | 1 |
| 2021 - 6 | 2.0000 |
| 2.0000 | 0.0000 |
| Item Total: | 2.0000 |
| 2021 - 6 | 25.00 |
| Subtotal by Item Number: | D11111111-DF |
| D11111112-DF | Stocking Unit: |
| Location: | 1 |
| 2019 - 1 | 1.0000 |
| 2019 - 2 | 4.0000 |
| 2019 - 3 | 3.0000 |
| 2019 - 4 | 4.0000 |
| 2019 - 5 | 3.0000 |
| 15.0000 | 0.0000 |
| Item Total: | 15.0000 |
| 2019 - 1 | 25.00 |
| 2019 - 2 | 26.00 |
| 2019 - 3 | 12.00 |
| 2019 - 4 | 13.00 |
| 2019 - 5 | 14.00 |
| Subtotal by Item Number: | D11111112-DF |