Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Summary billing provides the ability to combine invoices from multiple customers into a single invoice for a separate customer for billing purposes. The customers who take delivery of the product are referred to as summary ship-to customers. The customer who receives the billing information is referred to as the summary bill-to customer. Each customer that participates in summary billing will be configured as a summary billship-to customer or be linked to a summary bill-to customer. Customers linked to a summary bill-to customer are summary ship-to customers.

The summary ship-to invoices are used for sales analysis purposes. This allows users to do analysis on a more granular basis with the ability to report sales by customer location, region, state, etc. Summary ship-to invoices are not used for G/L posting or cash applications. The source documents for summary ship-to Invoices are customer orders, debit and credit memos.

The summary bill-to invoice is used for aging, cash application and posting to the General Ledger. They are not used in sales analysis because the summarized information does not provide sufficient detail for analysis purposes. The source documents for summary bill-to invoices are summary ship-to invoices.

The summarization process can occur in one of two methods, Average Price or Distinct Price.
Average Price combines units, pack and dollars for each distinct Item for all summary ship-to invoices being summarized then divides the dollars by the pack to provide an average price per unit for each Item on the summary bill-to Invoice.
Distinct Price creates a separate invoice item line on the summary bill-to invoice for each distinct item price combination from all the summary ship-to Invoices being summarized.

...

  1. Division Configurations
  2. Create Customers
  3. Summary Bill To Customer Setup
  4. Summary Ship To Customer Setup
  5. Create Customer Orders
  6. Allocate & Ship Release Orders

Step-by-Step Guide

Create Invoices for Summary Bill To Customers

  1. Navigate to the Create Invoices (Logistics -> Create Invoices) 

 

...

Upon entry all orders will be displayed for regular customers for the division you are currently in.

Image RemovedImage Added

 

Click the Summary Bill Customers radio button to access the summary ship to orders

Image RemovedImage Added

 

Select the orders to create invoices for then click the Auto Invoice Button.

Image RemovedImage Added

 

The Auto Invoice form is used to designate the invoice and as of dates for the Create Invoice process.

Image RemovedImage Added

 

There are 3 selections in the drop down. After selecting an option is completed click the OK button

Image RemovedImage Added

Use Dates Below allows the user to accept the default system dates or enter a desired date.

...

The invoice number assigned can be viewed by scrolling form to the right. Click the form Close button to exit.

Image Removed

 Image Added

This process should be repeated for all orders that will be part of the Summary Bill To Invoice.

 

Credit and Debit Memos fro Summary Bill To Customers

2. Navigate to the Adjustment Entry (Logistics -> Adjustment Entry) 

Credit and debit memos are create din created in the Adjustment Entry form.

The invoice adjustment invoices must be updated prior to creating the Summary Bill To Invoice.

Click New

Select ship-to customer

Enter Dates

Click "+" in navigation bar to enter items

Click Save to generate adjustment invoice

Image Added


Invoice Update for Summary Bill To Customers

3. Navigate to Invoice Update (Logistics > Invoicing > Invoice Update)

Upon entry all adjustment invoices will be displayed for regular customers for the division you are currently in.

Image Added

 

Click the Summary Bill Customers radio button to access the summary ship to adjustment invoices.

Select the adjustment invoices to update then click the OK button.

Image Added

 

Click the Save button to update the invoice 

Image Added

 

Click the Yes button in the Confirm message box. Upon completion the Update Status will change to Succeed. 

Image Added

 

Create the Summary Bill To Invoice

4. Navigate to Summary Bill To Invoice (Logistics > Invoicing > Summary Bill To Invoice)

Select the From and To Invoice dates and the Bill To Customer then click Retrieve (if left empty ALL Bill To Customers will be included)

Image Added  

 

There are two methods used to select the Summary Bill To customer(s)

1) Click the Select All check box will check the Inclu. check box  for All rows displayed      2) Click the Inclu. check box for each Summary Bill To Customer displayed 

The "+" can be selected to view the details (Ship to Invoices tab) for summary bill to invoice to be created. 

Image Added

 

The Invoice Preview tab is used to view the summary Bill To Invoice(s) to be created. The user can change the Summary Bill To invoice date, enter a Po number and use the "+" to view the summary Bill To invoice details. 

In this example two invoices will be created. One for the summary Ship To customer orders/ invoices and one for the summary Ship To customer debit/credit adjustment invoices. 

Click the Create button to generate the Summary Bill To Invoice(s).

Image Added

 

Click Yes in the Confirm message box to continue, No will return control to the previous form.

Image Added

 

The Summary Bill To Proof report is generated for each summary Bill To invoice created.

Note: This is the only time this report is available to print.

Image Added

 

 

Correcting (Reversing) a Summary Bill To Invoice

5. Navigate to Logistics Invoicing Unsummarize Summary Bill To Invoice 

Summary Bill To Invoice can be unsummarized prior to invoice registration. The summary Bill To Invoice will be voided.

This process is used to add additional invoices, use a different summary Bill To Invoice date or PO number or Reprice an item line on the summary Ship To invoices.

 

Image Added