Skip to main content
Answer

Split out Report (Pro Forma Invoice in this Case) based on Condition

  • August 24, 2023
  • 1 reply
  • 81 views
K
Semi-Pro II
Forum|alt.badge.img+1

Hi All,

 

I am currently working through a Requirement for the proForma Invoice where we would like to split Time and Material Project Entries with their separate Headers and after each other:

Basically Project Task 1 with the Code 00 will always be Labor and needs to flow into the Time Header Section.

The Rest will always be Material.

So I need to associate the Line/Detail Section to the Grouped Header of Time.

I cannot figure out how to associate a certain Detail section with the appropriate Header Section.

Visual Expressions didn’t bring me very far yet as it is not determining where the specific Lines shows up

 

 

Any thoughts on how to associate the Detail Section with the Header Section?

Best answer by miguel80

Hi! I would solve it with a SubReport. Use the main report to show only the “Time” items, and in that group footer add a subreport that has the information for the “Materials”.

 

Hope that helps

1 reply

miguel80
Semi-Pro III
Forum|alt.badge.img+3
  • miguel80
  • Semi-Pro III
  • Answer
  • August 25, 2023

Hi! I would solve it with a SubReport. Use the main report to show only the “Time” items, and in that group footer add a subreport that has the information for the “Materials”.

 

Hope that helps

Miguel Q
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved