JD Edwards GXSALES

Use the GXSALES formula to retrieve sales totals based on sales criteria. Sales data may be retrieved from either the Sales Order Detail file (F4211), or the Sales Order History file (F42119).

Syntax

=GXSALES("Configuration","Total Field","Total Type","Retrieve Data from Sales History File","Criteria 01","Criteria 02","Criteria 03","Criteria 04","Criteria 05","Criteria 06","Criteria 07")

Parameters

The following are GXSALES formula parameters for JD Edwards ledgers:

Configuration

Identifies the host configuration from which to retrieve sales totals. May specify either the full configuration name or only the number.

Total Field

Identifies the related sales field to be totaled. Total field options are:

Description	Table.Field
Extended Cost	`F4211.SDECST`
Extended Price	`F4211.SDAEXP`
Gross Weight	`F4211.SDGRWT`
Open Amount	`F4211.SDAOPN`
Qty Backordered	`F4211.SDSOBK`
Qty Canceled	`F4211.SDSOCN`
Qty Committed	`F4211.SDSONE`
Qty Open	`F4211.SDUOPN`
Qty Ordered	`F4211.SDUORG`
Qty Shipped	`F4211.SDSOQS`
Qty Shipped To Date	`F4211.SDQTYT`
Trade Discount	`F4211.SDTRDC`

Total Type

Identifies the type of total to be calculated. Valid types are:

Average
Count
Maximum
Minimum
Summary

Criteria/Value

Identifies up to seven criteria parameters, and the associated value to be used for selecting data. The list of available selection criteria fields is maintained in Application Configurator by the administrator.

Retrieve Data from Sales History File

Indicates to retrieve data from the sales history file (F42119) instead of the sales order detail file (F4211).

Formula Example: GXSALES Extended Price (Average Sales)

=GXSALES(1, "F4211.SDAEXP","AVG","SALES;HISTORY=YES","F4211.SDTRDJ|D","6/01/1998.6/30/1998","F4211.SDMCU|B12","30","F4211.SDDCTO|A02","SO")

Retrieves the average sales totals from sales history file F42119, for order date range 6/1/1998 to 6/30/1998.

See JD Edwards Formula Maintenance for GXSALES for more information.