A new CRM Order Book report lists every sales order line with all its order details, with grouping, pivot reports and Ask AI.
Order Book report
CRM now has an Order Book page that shows every sales order line together with every field of its order. Important columns load first, and the other columns, including the picture, are in the column chooser and load only when you show them.
Excel export of the Order Book
You can export the Order Book, in both Lines and Grouped views, to Excel.
Ask AI on the Order Book
Ask questions about the data the Order Book is showing. Answers to repeated questions are cached until the data changes. You can save any answer as a grid layout or a pivot report. Outside the development environment, Ask AI needs an AI key set up for your company.
Saved layouts and pivot reports for the Order Book
You can save the Order Book's columns and its Lines or Grouped mode as a layout. Pivot Analysis also supports saved Order Book reports.
Group the Order Book on the server
Switch between Lines and Grouped views. You can group by parent material (variants roll up), customer, order, season, order type, merchandiser, sales person, or order or delivery month. Each group is split by unit and shows total and pending quantity and the average selling price in INR, net and before tax. Click a group to see its lines.