Follow

ID750 Combine Freight Charges On Contract Misc Tab and Invoice, Overview & Sample

Automatically enters Freight Charges on Contract Record

Jump to Overview | Samples | Variables | Alert Functionality | Best Practices & Tips |  Related Alerts |

Click to Subscribe

Overview

Overview

This process adds the supply order freight charge to the contract, so the charge is invoiced on the next contract invoice, instead of on a zero dollar supply order. This avoids sending out multiple small dollar amount invoices for freight charges, and moves those charges onto the next Contract invoice to be billed.

This process maintains a permanent record on the Contract Record Miscellaneous tab of what was billed for which shipment, and when. The charge shows on customers invoice as separate line item. 

 

Run Schedule: End of Day

Type of Output: Email

 

*  *  *

Sample

Sample

Freight Charge on Contract Invoice:

Sample_Invoice.png

Daily Summary:

ID750_Sample_Output.png

 

*  *  *

Variables

Variables

ID750Var2.PNG

Variable 2: Price method for charge, Enter Markup, FlatRate, OR Cost.

FlatRate-fixed freight charge to be assigned to each charge

Markup-% markup applied to actual cost of freight.  (i.e. Freight cost is 5.00. Multiply that by 1.50 for a 50% markup and you get $7.50). Requires Shipping Record have Freight Cost listed.

Cost-actual freight cost on Sales Order. If you select Cost, then you MUST have cost populated on each Sales Order Shipment:

ID750FreightCost.PNG

 

Variable X: Enter your Flat Rate (per shipment) with decimals OR your multiplier Flat Rate in decimals (i.e. if multiplier is 15%, then enter 1.15 or for 30% enter 1.30or Multiplier for freight charge. 

Variable 3: Misc Charge Code (not description) to use on Contract Charge (you will need to set this up or enter one you already have in eAuto)

 

 

ID750VarY.PNG

Variable Y: Consider Credited Fulfillment reversals, enter Include or Exclude.

Include = Freight Charge will be removed if order credited.

Exclude = Freight Charge will still be incurred even if order credited.

Variable Z: Order Type(s) to Include (separate multiple with comma)

Variable 4: Enter Contract Bill Code(s) to include (blank for all, separate multiple with comma)

Variable 1: Enter Ship Method(s) to exclude from this process (separate multiple with comma)

Variable W: Custom Property on Customer/Contract custom properties defer/charge/no charge (we will create this for you)

*  *  *

Alert Functionality

Alert Functionality

1. This process will NOT work if you bill base AND overage to the leasing company.

2. Looks at Sales Order Shipments where the Bill checkbox is not checked and the item is associated with a contract, it then adds the Misc Freight Charge to the contract. A supply order for staples that are chargeable & freight (not covered by a contract), will be excluded in this alert.

ID750d.PNG

3. If multiple freight charges incurred, only one line item will appear on invoice showing TOTAL of all charges.

4. Sample of Daily Summary email, showing contracts that had a charge added. Reports SO invoice# freight charge for reference. You will only receive daily summary IF there are qualifying orders (for both Test and Live mode)

**Note the indication of no charge assessed on line 2, is due to excluded ship methods listed in Variable 1 of your subscription.

ID750_Sample_Output.png

5. If you receive the summary and decide you want to override when a particular charge is assessed, this can be done by editing the charge line item and changing whether it bills with the base or overage or lease to override this global setting if needed. It will then bill accordingly with that contracts next invoice when pushed through the billing queue.

ID750c.PNG

6. We will set this process up in Test Mode first so you can review before actually assessing charges to your customers. When switching the alert from test to live mode, the alert only looks back one day for qualifying Sales Orders. When set to live, the alert will only add charges to ones that previously didn't trigger in test mode. We could wipe the event log clear and change the look back if you want to assess charges for the last the last couple weeks or the last month. We wouldn't want to look back further than a month though.

7. Creating Misc Charge Code - The Misc Charge Code in Variable3 must exist in eAuto. We will NOT set this up for you, you will need to create.

The process does not consider the Method, so you can leave as seen in screen shot below as we use your variable settings to determine method. If you check off both Base & Overage, then the charge will bill with the next most recent billing whether it be base or overage. Most clients set this to overage to avoid any problems if the base might bill to an alternate party i.e. Lease company.

ID750MiscCode.PNG

 

8. Once running live, the charge can be seen on Contract Record Miscellaneous tab:

**You can uncheck 'Show only current charges' to see charges already billed.

ID750a.PNG

Details of Sales Order created for each charge shows in the Notes:

ID750b.PNG

9. Using Custom Property - we will set up the Custom Property ZCJFreightChargesToContract for you with default of Charge. This Custom Property can be used to turn OFF this process on a specific Customer or Contract Record OR to defer to the settings on either the Contract or Customer Record.

Charge is to asses the Misc Charge for freight

No Charge is to NOT assess the Misc Charge for freight

Defer is used to push the alert to look at another level for the setting. So if you had defer set on the contract record then it would look to the customer record for the setting or vise versa. For example, you could set Customer Record to 'defer' to have the alert process look at Contract Record Customer Record setting. 

Contract Record:

1.png

Customer Record:

ID750CPCustomer.PNG

 

*  *  *

 

Best Practices & Tips

Best Practices & Tips

1. You must be following best practice of linking your supply orders to the contract. See this post for best practices.

Custom Property Set Up

Custom Property Set Up

Step 1: Create Attribute via Lists & Codes / Attributes / New:

Attribute Name: ZCJFreightChargesToContract

Description: Bill Freight Charges as Misc Charge on Contract

Data Type: User-Defined lookup

Lookup List: Charge

                     No Charge (must have space between words)

                     Defer

CP1.png

Step 2: Assign Attribute to BOTH Customer and Contract Configurations via Lists & Codes / Configurations (Custom Properties). Shown below is just Customer Properties, so be sure to also do for Contract Properties:

** Be sure to set default of Charge and select 'Quick Add' before selecting OK

CP2.png

CP3.png

 

 

*  *  *

Related Alerts

Related Alerts

ID216 - Send Order Confirmation for Sales Order Entry

ID200 - Send Supply Shipment Email with tracking Details to Customers

 

*  *  * 

 

 

 

 

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk