How-to: Background job for stock valuation

Stock valuation screen field

Parameter

Description

-r

Server name

-D

Database name

-u

User name (obsolete)

-F00000000435

For checking, and you must have the stock valuation menu rights to perform stock valuation via the background job. If you do not have rights, the error message “You have insufficient rights to perform this operation” will be displayed. If this parameter is not defined or wrongly defined, the message “Invalid parameters” will be displayed.

-~

You have to end the system parameters with these characters. After this, you can provide parameters for the functional flow of the application. If you do not provide this parameter, all the parameters above will be treated as parameters for your application rather than system parameters to automatically log in to a specific database.

-BckJob;

To indicate the executable file is triggered via the task scheduler or command prompt. If this is not defined, the Stock valuation screen will be displayed.

Transaction date

-TDF;

-TDT;

To indicate the transaction date range for filtering purposes. You can define one or both of the parameters. 

For example:
If “-TDF31052012;” is defined, the system will retrieve all the records after 31/05/2012.

If “-TDT31122012;” is defined, the system will retrieve all the records before 31/12/2012.

If “-TDF31052012;” and “-TDT31122012;” are defined, the system will retrieve all the records between 31/05/2012 and 31/12/2012.

If “-TDF;” and “-TDT;” is NOT defined, the system will retrieve all the transaction records. 

This parameter is applicable only if the Stock valuation as from last revaluation check box at System ➔ General ➔ Settings ➔ Inventory settings, under the Entry section is not selected. If you type “- TDF”, and “- TDT”, this parameter will be ignored even if the Stock valuation as from last revaluation check box is selected, and the logic will be the same as Inventory ➔ Warehouse management ➔ Stock valuation.

Item group

-IGF;

-IGT;

To indicate the item group range for filtering purposes. You can define one or both of the parameters.

For example:
If “-IGF5;” is defined, the system will retrieve all the records after item group 5.

If “-IGT10;” is defined, the system will retrieve all the records before item group 10.

If “-IGF5;” and “-IGT10;” are defined, the system will retrieve the records between item group 5 and item group 10. 

If “-IGF;” and “-IGT;” are not defined, the system will retrieve all the item group records.

Item

-IF;

-IT;

To indicate the item code range for filtering purposes. You can define one or both of the parameters.

For example:
If “-IF100;” is defined, the system will retrieve all the records after item code 100.

If “-IT200;” is defined, the system will retrieve all the records up to and including item code 200.

If “-IF100;” and “-IT200;” are defined, the system will retrieve the records from and including 100, and up to and including 200.

If “-IF;” and “-IT;” are not defined, the system will retrieve all the item code records.

Make item

-M;

This is an optional parameter. The values for this parameter are:

A - All
Y – Make item
N – Non-make

Anything other than these values will, by default, be "A".  

Level

-L;

This is an optional parameter. The values for this parameter are:

A - All
0 – Level zero
1 – Level one
2 – Level two
3 – Level three

Anything other than these values will, by default, be "A". 

User-defined field via [Inventory ➔ Items ➔ Assortments]

-ASST01;
-ASST02;
-ASST03;
-ASST04;
-ASST05;
-ASST06;
-ASST07;
-ASST08;
-ASST09;
-ASST10;

To indicate the item assortment for filtering purposes. In Exact Globe+, up to 10 assortments can be defined. If you defined 4 assortment parameters but there are only 3 assortments defined in Exact +, the last defined parameter will be ignored.

Type “ASST01” followed by assortment properties code.

For example:
- ASST01ABC;

Zero amounts (APP)

All amounts (APP)

Cost price/Purchase price

-ZAAPP;

-AAAPP;

-PAPP;

This group of parameters is only valid if the Valuation method per item check box under the Entry section at System à General à Settings à Inventory settings is selected. Otherwise, these parameters will be ignored.

If you define “-ZAAPP;”, the Zero amounts (APP) check box will be selected.

If you define “-AAAPP;”, the All amounts (APP) check box will be selected.

If both parameters are defined, the second parameter will always overwrite the value of the first parameter.

If “-ZAAPP;” is defined, the possible values for -PAPP; are C (Cost price) or P (Purchase price). For example, PAPPP. Anything other than the possible values will, by default, be C.

For “-AAAPP;”, you do not have to define the value behind because it will, by default, always be 1. (APP).

Zero amounts (SCP)

-ZASCP;

This group of parameters is only valid if the Valuation method per item check box under the Entry section at System ➔ General ➔ Settings ➔ Inventory settings is selected. Otherwise, these parameters will be ignored.

If you define “-ZASCP;”, the Zero amounts (SCP) check box will be selected. You do not need to define the value after Use price because by default, it will always be C (Cost price).

Zero amounts (FIFO/LIFOActual costing)

Cost price/Purchase price

-ZAOth;

-POth;

This group of parameters is only valid if the Valuation method per item check box under the Entry section at System ➔ General ➔ Settings ➔ Inventory settings is selected. Otherwise, these parameters will be ignored.

If you define -ZAOth;, the Zero amounts (FIFO/LIFO/Actual costing) check box will be selected. The possible values for -POth; are C (Cost price) or P (Purchase price).

Zero amounts

All amounts

Cost price/Purchase price

-ZAmt;

-AAmt;

-P;

This group of parameters is only valid if the Valuation method per item check box under the Entry section at System ➔ General ➔ Settings ➔ Inventory settings is not selected. Otherwise, these parameters will be ignored. Depending on the stock valuation method, the logic is same as the above.

-S;

To indicate to execute the executable file in silent mode. Error or warning messages will not be displayed.

Report

-R;

The values for the parameters are:

N - None
T – Totals only
D – Detailed information

Anything other than these values will, by default, be N. If this parameter is not defined or wrongly defined, the report will not be generated.