Accountright Item Invoice not recording cost of goods for inventoried item

Question

we have recently made changes to job codes and reallocated some sales invoices to new codes. Since doing this the affected invoices are not calculating and recording the cost of goods for the inventoried item. Can anyone assist? thank you

Carolinadg · Answer

Hey @ChalkHill

Is it only for invoices with this item? is it only happening when you apply or update the job code against the already saved invoice?

How were these sales entered in ARL ? ( Eg: Manually, imported, third party integrated? )

ChalkHill · Answer

Can anyone assist with this?? I have tried deleting the invoices and re entering but still ended up with no COGS recording for the sale. When the invoice was deleted the COGS did not return to the inventory account. So basically I ended up with an item showing 33000+ units with no value, which makes sense. Also tried to delete the original inventory journal that recorded the purchase ( I did this in a back up file) but was unable to receiving the response that it would create a value less than 0.  Since attempting this everytime I try to open the back up file myob crashes...

ChalkHill · Answer

Hi @Carolinadg , thanks for your response. I have tried inserting the dot but this made no difference. I adjusted the job codes on the invoices manually and then saved. I read on a forum that if the stock is all sold (which it was) when you resave and the value is 0  MYOB calculates using the COG at the date you save and not the date of the invoice. To try and counter this, I deleted the invoice and re entered but the problem still persists. While I understand that MYOB calculates using the most recent COGS surely if you delete an invoice it also reverses the COGS entry?! Any advice or assistance you can offer to resolve this issue would be greatly appreciated.

Regards

Julie