By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
0
Reactions
1,134
Views
September 1, 2022 4:23 pm
I have created a version of the Sales Orders GI that provides SOLine level data
On the SO Line it shows Branch ID (SOLine.BranchID)
On the Financial Tab in the order there is Branch (SOOrder.BranchID)
I need to create a report that shows where the SOOrder.Branch ID is not the same as the SOLine.BranchID
Does anyone have any suggestions?
1 Reply
October 13, 2023 9:38 pm
Hi Lorne,
Going through old posts here. You probably figured this out already, but here's a way to get what you're looking for with a Generic Inquiry.
Add both SOLine and SOOrder to the Generic Inquiry like this:
You can then add a formula column like this:
=IIf([SOOrder.BranchID]<>[SOLine.BranchID],'Branch Mismatch','Branches Match')
Finally, add a filter to the Generic Inquiry like this to catch only the mismatches:
Online Members
