Hi
We have only just discovered at year end that the purchase accrual account has many differences - mainly price (receipt price v bill price) difference and exchange price! how do we clear all these differences in Dec22(our year end )?
This means that the stock received is at the wrong price(per Purchase order). It should be at the price per the purchase bill. We received the stock first at a date eg in May22 and we post the bill it in July22. since then many transactions have been posted for this item eg fulfilment of sales order. Our stocks are valued at average cost.
The steps that our team has carried out is in this order:
- receive the items at the wrong price(per PO),
- change the PO (reflect the correct price per bill) and
- then we post the bill. Unfortunately, this has no impact on the item received at the wrong price(as this step 1 happened before step 2: change the price of the PO!)
I gather the only way to clear the differences in the accrued purchase is to post the difference to the variance account for the affected items. Is this correct? this variance account we have to create is a cost of sales expense account?
However, in future what we really want is to change the price of the receipt to match the bill to ensure the stock item is picking up the correct price. Can we retrospectively change the price ie open the period when the item was received and change the price on the item receipt record? this I think relates to answerid 28092 Inventory Costing Recalculations? if we do this, I assume there is no variance to post as the stock received will be at the same price as the price per the purchase bill?
Also, for each item record, we have not set up the account codes for Exchange Rate Variances, Bill Quantity Variances, and Bill Price Variances fields. to set this up, we will use one variance account for all these 3 variances..
In answer id 11157 - Vendor Bill Variances, I would like to Posting Variances Based on Vendor Bill Lines. However, On the item record, I could not find the "Match Bill to Receipt" box to check. where is this box to check (see extract note below)? we don't really want to check the box against each item in the PO.
see attached one of our item record. also do i need to fill in 0 for the 6 tolerances boxes?
extract from answer id 11157 On an item record, check this box to make the Match Bill to Receipt box checked by default on transaction lines for this item. Then, purchase orders that include this item default to have this box checked and variances are generated based on vendor bill lines. This preference is disabled by default. Even when enabled, this option can be changed on individual purchase order lines.