Announcements
No record found.
Hi
Is there a way to add 'Classification balances' menu on the factbox panes for sales order. We can see it under 'All Customers' but want to view it in Sales Orders as well.
*This post is locked for comments
Hi,
Yes.Its possible. Please perform the following steps:
(i) Navigate to the form CustBillingClassificationBalance and add below code in method executeQuery(Path: \Forms\CustBillingClassificationBalance\Data Sources\CustBillingClassificationBalance\Methods\executeQuery)
switch (element.args().dataset()){case tablenum(CustTable) :custTable = element.args().record();break; case tablenum(SalesTable) : // Added codesalesTable = element.args().record();custTable = custTable::find(salesTable.CustAccount); // I have added customer account, you can choose to have invoice accountbreak; }
(ii) On the form SalesTableListPage, create a new part under Parts node and set properties like below.
You can see the fact box pane as(colored in yellow) :
Hi Chaitanya
We're getting an error when it compiles/saves the new query.
Your method declaration is missing on the screenshot, so you get a Syntax error during compilation.
Hi Vilmos
I'm not sure what that means exactly. Do you know what line or syntax we would need to add?
Hi Sukrut
Added that line but get error below.
Please declare salestable in classdeclaration of the form as below (as suggested by other experts above) as
Salestable salestable;
Hi all
You're gonna have to dumb it down a bit for me. I'm not a programmer or database administrator.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
