Thank you @yhartman!
Hi @yhartman,MIN/MAX Function work great to the field! The only thing is that one of the invoice it return a rather non-chronological order. I can live with that for now and will try looking into it if it happen again. Kind regards,Calvin
Thank you @Naveen Boga !
Hi @Naveen Boga,I have tried to import the XML once more but still providing the same error. Below is the Trace for the error:Kind regards,Calvin
Hi @Naveen Boga,I have upload the XML but it came with below error:Kind regards,Calvin
Hi @Naveen Boga,Please see below for my XML file. Thank you for your assistance. Calvin
Hi @Naveen Boga,Thank you for the instruction and XML file. However I am not familiar what is Instance and where I can load the XML to. When I was referring to Generic Inquiry, I am referring to screen ID CST.SM.20.80.00. Please see below screen shot of the screen I am referring to:Is there a way to make edit so it can achieved what I wanted? The current issue I have is that the order duplicate itself based on the number of Activities that is in the customer profile:If this could be done without updating instance or other access that would be best. Kind regards,Calvin
Thank you Yhartman. I am able to create the group and rearrange the fields to group the Inventory ID all together for the skid Scenario. I am wondering how would I be able to list all the Box Description for my Box Scenario? I am hoping to list out all the box number in the same text box (not grouping them, but have them all listed as in one box.)This is the current print when I do not group them together. It will should the box number where “Line #” field is but I would like it to show “1-7” in one single box. I seen it before but do not remember which report it was. Kind regards,Calvin
Hi Naveen,Thank you for your solution. May I know if this work needs to be done in Project level or at Generic Inquiry level? I am not familiar with editing project as I have no experience in SQL and programming. If this is from the Generic Inquiry screen, would you be able to show me in more detail steps on how to get to the below screen shot?Thank you for your help!Calvin
Hi Yhartman, Please see below is my screen shots of the report setup: I am not knowledgeable in the grouping field and only have access to Report Designer. I am hoping to avoid using Group if possible. Thank you,Calvin
Thank you Yhartman!It work perfectly! This is great ;) Thank you for your prompt assistance. Calvin
Hi Yhartman,Thank you for your instructions. Unfortunately it did not work on my report. Below would be my screen shots of the steps I followed. Please let me know if there is an error in between the steps. for the email, it has two ‘ instead of a “When I try to generate just the report to see, it gave me an error and not able to generate a info. Thank you,Calvin
Hi Yhartman, I am looking to have add the person who is logged in on the UI, not the person who created. Example warehouse would be the one creating invoice during the shipping process. I would want my Sales team to be able to email invoice to customer and CC or BCC back to the Sale person who click on the Action “Email Invoice”. I have tried using =Report.GetDefUI('RowAccessInfo.UserName'), which does return the login name which is the email address of the user base on testing it on a text box in the Report Designer, however it seems the system does not recognized the output. I had hardcode email address in Report Designer and it work fine, but that would mean only that one particular email address will get all the email, regardless of who is actually logged in and email the invoice out. Thank you.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.