Skip to main content
Question

customer transaction report difference


uaksoy
Do Gooder (Customer)
Forum|alt.badge.img+2

Hi all,

Our accounting department came up with difference on the report which is ifs’s standard customer transaction report(pdf).

The report that I had a bit chance to review details and noticed that an advance invoiced was matched 2 payment separately.(currencies: invoice usd, payment usd, company eur)

The transactions probably proceeded as follows: IFS converted invoice currency into company currency and calculated difference due to rounding. Then posting control pp13 worked and added line for the amount of difference. (fx gains)

I think the report shows wrong value and wonder that someone might have experience similar problem. It should have shown as 418,12 instead of 418,14. There might be another difference.

ps: For related account gl opening and closing report is not showing any difference.

Here is the gl voucher details:

Thanks in advance,

asahin
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • June 13, 2024

Hello;

You can find this problem by analyzing the SQL queries returned in the report.This PDF report must be packaged with .RPI extension


uaksoy
Do Gooder (Customer)
Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • July 3, 2024

Hi @asahin,

Thanks for answer. Yes, I did it and found that a bug probably caused such a differences. So, I’ll report to IFS instead of update couple fields on db.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings