• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

STock FIFO Valuation

Hemant Shah

New Member
Dear Chandoo,
Hi How are you! Your website has helped me alot with my VBA queries...

I was looking into one of your post on STock FIFO Valuation & the file was found very helpful.

I just have one query with it...If there are multiple Stock items how would it help with calculation.. I am attaching the file for you reference.

REgards,
Hemant Shah
 

Attachments

  • FIFO_Stock Valuation Report Macro.xlsm
    23.2 KB · Views: 17
Hi:

Is the attached correct?

Thanks
 

Attachments

  • FIFO_Stock Valuation Report Macro.xlsm
    22.1 KB · Views: 13
Hi,

Yes, but if you are referring to Negative stock at the beginning, then that I was just trying to see how the macro reacts if negative stock is at the beginning. You can refer attached file.

Regards,
Hemant Shah
 

Attachments

  • FIFO_Stock Valuation Report Macro.xlsm
    22.9 KB · Views: 8
Hi:

I did not get you what does the macro do. I just change the formula in there to accommodate multiple inventories.

Thanks
 
Dear Nebu,

Ok my Mistake... I could not explain you correctly.

What the current macro does is "It calculates the Sales Amount" in column#H.

So what I want is when the macro runs, based on the Article# change the macro should calculate correct figures...

I have tried to explain the same in the file too..

Sorry for the inconvenience...

Regards,
 

Attachments

  • Copy of FIFO_Stock Valuation Report Macro.xlsm
    31.6 KB · Views: 8
Hi:

Please find the attached.

Thanks
 

Attachments

  • Copy of FIFO_Stock Valuation Report Macro.xlsm
    34.2 KB · Views: 40
Back
Top