I’ve spotted what appears to be a bad account configuration but am having trouble determing the fix.
A PO is created for purchase of parts. These parts are used to build our end product. The parts are inventory items that are not sold and have a class code of Common Components. The PO is released, received and a voucher created to pay the invoice. After the voucher is posted the Accounting->Accounts Payable->Reports->Voucher Register shows the voucher listed twice. The line with the Debit amount shows the account as Purchase Price Variance but it should be Materials Cost according to our accountant. The other line in the report for this voucher showing the Credit amount has the account as A/P Trade which I think is correct.
Where in the configuration of xTuple (v4.11.3) is the setting that defines the Debit account used by a voucher?
Configuration elements I have found include:
-
Payable Assignments has one entry with Vendor Type: All, A/P Account is assigned to “A/P Trade” account number, Prepaid Account to PREPAID account number and Discount Account to Returns & Allowances account number.
-
We have two Cost Categories:
FG: Finished Goods
Materials: Materials - Main Stock
The Materials cost category does show the Purchase Price Variance account being assigned to our Purchase Price Variance account number but I don’t see how that account number ends up showing in the Voucher Register as the Debit account.
Tips or suggestions are appreciated. I’ve read the Reference Manual section for account setup but have no background in accounting so could be missing something obvious.