How to Print the Posting Journals Report on Sage 300


  1. Open Accounts Receivable > A/R Transaction Reports > Posting Journals.
    • Note: You can also open the Posting Journals report by double-clicking in the Posting Sequence Number column on the Batch List screen for the batch you need.
  2. From the Select Posting Journal options, select the type of journal to print: Invoice, Receipt, Refund, or Adjustment.  The Invoice Posting Journal includes credit note and debit note transactions.  If you use multicurrency accounting, you can also select Revaluation or Provisional Revaluation.
  3. Select a Sort By option to specify the order in which to list transactions on the posting journal:
    • Batch/Entry. This option lists transactions in order by the batch and entry numbers they were assigned when you entered them.
    • Customer Number. This option lists transactions in order by their customer numbers.
    • Document Date. This option lists transactions in order by the dates that you entered when you created the transactions.  The choice you can make varies with the type of journal you want to print. You select Check Date for this option when you are printing receipt posting journals. You select Adjustment Date when you are printing adjustment posting journals.
    • Document Number. This option lists invoices, credit notes, and debit notes by their document numbers. These can be document numbers you assigned, or the numbers that are assigned automatically by Accounts Receivable, using the prefix and next number entered for each document type on the A/R Options screen.
    • Check Number. This option lists receipt transactions by the check or receipt number you entered with each transaction or by the numbers that are assigned by Accounts Receivable to transactions entered without numbers.
    • Adjustment Number. This option lists adjustment transactions by the adjustment number that Accounts Receivable assigns to the transactions when you create them. This option will order the transactions in the same order as sorting by batch and entry
      number, unless you create transaction batches in a non-sequential order. For example, if one person opens an adjustment batch but does not enter the adjustments until after a second person has opened a second batch and entered transactions, then the transactions in the second batch would be listed first.
  4. Use the From Posting Sequence and To Posting Sequence fields to specify the lowest and highest numbers in the range of posting sequences for which to print journals.  A unique posting sequence number is assigned each time you post batches. These fields display the lowest and highest posting sequence numbers in your Accounts Receivable system for the type of journal you select. (You use the Clear History screen to clear posting sequences for the journals you have already printed to a printer or file.)
  5. Select additional options for the report, as follows:
    • Reprint Previously Printed Journals. Select this option if you want to print additional copies of journals you printed before.  Do not select the option if you want to print only the journals you have not already printed from the specified range of posting sequence numbers.
    • Include Job Details. Select this option to include the contract, project, category, and resource for each job-related transaction.
    • Include Optional Fields. Select this option to include optional field information for each printed transaction. (The option is available only if you use optional fields with Accounts Receivable.)
    • Include G/L Ref./Desc. Select this option to print the G/L reference and description with each transaction.
  6. Click Print.
    • If you are printing to a physical printer, the Print window appears. Confirm your printer selection and the number of copies to print, and then click OK. Otherwise, click Cancel or Setup.
    • If you are printing to the screen (preview), the report appears in a new window. You can print the report or export it to a file.
      • Note: For Web-based clients, the preview screen appears first when you click the Print button.
    • If you are printing to a file, the Export window appears. Specify the file format (for example, PDF, DOC, or XLS). Also, specify a destination for the file:
      • Application. View the report in an application that can open files of the specified format (for example, if you specify PDF as the file format, the report opens in Adobe Acrobat). You can then save the file.
      • Disk file. Save the report to a location you specify.
      • Microsoft Mail. Send the report as an e-mail attachment.
        • You can enter the name of a non-existent file or directory to be created by the system when you print. When you print to a file, the report is assigned a unique name, for example, CS1000.TXT.
    • If you are printing to e-mail, an e-mail message appears with the report attached.