Recent content by OmarDahy

  1. O

    Need Help With Code VBA For FIFO

    No, I haven't thought about this point. If I can add a new point to the invoice types, let's say number 99. We'll need to address this here. I feel like the issue is much bigger than my current level. If anyone can help me recreate this code from scratch until we reach a good point, I don't know...
  2. O

    Need Help With Code VBA For FIFO

    Yes, I have used two data sources here. The first one is based on queries, which are intended to verify the accuracy of the FIFO code. The second is the summary table TblFifoSummary, which reflects the details found in the table TblFifoStockLocal. For example, in the case of item number 3, the...
  3. O

    Need Help With Code VBA For FIFO

    First of all, thank you very much for your kind comment. Yes, there are some comments in the code that explain the COGS calculation using FIFO. However, I'm facing an issue specifically in the Case 2 section (Sales) my problem and this other sample All I need to know is why this...
  4. O

    Need Help With Code VBA For FIFO

    Good evening/morning, depending on your time zone. I don't want to get into an introduction, so I'll get straight to the point. I have a problem with the attached file code. This is code for calculating the cost of goods using the FIFO method. The code works well, but it has a serious problem...
Back
Top Bottom