By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
3
Posts
2
Users
2
Likes
301
Views
February 8, 2023 7:32 am
Hi,
Would anyone be able to give some guidance on if it’s possible to add the SO # to the account details screen. I noticed there is an account details GI (see screenshot). I know if you click the reference # for the IN module, it brings you to the Issues screen where you can see the SO number. I can’t figure out how to link those two tables (if that is even possible).
Any guidance would be greatly appreciated.
2 Replies
June 30, 2023 10:03 am
You can add that field by adding a LEFT JOIN on the Batch table's BatchNbr column to INRegister BatchNbr column.
- Add the INRegister to the Tables section
- Add the relation and link in the Relations section
- Add the SOOrderNbr column in the Result Grid section
Screenshots attached.
June 30, 2023 10:17 am
Hi @charles-craig, thanks. I wound up doing something similar with the INTran table.