Dear experts,
I need to map in Liquidity Planner GL accounts managed with open items.
The idea is that it may happen that, for any reason, an invoice may have been posted as "Vendor @ BS account".
If the BS account is managed as OI, that account may later be cleared against another account. Let's say we have "BS account @ P&L account".
Also, I wanto to assign the account to 2 different LIs, based on the vendor's reconciliation account (eg. "water from 3rd party vendor" OR "water from intercompany vendor").
No problem with P&L accounts: I added them to FLQINFACC against a generic LI "WATER" (in case the query don't work) and I created 2 query for each LI (if the account is WATER and the buffer item is INTRA_VENDOR, then use LI INTRA_WATER; if the account is WATER and the buffer item is EXTRA_VENDOR, then use LI EXTRA_WATER).
However, I couldn't do something similar with OI managed BS accounts.
My objective is to get to:
1. the LIs assigned to the BS account, if it has not been cleared
2. the LIs assigned to the the P&L account, if the BS account has been cleared.
I tried as follows:
1. Add the BS account to FLQINFACC
2. Create 2 query, so that if the BS account is not cleared, it is assigned to the INTRA_WATER or EXTRA_WATER, based on the buffer item
However, this doesn't work: if I set the Further flag in FLQINFACC, then it works for cleared BS accounts (it dives to the P&L account). If I don't set the Further flag, it only works for non-cleared BS items (and I get the INTRA or EXTRA_WATER LI).
I also tried to create a third query (if the BS account is cleared, it should be assigned to a new buffer item, eg. CLEARED_OI_BS), and added the new buffer in FLQAF, but it still doesn't work.
What is wrong, I don't get it: is it that you cannot have both a Further and a Query on the same account?
Any help would be much appreciated!
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.