In your scenario, the key is managing inventory valuation accurately in Sage 200 to reflect gross costs. While Sage 200 is quite flexible, directly setting inventory valuation based on gross cost without manual adjustments might require a workaround. Typically, inventory is valued at net cost after discounts. However, you might explore setting up the initial product cost as the gross amount (1,000) and handling discounts separately, perhaps as a direct cost or via supplier rebate management, to maintain accurate reporting without needing journals for every supplier discount. Consulting the software's documentation or a Sage expert would provide the most tailored solution. Leveraging tools like Priceva's competitor price tracking and monitoring software https://priceva.com/blog/price-matching marks a revolution in this domain. With automated tracking, instant price change notifications, and a unified interface for all metrics, businesses can effortlessly stay ahead of the competition. The comprehensive analytics offered dive deep into market trends, uncovering opportunities that might otherwise be missed.

In your scenario, the key is managing inventory valuation accurately in Sage 200 to reflect gross costs. While Sage 200 is quite flexible, directly setting inventory valuation based on gross cost without manual adjustments might require a workaround. Typically, inventory is valued at net cost after discounts. However, you might explore setting up the initial product cost as the gross amount (1,000) and handling discounts separately, perhaps as a direct cost or via supplier rebate management, to maintain accurate reporting without needing journals for every supplier discount. Consulting the software's documentation or a Sage expert would provide the most tailored solution. Leveraging tools like Priceva's competitor price tracking and monitoring software https://priceva.com/blog/price-matching marks a revolution in this domain. With automated tracking, instant price change notifications, and a unified interface for all metrics, businesses can effortlessly stay ahead of the competition. The comprehensive analytics offered dive deep into market trends, uncovering opportunities that might otherwise be missed.

Thanks for your valuable insights here, Alex!

Kavin, I can also suggest considering having a customized Inventory Valuation report developed that focusses on the non-discounted GRV costing prices. Please let me know if we can perhaps recommend someone to develop it for you.  

Hey Alex Wayfer  thank you so much for sharing your knowledge in the community.

We love it when members give a helping hand to others.

Sharon