Search results

  1. H

    Fifo batch allocation

    Pls refer to file I uploaded https://www.dropbox.com/s/7malgcn5gdy8bp2/Fifo%20by%20sales.xlsx
  2. H

    Fifo batch allocation

    @jdraw : I summarize. Your file gives result of stock on fifo basis means qty from different p.inv no. While I need the supplied /sold qty is from which bill no. Means what was the bill no of the supplied item
  3. H

    Fifo batch allocation

    @vbalnet I also shared one access file that output is same what I want Secondly in short I mean to say one Jdraw file focusing on Closing stock with Fifo based price what I need is to find the sales made belonged to which p.inv no. Excel file describe all
  4. H

    Fifo batch allocation

    @jdraw can you give idea that I need sold quantity batch reference @vbalnet if you find time I hope you can guide me
  5. H

    Fifo batch allocation

    I have checked the sample database but I need the reverse means .the file shows the closing stock from batches with price while I need only the sold with batch no
  6. H

    Fifo batch allocation

    I will .even I will put some real data and will share file
  7. H

    Fifo batch allocation

    I will look them one by one and will try to understand . After going I will share my experience . But I am thankful for helping me
  8. H

    Fifo batch allocation

    Dear can you help me
  9. H

    Fifo batch allocation

    Thanks for helping. Pls find the attached file. Infact orally for small data I can understand the way but for large set no idea. Pls find the link to download https://www.dropbox.com/s/7malgcn5gdy8bp2/Fifo%20by%20sales.xlsx
  10. H

    Fifo batch allocation

    The records are from two different tables or can be from one table. In fact if you download this file and check.he made make relations for query if possible I need to know only fifo batch report
  11. H

    Fifo batch allocation

    This is exactly what I need but I failed to understand the logic access-programmers.co.uk/forums/showthread.php?t=153802
  12. H

    Fifo batch allocation

    Apparently no link as each have its own calculations.
  13. H

    Fifo batch allocation

    Fifo desired for report for batch means first quantity out of first purchase. Tables are linked to maintain stock means total sales - total purchased = stock
  14. H

    Fifo batch allocation

    Hi all There no idea coming to my mind to how to perform me. That is what I need. Suppose I have purchase table with following data Batch no. Quantity. Date. 1001. 100. 01/01/2014 1002. 50. 02/01/2014 Now supposingly sales as follows...
  15. H

    Sales batch report

    I can see the reports and queries but still I failed to understand logic. Even on paper how to do it
  16. H

    Sales batch report

    Actually the logic I still not understand I tell you one example Let say batch no 1 has 100 pieces and batch no 2 has 50. Suppose we made sakes of 150 pieces. I need report which can tell first 100 pieces were of batch no1 and 50 pieces are of batch no2
  17. H

    Sales batch report

    In short I want to take report that particular output was which batch of input
  18. H

    Sales batch report

    access-programmers.co.uk/forums/showthread.php?t=153802
  19. H

    Sales batch report

    Sorry I cannot share my links but what I need I found but I want to learn the logic
  20. H

    Sales batch report

    Any friend give me idea
Back
Top Bottom