FrontAccounting forum — Supplier Balances Report (201)

Re: Supplier Balances Report (201)

2018-02-07T05:22:39Z

Pass a correction (Journal) voucher.

Re: Supplier Balances Report (201)

2018-02-06T21:04:45Z

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)

2018-02-06T19:01:28Z

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)

2018-02-06T12:55:37Z

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

Re: Supplier Balances Report (201)

2018-02-06T09:01:17Z

All values are okay as per attachment.

Re: Supplier Balances Report (201)

2018-02-06T00:00:00Z

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)

2018-02-05T23:50:36Z

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