Well those tables exist on the DB, didnt work means I dont get the result with my CTE

Thank you anyway

Hello

here are the tables, my code didnt work because is not bring the unposted invoice

Thank you

Hello Thank you for replay, I changed to use RANK and it works but know the issue I have is that is no bringing the null values

Hi

did you check if you still have your temp  tables,

I will test it

Thank you!!