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 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, so the item didn't have a Last Cost.

2. You then fully sold the item, bringing the on hand quantity back to 0.
3. You then edit and re-record the sale, which overrides the actual COGS for that sold and replaces it with 0.

And you will find:

• 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, you'll create an inventory adjustment to reinstate the correct COGS for the item. You'll then edit and re-record the sale to correct the COGS. Finally, you'll delete the inventory adjustment.

You'll need to repeat these steps for every items 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.