Cash Receipts Journal with Invoice Amount

SUGGESTED

Hello! I have Sage 50 and also the Intelligence Reporting. My question; Is there any was possible to create a report that is the cash receipts journal that has what the total $ the invoice is for whether or not if only 50% of it was paid? I can get the invoice #, the amount paid, customer, etc. But I need a report that shows me the total amount of the invoice too. Basically a report that will tell me each month; out of all the cash receipts, which invoices were paid in full? 

Also, I thought the intelligence reporting was going to be the answer but it looks like it only helps with customizing financial statements. What is the "Connector" add on? Will that help me customize more thorough reports of what I need? Like cash receipts, job profitability reports, etc.?

  • 0
    SUGGESTED

    Hi Nicole, The short answer is yes IR can produce the report you are seeking. The connector is where the programming magic happens, aka, where the containers are programmed. If you have begun your learning phase of IR, you can add the total invoice amount by using JrnlHeader.MainAmount. If you have not begun your learning, you can contact me offline to explore that option. Another option is to get someone to write the report for you.