Hello again Romryan
There is something which I don't clearly understand about your situation, why is your client filling the AA analysis details on the prepaid-expenses account then refiling again on the expense account !
I believe the process of prepaid expenses is supposed to go as follows:
An invoice is posted with the total amount of the prepaid expense (let's say Rent), which could be automated with the expense and deferral module. Once used, the same invoice will create a number of journal entries to close the total of the prepaid amount in the associated expense. Analytical accounting analysis are usually filled on the expense account level, such as expense allocation, type ..etc.
Lets consider a simple example, you are recording an invoice for a whole year rent, a total of $ 12000
I will suppose that you are using the revenue and expense deferral module to automate this process, so once creating the invoice, the following journal entries are to be posted:
Account Dr Cr
Prepaid Expense 12000 0
Accounts Payable 0 12000
According to the deferral configuration, I would suppose that a 12 journal entries will be created, to allocate the expense throughout the 12 periods.
Date 1/1 (for instance)
Account Dr Cr
Rent Expense 1000 0 >> AA is to be associated, right ?
Prepaid Expense 0 12000
I would suppose that the analytical details are to be associated with the expense account, which is the rent account in this case, right ?
If you are to follow this process, please be aware that AA integration with Revenue and Expense Deferral is limited, and you may have to consider one of three manual options illustrated in knowledge base Article ID: 3006081
These options are "as derived from support article above"
"
Option 1 - Post the deferral in GL. Then click on Transactions, point to Financial, point to Analytical Accounting, and click on Edit Analysis. Select the Journal Entry of the deferral and proceed to add/edit the AA data.
Option 2 - Stop the batch in GL and add the AA codes to the transactions in the GL work batch.
Option 3 - Enter default AA codes in the Trx Dimension Code Default fields on the Accounting Class, and these codes will get automatically assigned to the deferral entries. However, you would still have to use one of the other options if you want to change any of the codes.
"
Your feedback is highly appreciated,