In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Adding a group that only applies to another existing group
I have (2) existing groups in a Pro Forma invoice report. One for T&M lines and one for Progress Bill lines. I want to group my T&M lines by Account Group, but when I add a Group for Account Group, the Progress Bill lines do not print on my report. Is there a way to group to content of only one of the existing groups?
I believe this is because I am using the Schema builder Relationship between the PM ProformaLine table and the PMTran table to get the transaction Account Group ID Description. However, the Progress Bill Proforma line does not have a PMTran transaction.
Try using the IsNull formula in your group formula so it can have a value (any value) to group on even when Account Group is null.
I know this was a long time ago, but any update? I am attempting to group the T&M portion of (PM642000) by Task/Cost Code, but have not had any success. I can successfully create a (separate) (sub)report of the T&M lines and group by task/Cost Code. BUT this does NOT work when I add the subreport. Any ideas why this may be? Are there too many existing groupings in PM642000 to begin with?