We have an issue on the offsetting account field in FAGLL03, the note 1034354 - FAGLL03: Display of offsetting account information has already been implemented but some values are incorrect.
The issue occurs when there are multiple line items which uses different accounts.
Sample: current logic will make account C as default offsetting account
Debit - Account A - value 100
Credit - Account X - value -100
Debit - Account B - value 200
Credit - Account X - value -200
Debit - Account C - value 300
Credit - Account X - value -300
In FAGLL03 - the offsetting account for account X is set to account C since based on note 1034354 it will use the account with the highest value.
So, currently we're trying correct this issue but we have encountered scenarios that makes it difficult to get the correct offsetting account.
1. Multiple line items with same amount but with different account numbers (tried using assignment and text field but it is blank)
Sample: if the value is the same as 100, the current logic will use the first account encountered - account A will be defaulted
Debit - Account A - value 100
Credit - Account X - value -100
Debit - Account B - value 100
Credit - Account X - value -100
Debit - Account C - value 100
Credit - Account X - value -100
2. Multiple line items that offsets to only 1 line item.
Sample: which account should be the offsetting account of X? currently the first account (A) will be defaulted as offsetting account just like in scenario 1.
Debit - Account A - value 100
Debit - Account B - value 100
Debit - Account C - value 100
Credit - Account X - value -300
Thanks in advance for those who will answer on my inquiry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.