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 sold all stock on hand for this item bringing the quantity on hand 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, like this:

You'll also notice when running reports:

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

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

Workaround

1. Enter an inventory adjustment for each affected 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 each affected 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).