Add ability to only include transactions from a Company Owned Carrier

Issue No: MFT-605
Created 7/13/2017 10:53:03 AM
Type Feature
Priority Major
Status Closed
Resolution Fixed
Fixed Version 17.3
Description A Ship Via can be setup to be a Company Owned Carrier. If so, it means the iRely user also owns/operates a Transportation business that carrier fuel. In other words, this iRely user may be required to file for a state's Transporter's Return. A Transporter Return may only be concerned with Sales Invoices and Transports Loads in which the filer (the iRely user) is the Ship Via.   This is where to setup Company Owned Carrier.   !pastedImage_d79119_0.png!   In a Transports Load, there is Ship Via, meaning who transported that fuel to the customer.   !pastedImage_d79119_1.png!   In MFT, when a RC is part of a Transporter's Return, it should only look at Transports Loads in which the Ship Via is the Company Owned Carrier.   Now, Mark should have already implemented this feature, and created a usp to handle this for Indiana's SF401 Transporter's Return's RCs (uspTFSF401InvoiceTax). However, I cannot locate this usp in the Source Database.   Here is what we need to do:   1. If we can locate this usp, then we should be abel to re-use most of its coding. If we cannot locate it, then we must start from scratch.   2. Either way, the usp cannot be specific to Indiana SF401. It should be generic like "uspTFGetInventoryTax" or "uspTFGetInvoiceTax", so it can be used by other Transporters Return's RCs. I suggest naming it "uspTFGetTransporterTransactions". Note this usp should filter in/out only Transport Loads, so it is not specific to either the Inbound or the Outbound side.