In this series, we answer real-life questions from Acumatica users.
QUESTION: I have a variance in my PO accrual report. How do I correct it?
ANSWER: If you have a report in which there is an accrual account difference, the cause may be multiple Reversals of AP Bills. If this is the case, here is how to resolve it:
First, if you perform a Reverse Action in an AP Bill created from a PO Receipt, as shown below:
Please note that the system provides a warning:
If you continue, all links to the PO Receipt are carried over to the Debit Adjustment (highlighted below):
Unfortunately, there is no restriction to the number of times the AP Bill Reversal Action can be performed, allowing, in this example, creation of a second Debit Adjustment tied to the same PO Receipt:
When the Debit Adjustments are released, the result is double Unbilled Quantities and Unbilled Amounts in the Purchase Receipt Accrual Details report:
It is not apparent how to correct this error. You can do so by creating a new AP Bill against the PO Receipt:
The system will take all documents associated with the Receipt into account and create a net Bill, i.e., double the Quantities and Amounts, as shown in this example:
Once the Bill has been released, the PO Receipt has been cleared from the report: