Hi NarmadaThanks it works fine but I am having one issue in this When I calculate the AR for October it is matching but when I want to look the current Date AR the values does not change. I don’t understand that why it is happening any idea why it like that.
Hi @Narmada It is in the same table or some other view/table? as I did not know about IFS so it is hard for me to trace it if you can guide me more specific view/table as you mentioned for GL Voucher Row it would be easier for me to fetch. As I explained the total for month of October is perfect there are transactions in November but the totals are not affecting. It means some where the date is there is the GL VOUCHER ROW Tab if I am not mistaken.
Hi @NarmadaI found this view which is combination of Header and Details. But with this view the result is same, it is so confusing for me. select * from GEN_LED_VOUCHER_ROW_UNION_QRY where COMPANY='XXX’
@Narmada this is interesting now.I run the query which you gave me so the OCTOBER balance is showing correct as per the AR analysis report but going forward in November at any given date the figures does not change it remains same as October then when I go back to September or any given date in September the figures are not matching what report says. @Narmada I need your help in this if you can give your expert advise.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.