JD Edwards GXSALES Drill Down

Once GXSALES formulas are constructed, drill down capability to the sales detail related to the amount, quantity, or weight exists. The drill down results can appear in a single panel, tabbed panel, or worksheet based on the option in the user's Spreadsheet Server Settings. Additionally, GXSALES criteria in Application Configurator determines whether a field appears in the Sales Detail drill down grid.

Select a cell containing a GXSALES formula, then, from the Spreadsheet Server Ribbon, select Drill Down, or, right-click and select Spreadsheet Server > Drill Down. The Sales Detail drill down appears showing, the associated sales detail from the F4211, F4101, and F0101 files.

Tip: The drill down data may also be pushed directly to a panel or worksheet by selecting the Spreadsheet Server Ribbon equivalent.