How to trouble-shoot missing AAI error when doing retainage release in Contracted PO Vouchering

Hi, looking into debug log has been real headache but it would be useful when you know the right way of debugging the error :

For example, why it resulted in this misssing AAI error when doing  retainage release for the vouchered contract PO..

In the log there, it did state that

SELECT * FROM JDE_CRP.CRPDTA.F0012 WHERE ( KGITEM = 'PTVATD' AND KGCO = '00000' )
No More Data found ; could not load this item in F0012 AAI table
OUT->[ 1] <Item>: szItemNumber <type>: STRING <Value>: [PTVATD]
Return value is 2 for ValidateAAICompletely. (BSFNLevel = 2) ; validate AAI BSFN failed

whereas the PCVATP it did have the AAI item in the F0012

SELECT * FROM JDE_CRP.CRPDTA.F0012 WHERE ( KGITEM = 'PCVATP' AND KGCO = '00020' )
Fetched the record ; found the item in F0012
OUT->[ 1] <Item>: szItemNumber <type>: STRING <Value>: [PCVATP]
Return value is 0 for ValidateAAICompletely. (BSFNLevel = 2)


with these statement, PCVATP already in the F0012 table..it did not trigger AAI error except the PTVATD

So, you just need to create a PTVATD item into AAI , Ensure that the debit and credit account for Financial AAI PTVATD and PCVATP are set up correctly and NOT pointing to the same account.

According to Oracle :

If P4314 Version has the processing option for Retainage # 2 set to a 1 = Apply taxes to retainage when retainage is released, the tax explanation code is C or V, then the AAIs PTVATD and PCVATP are invoked.

When you match with deferred VAT Taxes, it should credit PCVATP and debit PTVATD
PCVATP = negative and PTVATD = positive
And when you release retaianges, it is the other way around
PCVATP = positive and PTVATD = positive

Hope that helps...