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