Net Activity is not getting updated for Bank Statements in Functional Currency

Summary:

Net Activity is not getting updated for Bank Statements in Functional Currency

Content (please ensure you mask any confidential information):

Hello, we have B2B for Bank Statements and GL where we have built 2 interfaces with the same location but one with Entered Currency and other with Functional Currency.

Every month we continually face to see the Bank Statement column for the Functional Currency (EUR) not updated correctly due to Unexplained Differences.

This is due to the Net Activity missing data.

We fixed this for the previous period by importing data in Merge Mode but how could we have a permanent fix for this in future periods?