1Transaction Processing
Option 4Invoices Journal
Use this function to print a journal of invoice transactions entered through either invoices entry function. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Invoices information, this step provides sequencing of data records by Post Now?, Operator ID, Control Number, Post Year, and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Print Journal?, Journal OK?, and Invoices Printed?, with the option to enter userspecified comparisons at run time.
- Step 2This is the standard disposition used for all transaction journals.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Accounts Receivable Invoices Journal, this step formats the Invoices and Invoice Line Items information. The following data items are shown: Transaction No, Customer, Name, Tax Code and District, Terms, Post Month and Year, Invoice and Due Date, Customer PO, Comm on Sub?, Order No, Subtotal, Receivable Account, Description, Transaction Type, Salespersons, Comm Percent, Comm Basis, Invoice Number, Apply To, Invoice Amount, Deposit, Discount, Freight, Sales Tax, Line Item, Offset Account, Line Item Type, Price, Quantity, Amount, Item Code, Description, Sub Type, Sub Code, and Cost. As appropriate, group headings appear whenever a change occurs in Control Number or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control Number. When totals are specified, the following items are accumulated: Invoice Total, Deposit Total, Discount Total, Freight Total, Tax Total, Control Total, and Hash Total. Grand totals print at the end, showing Journal Errors and Journal Warnings.
A sample is shown below.
Expert Computing, Inc.
10/12/94 15:10 LGG Page: 1
Accounts Receivable Invoices Journal
Trx Customer Tax Cd/Dst Trms Mo/Yr Inv Date Due Date Customr PO C/Sub? Order No
Subtotal
Receiv Account Trx Type Description Sls Comm Comm
Invoice Apply To Invc Amount Deposit Cust Disc Freight Sales Tax Rep Pct Basis
=================================================================================================================================
Control Group SRR / 0013 Orders through 8/20/89
Post Month/Year 08 / 89
0001 00000040 Burlington Enterprises 002 001 002 08 89 08/21/89 09/20/89 89A-556 007210 1850.00
1030001001WH Accts Receiv, Sales/Wholesale AR Invoice special order shipped 8/18/89 010 5.0
3011 3011 685.32 1200.00 .00 35.32 .00
Line Account/Item Cd Description Item Type/Sub Code Price/Cost Quantity Comm Pct Amount
0001 3010001001MA Sales, Manufacturing Taxable Sales 1200.000 1.00 1200.00
special order desk GL JONES 985.630
0002 3010001001WH Sales, Wholesale Taxable Sales 325.000 2.00 650.00
leather office chair 489.550
—————
— Line Items Total —> 1850.00
_________________________________________________________________________________________________________________________________
0002 00000020 Master Sellers Company 002 001 001 08 89 08/21/89 08/21/89 1358.25
1030001001WH Accts Receiv, Sales/Wholesale AR Invoice 8/15/89 shipment 020 5.0
3012 3012 1452.20 .00 .00 24.62 69.33
Line Account/Item Cd Description Item Type/Sub Code Price/Cost Quantity Comm Pct Amount
0001 3010001001WH Sales, Wholesale Taxable Sales 271.650 5.00 1358.25
file cabinet 1064.870
—————
— Line Items Total —> 1358.25
_________________________________________________________________________________________________________________________________
0003 00000040 Burlington Enterprises 002 001 002 08 89 08/21/89 09/20/89 099852 3580.11
1030001001WH Accts Receiv, Sales/Wholesale AR Invoice 8/18/89 shipment 010 5.0
3013 3013 3854.21 .00 .00 .00 274.10
Line Account/Item Cd Description Item Type/Sub Code Price/Cost Quantity Comm Pct Amount
0001 3010001001WH Sales, Wholesale Taxable Sales 675.200 2.00 1350.40
10’x8' shelving unit 1147.200
0002 3010001001WH Sales, Wholesale Taxable Sales 154.360 10.00 1543.60
metal shelf 1241.030
0003 3010001001WH Sales, Wholesale Taxable Sales 206.980 3.00 620.94
6’x3' bookcase 510.600
0004 3010001001WH Sales, Wholesale Taxable Sales 65.170 1.00 65.17
desk set 50.250
0005 3010001001WH Sales, Wholesale Sales Tax 274.100 1.00 274.10- Step 5In order to print the Accounts Receivable Journal Summary, this step formats the Summarized Distributions information. The following data items are shown: Post Year, Post Month, GL Account, Description, Journal Code, Operator ID, Transaction Date, Debits, and Credits.
A sample is shown below.
Expert Computing, Inc.
10/12/94 15:11 LGG Page: 1
Accounts Receivable Journals Summary
!!! ONE OR MORE OF THE CONTROL GROUPS ON THE DETAIL JOURNAL CONTAINED ERRORS; GROUPS WITH ERRORS WILL NOT POST !!!
Yr Mo Account Account Name Jrnl ID Trx Date Debits Credits
=================================================================================================================================
89 08 1030001001WH Accts Receiv, Sales/Wholesale ARIV SRR 08/21/89 7121.99
89 08 2020001001 Sales Tax Payable, Sales ARIV SRR 08/21/89 343.43-
89 08 2051000000 Sales Deposits ARIV SRR 08/21/89 1200.00
89 08 3010001001MA Sales, Manufacturing ARIV SRR 08/21/89 1200.00-
89 08 3010001001WH Sales, Wholesale ARIV SRR 08/21/89 6790.61-
89 08 4071000001WH Customer Disct, Sales/Wholesal ARIV SRR 08/21/89 120.00
89 08 4190000001WH Freight Out, Sales/Wholesale ARIV SRR 08/21/89 107.95-
—————— ——————
— Grand Totals —> 8441.99 8441.99-
============= =============