To compare the contract revenue on ShipOut equipment against vendor invoices (servicing dealer) linked to the equipment. This report provides you details on ITT (InterTerritorial) Revenue vs. Costs to help determine how your ITT business is doing. You can review at Customer Level with drill down to Equipment Level, as well as see from AP Vendor Level. Additionally, seeing the revenue against the costs, enables you to make any needed journal entries to ITT Revenue Service sub accounts.
This report looks to your coding in eAuto used to identify what equipment is considered ShipOut. Based on recommended Best Practices, we've provided option of one of the four codes to identify on 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 listed on ID945, then report will use codes you've listed on ID318 variables for auto populating the filters on SSRS.
Of special note:
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.
SSRS Report Filters:
Currently you need to manually fill in From and Thru GL Period (no drop down available), format is YYYYMM (i.e. 201801)
Page 1 - - Grouped alphabetically by Customer Name to review revenue billed for ITT.
**The vendor costs listed here is for reference purposes and only include vendor invoices where customer invoice for the same contract were in the same GL Period. Please see page 2 to see Total vendor costs linked to contracts for the reporting period
Shows Customer Name, Contract Invoice #, Contract #, Equipment Detail, GL Period:
Shows Revenue Billed, BW & CLR clicks as well as dollar amount for matching GL Period AP Vendor Invoices:
Reference totals at bottom to determine need for Journal Entry to ITT Revenue Service:
ITT Revenue Billed vs. Matching Vendor AP Invoices
Page 2 - Grouped alphabetically by Customer Name to review Vendor AP Invoices Linked to Contracts.
**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 mis-matched billing cycles between your contract and the vendor's contract billing cycle.
Shows Customer Name, Contract Number, AP ITT Vendor, Voucher Details:
Best Practice suggested: 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):
Page 3 - Grouped alphabetically by ITT Vendor Name
**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 mis-matched billing cycles between your contract and the vendor's contract billing cycle
Shows Vendor Name, Number, if linked via Custom Property
Indicates if Vendor Record linked per Configurations:
Sample Vendor Record Configured: