Road Map: AR Invoice Register

Use the AR Invoice Register (RR) program to select confirmed shipments to invoice and print the AR Invoice Register, which creates AR invoices, updates commissions, sales statistics, and the general ledger. See Background for more information.

Before you run this program each time

You should run these programs in this sequence:

  1. Sales Order Maintenance (OE) to enter orders, and optionally obligate items and create shipments.

OR

One-Step Invoice Entry (RE) to enter an order, obligate items, create a shipment, and confirm the shipment in one step.

OR

Quote-to-Order Transfer (EPIB) to transfer:

  • Sales orders imported from ASCII files with Order Import (EPI).

  • Sales quotations entered with EDI/Sales Quote Maintenance (QOE).

  • Customer projects transferred with Project Maintenance (PSM).

  • Orders created with Repetitive Billing Report (RBIC).

  1. (Conditional) Order Shipment Selection (OSS) to select sales orders or order lines to obligate, and to create shipments, if you have not done so with Sales Order Maintenance.

OR

Sales Order Auto Processing (OAP) to obligate sales orders and create shipments.

  1. Sales Shipment Confirmation (OC) or Secured Confirmation (SOC) to create a shipment, if you have not already done so, and confirm the shipment.

    AND/OR

Bill of Lading Maintenance (BLM) to create a bill of lading and confirm the shipments and bill of lading.

  1. Bill of Lading Print Queue (BLPPM) to process the bill of lading queue.

OR

Bill of Lading Print (BLP) to print or reprint a specific bill of lading document, and optionally, a commercial invoice if the shipment is to another country.

You may also have run:

  • One-Step Invoice Entry (RE) to enter a credit memo, debit memo, adjustment, or reversal.

  • RMA Maintenance (RMA) to enter an authorization for a customer to return material and AR Invoice Register (RR) to invoice and print the AR Invoice Register.

AND CONDITIONALLY

Receiver Maintenance (IRC) to receive the returned material and AR Invoice Register (RR) to invoice and print the AR Invoice Register.

Before you run this program the first time

You should run these programs:

  • System Options Maintenance (XM) (Accounts Receivable Options) to set these options: Separate invoice numbering?, Tax detail file active?, Include misc charges in terms disc calc? and Include freight in terms disc calc?

  • System Options Maintenance (XM) (GL Journal Options) to set these options for updating the general ledger: Print journal after register?, Print from GJ?, Post in D=Detail or S=Summary, Post from R=Register or J=Journal, and Erase posting files after posting?

  • System Options Maintenance (XM) (Inventory Control Options) to set the Inventory interfaced to GL? option.

  • System Options Maintenance (XM) (Order Processing Options) to select the Updates sales history by cust by item? option (if you want to write a history file when invoices are processed) and set the Customer surcharges active? option.

  • System Options Maintenance (XM) (Sales Commission Options) to set these options: Commission processing active?, Payable at time of I=Invoice or P=Paymnt, Commission based on P=Price or M=Margin, Enable commission rates per line?, Excl header disc from comm amt?, Excl line disc from comm amt?, Incl freight in comm amt?, Incl misc charges in comm amt?, Excl credit adj from comm amt?, Excl debit adj from comm amt?, Excl terms disc from comm amt?, Non-comm default for non-stock items, Apply splits to flat amounts?, and Process comm for progress payments?

  • System Options Maintenance (XM) (Warranty Tracking Options) to set these options: Warranty tracking active?, Component tracking active?, Track component detail?, Operation tracking active?, Track operation detail?, Track customer address, Warranty assignment method, Track shipment detail?, and Default warranty duration.

  • System Options Maintenance (XM) (Enterprise Options) to select a date display format for your enterprise, Branch Maintenance (TBM) to select a date display format for your branch, or User Maintenance (UIM) to select a date display format for an individual user.

  • Batch Number Setup (XBC) to set up a batch numbering scheme for batch number assignment and set the Allow manual assignment? option.

  • Numbering System Setup (XOC) to set up the layout for invoice and warranty numbers.

  • User Maintenance (UIM) to give each user who will run this program permission to update the general ledger; select Allow final reg upd?

  • GL Account Maintenance (GMM) to set up GL organization codes and GL accounts.

  • Posting Criteria Maintenance (XPC) to set default and specific GL organization codes and GL accounts for automatic posting to the general ledger. You set them up for these posting names: AR, COGS-LABR, COGS-MATL, COGS-OS, COGS-OVHD, COMM ACCRU, COMM EXP, CURR EXCH, DEPOSIT, FREIGHT, INVENTORY, MISC REV, PREPAYMENT, REVENUE, RMA RETURN, SALES TAX1 - SALES TAX10, SURCHARGES, and TRADE DISC.

  • GL Accounting Period Maintenance (GDM) to set up the GL calendar.

  • Terms Code Maintenance (TER) to set up codes for cash payment discounts, discount dates, and due dates.

  • Branch Maintenance (TBM) to set up branches.

  • Branch Groups Maintenance (TGM) to set up branch groups.

  • Customer Maintenance (CM) to set up customers.

  • Price-Contract Maintenance (PCM) to set up prices, discounts, and surcharges.

  • Sales Commission Hierarchy Maintenance (SCHM) program to set up the sales rep hierarchy that determines how sales reps are assigned to a sales order or line and set up the commission rate hierarchy that determines which commission rates apply to a sales order or line.

  • Document Output Parameters Maintenance (TDOC) to set options for outputting or queuing invoices.

  • Output Device Maintenance (XDM) to set up the output devices that you plan to use.

  • Date-Output Device Maintenance (ZE) to select your default output device and set whether you can override that device.

After you run this program

You will most likely run these programs in this sequence:

  1. Invoice Print Queue (RPPM) to process the queue.

OR

Invoice Print (RP) to print or reprint customer invoices.

  1. Cash Receipts Entry (RCE) to apply cash received from customers to AR invoices, apply adjustments to existing transactions, enter miscellaneous cash, and enter customer deposits and on-account payments, and print the Cash Receipts Register.

You may also run these programs:

  • AR Adjustments Entry (RB) to apply an AR adjustment or write-off to an invoice, enter an adjustment or write-off, transfer an invoice balance to another AR account, and print the AR Adjustment Register.

  • AR Invoice Maintenance (RM) to mark an invoice disputed, enter promised payment information, and change AR terms for an open invoice.

  • One-Step Invoice Entry (RE) to enter a credit memo, debit memo, adjustment, or reversal.

  • AR Invoice Inquiry (RQ) to display invoice details.

  • Invoice Transactions Inquiry (RIQ) to display all transactions associated with an invoice.

  • AR Inquiry (RA) to display a customer's transactions and prepare aging schedules.

  • Statement Print Selection (RSS) to create customer statements that meet your criteria and queue them for output and Statement Print Queue (RSPM) to process the queue.

    OR

Statement Print (RS) to print customer statements that list open AR transactions.

  • Packing Slip Print (OPAK) if you are using barcode scanning, to print a packing slip for invoiced orders with barcoded shipment information.