FrontAccounting forum — Supplier Balances Report (201)

Re: Supplier Balances Report (201)

null@example.com (apmuthu) — Wed, 07 Feb 2018 05:22:39 +0000

Pass a correction (Journal) voucher.

Re: Supplier Balances Report (201)

null@example.com (Alaa) — Tue, 06 Feb 2018 21:04:45 +0000

Seems like we have got it wrong....
so in case of inserting a wrong opening balance, what is the best way to edit it

Re: Supplier Balances Report (201)

null@example.com (apmuthu) — Tue, 06 Feb 2018 19:01:28 +0000

If you made your Opening balances using a single Journal Voucher in the previous fiscal and closed it and had it brought forward into the new year all should be okay.

Re: Supplier Balances Report (201)

null@example.com (Alaa) — Tue, 06 Feb 2018 12:55:37 +0000

so do i need to edit the opening balance in the database ?

Re: Supplier Balances Report (201)

null@example.com (apmuthu) — Tue, 06 Feb 2018 09:01:17 +0000

All values are okay as per attachment.

Re: Supplier Balances Report (201)

null@example.com (Alaa) — Tue, 06 Feb 2018 00:00:00 +0000

i'd like to add that we get the correct balance value when we use the supplier transaction inquiry, so there must be something wrong with the report, specially when we select to show the balance "set show balance to yes"

so in one report if we keep "Show Balance no" we get the correct value which is 108,144.00
and when we set it to yes, the balance is -126,185.00

Supplier Balances Report (201)

null@example.com (Alaa) — Mon, 05 Feb 2018 23:50:36 +0000

Hello,
we have started this year with a new FA system, and to get the suppliers balances we added the balance for each supplier in the last day of 2017 by a journal voucher and closed the year.

Now the bug we are getting is kinda weird..
sometimes the opening balance is credit when it should be debit and sometimes its debit when it should be in the credit field.

sometimes the opening balance is credit and that is correct, but it gets a minus sign in the balance and thats not right.
supplier invoice should be credit and supplier payment should be debit.

also there is nothing called charges in accounting.. you should use credit and debit "thats easily fixed by updating the PO file"

please check the image.

https://ibb.co/b5fKAc