frequently asked questions

All your questions in one place.

DocInfo

This method returns a piece of information from a given commercial document.

Syntax:

oBiz.DocInfo(<cMethod>, <dEndDate>, <dStartDate>[, <nComplement, <cComplement>>])

 

Parameters

Description

cMethod

Indicates which type of statistics has to be returned. The possible values are:

vente chiffre affaire: sales amount;

vente chiffre affaire categorie: sales amount by document category;

vente chiffre affaire groupe article: sales amount by item group;

vente chiffre affaire paiement methode: sales amount by payment method;

vente chiffre affaire paiement type: sales amount by payment method type;

vente chiffre affaire marge: margin on the sales amount;

vente marge groupe: margin by group on the sales amount;

achat montant total groupe article: purchases amount by item group;

achat montant total: purchase amount;

achat montant total categorie: purchase amount by category.

dEndDate

The transactions up to the date specified are selected. The parameter is mandatory. If the parameter is missing no transactions are selected.

dStartDate

The transactions starting from the date specified are selected. The parameter is mandatory. If the parameter is missing no transactions are selected.

nComplement

Parameter that can be coupled with some of the cMethod parameter.

 

If cMethod = vente chiffre affaire paiement méthode then it can contain the ID of the payment method of the documents (do_ban_pay).

 

If cMethod = vente chiffre affaire paiement type then it can contain the ID of the type of the payment method of the documents (bq_type).

 

If cMethod = vente chiffre affaire categorie then it can contain the ID of the category of the documents (do_catego).

 

If cMethod = achat montant total categorie then it must contain the ID of the category of the documents (do_catego).

cComplement

Parameter that can be coupled with some of the cMethod parameter.

 

If cMethod = vente chiffre affaire groupe article then it can contain the items group on which a filter has to be applied.

 

If cMethod = vente marge groupe then it can contain the items group on which a filter has to be applied.

 

If cMethod = achat montant total groupe article then it can contain the items group on which a filter has to be applied.

 

Examples:

*/ Instantiate end set the database location.

oBiz = createobject("bizinfo.application")

oBiz.cDatabasePath = "C:\WinBIZ Data"

oBiz.nCompany = 1000

oBiz.nYear = 2017

*/ Show the total sales amount for the company.

messagebox(oBiz.DocInfo("vente chiffre affaire"))

*/ Show the total sales amount for the company from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente chiffre affaire", {31.03.2017}, {01.03.2017}))

*/ Show the total sales amount for the document category with ID = 15 from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente chiffre affaire categorie", {31.03.2017}, {01.03.2017}, 15))

*/ Show the total sales amount for the items group ITEM_TEST from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente chiffre affaire groupe article", {31.03.2017}, {01.03.2017}, , "ITEM_TEST"))

*/ Show the total sales amount for the payment method whose ID is 4 from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente chiffre affaire paiement methode", {31.03.2017}, {01.03.2017}, 4))

*/ Show the total sales amount for the payment type whose ID is 3 from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente chiffre affaire paiement type", {31.03.2017}, {01.03.2017}, 3))

*/ Show the total margin amount for the company from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente chiffre affaire marge", {31.03.2017}, {01.03.2017}))

*/ Show the total margin amount for the items group ITEM_TEST the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("vente marge groupe", {31.03.2017}, {01.03.2017}, , "ITEM_TEST"))

*/ Show the total purchases amount for the items group ITEM_TEST from the 01.03.2017 to the 31.03.2017.

messagebox(oBiz.DocInfo("achat montant total groupe article", {31.03.2017}, {01.03.2017}, , "ITEM_TEST"))

*/ Show the total purchases amount for the company.

messagebox(oBiz.DocInfo("achat montant total"))

*/ Show the total purchases amount for the company for the category 6

messagebox(oBiz.DocInfo("achat montant total categorie", {31.03.2017}, {01.03.2017}, 6))

Did you find this article useful?

0 out of 0 found this helpful