Examples of automatic functions to run

Examples of automatic functions to run.

With the /r parameter you can start Visma Business from a Scheduled task and peform batch jobs that are time consuming during night time.

Regenerate stock

This example need a prepeared layout to run

@FIRM_BEGIN (Firm no)
@OPEN_WINDOW (Layout no)
@GO_TO_SUBWINDOW_FOR_TABLE (123)
@SELECT_ALL ()
@DEFAULT_PARAMETERS (1)
@EXEC_PMC (244)
@CLOSE_WINDOW (Layout no)

Regenerate accounting balances

This is running from the raw table

@FIRM_BEGIN (Firm no)
@OPEN_SUBWINDOW (26)
@DEFAULT_PARAMETERS (1)
@EXEC_PMC (196)

Receival of purchase invoice

This reseive purchase invoice line and updates a batch automatically, more information can be added to the order and order line

@FIRM_BEGIN (Firm no)
@DEFAULT_PARAMETERS (1)
@READ_ORDER (Order no)
@Ord (OrdNo,InvoNo,LstInvoDt,DueDt)"Order no" "Invoice no" "Invoice date" "Due date"
@OrdLn (OrdNo,LnNo,RlzN)"Order no" "Line no" "Qty"
@SAVE_ORDER (Order no)

Update all batches

This is running from the raw table

@FIRM_BEGIN (Firm no)
@OPEN_SUBWINDOW (44)
@SELECT_ALL ()
@DEFAULT_PARAMETERS (1)
@EXEC_PMC (156)

Update sale order batches from the Batches table

This is running from the raw table

@FIRM_BEGIN (Firm no)
@OPEN_SUBWINDOW (44)
@GO_TO_COLUMN (861)
@FIND (9)
@DEFAULT_PARAMETERS (1)
@EXEC_PMC (156)

Example of a file adding new rows in the "Language" table:

@FIRM_BEGIN(9999)
@OPEN_LOG_FILE(LOG9999A.TXT)
@IMPORT_METHOD(3)
@Lang (LangNo, Nm, AddDescr)
44 Engelsk 0
45 Danish 0
46 Swedish 0
47 Norwegian 1
49 German 0
@FIRM_END(9999)
@CLOSE_LOG_FILE()