Update Stock Master During Sales Transaction

If you want to update stock master at the time of sales transaction then you have to use bellow process.

Step 1:- Add UDF in stock master. Which value needs to update.

Step 2:- Add UDF in Sales Entry in ALLINVENTORYENTRIES.

Step 3:- Write a function on sales form Accept and update the master bellow code will be help you.

<br /> <br /> [#Line: EI ColumnOne]<br /> <br /> add : option :EI ColumnOne22 :@@issales <br /> <br /> [!Line: EI ColumnOne22]<br /> <br /> add : right field : before:VCH QtyTitle:yen <br /> <br /> <br /> [#Line: EI InvInfo] <br /> add : option :opSalesorder1x :@@issales <br /> <br /> [!Line: opSalesorder1x] <br /> <br /> Add : right field : before:VCH BilledQty:yen2 <br /> <br /> [field :yen]<br /> use : Short Name Field<br /> width : 1 inch<br /> align : centre<br /> skip : yes<br /> Setas : "Kacha"<br /> [field :yenx]<br /> use : Short Name Field<br /> width : 1 inch<br /> align : centre<br /> skip : yes<br /> Setas : "Type" <br /> <br /> [field :yen2]<br /> use : amount Field<br /> width : 1 inch<br /> align : centre<br /> Storage:rt1<br /> Set Always: yes <br /> <br /> [field :yen2a]<br /> use : amount Field<br /> width : 1 inch<br /> align : centre<br /> Storage:rt2<br /> Set Always: yes<br /> <br /> [System:UDF]<br /> rt1:Amount:1125<br /> rt2:Amount:1126<br /> kacha:Amount:1127<br /> paka:Amount:1128<br /> <br /> [#Part: STKI Basic Features]<br /> add : option:opSTKIBasicFeatures1<br /> <br /> [!Part :opSTKIBasicFeatures1]<br /> add : part : after :STKI Units : PFreeRate <br /> <br /> <br /> [Part :PFreeRate]<br /> line :FreeRatea <br /> <br /> [line :FreeRatea]<br /> field : short prompt, FreeRatea<br /> local : field : short prompt : set as : "Kacha Rate"<br /> <br /> [Field : FreeRatea]<br /> use : amount field<br /> storage : kacha<br /> set always : yes<br /> <br /> <br /> [#Form: sales color]<br /> <br /> On : Form Accept : Yes: Call: Test Function<br /> <br /> [Collection : GetInvDetails]<br /> <br /> Source Collection : .<br /> Walk : ALLINVENTORYENTRIES<br /> By : StockItemName : $StockItemName<br /> Fetch : StockItemName,RT1,RT2<br /> <br /> [Function : Test Function]<br /> <br /> <br /> Variable : StockItemNameVar : String<br /> Variable : VarKacharate : Amount<br /> Variable : VarPakaRate : Amount<br /> 10 : Walk Collection : GetInvDetails<br /> <br /> 20 : set : StockItemNameVar : $StockItemName<br /> <br /> 30 : Set : VarKacharate : $RT1<br /> 41P : Call : StockUpdateFunction:##StockItemNameVar:##VarKacharate:##VarPakaRate<br /> 40A : End Walk<br /> <br /> [Function: StockUpdateFunction]<br /> <br /> <br /> Parameter: VarStock : String<br /> Parameter: VarKahaRate : Amount<br /> Parameter: VarPakaRate : Amount<br /> <br /> <br /> <br /> 010 : New Object : StockItem : ##VarStock : Yes<br /> <br /> 12 : Set Value : kacha : $$TgtObject:##VarKahaRate<br /> <br /> 50 : Alter Target<br /> <br /> <br /> <br />

Update Stock Master Screen:-