BOM Summary Excel export
Posted: 20 Jan 2022, 21:51
Hi Bruce,
Been trying to do something for hours and hours!...should of just watched the footy!
Current report works summarizing when makeup cost is not equal to the assembly sku's last cost price standard.
However, I wish to add the sub components into my report (Col H:R). I can return the component codes and component qty. However, codes are a bit meaningless I want to return the component descriptions? So I can check quickly line by line that all the BOMs have been mapped correctly. My colleague was going to check the mapping tomorrow so thought would be easier on an excel with one line per each assembly. I can make my report work where the components are pulling through component descriptions, but they fall below each assembly across multiple lines. So it slows down scanning/checking and manipulating the data filtering on my assembly cols in excel e.g. Supplier.
Col A:F is my assembly fields.
Could get around it manipulating my excel by adding helper columns next to my component codes then doing a lookup but its a bit messyeven if make an excel vba macro try and speed it up.
Or is this best done that OBDC method you shown me in the past?
Many Thanks
Been trying to do something for hours and hours!...should of just watched the footy!
Current report works summarizing when makeup cost is not equal to the assembly sku's last cost price standard.
However, I wish to add the sub components into my report (Col H:R). I can return the component codes and component qty. However, codes are a bit meaningless I want to return the component descriptions? So I can check quickly line by line that all the BOMs have been mapped correctly. My colleague was going to check the mapping tomorrow so thought would be easier on an excel with one line per each assembly. I can make my report work where the components are pulling through component descriptions, but they fall below each assembly across multiple lines. So it slows down scanning/checking and manipulating the data filtering on my assembly cols in excel e.g. Supplier.
Col A:F is my assembly fields.
Could get around it manipulating my excel by adding helper columns next to my component codes then doing a lookup but its a bit messyeven if make an excel vba macro try and speed it up.
Or is this best done that OBDC method you shown me in the past?
Many Thanks