Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

Table 4-1 Stock Ledger Download - Filter Criteria

FieldsDescription
DepartmentEnter, select or search for the department.
You must enter either the department or the location for the
download.
ClassEnter, select or search for the class.
SubclassEnter, select or search for the subclass.
CurrencySelect if you want to download the data in the local or the retailer’s
primary currency.
This field is a required field.
LocationSelect the location type. Then enter, select or search for the
location.
You must enter either the location or the department for the
download.
ViewSelect if you want to view the data by days, months, or weeks.
This field is a required field.
End of PeriodEnter, select or search for the end of period date.
This field is a required field.

3. In the Download Details section, select the template from the list. The Template field is a required field. The following templates are available.

  • Cost Template

This option will generate a file that contains only cost columns of the selected View.

  • Retail Template

This option will generate a file that contains only retail columns of the selected View.

  • Cost-Retail Template

    • This option will generate a file that contains both cost and retail columns of the selected View.

4. Click Download to download the spreadsheet with the selected stock ledger records on your desktop.


In this guide