Skip to main content

Hello, 

in the fact_customer_order_line_bi . I cannot see the correct amount if I have a credit that was made at the order level following an RMA. I can just see the amounts on the order line side and not on the invoiced line side and that creates 
an imbalance at the sales level.

Exemple : 

Customer Order line  Side :

fact_customer_order_line_bi : 

in power bi  fact_customer_order_line

Customer invoiced Line side : 

 

The  question : is there a way to resolve this issue and get the customer order line amount correctly

Be the first to reply!

Reply