Wrong Unit Cost on ROG

Hello everyone,

I am trying to process the ROI for a PO and I keep getting a variance saying the unit cost is off. It is showing the ROG unit cost as higher than what was invoiced. When I go into the PO the price has been changed to match the invoice but I am assuming the incorrect cost is already recorded on the ROG which is why it keeps giving us the variance warning when we try to process the ROI. How can we fix this?

Christina

Parents
  • Working as designed.

    When you post a RoG with no invoice, inventory value is increased with an equivalent posting to the Purchase Clearing GL account.  When you later post the RoI, that exact RoG amount has to be removed from the Purchases Clearing account... so when there is a mismatch between RoI and RoG, a variance is posted (so AP, PC and variance amount all together balance the posting). 

    You can't retroactively correct the RoG cost during RoI... Sage 100 is not designed to allow it... and technically that inventory may already be gone (inventory amount translated into COGS).

  • in reply to Kevin M

    Thank you for your response. None of the inventory that was received had been sold yet thankfully. We ended up having to do a return of goods then go in and correct the unit cost, bring it back in and do a new ROG and then the ROI was completed. 

Reply Children
No Data