AnyOne has experience with pharmacies and Pharmaceutical companies apps . RRS feed

  • Question

  • hi , i am developing an application for pharmacies and small Pharmaceutical companies , the situation is :

    the pharmacy can buy a specific medicine ("Cetal" for example with item_id "1") from a store with different expiry dates (2016 and 2017 i.e.) .

    so , my stock table (item_detail) has these columns

    ( patch_no , item_id , qty , expiry_date )  -- for example .

    the "patch_no" column is for distinguishing the same medicine , for example

    insert into item_detail values

    (1 , 1 ,  50 , '10/10/2016) ;

    insert into item_detail values

    (2 , 1 ,  50 , '10/10/2016) ;

    first problem , in any application , when a pharmacy buy medicines , there is a "purchase invoice " , which should insert the medicine automatically into the stock table(item_detail)  .

    which means that there will be "2" records for the same medicine(cetal) in the "purchase invoice " , which i think it is not a normal thing .

    another section of this problem is the user has to write the "discount" and "bonus" in each record for the same medicine , and may be there 3 rows not 2 .

    second problem is about " sales invoice " , when the pharmaceutical company sells a medicine with different batches ,

    the same thing will happen , may be i can store the invoice with 2 rows for the same medicine , but the report printed will only have the sum(quantity) group by item_id , but writing the discount and bonus problem still exists , and another problem is i do not have a proof that i sold him 2 different patches , because the buyer has an invoice which is different from the one i have , he have the sum(quantity) , without expiry dates .

    i think this is enough for one post  .

    thank you so much

    -  talking about " sales invoice "

    • Moved by Kalman Toth Tuesday, November 18, 2014 7:49 PM Not database design
    • Moved by Kristin Xie Wednesday, November 19, 2014 2:32 AM
    Tuesday, November 18, 2014 11:29 AM

All replies

  • Hi eslam,

    Thank you for visiting the MSDN forum.

    I’m afraid that it is not the correct forum about this issue, since this forum is to discuss Visual C#. I am moving your question to the moderator forum ("Where is the forum for..?"). The owner of the forum will direct you to a right forum. Thanks for your understanding.

    Have a nice day!

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, November 19, 2014 2:31 AM
  • MSDN forums are geared towards specific application development issues using Microsoft technologies. TechNet forums are more towards IT professionals and solving issues with use of Microsoft software. It sounds like you're looking for an application design assistance forum for which there really are none here.




    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, November 19, 2014 2:43 AM