Identical product (varying costs) and profit/stock value calculations

Follow

john tan

• April 01, 2018 21:41

Hi,

when creating purchase documents for a given product (ABC) purchased over 2 points in time at varying purchased prices i.e. $90 at week 1, $100 at week 2. Does the system factor these price differences in calculating overall stock value (as seen in the stock tab) and in the profit and margin report?

I'm asking as I noticed that the system does not factor the differences in purchase price for a given product.  In fact, it seems to base subsequent profit/costing calculations and inventory value calculations off the initial costing figure keyed in upon creating the product within the system.

If not, will such a feature be released in future patches? I think having such a feature would enormously benefit users of your (already awesome) POS system, as having fluctuating prices for identical product purchases is a very common issue that most business owners would face!

3

• 

  john tan

  • April 02, 2018 12:43

  also would like to point out that as a result of this characteristic, subsequent profit calculations based on newer cost prices are not reflected in the profit report, so the profit report is inaccurate, along with the value of total stock.

  0

  Comment actions Permalink
• 

  Aronium Support

  • April 05, 2018 07:14

  Hi John,

  Unfortunately, this feature is currently not available.

  We do have plans to add calculation of keeping track of average price in some of the future updates, but it is not scheduled for development yet, so, we cannot promise any dates on this at the moment.

  Thanks, Aronium team.

  0

  Comment actions Permalink
• 

  hafiz4saqib

  • April 24, 2018 18:30

  Guide me here ......

  0

  Comment actions Permalink
• 

  Aronium Support

  • April 25, 2018 07:24

  Hi Hafiz,

  Every sale will store current cost price, and that price will be used for profit calculations. It seems to me that you have left old cost price after new purchase.

  What you should do, you should enable "Automatically update cost price on purchase" option in settings, this way you will be asked to update cost price once it is changed.

  

  With this option enabled, you will be prompt to update cost price on purchase keeping your cost price accurate, as shown in the screenshot below.

  

  You can read more about this at https://help.aronium.com/hc/en-us/articles/115000719352-Product-settings.

  Hope this helps.

  Best regards, Aronium team.

  0

  Comment actions Permalink
• 

  hafiz4saqib

  • April 25, 2018 13:42

  My report was after enable this setting which you are mention above.

  Any hope ????

   

  0

  Comment actions Permalink
• 

  Aronium Support

  • April 25, 2018 22:01

  Hi Hafiz,

  We were able to reproduce this issue by following your guide. Unfortunately, we identified an issue there in the following scenario:

  1. Create a purchase with new cost price
  2. Confirm cost price change on document save
  3. Go back to sales screen (without restarting Aronium)
  4. Sell item. Item's cost price is not updated and item sale is recorded with previous cost price, resulting in a bad report, as in your example.

  At this moment, the easiest way to ensure this doesn't happen anymore is to restart Aronium once you change cost price. This will ensure items are loaded with the latest / accurate cost prices and will be stored that way.

  This issue will be fixed in next update, we are sorry for this inconvenience.

  If you wish to change these records (sales) that are saved with bad cost price, please reach out to support@aronium.com so we can find the fastest way to fix them together.

  Thanks.

  0

  Comment actions Permalink
• 

  hafiz4saqib

  • April 25, 2018 22:08

  I can wait for new update to fix this issue ......

  0

  Comment actions Permalink
• 

  Aronium Support

  • April 25, 2018 22:11

  Thank you.

  We'll notify you on this thread once it is fixed.

  Best regards, Aronium team.

  0

  Comment actions Permalink
• 

  Aronium Support

  • June 07, 2018 21:01

  Hi Hafiz,

  Version 1.22 is released, with previously mentioned issue fixed. Once you update Aronium to the latest version, product cost prices will be updated in sales automatically..

  Thank you for your patience.

  Best regards, Aronium team.

  0

  Comment actions Permalink
• 

  Mahmoud Ramadan

  • November 21, 2022 04:55
  • Edited

  Welcome

  I still have the above problem

  
  And I have to restart the system in order for the new cost of the product to be calculated correctly

  0

  Comment actions Permalink

Please sign in to leave a comment.