unpaid bills report

ian_7002967
ian_7002967 Member Posts: 13 Novice Member Novice Member
edited June 2020 in Accounts Hosted
We would like to modify the monthly unpaid bills report to include the general ledger code that apply to each of the bills received. I had a look at all the modify options and have been unable to establish how to do it. Am sure somebody out there will be able to help me
Ian

Comments

  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,133 Accredited Partner Accredited Partner
    edited June 2020
    I dont think this will work Ian - the Unpaid Bills report is a report that picks up header records - eg Bill No - Date - total amount, supplier name etc, one line for each transaction... - you need a transaction detail report in order to get the GL code (account name) to show up - and this could be multiple lines for each transaction - so not going to happen...  the only way this would work is if you were to put something in the top Memo area of the bill - which you could then choose to display on the unpaid bills report by choosing to show the Description column... HOWEVER... I just had a play and you may get what you want if you choose to add the Description and the Account columns - then head over to Filters and select for the Accounts option - For Detail accounts matching - All Income/Expense accounts - this will increase the number of lines displayed because it will show one line for each split line on the transaction - but may be what you are looking for?  Cheers Linda
  • ian_7002967
    ian_7002967 Member Posts: 13 Novice Member Novice Member
    edited October 2017
    Thanks Linda for your prompt response I will have a look and see how we go with it

    Cheers

    Ian