Imagine you receipt 10 items at £5. You have an asset value of £50 and an Average Cost of £5. Now you receipt 10 of the same items at £10. You have an asset value of £150, and an Average cost of £7.50 ((10x5)+(10x10))/20. As you can see, this is a weighted value. As you reduce your inventory, you will use inventory from…

The above is an exposure within the Saved Search, it simply requires a Join to the preferred supplier sub-list. On the UI, you can visit the Purchasing/Inventory tab and then the Suppliers sub-list to see the preferred supplier. You could also pull the value into a custom field if desired, though I believe you will need to…

The Purchase Price currency is set by the preferred supplier's primary currency. Where this is not available, the base currency of the subsidiary is used. Therefore, to identify the currency of the purchase price, you can use {preferredvendor.currency} or simply select the Preferred Supplier/Vendor fields and then…

Average Cost is a weighted value calculated using FIFO/LIFO/Lot Numbered Costing - if you reduce the quantity to 0 on Day 1, the average cost will be 0 for all items (assuming you have no history of inventory/costing issues such as underwater inventory), thus when you import the inventory the following day at 0, it will…