Forum Discussion

ltroutne's avatar
ltroutne
Copper Contributor
Dec 09, 2022
Solved

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 - 62.0000
2.00000.0000
Item Total:2.0000
  
2021 -  625.00
Subtotal by Item Number:D11111111-DF   
  
  
D11111112-DF   Stocking Unit:
Location:1
2019 - 11.0000
2019 - 24.0000
2019 - 33.0000
2019 - 44.0000
2019 - 53.0000
15.00000.0000
Item Total:15.0000
  
2019 - 125.00
2019 - 226.00
2019 - 312.00
2019 - 413.00
2019 - 514.00
Subtotal by Item Number:D11111112-DF   

Resources