Changing the Body of an A/R Report

A/R Selections Subscreen

Use the A/R Selections subscreen to set sorts and limits. The fields in this subscreen pull information from your A/R files.

You can set sorts and limits in two groups. The first sort group is the A/R Selections record. It contains the following fields:

• Cust # Customer's account number
  Trial balances and statements must include customer account number as one of the sorts.

• Invoice # Invoice number for a posting
  Trial balances and statements must include invoice number as one of the sorts.

• Date Posting date

• Check # Check number you enter when posting payments

• Debits $ Debit amount for a posting

• Credits $ Credit amount for a posting

• Tax $ Tax amount for a posting

• Discount $ Discount amount for a posting

• Loc G/L location for a posting

• Remarks Posting remarks that describe the posting type (payment, invoice, etc.)

• P/O # Purchase order number for an invoice

• Disc Date: Date for a discount posting

• Sel Date: Aging date (For drop ship orders, this date is updated from A/P.)

• Type: System-generated code that indicates whether a posting was made to a master customer account or a departmental account. There are two valid codes:

• •  1 Posted to a master account

  •  2 Posted to a departmental account.

• Disc Discount type. Valid discount types include the following:

• •  S Standard discount

  •  P Cost-plus discount

  •  C  Contract price

  •  *  Sale contract

  •  1-5  Column price

  •  N  Net price.

• Pos Point-of-sale flag. There are two valid settings:

• •  Y  Invoice is from point-of-sale

  •  N  Invoice is not from point-of-sale.

• Post Type Indicates the type of posting made. Valid post type codes include:

• •  1  Invoice

  •  2  Credit

  •  3  Payment

  •  4  Adjustment.

• Dept Customer's department

• Comm Flag Commission code, which is specified in the Order Entry window.

• Slsm Number of the salesperson for an invoice.

The second sort group includes the following:

• Invoice Totals Totals for each invoice. There are three invoice total fields:

• •  Total $  Invoice total

  •  Discs $ Total discount for the invoice

  •  L $  Remaining balance for the invoice.

• Batch Totals Totals for each batch. There are three batch total fields:

• •  Total $ Total amount for the batch

  •  Cash $ Total cash amount posted for the batch

  •  Check$ Total amount from checks posted for the batch.

• Aging Breaks out A/R totals by age:

• •  Curr $   Total from invoices less than 30 days old

  •  Over 30 $  Total from invoices that are from 31 to 60 days old

  •  Over 60 $  Total from invoices that are from 61 to 90 days old

  •  Over 90 $  Total that is over 90 days old.

• Type Breaks out A/R totals by posting type:

• •  Inv $ Total invoice amount

  •  Credit$ Total credit amount

  •  Pay $ Total payment amount

  •  Adjust$ Total amount for adjustments

  •  Fin $  Total amount for finance charges.