Creating a Purchasing and Sales Journal

The Purchasing and Sales Journal (TX226) lets you list transaction totals for several applications, including credit and debit memos, prepayments, and transaction distribution details. The transactions list for:

  • Accounts Payable

  • Cash Management

  • Billing

  • Billing and Revenue Management

  • Accounts Receivable

  • Tax (manually specified tax transactions)

The report is useful during VAT auditing to ensure that no purchase or sales transactions were omitted and that the transactions were correctly taxed.

Before running the report, you must run a data load program, Journal File Create (TX101), to create a tax file for TX226 to read. Then you run TX226 to list transaction totals. Finally, you run a data purge program, Journal Detail Purge (TX301), to purge the data and be able to report on different transactions the next time. After purged from the file, TX101 no longer selects these records.

Create a purchasing and sales journal

  1. Run the data load program. Run Journal File Create (TX101). The program writes the input and output transactions to a new tax file. Input transactions come from Accounts Payable, Cash Management, or Tax. Output transactions come from Accounts Receivable, Billing, Billing and Revenue Management, Cash Management, and Tax.

    Select the company, process level, transaction source, and tax period range.

  2. Run Purchasing and Sales Journal (TX226) to create a purchasing and sales journal.
  3. Specify this information:
    Process Level

    Select the process level to include in the report.

    Source

    Specify whether to include input transactions, output transactions, or both.

    Accounting Unit

    Select a general ledger accounting unit.

    Account

    Select a general ledger account.

    Sub Account

    Select a general ledger subaccount.

    Tax Period Range

    Specify the tax year and tax period. If you only specify a From tax period, only one period shows.

    Distribution Lines

    Specify whether to include distribution lines in the report. The default is No.

  4. Run the purge program to delete journal records, after you have finished reviewing them. Run Journal Detail Purge (TX301). Select the company, process level, source, and tax period range.