dear experts, i have to get stock item standard selling price in rate (inclusive of tax) table. i tried by i am getting errors or no result ;; 1st try [#Field:VCH Rateincl] set as:STKitem StdPrice Skip Forward:Yes Set Always : Yes ;; 2ND try [#Field:VCH Rateincl] set as:#STKitem StdPrice Skip Forward:Yes Set Always : Yes ;; 3rd try [#Field:VCH Rateincl] set as:$STKitem StdPrice Skip Forward:Yes Set Always : Yes ;;4th try [#Field:VCH Rateincl] set as:Stockitem StdPrice Skip Forward:Yes Set Always : Yes ;;5th try [#Field:VCH Rateincl] set as:Standard selling Price Skip Forward:Yes Set Always : Yes
When you are referring to any Object/variable etc in SET AS.......... never give a space/gap.......... If a Field name is -------- Standard Selling Price......... In Set As : you have to omit the space. ---- #Standardsellingprice
You topical is same as your previous THREADS,,,,,,,, then continue using the same thread....... no need to open a new THREAD everyday or for every query.
yes Amit sir, This is related to my previous query. But as Plan 'A' failed, i am trying for plan' B'. Thank u sir for you Valuable reply and support.
dear Amit sir, the code is not working. please help me... [#Field:VCH Rateincl] set as:#Standardsellingprice Skip Forward:Yes Set Always : Yes
I have not given you the solution......Please read my post again.........."If a field name is ........" .....IF ...... you have to use whatever the field name you are referring to.
sir, still code is not working. i am seeking your help... [#Field:VCH Rateincl] set as:#STKITEMstandardprice [#Field:VCH Rateincl] set as:#stockitemstandardprice
Method Name For Standard Selling Price is --$StandardPrice Method Name For Standard Purchase Price is-- $StandardCost You want to fetch Standard Selling Price according to stock Item So, You have to fetch it according to stock item name Example: [Field: Example] Set as: $StandardPrice:StockItem:$StockItemName For Standard Purchase Price [Field: Example] Set as: $StandardCost:StockItem:$StockItemName
There are many Solutions For This Problem Here is the list 1. Which I told You 2. By Using CollectionFieldByKey Function 3. Creating a own function Which Will return the desired value... List can continue But I suggest you to improve your basics first after that You will Find Tdl Easy
dear experts, Help needed for for hiding stock items. i need to hide the stock items in stock items list when the closing balance becomes zero"0". and should unhide when closing balance is more than zero. please guide me. what function to use to hide stock item- inactive or invisible or any other function.... [#Field: VCHACC StockItem] Inactive :if($StockItem:#VCHStockItem:$ClosingBalance contains " 0 ") then No else Yes
Do not understand your LOGIC...... Assume...Stockitem ABC is 0 ...... but you are entering a voucher.....then how do you want that field to be inactive......??? The very fact that you are entering a VOUCHER with a stockitem which was previously 0........ now you are increasing the quantity.........if your formula works, then it means you would not be able to enter any new StockItems. Second...your formula is correct, but in the wrong order........... please refer Developer to get the formula in the right order. Also when number/amount is concerned you should not use "Contains" ............ instead you should use "+" ," -" . "/", ' * ' or " = " signs.
dear sir, i want to to temporary hide the stock items when the closing stock is zero, while passing sales voucher . and show(unhide) stock items when closing stock is more than zero in stock item list.....
Syntax To Find Something In this we will find Parent of the stock Item <Method Name Which you Want to find>: <Source Object>:<Key Value> Example: $Parent:StockItem:$StockItemName Please Try to understand rather than Copy Pasting Codes... I already gave you multiple solutions based on this syntax
Invisible Attribute is working in vch stock item field. but i want Invisible Attribute in "list of stock items". please help sir.
In list of accounts......which is a table/collection ..... you can only filter it.......... the attributes like Invisible etc are not applicable to tables/collections.
You have already been helped ..... TWICE....... the syntax also given by Himanshu. You have to understand, learn and apply. If others do simple corrections for you, then you will not gain any knowledge.