| By | Date | Customer
Can View | | Note Status? | Response | Assigned To | Priority | Status | |
|
Nathan Palmer
|
2/13/2024 8:10:53 PM
|
NO
|
|
|
Merged to 12/14.
|
Brian Cronin
|
High
|
Ready For Install
|
|
|
Nathan Palmer
|
2/13/2024 7:27:47 PM
|
NO
|
|
|
|
David Wilken
|
High
|
Ready For Testing
|
|
|
David Wilken
|
2/13/2024 9:24:24 AM
|
NO
|
|
|
Changeset 71574
AirTrak/Main/International/Docs.aspx.vb
AirTrak/Main/International/Docs_New.aspx.vb
changes: bugfix for housebill with single carrier label
|
Nathan Palmer
|
High
|
Merge to 79/162
|
|
|
Nathan Palmer
|
2/12/2024 6:53:17 PM
|
NO
|
|
|
|
David Wilken
|
High
|
Ready For Testing
|
|
|
David Wilken
|
2/12/2024 4:06:48 PM
|
NO
|
|
|
Changeset 71565
AirTrakDataAccess/DataAccess.vb
AirTrakDataAccess/VendorExpansion.vb
changes: move GetVendorPrefix() function from DataAccess.vb to VendorExpansion.vb
|
Nathan Palmer
|
High
|
Merge to 79/162
|
|
|
David Wilken
|
2/12/2024 2:33:58 PM
|
NO
|
|
|
Changeset 71563
AirTrakDataAccess/DataAccess.vb
changes: select vendor prefix based on expansion code
|
Nathan Palmer
|
High
|
Merge to 79/162
|
|
|
Brian Cronin
|
2/12/2024 2:00:05 PM
|
NO
|
|
|
Dave,
Thanks for the info. Yes…that is what you should do. Note: base on a control flag (I can’t remember which one), we would need to go to these tables instead (note the word “updates” as the end of them – if you look at the code, you should be able to easily find the control flag):
tbl_LinehaulCarrierVendorsUpdates
tbl_AirCarrierVendorsUpdates
tbl_LTLCarrierVendorsUpdates
|
David Wilken
|
High
|
Re-Work
|
|
|
David Wilken
|
2/12/2024 12:13:07 PM
|
NO
|
|
|
Brian,
Currently the vendor prefix is chosen via UNION of tbl_AirCarrierVendors and tbl_LinehaulCarrierVendors. The quick and dirty fix is to add tbl_LTLCarrierVendors to this UNION.
I'm not confident that this is a very good solution. The vendor prefix query we have currently doesn't take VendorExpansion into account. This becomes a problem in our test database because we already have a lot of vendors with records in both tbl_AirCarrierVendors and tbl_LinehaulCarrierVendors. For instance, vendor '1ST -MCI' is in all three vendor expansion tables (see below). If I simply add tbl_LTLCarrierVendors to the UNION, it will most likely still return one of the other vendor prefixes.
1. Should I add VendorExpansion to the query?
2. If #1 is yes. Would this be the algorithm?
VendorExpansion in ('AALTL') -> use tbl_LinehaulCarrierVendors
VendorExpansion in ('AIR') -> use tbl_AirCarrierVendors
VendorExpansion in ('LTLCA') -> use tbl_LTLCarrierVendors
select b1.VendorId, 'tbl_LinehaulCarrierVendors' as Table1, a1.VendorPrefix as VendorPrefix from tbl_LinehaulCarrierVendors a1
inner join tbl_vendors b1 on b1.PK_VendorNo = a1.FK_VendorNo where b1.VendorID = '1ST -MCI'
union
select b2.VendorId, 'tbl_AirCarrierVendors' as Table1, a2.AirCarrierPrefix as VendorPrefix from tbl_AirCarrierVendors a2
inner join tbl_vendors b2 on b2.PK_VendorNo = a2.FK_VendorNo where b2.VendorID = '1ST -MCI'
union
select b3.VendorId, 'tbl_LTLCarrierVendors' as Table1, a3.VendorPrefix as VendorPrefix from tbl_LTLCarrierVendors a3
inner join tbl_vendors b3 on b3.PK_VendorNo = a3.FK_VendorNo where b3.VendorID = '1ST -MCI'
order by VendorPrefix
VendorId Table1 VendorPrefix
-------- ------ ------------
1ST -MCI tbl_LinehaulCarrierVendors
1ST -MCI tbl_AirCarrierVendors 000
1ST -MCI tbl_LTLCarrierVendors pll
|
Brian Cronin
|
High
|
Questions
|
|
|
Brian Cronin
|
2/10/2024 2:47:27 PM
|
NO
|
|
|
Dave - they found 1 more issue with this. Please review and bill your time to the original task.
If you generate this label from a LH carrier line, it will include the 'Inbound/Outbound Report - Vendor Prefix' in the number below the barcode - I think it includes it in the barcode too, but please check.
We need to include that prefix - if filled out - when they generate it from an LTL line as well. That field exists for the LTL additional info page as well.
|
David Wilken
|
High
|
Priority
|
|
|
Nathan Palmer
|
1/15/2024 6:19:35 PM
|
NO
|
|
|
|
Brian Cronin
|
High
|
Ready For Install
|
|
|
David Wilken
|
1/15/2024 12:47:47 PM
|
NO
|
|
|
Changeset 71220 (12/14 build)
AirTrak/Main/Reports/ForwardAirLabelAR.aspx.vb
changes: add null check to ConsolNo
|
Nathan Palmer
|
High
|
Branch - 12/14
|
|
|
Nick Schubert
|
1/15/2024 12:14:45 PM
|
NO
|
|
|
Dave - The button now shows on MiscCosts.aspx but anything you try to view the label, it gives you the error below. It works fine everywhere else.
Server Error in '/WorldTrak' Application.
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[FormatException: Input string was not in a correct format.]
Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +224
Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value, NumberFormatInfo NumberFormat) +83
[InvalidCastException: Conversion from string "" to type 'Double' is not valid.]
Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value, NumberFormatInfo NumberFormat) +207
Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value) +12
AirTrak.ForwardAirLabelAR.Page_Load(Object sender, EventArgs e) +3134
System.Web.UI.Control.OnLoad(EventArgs e) +97
System.Web.UI.Control.LoadRecursive() +61
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4676.0
|
David Wilken
|
High
|
Re-Work
|
|
|
Nathan Palmer
|
1/12/2024 5:08:55 PM
|
NO
|
|
|
Found some missing code, added and rebuilt.
|
Brian Cronin
|
High
|
Ready For Install
|
|
|
Nick Schubert
|
1/12/2024 2:07:05 PM
|
NO
|
|
|
|
Nathan Palmer
|
High
|
Branch - 12/14
|
|
|
David Wilken
|
1/12/2024 1:43:55 PM
|
NO
|
|
|
Nick - odd 12/14 merge issue with MiscCosts.aspx.vb. The button did get added the page, but the VB code that makes it visible is missing. However, I do see checkin comments for MiscCosts.aspx.vb, so it appears that it should be there.
Nate - See attached 'MiscCosts_1214_merge_question'. I don't see any changes between the last two versions of this file. I do notice that the newest change is in a 'merge' status instead of 'merge,edit'. I do see 26893 code changes in the other associated files (aspx, designer.aspx), and those files are in a 'merge,edit' status. Do we need to manually add the code into this file?
|
Nathan Palmer
|
High
|
Questions
|
|
|
Nick Schubert
|
1/12/2024 12:11:01 PM
|
NO
|
|
|
Dave - HAWB 5009732 on Omni Stage A. I can print/email the Carrier Label via the LTLBOL page and the Documents page, but I don't see the Carrier Label button on the MiscCost.aspx page. Can you please review?
|
David Wilken
|
High
|
Questions
|
|
|
Nathan Palmer
|
1/11/2024 7:35:51 PM
|
NO
|
|
|
|
Brian Cronin
|
High
|
Ready For Install
|
|
|
Nick Schubert
|
1/11/2024 1:09:47 PM
|
NO
|
|
|
Email looks good on 162.
|
Nathan Palmer
|
High
|
Branch - 12/14
|
|
|
Brian Cronin
|
1/11/2024 12:58:21 PM
|
NO
|
|
|
|
Nick Schubert
|
High
|
Ready For Testing
|
|
|
David Wilken
|
1/11/2024 12:33:45 PM
|
NO
|
|
|
tested successfully on 162 (hawb 15110)
|
Brian Cronin
|
High
|
Ready For Testing
|
|
|
Nathan Palmer
|
1/10/2024 6:01:13 PM
|
NO
|
|
|
|
David Wilken
|
High
|
Ready For Testing
|
|
|
David Wilken
|
1/10/2024 4:18:07 PM
|
NO
|
|
|
Changeset 71168
AirTrakDataAccess/DataAccess.vb
changes: add 'AIR' expansion code to GetCarrierLabelByOrderNo query
|
Nathan Palmer
|
High
|
Merge to 79/162
|
|
|
David Wilken
|
1/10/2024 3:08:38 PM
|
NO
|
|
|
Changeset 71166
AirTrak/Main/International/Docs.aspx
AirTrak/Main/International/Docs.aspx.vb
AirTrak/Main/International/Docs_New.aspx
AirTrak/Main/International/Docs_New.aspx.vb
AirTrak/Main/International/EmailDoc.aspx
AirTrak/Main/International/EmailDoc.aspx.vb
AirTrakDataAccess/DataAccess.vb
|
Nathan Palmer
|
High
|
Merge to 79/162
|
|
|
Brian Cronin
|
1/9/2024 4:09:06 PM
|
NO
|
|
|
Dave - Let's discuss this again tomorrow morning on a Zoom. I want to make sure I answer you question correctly. Hit me up first thing before my calls start.
|
David Wilken
|
High
|
Questions
|
|
|
David Wilken
|
1/9/2024 2:04:27 PM
|
NO
|
|
|
Brian - The 'Carrier Label' report selections on both the Documents and EmailDoc pages already have a sub-selection grid associated with them, associated by air carrier costs. We don't see it with test HAWB 15110 because there's one and only one MAWB on it. If a housebill has multiple air carrier costs (ex HAWB 13376) then the sub-selection will show.
See attachment '26893 questions 20240109.docx'
Should this sub-selection grid be replaced by one that associates data by expansion code (such as AALHL, AIR, LTLCA) instead of air carrier costs?
|
Brian Cronin
|
High
|
Questions
|
|
|
Brian Cronin
|
1/8/2024 3:31:41 PM
|
NO
|
|
|
Dave - per our conversation: You know what to do now.
|
David Wilken
|
High
|
In progress
|
|
|
David Wilken
|
1/3/2024 12:46:51 PM
|
NO
|
|
|
Brian - I'm not sure I understand here. When I click Email from the documents page, I see carrier label (see email_carrier_label.png).
Are you talking about when we email from the CarrierAlert.aspx page? From here I don't see the Carrier Label checkbox. Do you mean to enable it when emailing from the CarrierAlert.aspx?
|
Brian Cronin
|
High
|
Questions
|
|
|
Brian Cronin
|
1/2/2024 9:05:05 PM
|
NO
|
|
|
Dave - Everything you have done so far works, but there is no option to email the label. When the carrier label is generated for a LH vendor, you can email it by accessing the eamil docs page.
We need to be able email the label when an LTL Carrier is on the shipment too.
|
David Wilken
|
High
|
Re-Work
|
|
|
Brian Cronin
|
1/2/2024 3:26:02 PM
|
NO
|
|
|
This looks good, but I see an issue if they want to email it. On the example below, it will only email the LH line item. If there is no LH line item, I most likely won't be able to email it at all.
Question into Bob.
|
Brian Cronin
|
High
|
Waiting on Feedback
|
|
|
Nick Schubert
|
12/19/2023 1:28:37 AM
|
NO
|
|
|
Brian - Looks good to me. Passing to you for final test.
I tested with HAWB 15110.
|
Brian Cronin
|
High
|
Ready For Testing
|
|
|
Nathan Palmer
|
12/18/2023 6:36:29 PM
|
NO
|
|
|
|
David Wilken
|
High
|
Ready For Testing
|
|
|
David Wilken
|
12/18/2023 4:21:13 PM
|
NO
|
|
|
Changeset 70994
AirTrak/Main/International/MiscCost.aspx
AirTrak/Main/International/MiscCost.aspx.designer.vb
AirTrak/Main/International/MiscCost.aspx.vb
AirTrak/Main/Operations/CarrierAlert.aspx
AirTrak/Main/Operations/CarrierAlert.aspx.designer.vb
AirTrak/Main/Operations/CarrierAlert.aspx.vb
|
Nathan Palmer
|
High
|
Merge to 79/162
|
|
|
Nick Schubert
|
12/18/2023 2:13:38 PM
|
NO
|
|
|
Dave - See below.
1. Just show the Ref # you have circled in your screenshot from #2 in the MAWB field on the label.
2. Yes. Take a look at how the carrier label is generated for the LH Vendor I added on HAWB 15110. You are going to generate the exact same way, but we are just using the Ref # field instead of the MAWB field like we do with LH.
|
David Wilken
|
High
|
Questions
|
|
|
David Wilken
|
12/18/2023 1:48:42 PM
|
NO
|
|
|
Nick - couple of questions (see 26893 attachment)
1. There's a MAWB field on the carrier label. Is this still valid for LTL carriers, or should it be hidden?
2. Is the barcode supposed to be generated from the circled ref #? I'm using HAWB 15110 for an example, and it generates 3 labels (probably one per dim line item)
|
Nick Schubert
|
High
|
Questions
|
|
|
Nick Schubert
|
12/6/2023 12:40:53 PM
|
NO
|
|
|
Good to move forward with this one now.
|
David Wilken
|
High
|
Open
|
|
|
Nick Schubert
|
12/6/2023 11:49:47 AM
|
NO
|
|
|
Dave - Please hold on this for now. We are still waiting on approval before we move forward.
|
David Wilken
|
High
|
On hold
|
|