In Report Designer How can I join AMEstimateItem table and SOLine table?
Solved
Table Relationship
Best answer by Naveen Boga
Here is the screenshot for reference.
Probably you might need to follow the below steps.
- Please double-check if you have already enabled the Manufacturing module in the Enable/Disable screen
- Check with the Estimate ID field is showing in the Sales Orders screen → Details tab.
- As you wanted this in the report. You need to click on the Load Schema and click on the Refresh All to load the fields like showing the below screenshot.
Hope these steps helps.
+19AMEstimateItem Inner Join SOLineExt
JFYI, SOLineExt (this is default Acumatica DAC only)
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
1 person likes this
+3Use AMEstimateItem(EstimateID) inner join SOLine(AMEstimateID) instead of SOLineExt.
Regards,
Sagar, Greytrix
Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
1 person likes this
+19Here is the screenshot for reference.
Probably you might need to follow the below steps.
- Please double-check if you have already enabled the Manufacturing module in the Enable/Disable screen
- Check with the Estimate ID field is showing in the Sales Orders screen → Details tab.
- As you wanted this in the report. You need to click on the Load Schema and click on the Refresh All to load the fields like showing the below screenshot.
Hope these steps helps.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.