Sage 300

 View Only
  • 1.  Hi all - What is the best report to run in 300 to

    Posted 05-18-2018 07:48
    Hi all - What is the best report to run in 300 to reconcile your purchases clearing account? I'm sure I've run into this before but can't remember. Seems like there should be a 'received by not invoiced' report but nothing is jumping out at me. Thoughts? Ideas? Thanks!


  • 2.  RE: Hi all - What is the best report to run in 300 to

    Posted 05-18-2018 08:01
    Marc - There isn't one. We had to create a custom report using 2 tables and a view. I'm sure I can get a copy of the report and view.


  • 3.  RE: Hi all - What is the best report to run in 300 to

    Posted 05-18-2018 08:18
    Marc - here is the report and view. We use this at most of our 300 clients.

    Attachment(s)

    txt
    vPORECEIPTS.txt   959 B 1 version


  • 4.  RE: Hi all - What is the best report to run in 300 to

    Posted 05-18-2018 09:14
    Thank you Lloyd - this report is awesome!