Affiliate Field has Extra Space on Beginning Balance For Accounting Period 0

Hello,

Our users have identified an issue with the PS_LEDGER where there is an extra space on the affiliate field for some interunit transactions. We have checked the journal lines for these transactions and the journal lines do not have the extra space however when the year end close process is ran, the PS_LEDGER has an extra space for these transactions which makes it very difficult to balance using reports and/or queries. What would cause this extra space on the PS_LEDGER? This is an example of the SQL that we have identified some of the transactions on the