Create an advance for 5% on Jan 1st. This advance is $10,000 CAD or 5%. The date and currency data are both Jan 1st.
Create a bill for 100% of the forward on Feb 1st. The Bill is for $200,0000 USD with a date of Feb 1st and a currency date of Jan 1st. The account this is posted to can be a custom currency forward account that is set up to be a bank in system five. Note: this currency forward account should have a selected currency of USD.
System Five will ask you if you want to apply the advance as you create the $200,000 USD bill. Please apply the advance.
If you need to add this after the fact, please manually add the GL code for advances to the bill, and put the amount on the invoice at a negative amount. In this case -$10,000 USD. The currency date of this line should be Jan 1st.
Now you pay off the bill on Feb 1st for the remaining balance of $190,000 USD or 95%. The Date of the Cheque is Feb 1st, the currency date of the line on the cheque is Jan 1st.
The currency forward supplier now has a balance of $0 and all exchange gain/loss entries are correct.
Create a $200,000 USD or 100% advance for the inventory supplier. Advance date is Feb 1st and currency date is Jan 1st.
Please select the USD currency forward account you previously created when creating the advance.
When you create the bill and apply the advance make sure that you set the currency date of the advance line to be Jan 1st.