We have Microsoft business central as our ERP system and I have conected an Excel file to the price list table of BC to check that we have all the prices that should be there
I have a pricelist with 1000 items. (Actually it's more items and more prices, in multiple companies but I simplify for the example here)
All of these 1000 items should have 10 different prices.
Price A
Price B
Price C
Price D
and so on.
Today, some of these itmes are missing certain prices.
In the Excel file you can see what I mean.
I need to add each price type to each item code so I can see what prices are missing.
I think it is clear if you check the file.
I have a pricelist with 1000 items. (Actually it's more items and more prices, in multiple companies but I simplify for the example here)
All of these 1000 items should have 10 different prices.
Price A
Price B
Price C
Price D
and so on.
Today, some of these itmes are missing certain prices.
In the Excel file you can see what I mean.
I need to add each price type to each item code so I can see what prices are missing.
I think it is clear if you check the file.