reports

Statistics will not give you the answers you need.

You should use scripting language, in document list views, but it's not easy to explain it on the forum. We usually give this kind of assistance only with remote assistance.

In this case you should:

FIRST STEP


Select a document type list (for example immediate invoice) and click on filters

STEP TWO

Select all the sales documents you want to process

STEP THREE

After clicking show (F10), select view menu

STEP FOUR

add a field that is the result of a script

STEP FIVE

Paste or create a script like this:

Option Explicit

Dim Quant
Dim sale
Dim purc
Dim saletot
Dim purctot

If Product.Id > 0 Then

    Quant = Rdy.toDouble(DocRow.CustomField(30))
    sale = Rdy.toDouble(DocRow.CustomField(49))
    saletot = Quant * sale

    purc = Rdy.toDouble(DocRow.Product.InventoryValueFIFO(DocRow.Doc.DocDate))
    If purc = 0 Then
        purc = DocRow.Product.CustomField(700)
    End If
    purctot = Quant * purc

End If

Response.Write(Rdy.FormatCurrency(saletot - purctot))

This script makes the difference between the sales total and the purchases total


Using scripts, you can do a lot of custom statistics, but you need to have programmer's skills

Hi Frank

How to you run the script after it is added??

Once you've inserted it in the view, you just have to run the search again.

Frank

the option doesn't show up in the view,
do I copy from Option explicit to end if?

After scrip is copy from step 5 any other step need to be taking?

You have to copy all the script, the last row is the result:

Option Explicit

Dim Quant
Dim sale
Dim purc
Dim saletot
Dim purctot

If Product.Id > 0 Then

    Quant = Rdy.toDouble(DocRow.CustomField(30))
    sale = Rdy.toDouble(DocRow.CustomField(49))
    saletot = Quant * sale

    purc = Rdy.toDouble(DocRow.Product.InventoryValueFIFO(DocRow.Doc.DocDate))
    If purc = 0 Then
        purc = DocRow.Product.CustomField(700)
    End If
    purctot = Quant * purc

End If

Response.Write(Rdy.FormatCurrency(saletot - purctot))

frank
got the scrip in still doesn't show in view box but when I do a search with the scrip in I get this

Error executing script
Row : 9   Column : 0
Source : Microsoft VBScript runtime error
Error detail : Argument not optional: 'Product'


Error executing script
Row : 9   Column : 0
Source : Microsoft VBScript runtime error
Error detail : Argument not optional: 'Product'


Error executing script
Row : 9   Column : 0
Source : Microsoft VBScript runtime error
Error detail : Argument not optional: 'Product'


Error executing script
Row : 9   Column : 0
Source : Microsoft VBScript runtime error
Error detail : Argument not optional: 'Product'

Are you sure you've inserted the script in the view AFTER clicking on SHOW (F10) like I've told you in step 3?

frank

I deleted the script, than added it one step at the time,
don't get the run time error but still can't see it in the view option
I when step by step??

This is the reason why we usually do this use remote assitance... forum is not suitable for this kind of problem.
Call me on skype and I will have a look, even if I'm not a programmer and I'm not sure to be able to help you.