Forum Discussion

ChalkHill's avatar
ChalkHill
Experienced Cover User
4 years ago

Accountright Item Invoice not recording cost of goods for inventoried item

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

4 Replies

Replies have been turned off for this discussion
  • Hi ChalkHill 

    If you go back to those invoices, enter a dot on the memo and save, does it make any difference? Also, how were these invoices entered into the software? and did you manually update the job codes or was this done in a bulk update via the import/export functionality?

  • ChalkHill's avatar
    ChalkHill
    Experienced Cover User
    4 years ago

    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

  • ChalkHill's avatar
    ChalkHill
    Experienced Cover User
    4 years ago

    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...

  • Carolinadg's avatar
    Carolinadg
    Former Staff
    4 years ago

    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? )