This report shows all transactions and the associated GL account information for the GL date range and accounts that you specify. Use the Sales Journal when balancing your accounts receivable aging to the general ledger.
When reconciling, the total on the Sales Journal by GL Account should equal the total of postable items in the Transaction Register.
To match both foreign and functional currency amounts to your general ledger, run your Sales Journal by currency. If you want to preview your post to see if your debits match your credits, run the Sales Journal with a posting status of Unposted.
For MFAR customer, you are able to match the Sales Journal by GL Account report at the aggregate level not at the level of each company segment value.
Note: See also: Common Report Parameters for Reconciliation Reports.
Entered Currency: To match foreign currency amounts against your general ledger, select the foreign currency code. If you do not select a code, then the report will not display amounts in the Foreign Currency columns.
GL Account Type: The type of general ledger accounts to include in this report. You can enter Freight, Receivable, Revenue, and Tax account types.
Order By: Sort your information by choosing one of the following:
| Customer | Sort and print your sales journal information by customer name. |
| Invoice Number | Sort and print your sales journal information by invoice number. |
Company: The balancing segment for this group of transactions.
Currency: The currency code for this group of transactions.
GL Account Type: The general ledger account type for the sales journal information on this page of the report.
GL Date (Date) to (Date): The range of invoice general ledger dates you selected to print on this report.
Posting Status: The posting status for sales journal information on this page of your report.
Subtotal by Invoice Currency: The total amount of debits and credits for an invoice in your functional currency.
Totals: The total amount of debits and credits for this report in both your foreign and functional currency.