Go to BNE Sheet
Copy the customer code and SKU
Go to Pri sheet
filter the customer code with copied once and filter the SKU column with the copied value
go to validate invoice then filter the value N/A
Afterv the filteration we get the value in Billed quantity add the value and paste BNE Sheet
these is the BNE Sheet