Forum Discussion

shabirAhmad's avatar
shabirAhmad
Helper II
3 years ago

Issuance and Reciept Inventory from inventory Table

Hi Experts,

 

I have InventTrans Table and in that table there are 2 columns 1 field StatusIssue 2 StatusReceipt. Now if the StatusIssue  is == Sold this will show me Issuance and if  the field is StatusReceipt is == Purchased it will be Reciept now how can i get this.

 

 

Best Regards,

Shabir Ahmad

Need Help

6 Replies

  • Prateek97's avatar
    Prateek97
    Resolver III
    3 years ago

    Hi shabirAhmad ,

     

    You can use following:

     

    Flag = IF([StatusIssue]="Sold","Issuance",
                         IF([StatusIssue]="Purchased","Receipt",

                                  "NA"))

     

    Please mark this as solution if it solves your problem 🙂

     

    • shabirAhmad's avatar
      shabirAhmad
      Helper II
      3 years ago

      Hi Prateek,

       

      Thanks for your reply, actually there will be 2 fields in Report 1 field showd show Inventory Issuance and another field will show inventory Receipt.That means issuance field should show inssuance(Status::Sold) and Reciept field should show (Status::Recipt) reciept in report.

       

      Best Regards,

      Shabir Ahmad

      • Prateek97's avatar
        Prateek97
        Resolver III
        3 years ago

        Hi shabirAhmad ,

         

        Can you please give the table structure and the sample output in a table format. That would help to understand the issue better

  • shabirAhmad's avatar
    shabirAhmad
    Helper II
    3 years ago

     

    Hi Prakeet,

    output should be

     

    Issuance / SoldReciept / Purchased
      
      

     

    Best Regards,

    Shabir Ahmad

     

    • Waqas_BIspecs's avatar
      Waqas_BIspecs
      Frequent Visitor
      3 years ago

      Hi shabirAhmad ,

       

      Prateek's solution is perfect based on your 1st explaination. Problem which i see with your explaination is that you have 2 comparative values but you are expecting 3 outputs. can you please explain. there is something that you couldnt put in your question. 
      if you want an output like this, then prateeks solution is the most appropriate. 

      if this is not your output table,  then please provide table layout you are looking for with the fields filled as we did, fill it the output values as well please. 

      we all are here to help 😐