Skip to main content
Solved

Details Sections Print Order

  • January 25, 2023
  • 6 replies
  • 133 views
gauravsharma96
Jr Varsity III
Forum|alt.badge.img

Hi,

 

I need the detail section to print by invoice due date:

Due in the next 7 days print first

Due over 7 days print second

Anything already overdue print last.

 

I have created 3 detail sections 

and for each section have added a visible expression:

=([ARInvoice.Status] = 'N') And (DateDiff('d', Today(),[ARInvoice.DueDate]) > '0' And 
DateDiff('d', Today(),[ARInvoice.DueDate]) < '8')

 

=([ARInvoice.Status] = 'N') And (DateDiff('d', Today(),[ARInvoice.DueDate]) > '7')

 

=([ARInvoice.Status] = 'N') And (DateDiff('d', Today(),[ARInvoice.DueDate]) <= '0')

 

however when I run the report it prints in the wrong order

 

 

I have also tried to do this as a group with the same result using a nested IIF statement and only 1 detail section.

=IIf( DateDiff('d', Today(),[ARInvoice.DueDate]) > '0' And 
DateDiff('d', Today(),[ARInvoice.DueDate]) < '8', [ARInvoice.DueDate],
IIf (DateDiff('d', Today(),[ARInvoice.DueDate]) > '7',[ARInvoice.DueDate],
IIf (DateDiff('d', Today(),[ARInvoice.DueDate]) <= '0',[ARInvoice.DueDate],
'')))

 

Any help will be appreciated.

 

Best answer by miguel80

Hi,

You can either order them by DueDate in ascending or descending order, but you can’t have that particular order on the report. If I understand correctly you want:

  • Due in less than 7 days
  • Due in more than 8 days
  • Past Due

But that is not chronological… you could do:

  • Due in more than 8 days
  • Due in less than 7 days
  • Already past due.

If it’s very important for you to achieve this particular order you can use a subreport to do it.

Let me know and I can tell you how.

I have a version of you report that works with the alternate order if you want it.

View original
Did this topic help you find an answer to your question?

6 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 704 replies
  • January 25, 2023

Hi @gauravsharma96! For this issue when you specify a grouping section, you can specify how that group sorts:

If you are needing to sort the detail section then you can specify how this sorts in the report printing screen or in the build schema:

Have you already tried using these sections?

gauravsharma96
Chris Hackett
2 people like this
  • gauravsharma96
    gauravsharma96
  • Chris Hackett
    Chris Hackett
gauravsharma96
Jr Varsity III
Forum|alt.badge.img
  • gauravsharma96
  • Author
  • Jr Varsity III
  • 18 replies
  • January 26, 2023

HI, @BenjaminCrisman, thanks for the reply, yes I have tried that, cant seem to find a way to print the 3 detail sections in the order required, will keep testing and .come back if I get a solution

miguel80
Semi-Pro II
Forum|alt.badge.img+1
  • miguel80
  • Semi-Pro II
  • 71 replies
  • January 30, 2023

Do you still have this issue? Can you please attach your report?

Miguel Q
gauravsharma96
Jr Varsity III
Forum|alt.badge.img
  • gauravsharma96
  • Author
  • Jr Varsity III
  • 18 replies
  • February 1, 2023

Hi @miguel80, still have the issue, I have uploaded the report any support is appreciated.

1 Attachments
miguel80
Semi-Pro II
Forum|alt.badge.img+1
  • miguel80
  • Semi-Pro II
  • 71 replies
  • Answer
  • February 2, 2023

Hi,

You can either order them by DueDate in ascending or descending order, but you can’t have that particular order on the report. If I understand correctly you want:

  • Due in less than 7 days
  • Due in more than 8 days
  • Past Due

But that is not chronological… you could do:

  • Due in more than 8 days
  • Due in less than 7 days
  • Already past due.

If it’s very important for you to achieve this particular order you can use a subreport to do it.

Let me know and I can tell you how.

I have a version of you report that works with the alternate order if you want it.

Miguel Q
gauravsharma96
Chris Hackett
2 people like this
  • gauravsharma96
    gauravsharma96
  • Chris Hackett
    Chris Hackett
gauravsharma96
Jr Varsity III
Forum|alt.badge.img
  • gauravsharma96
  • Author
  • Jr Varsity III
  • 18 replies
  • March 17, 2023

Thanks @miguel80 for looking at this, customer is ok with the solution as is, I will play around with sub reports for the future, thanks again much appreciated.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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