Description |
When an Invoice has a Source of Tank Delivery, there is no Ship Via data (Ship Via = Carrier = Transporter). However these Invoices may need to be reported for MFT purposes with Carrier information.
!pastedImage_d101574_0.png!
So we will do:
# When Invoice Source = Tank Delivery AND Ship Via is blank, find the Company Owned Carrier, and populate tblTFTransaction's Transporter related fieilds with this Company Owned Carrier's info.
# If there is more than one Company Owned Carrier, use the first one's info. First = sorted by Id.
# Do this in all SPs where Invoices are reported.
!pastedImage_d101574_1.png!
|