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.
Answer
Page Break on Sales order Form
Best answer by aaghaei
Actually, I guess you can make it work. I suggest:
- Open the report you want to customize using Acumatica Report Designer.
- 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.
- Remove all of the labels and fields (if any) from the copy you created and reduce its height to zero.
- 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))
- 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.
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.
+10Actually, I guess you can make it work. I suggest:
- Open the report you want to customize using Acumatica Report Designer.
- 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.
- Remove all of the labels and fields (if any) from the copy you created and reduce its height to zero.
- 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))
- 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.
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.