Credit Card Net Exchange Billing
Credit card net exchange billing allows the system to hold the credit invoice for a return to net it against the debit invoice for the associated exchange in order to reduce the number of transactions that occur for an exchange. The system uses the automatically created EXC Net Billing for Exchanges deferred payment option to determine how long to delay billing the customer’s credit card, based on the invoice date and the # of days for deferral defined for the EXC payment option.
Examples of net exchange billing: The remaining amount after the system performs credit card netting determines whether the system charges or credits the customer’s credit card.
Type of Exchange | Example |
---|---|
Even exchange |
Credit invoice for returned item = $50.00 Debit invoice for exchange item = $50.00 During deposits, the system nets the credit invoice containing the returned item against the debit invoice containing the exchange item to determine the remaining amount to deposit: 50.00 debit - 50.00 credit = 0.00 balance The system does not charge or credit the customer’s credit card. See CC Net Example: Even Exchange for more details. |
Uneven exchange for less expensive item |
Credit invoice for returned item = $100.00 Debit invoice for exchange item = $60.00 During deposits, the system nets the credit invoice containing the returned item against the debit invoice containing the exchange item to determine the remaining amount to deposit: 100.00 credit - 60.00 debit = 40.00 credit The system credits the customer’s credit card $40.00. See CC Net Example: Uneven Exchange for Less Expensive Item for more details. |
Uneven exchange for more expensive item |
Credit invoice for returned item = $100.00 Debit invoice for exchange item = $140.00 During deposits, the system nets the credit invoice containing the returned item against the debit invoice containing the exchange item to determine the remaining amount to deposit: 140.00 debit - 100.00 credit = 40.00 debit The system charges the customer’s credit card $40.00. See CC Net Example: Uneven Exchange for More Expensive Item for more details. |
Eligible orders: An order is eligible for net exchange billing if:
-
the Use CC Net Exchange Billing (M23) system control value is selected, and
-
the Hold Days for CC Netting (M24) is set to a number greater than 0, and
-
the order contains a credit card pay type, and
-
a deferred or installment pay plan has not already been assigned to the credit card pay type on the order (see Deferred/Installment Billing Overview).
Accepting an exchange transaction on an order eligible for net exchange billing: When you accept an exchange transaction on an order eligible for net exchange billing, the system:
-
updates the ODT Seq # field in the RA Exchange Item table with the order detail sequence number of the exchange item added to the order in order to link the exchange item to the associated returned item.
-
creates a manual authorization for the return amount, using the authorization code defined in the Default Auth Code for CC Netting (M25) system control value. The expiration date for the manual authorization is based on the Reauthorization days defined for the credit card pay type.
-
places the associated refund on hold and updates the Hold until date based on the # of days for deferral defined for the EXC deferred payment option. The system holds the refund for this number of days to allow time for the system to net the credit invoice containing the return item against the debit invoice containing the exchange item.
Billing an exchange transaction flagged for net exchange billing: When the exchange transaction is processed through billing, the system:
-
creates the credit invoice and assigns the EXC deferred payment option to the invoice. The system considers a credit invoice pending net exchange billing if the Invoice Payment Method record contains the EXC deferred payment option code in the FPO Payment Code and the credit invoice has not yet been deposited (the Deposit created date for the Invoice Payment Method record is blank).
-
updates the Deposit Release Date for the Invoice Payment Method record for the credit invoice with the calculated release date using the current date + the # of days for deferral defined for the EXC payment option. The deposit release date indicates when the deposit is eligible for processing; the system will not process the credit invoice until its deposit release date has been reached.
Reviewing the order in Order Inquiry: When reviewing orders flagged for net exchange billing:
-
EXC displays under the Line # field on the Order Inquiry Detail Screen for the order detail line that contains the return item to indicate the returned item is associated with an exchange item. Note: The system identifies the order detail line that contains the exchange item by the associated Order Line History record that contains the exchange reason code. You can review order line history on the Display Order Line History Screen.
-
the Net Bill field on the Display Invoices Screen for the credit invoice displays an asterisk, indicating the credit invoice is currently pending for net exchange billing. The system considers a credit invoice pending for credit card net exchange billing if the Invoice Payment Method record contains the EXC deferred payment option code in the IPM FPO Payment Code and the credit invoice has not yet been deposited (the IPM Deposit created date is blank).
Reviewing the refund: When reviewing refunds flagged for net exchange billing:
-
the Net field on the Work with Refunds Screen and Work with Refunds By Order# Screen displays an asterisk for a refund that is pending net exchange billing.
-
the text *NET BILLING displays next to the Amount field on the Change Refund Screen and Display Refund screen.
-
the system prevents you from changing the pay type of the refund to another pay type (the Pay type field on the Change Refund screen is display-only).
-
the Refund Due List by Type and the Refund Due List by Order # reports display an asterisk after the amount if the refund has been flagged for net exchange billing.
Generating a pick for the exchange item: During pick slip generation for the exchange item, the system applies the manual authorization to the shippable amount and performs batch authorization for any remaining balance due.
Shipping and billing the exchange item: When the shipment for the exchange item is processed through billing, the system:
-
creates the debit invoice for the exchange item and assigns the EXC deferred payment option to the invoice.
-
updates the Invoice Payment Method record for the debit invoice:
-
the IPM Auth # contains the authorization code defined in the Default Auth Code for CC Netting (M25) system control value.
-
the IPM Auth Date and IPM Deposit Release Date contain the current date.
-
-
updates the IPM Deposit Release Date for the credit invoice flagged for net exchange billing to the current date, releasing the credit invoice for netting.
-
processes the refund, even if the Hold until date for the refund has not been reached. However, the system does not print or email the credit card credit acknowledgment for the refund until the next time you run process refunds.
-
updates the Pay Plan Code field for the credit card pay type on the Display Order Pay Type Screen (2 of 2) with the EXC deferred flexible payment option.
Processing deposits: When you process deposits, the system nets the credit invoice containing the return item against the debit invoice containing the exchange item.
-
If the net difference is a credit, the system sends the credit invoice to the service bureau for settlement in order to refund the customer's credit card the net amount.
-
If the net difference is a debit, the system sends the debit invoice to the service bureau for settlement in order to charge the customer's credit card the net amount.
-
If the net difference is zero, the system does not send any invoice amount to the service bureau for settlement. No amount is applied to the customer's credit card.
Processing refunds: When you process refunds, the system defers the printing and emailing of credit card credit acknowledgments associated with refunds flagged for net exchange billing until the system nets the credit invoice containing the return item against the debit invoice containing the exchange item.
Once netting is performed, the system prints and emails credit card credit acknowledgments for refunds flagged for net exchange billing the next time you run process refunds. In addition, the Credit Card Credit Register displays an asterisk after the refund amount if the refund is flagged for net exchange billing.
The Display Refunds for Order Screen displays the amount of the refund that was processed.
-
If the net difference is a debit, the refund amount updates to .00.
-
If the net difference is a credit, the refund amount updates to the net credit amount.
-
If the net difference is zero, the refund amount updates to .00.
Reviewing order transaction history: The system creates the following Order Transaction History records during the net exchange process to help you understand the updates that have taken place. You can view these messages on the Display Order History Screen.
When the exchange transaction is accepted and processed through billing, the system creates records similar to the following:
Type | Transaction Note | Amt | User |
---|---|---|---|
RTN AUTH |
RA Credit pending processing |
100.00 |
TBROWN |
AUTH |
MANUAL AUTH# DETECTED - CCNET |
100.00 |
AUTH |
SHIPMENT |
CREDIT BILLED ON INVOICE# 0001014 |
100.00- |
TBROWN |
When you ship and bill the exchange item, the system creates records similar to the following:
Type | Transaction Note | Amt | User |
---|---|---|---|
REFUND |
CC Crd for inv# 1014 processed-deferred |
100.00 |
your default user |
SHIPMENT |
Pick# 0003977 Billed on Invoice# 0001015 |
60.00 |
TBROWN |
When you process deposits, the system creates a record similar to the following:
Type | Transaction Note | Amt | User |
---|---|---|---|
REFUND |
Refund amount netted to -40.00 |
|
TBROWN |
Reviewing order payment history: The system creates the following Order Payment History records during the net exchange process to help you understand the updates that have taken place. You can view these messages on the Display Order Payment History Screen.
When the exchange transaction is accepted, the system creates records similar to the following:
Type | Note | Inv | User |
---|---|---|---|
B |
Inv# 1014 created for $100.00- |
1014 |
TBROWN |
B |
with a deposit release date of 20815. |
1014 |
TBROWN |
When you ship and bill the exchange item, the system creates records similar to the following:
Type | Note | Inv | User |
---|---|---|---|
B |
Inv# 1015 created for $60.00 |
1015 |
TBROWN |
B |
with a deposit release date of 12915. |
1015 |
TBROWN |
When you process deposits, the system creates records similar to the following:
Type | Note | Inv | User |
---|---|---|---|
N |
Pend Dep of $60.00 on INV1015 netted |
1015 |
TBROWN |
N |
against CRD1014 reducing to $40.00-. |
1015 |
TBROWN |
N |
Pend Dep of $60.00 on INV1015 netted |
1014 |
TBROWN |
N |
against CRD1014 reducing to $40.00-. |
1014 |
TBROWN |
D |
Deposit confirmed $ 40.00-. |
1014 |
TBROWN |
Net exchange billing considerations:
-
An order is not eligible for net exchange billing if:
-
you return an item and then manually add an exchange item to the order.
-
the exchange item is soldout.
-
In these situations, the system does not link the exchange item with the return item and processes the return and exchange separately.
-
If you cancel the exchange item, the system does not perform net exchange billing and credits the customer’s credit card for the amount of the return.
-
If the manual authorization created for the return amount expires before the exchange item is shipped and billed, the system performs batch authorization during pick slip generation and continues to hold the credit invoice and refund in order to perform net exchange billing during deposits.
-
Regardless of whether you consolidate invoices, the system flags all credit and debit invoices associated with the return and exchange transaction for net exchange billing. See the following for examples:
-
If the order contains more than one credit card, the system includes both credit cards in the net exchange process.
-
If an item on the order is shipped and billed on the same day as the exchange item, the system includes the amount of the additional item in the net exchange process. See CC Net Example: Even Exchange Plus Additional Item for an example.
In this topic:
Credit Card Net Exchange Setup
Before you can use credit card net exchange billing, you must complete the required setup. Information requiring setup includes:
System Control Values for Credit Card Net Exchange Billing
System Control Value | Description |
---|---|
Use CC Net Exchange Billing (M23) |
Select this system control value if you want the system to net credit invoices with debit invoices before a deposit is sent to the service bureau for an invoice associated with an exchange. |
Hold Days for CC Netting (M24) |
Enter the number of days the system holds debit and credit invoices for credit card net exchange billing. The system updates the # of days for deferral field for the EXC Net Billing for Exchanges flexible payment option record with this number. Any existing refunds and Invoice Payment Method records are not updated with the new hold days. Note: Net exchange billing does not work unless this system control value is set to a number greater than 0. |
Default Auth Code for CC Netting (M25) |
Enter the authorization code the system uses when creating a manual authorization to allow for the netting of invoices during the credit card net exchange process. |
Deselect this system control value if the Use CC Net Exchange Billing (M23) system control value is selected. You cannot use preload deposit processing if you are using Credit Card Net Exchange Billing. |
EXC Net Billing for Exchanges Flexible Payment Option
The system creates the EXC Net Billing for Exchanges flexible payment option automatically if you select the Use CC Net Exchange Billing (M23) system control value for use during the Credit Card Net Exchange process. You cannot change or delete this flexible payment option or use this flexible payment option for deferred/installment billing. The default settings for the EXC flexible payment option are described below; see Working with Flexible Payment Options (WFPO) for more information on flexible payment options.
This flexible payment option is deleted automatically if you deselect the Use CC Net Exchange Billing (M23) system control value.
Field | Description |
---|---|
Payment Code |
Delivered as EXC. |
Description |
Delivered as Net Billing for Exchanges. |
Type |
Delivered as Deferred, indicating the system defers depositing the amount the customer owes for an order shipment for a specified period of time. |
Start |
Does not apply to net exchange billing. |
End |
Does not apply to net exchange billing. |
Expiration Date |
Does not apply to net exchange billing. |
View in OE/OM |
Delivered as unselected, since the EXC Net Billing for Exchanges flexible payment option is not an available selection during deferred/installment billing. |
Restrict to entity |
Delivered as 0, indicating the flexible payment option is not restricted to a specific entity. |
Auth full amount |
Delivered as unselected since this field is not used during the credit card net exchange process. |
Merchant ID Message |
Delivered blank since this field is not used during the credit card net exchange process. |
Ship Complete |
Delivered as unselected since this field is not used during the credit card net exchange process. |
Display Summary |
Delivered as unselected since this field is not used during the credit card net exchange process. |
Auto apply |
Delivered as No auto apply since this field is not used during the credit card net exchange process. |
Validate CC ext dt |
Delivered as unselected since this field is not used during the credit card net exchange process. |
Pick Message |
Delivered blank since this field is not used during the credit card net exchange process. |
Deferred Values |
|
# of days for deferral |
Delivered as 0. The system updates this field with the number of days you enter in the Hold Days for CC Netting (M24) system control value. This is the number of days the system holds debit and credit invoices for credit card net exchange billing. The system also uses this number to determine the manual authorization date during Credit Card Net Exchange Billing. |
Based On |
Delivered as Invoice Dt, indicating the system uses the invoice (billing) date and # of days for deferral field to calculate the deposit date. |
Fixed deferral date |
Delivered as 0 since this field is not used during the credit card net exchange process. |
Installment Values |
The # Of Installments, Interval, and Fixed Installment day fields are set to 0 for the EXC flexible payment option. |
Qualification Values |
The Offer and Item fields are blank and the Minimum Amt and Pay Type fields are set to 0 for the EXC flexible payment option. |
Credit Card Net Exchange Edit in Work with Pay Types (WPAY)
If the Use CC Net Exchange Billing (M23) system control value is selected, you cannot define an Alternate refund type or Alternate refund category for a Credit Card Pay type category pay type; the system displays an error message: Alt refund type/category not allowed with CC Net Exchange Billing.
Also, if an alternate refund type or alternate refund category is defined for an existing pay type, the system will ignore the alternate refund values and instead perform credit card net exchange billing for eligible orders.
Credit Card Net Exchange Examples
-
CC Net Example: Even Exchange
-
CC Net Example: Uneven Exchange for Less Expensive Item
-
CC Net Example: Uneven Exchange for Less Expensive Item Plus Ship Alone Item; Invoices Consolidated
-
CC Net Example: Uneven Exchange for More Expensive Item
- CC Net Example: Uneven Exchange for More Expensive Item Plus Ship Alone Item, Invoices Not Consolidated
-
CC Net Example: Uneven Exchange for More Expensive Item Plus Ship Alone Item; Invoices Consolidated
CC Net Example: Even Exchange
The system performs the following steps during credit card net exchange processing when the returned item is the same price as the exchange item. In this example, no other items besides the exchange item are added to the order.
# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for another item for the same price ($100.00). The exchange item is in-stock and reserved on the order. The customer also adds another item for $30.00 to the order. |
3 |
When the return and exchange transaction is accepted and billed, the system:
|
4 |
You run pick slip generation for the exchange item. |
5 |
You ship and bill the exchange item and additional item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Even Exchange Plus Additional Item
The system performs the following steps during credit card net exchange processing when the returned item is the same price as the exchange item. In this example, an additional item for $30.00 is added to the order.
# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for another item for the same price ($100.00). The exchange item is in-stock and reserved on the order. The customer also adds another item for $30.00 to the order. |
3 |
When the return and exchange transaction is accepted and billed, the system:
|
4 |
You run pick slip generation for the exchange item and additional item. The system:
|
5 |
You ship and bill the exchange item and additional item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Uneven Exchange for Less Expensive Item
The system performs the following steps during credit card net exchange processing when the exchange item is less expensive than the return item. In this example, no other items besides the exchange item are added to the order.
# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for a less expensive item ($60.00). |
3 |
When the return and exchange transaction is accepted and billed, the system
|
4 |
You run pick slip generation for the exchange item |
5 |
You ship and bill the exchange item and additional item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Uneven Exchange for Less Expensive Item Plus Ship Alone Item; Invoices Not Consolidated
The system performs the following steps during credit card net exchange processing when the exchange item is less expensive than the return item. In this example, the customer also orders an additional ship alone item for $30.00. The Consolidated Invoice (B49) system control value is unselected.
# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for a less expensive item ($60.00). The customer also adds a ship alone item for $30.00 to the order. |
3 |
When the return and exchange transaction is accepted and billed, the system
|
4 |
You run pick slip generation for the exchange item ($60.00) and ship alone item ($30.00). The system generates a separate pick slip for each item. |
5 |
You ship and bill the exchange item and ship alone item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Uneven Exchange for Less Expensive Item Plus Ship Alone Item; Invoices Consolidated
The system performs the following steps during credit card net exchange processing when the exchange item is less expensive than the return item. In this example, the customer also orders an additional ship alone item for $30.00. The Consolidated Invoice (B49) system control value is selected.
Important:
In Order Management System 21.0 or higher, or Order Administration, you cannot select the Consolidated Invoice system control value if it is not already selected. If the system control value is currently selected (set to Y) and you deselect it (change it to N or blank), you cannot then change it back to selected. The option to consolidate invoices will be removed at a later date.# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for a less expensive item ($60.00). The customer also adds a ship alone item for $30.00 to the order. |
3 |
When the return and exchange transaction is accepted and billed, the system
|
4 |
You run pick slip generation for the exchange item ($60.00) and ship alone item ($30.00). The system generates a separate pick slip for each item. |
5 |
You ship and bill the exchange item and ship alone item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Uneven Exchange for More Expensive Item
The system performs the following steps during credit card net exchange processing when the exchange item is more expensive than the return item. In this example, no other items besides the exchange item are added to the order.
# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for a more expensive item ($140.00). |
3 |
When the return and exchange transaction is accepted and billed, the system
|
4 |
You run pick slip generation for the exchange item. During pick slip generation, the system:
|
5 |
You ship and bill the exchange item and ship alone item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Uneven Exchange for More Expensive Item Plus Ship Alone Item, Invoices Not Consolidated
The system performs the following steps during credit card net exchange processing when the exchange item is more expensive than the return item. In this example, the customer also orders an additional ship alone item for $30.00. The Consolidated Invoice (B49) system control value is unselected.
# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for a more expensive item ($140.00) and also adds a ship alone item for $30.00. |
3 |
When the return and exchange transaction is accepted and billed, the system
|
4 |
You run pick slip generation for the exchange item. During pick slip generation, the system:
|
5 |
You ship and bill the exchange item and ship alone item. The system:
|
6 |
You process deposits. The system:
|
CC Net Example: Uneven Exchange for More Expensive Item Plus Ship Alone Item; Invoices Consolidated
The system performs the following steps during credit card net exchange processing when the exchange item is more expensive than the return item. In this example, the customer also orders an additional ship alone item for $30.00. The Consolidated Invoice (B49) system control value is selected.
Important:
In Order Management System 21.0 or higher, or Order Administration, you cannot select the Consolidated Invoice system control value if it is not already selected. If the system control value is currently selected (set to Y) and you deselect it (change it to N or blank), you cannot then change it back to selected. The option to consolidate invoices will be removed at a later date.# | Step |
---|---|
1. |
The customer places an order for an item for $100.00. The item is picked, shipped, and billed. The order is processed through deposits. |
2. |
The customer returns the item for $100.00 to exchange it for a more expensive item ($140.00) and also adds a ship alone item for $30.00. |
3 |
When the return and exchange transaction is accepted and billed, the system
|
4 |
You run pick slip generation for the exchange item. During pick slip generation, the system:
|
5 |
You ship and bill the exchange item and ship alone item. The system:
|
6 |
You process deposits. The system:
|