Sum of Total(LC) to be tally with Revenue captured in PLD

[Former Member]

Dear Expert,

Whenever we give Total Discount at AR Invoice Footer, the actual Revenue captured will be different as Total (LC), because the Total Discount will be deducted from each row equally.

How can we show the actual Unit Price and Total(LC) in AR Invoice PLD so that the sum of Total(LC) can be tally with the AR Invoice JE Revenue?

Thanks.

Regards,

Lay Chin

[Former Member · Accepted solution]

Dear Lay Chin,

To achieve this, better create your report by Crystal Report. CR support SQL so that you can get exact result as long as query can give your the correct figure.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

Ok, I am trying the query, I am using StockSUM at INV1, feel that this is the correct field by testing a few orders.

Is it the correct field? If bz nvm, sorry to trouble you and thanks for the advise.

Thanks.

Regards,

Lay Chin

[Former Member · Accepted solution]

What is your LineTotal value? Is it before discount or not?

[Former Member · Accepted solution]

Hi Gordon,

Thanks for advise.

I have writen Query at Query Manager for user and accepted.

Regards,

Lay Chin

[Former Member]

Hi Lay Chin.......

Have you tried working with System Variable?

Regards,

Rahul

[Former Member]

Hi Rahul,

Do you know which system variable can be used? 80 for Unit Price and 84 for Total Price are not suitable.

Please advise.

Thanks.

Regards,

Lay Chin