Solved

Page Break on Sales order Form

  • 27 December 2022
  • 4 replies
  • 154 views

We have a client migrating from Sage 100 to Acumatica.  Currently, the have their Sage Sales Order form customized to Page Break after the user enters an * in the Item field in the SO entry screen.  I see there is a page break option which can be done by groups but don’t see how to accomplish the client’s need of user defined page breaks.  Anybody have any ideas on this one?  Crystal Reports/Sage 100 seems to handle this quite nicely  but stumped on how to do it in Acumatica.

icon

Best answer by aaghaei 28 December 2022, 02:27

View original

4 replies

Userlevel 4
Badge

 

Hi,

I looked into this requirement, and it appears that it is only possible to add page breaks to an entire section/group of the report using the page break property in report designer.

It doesn't provide the option to add page breaks after particular rows within the section itself unfortunately.

Userlevel 7
Badge +9

@tmckee54 @MinushaWeerasuriya76 

Actually, I guess you can make it work. I suggest:

  1. Open the report you want to customize using Acumatica Report Designer.
  2. Locate and Duplicate the section you want to add a page break on it. You will have your original section above the copy you created.
  3. Remove all of the labels and fields (if any) from the copy you created and reduce its height to zero.
  4. Add a variable to the Original section to check whether this should trigger a new line or not something like “Name: NewPageByAstrix and ValueExpr: =CBool(IIf(InStr([DAC.Field], '*')<>-1, 1, 0))
  5. Set the newly created section PageBreak: After and VisibleExpr: =$NewPageByAstrix=True

I tested this on GL Trial Balance Summary and worked fine. I am not so familiar with the Sales side to test it but the logic is the same.

 

That would be nice for Acumatica to add an Expression for Page Break same as Visibility Expression.

Awesome thanks Aaghaei!  That worked perfect!

Userlevel 4
Badge

Thanks for the info Aaghaei!! Greatly appreciate it

Reply


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