B1 Formatted Search Query: Volume & Weight Calculation

[clementchoi]

Hello all, 

I'm trying to write a FMS Query which will be able to show the total weight of a GRPO before it is posted. The same information can be found in the "Volume & Weight Calculation" window (Ctrl + W), in this case I would like to obtain the value "5903" and put under Total Weight (GRPO) via a FMS. May I know if this is feasible?

#SAP Business One

KR,

Clement

[BattleshipCobra]

I hate to be the bearer of bad news but you can't do what you're asking with stock SAP using an FMS.

If the data is not in the database then you can't pull it with FMS from a grid.  There is no way I know of that can loop the columns to do the total.  There is the "Volume and Weight Calculation" menu which shows it but you have to click into it (icons along the top).

Once the document is added, then the weight is totaled and stored at the header level and you can use something like SELECT $[OPDN.Weight] (SQL) and SELECT $[OPDN.Weight] FROM DUMMY (HANA) in FMS format to pull the info.

The issue with FMS queries is you can't loop the rows to do any totals UNLESS you have either an SDK add-on or something like B1UP.  You could easily loop through the rows and do a total of a column with B1UP using a WHILE loop or some UI API code.

Without it you will be stuck with the "Volume and Weight Calculation" menu.

If you do have B1UP I can help you with a macro to pull the information you need, B1UP can also place the fields better than the SAP UI editing.  Check out my demo:

http://b1updemo.battleshipcobra.com

Mike