I am trying to get quantity as a result and according to function wizard i should quite easily do so by putting in "quantity" in the what field for GL.It even says that i can choose the quantity option in th ewhat parameter
Navision: Determines what the GL Function returns. Options are Balance, Budget, Quantity, Credits or Debits
Great Plains: Determines where the GL function returns its data. Options are "Rows", "Columns", "Sheets", and "Cell". "Rows" will insert rows, "Columns" will insert columns, "Sheets" will insert sheets, and "Cell" will put a single value in the current cell. Additionally, you can use "Rows=x" and "Columns=x" to insert multiple rows or columns for each result, which works just like the NL function. If you leave this argument blank, it defaults to "Cell".
Note that the options available for the What argument depend on the Where argument. See the next argument for more details.
However, when i drill into what the only options i get is
balance,budget,credits,debits
is there something not right in my settings? hOW DO I GET TO CHOOSE QUANTITY?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Nick,
The help article you're reading is out of date. There used to be a way to specify quantity in the GL function in Jet v7 and earlier, but you had to also specify in the Jet options what field on your G/L Entry table you wanted to get the quantities from since it could be different in different cases. This was too complicated for most users, and was eliminated in Jet 2009. If you want to sum quantities now, you should just use an NL(Sum) function on the G/L Entry table.
Regards,
Hughes -
Jet Reports Historic Posts thank you
Please sign in to leave a comment.