Adding a column to payables reporting

In regards to job costing;

it would be super helpful when creating a report of all payables, to have the option to add the "order/quote" field to the reporting columns. That field is there, as an option to us, whenever you enter a payable invoice, but NOT as an option to add that field to your reporting. For example, I want to see all the payable for the last 6 months, for each job. I should be able to pull up a report of all payables entered, and add that column to my default report, then export. The sorting could be done separately once exported into excel. Right now I cannot add or remove that column at all. It isn't an option. 

  • You can formally suggest that feature (under the Help menu in Sage 50) or add your vote to the other suggestions to add the tItLU.sPONum field to reports. 

    If you want to get that information in a report sooner there are addon reporting tools such at XLGL, MSQuery, Excel, LibreOffice, Sage Intelligence, etc.

  • in reply to RandyW

    I went to the help menu to report this and it took me here??

  • in reply to Lylie

    On the latest release, 'Submit Product Idea ' is second from the bottom of the help menu.  It should take you to 'Ideations'.

    Don't get your hopes up, it seems unlikely that the Order Number field would not appear together in any report with the Invoice Number, despite requests to add them, in a product that has been on the market for *decades*, because someone just... forgot.

    There is a few technical difficulties, because the Order Number field is stored separately, can be blank, may not be unique, and can be 'Cleared' when invoices are paid.  But it's easy enough to query with a left outer join.

  • in reply to RandyW

    Thank you Randy Slight smile