Known issue in AccountRight 2022.1

We've identified that in certain situations, some sales will not show a Cost of Goods Sold (COGS) component.

This will be fixed in a future release, but until then there's a workaround below.

This issue only happens when:

1. You've entered initial quantity on hand for an item into AccountRight as an inventory adjustment. This means you didn't enter the initial quantity via an item purchase, which also means:

   • the average cost is $0

   • the last purchase price is $0

   • the standard cost is $0

2. You then fully sold the item, bringing the on hand quantity back to 0.
3. You then edited and re-recorded the sale, which overrode the actual COGS for that sale and replaced it with 0.

How do I know if I'm affected by this?

If you've performed the above steps, you'll notice:

• when recapping an edited sale, there are no lines for COGS

• incorrect reporting on inventory margins, for example in the Analyse Sales (Item) report

• an incorrect Cost Of Sales in the Profit & Loss report.

Workaround

To fix this issue, create an inventory adjustment to reinstate the correct COGS for the item. Then, edit and re-record the sale to correct the COGS. Finally, delete the inventory adjustment.

Repeat these steps for every item and sale affected by this issue.

1. Enter an inventory adjustment for the item to add one item into stock with the correct unit cost. The unit cost will be the items average cost (Inventory > Adjust Inventory).
   
2. Open and make a minor change to the sale, such as the Memo, and re-record the sale. This will recalculate the COGS correctly, as it will use the unit cost you specified in the inventory adjustment.
   

3. Delete the inventory adjustment you created in step 1 (Inventory > Items Register > click the zoom arrow to open the adjustment > Edit menu > Delete Adjust Inventory Transaction).
   

   If the delete option is greyed out, you'll need to change an AccountRight preference to allow transactions to be deleted (Setup > Preferences > Security tab > deselect Transactions CAN'T be Changed; They Must be Reversed option).
4. Repeat these steps for every item and sale affected by this issue.