Formula to return quantity of stock sold

Jet Reports Historic Posts

February 20, 2015 13:08

None

Not using the GL function since that will only pull financial information such as balance, budget, credits and debits.

You would need to use the NL(Sum) function to sum up the quantity of something in your database.

Date Votes

2 comments

0

Jet Reports Historic Posts February 20, 2015 13:08

Is it possible return quantity of stock sold for a specific dimension.

For example, the formula below returns the sales for the specific dimension:

=GL("Balance","50100","01/12/2014","31/12/2014","CONTRACTS",,"Total Argentina",,,,,Company A)

i want to be able to return the total quantity of stock items sold under those parameters

Comment actions Permalink
0

Jet Reports Historic Posts February 22, 2015 12:40

perfect

nl sum on sales invoice line qty sold, minus the same re sales cr memos filtered by dimension works here,

thanks

Comment actions Permalink

Please sign in to leave a comment.