Hi @BenjaminCrisman,Thank you for the suggestion. I have follow Lot/Serial Numbers report IN613000 and was able to map it so that it will show the Location ID when I am on the Report screen. Problem is once the report is run, it does not return me any value for items specify for the location. If I remove the location, the report will work just fine. Also another note. Would it be possible to set the parameter so I can choose the starting location and ending location for the report? Kind of like start date and end date?Kind regards,Calvin
Hi @BenjaminCrisman,Thank you for the reply. I did have INPIDetail.LocationID for both the parameter and the Filters setting, but it would not pull out the info. I can’t think of anything else that needs to be map in order for the items to show. I have attached the file of the report below for reference. Kind regards,Calvin
Hi @BenjaminCrisman,Sorry but I don’t quite understand what you are mentioning above. You mention only a filter on reporting printing screen. How would I be able to filter on the printing screen? Would you be able to elaborate on how to achieve that?Ultimately what I am hoping to get from the report is that I am able to select 3 or more location at a time so my warehouse can conduct the count with the specify location. In Prepare Physical Inventory Count function, I do find that the heavy amount of setup require in Stock Item and the lack of multi-selection of location (Having to exclude location one by one instead of able to choose which one I need) takes a very long time just to complete what I want, resulting me to look for alternative method in the report itself. I am hoping to be able to filter the location somehow in the report. Kind regards,Calvin
Hi @BenjaminCrisman,I was not aware you are able to filter on the printing report section instead of the report itself. This should satisfy what I am looking for.Thank you for your assistance and looking into this for me. Sincerely,Calvin
Hi @BenjaminCrisman,I have based the report under AR Aging MC report. I do not understand the variables as they are inter connect and the language is not something I am familiar with. I would want to get 30/60/90 days instead of last month/ 2 months/ 3 months ago. I have attached the report for your reference. Kind regards,Calvin
Thank you @Naveen Boga!
Hi @rsternberg96,Here is the screenshot of the result:As you can see, the same order number repeat itself multiple times with the same result. Kind regards,Calvin
Hi @mbridges00,What would I have to group it with in order to have it show only one? I tried SOOrder.OrderNbr and Inventoryitem.Inventory CD but they still won’t make it just one line. Kind regards,Calvin
Hi @kandybeatty49 I was unable to open the file. Would you be able to try to send the file or let me know what modification you might have made?Kind regards,Calvin
Hi @kandybeatty49,Thank you for the screen shot. I looked but I can’t tell what was done to rectify the issue where the Kit Item will show only once instead of showing up for every component item. Kind regards,Calvin
Thank you @BenjaminCrisman @manikantad18 for the solution!Kind regards,Calvin
Hi @Chris Hackett,I find out that my INItemCost was creating the duplicate result so I removed the relationship and now it does not duplicate multiple lines. Only issue is that I now lost the field where I can see the cost of my item. I can’t figure out how I should build the table relation and incorporate INItemCost.Kind regards,Calvin
Hi @Chris Hackett,I have not found a solution to this issue. I have my team to adapt a different way of packing for now until it can be resolved. Kind regards,Calvin
Already have an account? Login
Enter your 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.