VFP Expression to format the Instock figure correctly when using factoring in stock

richardd

Hi,  got a request to export some data out to Excel and a regular basis so just going to write some VFP code and export to excel.  Their stock is linked stock profiles which uses a range of different PACK sizes.  Opera must have internal formula to display the instock figures on screen in the correct format. 

Does anybody know the VFP formula / code to output the instock data in the correct format (so it looks like it does in Opera) ?

Many thanks

Rick

alan-bourke

Are you doing this as part of a Developer's Toolkit project or completely outside of Opera? Opera itself uses a function called sqexpquan(), which you can see if you look at the quantity field on the invoice layout, for example. So if you're not running qwithin Opera you would have to replicate what that function does - it's a bit too big a task for a single expression.