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 ...
Need Help
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 Prateek

       

       

       

      output should be in report like this as below