NM - Combined Fuel Report's E file (Excel file) has no data on a Worksheet

Issue No: MFT-1408
Created 3/4/2019 11:42:50 AM
Type Bug-QC
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3, 19.1
Description *Steps to Reproduce:* Step 1: Make sure to have at least 1 TR Transaction to be filtered in the Tax Forms   Step 2: Go to Motor Fuel Tax Form > Tax Authority > NM   Step 3: Check all schedules under Form 41306 and the Excel Export   Step 4: Click Run > Custom Date Range (Desired Date)   Step 5: Verify Data will be shown for each schedule that have successfully fulfilled the conditions to show the result   Step 6: Go to tab of Form 41306 - Excel Export and automatically Generate Excel Report   *Issue:* Locations Sheet in the Excel Report have null values   *Accepted:*   Locations Sheet should not be blank     On this page [http://inet.irelyserver.com/display/MFT/NM+Special+Requirements] , there are specs for the Combined Fuel Report's E File (which is an Excel file). This Excel file has two Worksheets, the second one is named "Locations" which is based on Uncommon fields and special requirements.   Issue: in the grid preview, Schedule A has records, but Excel > Locations Worksheet is empty. See comments for more info.   !pastedImage_d113207_0.png|height=268,width=578!   !pastedImage_d113207_1.png|height=420,width=1134!