ID318 - ITT Ship Out Revenue Allocations SSRS Report Overview & Sample:

SSRS report showing revenue allocations for ITT Ship Out equipment.

Jump to a specific section by clicking a link

Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts 

 

Click to Subscribe

Overview

Overview

To compare the contract revenue on ShipOut equipment against vendor invoices (servicing dealer) linked to the equipment. This report provides you with details on ITT (InterTerritorial) Revenue vs. Costs to help determine how your ITT business is doing. You can review at the Customer Level with drill down to the Equipment Level, as well as see from the AP Vendor Level. Additionally, seeing the revenue against the costs enables you to make any needed journal entries to the ITT Revenue Service sub-accounts.

This report looks at your coding in e-automate used to identify what equipment is considered ShipOut. Based on recommended Best Practices, we've provided the option of one of the four codes to identify on the Equipment Record:

• Condition Code
• Status Code
• Bill Code
• Territory Code

This SSRS Report will automatically look at your variables on ID945/ITT ShipIn ShipOut Dealers to auto-populate filters. If none are listed on ID945, then the report will use the codes you've listed on ID318 variables for auto-populating the filters on SSRS.

This information can also be viewed using the ID771 Power BI Profit and MIF Analysis report. See notes on how to get this information from the report here.

 

Run Schedule: On-Demand

Type of Output: On-Demand SSRS Report

 

*  *  *

Sample

Sample

Page 1 - - Grouped alphabetically by Customer Name to review revenue billed for ITT. 

Page 2 - Grouped alphabetically by Customer Name to review Vendor AP Invoices Linked to Contracts.

Expand to show Page 2 details

**This table contains all vendor invoices grouped by your customer for the reporting GLPeriods, regardless of whether or not a matching customer invoice for the GLPeriod was created. There may or may not be matching customer invoices for every AP vendor invoice due to mismatched billing cycles between your contract and the vendor's contract billing cycle.

 

Shows Customer Name, Contract Number, AP ITT Vendor, Voucher Details:

Page 3 - Grouped alphabetically by ITT Vendor Name 

Expand to show Page 3 details

**This table contains all vendor invoices grouped by Vendor for the reporting GLPeriods, regardless of whether or not a matching customer invoice for the GLPeriod was created. There may or may not be matching customer invoices for every AP vendor invoice due to mismatched billing cycles between your contract and the vendor's contract billing cycle

Shows Vendor Name, Number, if linked via Custom Property  

*  *  *

Variables

Variables

Variable 1: Condition Code(s) - If you use equipment condition codes to identify equipment shipped out of territory, enter the condition code here. Separate multiple codes with commas.

Variable 2: Status(s) - If you use the equipment status to identify equipment shipped out of territory, indicate the status used in this variable. Separate multiple statuses with commas.

Variable 3: Bill Code(s) - If you use a unique bill code on the equipment record to identify equipment shipped out of territory, list the bill codes used here. Separate multiple bill codes with commas.

Variable 4: Territory(s) - If you use a unique territory on equipment to identify equipment shipped out of territory, enter the territory names here.

Variable 7: Vendor Custom Property - Name of the custom property assigned to the vendor record that links back to the customer record for the ITT dealer.

Variable W: ShipOut Territory(s) begin with - If you have a large number of territories to indicate equipment shipped out of territory and the territories all begin with the same character string, enter that here.

Variable 8: Dealer Customer Types - Enter the name of the customer types used in e-automate to indicate the customer record belongs to a dealer.

Variable 9: Custom Property - Vendor Type - If using a custom property on the vendor record to indicate the vendor is a dealer, enter the name of that custom property here.

 

*  *  *

 

Alert Functionality

Alert Functionality

1. This alert allows for four different ways to track equipment that is a ship-out to a servicing dealer.

   1. Status - If the status is used to designate ship-out equipment, enter the statuses in Variable 2.

   2. Condition - If the condition on the equipment record is used to indicate ship-out equipment, enter the conditions used in Variable 1.

   3. Territory - If the territory indicates the equipment is a ship-out, enter the territory names in Variable 4.

   4. Bill code - If the bill code is used to indicate the equipment is a ship-out, enter the bill codes used in Variable 3.

Indicates if Vendor Record linked per Configurations:

Sample Vendor Record Configured:

 

*  *  *

 

OnDemand Report Filters

OnDemand Report Filters

You need to manually fill in From and Thru GL Period (no drop-down available), format is YYYYMM (i.e. 201801)

*  *  *

 

Best Practices & Tips

Best Practices & Tips

AP Invoices for ITT to be linked to Contract Number and drilled down to Equipment Level distribution (sample here shows WHERE this is done in AP Invoice):

Custom Property Set Up

Custom Property Set Up

Variable7 Custom Attribute Set Up:

For Vendor Record to link a vendor to the corresponding customer setup for the dealer, if you have a two way relationship where you and the other dealer are both servicing equipment for each other.

We suggest that you create a custom property (an attribute that has a datatype of 'Lookup' and for the 'Lookup type:'  and from the the drop down...select 'Customers (Number)'...and the lookuptype will be stored as  'AR_CUSTOMER_NUMBER' ) .  You would assign this attribute to your Configuration  (custom properties) that is associated to the Vendor table.

This is the only way we can truly determine that a dealer you are servicing equipment for (typically setup as customers for you to bill the dealer) may also be servicing equipment for you (where they are a vendor).  

Of course, you might be shipping equipment out to a dealership who does not have any equipment shipped in for you to service, but the missing 'link' helps us identify to you who you are spending money with and they might not be sending you business.

*  *  *

Related Alerts

Related Alerts

ID771 - Profit & MIF Analysis (Power BI)

ID945 - Tracking Ship Out and Ship In Dealer Relationship

 

 

*  *  *