Great callout. Let's get you to the finish line. First, you did the right thing by checking your mapping. You may have noticed that your products didn't map to anything. that's because your product list probably isn't loaded yet. You'll need to do that first before you can load the transactional data.
My time range matches the below. The DAT03 module export matches the requirements for 126.96.36.199.
When I apply the filter it shows the summary month columns as blank (this is the saved view which matches the requirement) if I switch off then reapply the filter the summary month column disappears. When I rerun the import action I still get the same error.
Well, we're a lot closer but we need to get the file to load with no errors. Some suggestions:
Make sure your calendar looks like this one
Add a Boolean Line item to SYS01 called Week? and set it to TRUE. Use this in your saved view filter to take out the months, quarters, halfs, and years.
I suspect you have aggregate time periods, like quarter and year showing up and not indicated in your calendar.
Your import action looks good so we just need to figure out what's causing the error. If you continue to get errors, go to the details section and scroll to the right to see what the specific error is.
Ah i think you have zeroed in on the source of the problem.
My calender settings in both models match the below.
So I have checked SYS01 has a Weeks Only line item - I think this is ok.
When I apply this as a time filter in the DAT03 module - I just get blanks - This is where I played with filter settings until I was able to match the requirement view rather than landing on the right solution.