In Report Designer How can I join AMEstimateItem table and SOLine table?
Best answer by Naveen Boga
View original
Userlevel 7
+17
AMEstimateItem Inner Join SOLineExt
JFYI, SOLineExt (this is default Acumatica DAC only)
Userlevel 1
There isn't a table call. SLineExt in Acumatica Report Designer
Userlevel 5
+1
HI
Use AMEstimateItem(EstimateID) inner join SOLine(AMEstimateID) instead of SOLineExt.
Regards,
Sagar, Greytrix
Userlevel 1
in SOLine there isn’t AMEstimateID
Userlevel 7
+17
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.