• Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Topic: Supplier Balances Report (201)

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

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Supplier Balances Report (201)

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Supplier Balances Report (201)

All values are okay as per attachment.

Post's attachments

Rep201_ok.zip 33.7 kb, 2 downloads since 2018-02-06 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Supplier Balances Report (201)

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Supplier Balances Report (201)

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.

apmuthu's Website

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Supplier Balances Report (201)

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Supplier Balances Report (201)

Pass a correction (Journal) voucher.

apmuthu's Website