I also have this need as the same item may lie in various locations in the same warehouse
hi - Thanks , I need to delete a segment which unfortunately is the 2nd segment
Hi no worries as I have done this today - All Good!!
Hi @andre89 One of our client uses the Power BI extensively, when we discussed on this scenario. here is the suggestions. Hope this helps! When you setup the odata feed: https://yourcompany.acumatica.com/odata/yourTenant You would just point the first dataset to Tenant 1, the second dataset to Tenant 2, And then, either in GI, or in Power BI, create a custom column "Tenant" and insert the Tenant name. Then in Power Query, or with a dax UNION append the queries together. Hi Naveen - Me again:(I am having so much resistance with Power BI and SQL views because of “security” issues I am going to try this recommendation.I have sucessfully created many PowerBI across tenant reports but our Tech Director does not approve of it due to security.Tell me please - Example my one SQL query looks at 10 tenants. Now with this recommendation in order to get all 10 tenant into the report i need to union the very same script 10 times with DAX union. Would if not be slow?Regards
Hi NaveenPlease advise, if the item is active and costing is average, when I assemble the item (Kitting item) is has a cost value in that location because that is where it was receipted into from Vendor purchases. However when i transfer that kit item into another location from where it will be sold the cost value no is Zero. This happens even when I assemble the kit in the second location
Done and dusted!!
@erina - The Link Widget is new in Acumatica 2021 R1. You’re probably on an older version of Acumatica, but hopefully upgrading to Acumatica 2021 R1 in the somewhat near future! Hi Tim Roadman How are you ? Hope you are doing well. Currently we are in acumatica 2021R2 version. Can i check with you if you know how do we add in the finance report - P&L link in dashboard using the dashboard widget “Link” below? @erina - The Link Widget is new in Acumatica 2021 R1. You’re probably on an older version of Acumatica, but hopefully upgrading to Acumatica 2021 R1 in the somewhat near future! Hi Tim Roadman How are you ? Hope you are doing well. Currently we are in acumatica 2021R2 version. Can i check with you if you know how do we add in the finance report - P&L link in dashboard using the dashboard widget “Link” below? Hi all - Did you come right with this as I too am kinda struggling to understand the parameter needed
Hi @andre89 One of our client uses the Power BI extensively, when we discussed on this scenario. here is the suggestions. Hope this helps! When you setup the odata feed: https://yourcompany.acumatica.com/odata/yourTenant You would just point the first dataset to Tenant 1, the second dataset to Tenant 2, And then, either in GI, or in Power BI, create a custom column "Tenant" and insert the Tenant name. Then in Power Query, or with a dax UNION append the queries together. Hi Naveen, thanks for all help. I am new to Acumatica so get a bit lost here and there BUT this community and mates like u sure do help!! I have successfully managed all those 3 steps of creating a DAC from a SQL view and can see it in my GI’s together with the company ID coming from the view.Now in PowerBI i need to create a report with all tenants do i still need to follow your advice cos i see all required fields within this GI. M problem is the ability to have drilldowns and drill through working all the time
Hi @andre89 This is just a thought. Please try. In PowerBI, you can fetch the data from GI with the CompanyIDs, and then frame the drill down urls like http…….com/Companyid=’ABC’..Screenid=SO301000..OrderType=’SO’..OrderNbr-’SO001234’ to drilldown to the documents. hope this helps. Thanks Hi my Friend. I will talk to one of our Senior Guys to explain. Many thanks
HI @andre89 Another shortcut may be to have, Create a SQL View showing the details from all company IDs. Create a DAC for the SQL View Create a GI and mark for ODATA. Thanks Thanks BUT will the drill down and drill through still work?
That is to say one report looking at 2 or more tenants
Hi MRoszkowski15 still getting same results. Changed Import scenario and ran export scenario as per import.
Great ! I will give it a go and revert
above data provider and below import scenarioduplicate data
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.