Inventory Module (Possible Issues)

I have setup a very simple test business (Server version 23.10.25.1106) with a single supplier and a single inventory item (along with the various mandatory accounts).

I then create a Purchase Invoice for 100 x Inventory Item @ $10.00 each PLUS Freight-in of $200:

The Summary Screen shows as follows:

I then run a Report (Inventory Revaluation Worksheet); and then use the New Inventory Revaluation tab:

The result of the above is shown in the following Summary Screen:


You will note that this has only moved the actual inventory cost (EXCLUDING freight-in) to the Inventory account in the Balance Sheet. The freight-in component has been left in Suspense. This is incorrect because the freight-in forms an integral component of inventory and should have been reflected in the Inventory account in the Balance Sheet (i.e. $1,200.00); with NOTHING in Suspense.

If the “old method” is used (i.e. by selecting Settings-Obsolete Features-Dynamic Rolling Recalculations-Inventory Items) then everything is reflected correctly as shown in the following Summary Screen:


Is this a bug?

Read this guide to allocate the freight - Add freight-in to inventory item costs | Manager

I agree that this is an issue.
Some time ago I changed from using the built in Freight-in and set up a separate expense account for freight.
After switching to the new Inventory revaluation method I found numerous transactions where I had not changed the freight account, had gone in suspense, so I had to go and change them all to just using the account I had set up. Fixed the suspense issue. However this does not add the freight expense to individual item costs.
@tony It appears @ozcpa has done as the guide suggests, like I had done originally, and got the same issue.
@lubos may need to look at this.

Thanks, but I was aware of “the process”. The problem is that it doesn’t result in the correct inventory costs (unless the “old method” is utilised … and that method is discouraged by @lubos the developer)

1 Like

I moved this topic to bugs. Whatever approach to inventory accounting is used, freight-in expenses should move with direct cost of inventory items.

@Tut Many thanks

@lubos Any idea when this issue is likely to be fixed?

There are a few issues I’m working through in relation to Inventory Revaluation Worksheet. This is a bug and will be soon.

2 Likes

@lubos Many thanks

Fixed in the latest version (23.11.2)

1 Like

Great @lubos Many thanks