To Retrive Qty Field

Dear All,

In Sales & Purchase voucher, how to retrive QTY Field of what the user enters.

Thanks

 

Hai,

For Actual qty Use "$ActualQty"
For Billed Qty Use "$BilledQty"

 

Dear Marudhachala,

Thanks for the reply but what exactly i needed is to calculate the qty entered by the user Multiply by MRP, But it is not working, when i save the voucher then again i open that voucher then it show the value.

Thanks

 

Hi,

Please send the Code so that i can guide you.

 

Sir,

I invoice iam using following code to get Total MRP of Goods Sold, but it is not working.



[Line : AGTMrp]
Fields: Simple Prompt, Simple Field
Local: Field: Simple Prompt: Info: "Total MRP "
Local: Field : Simple Field: Set As: ($$CollectionField:$AMRP:StockItem:$StockItemName:1:LedgerEntries) * ($$CollectionField:$BilledQtyAMRP:1:LedgerEntries)
Local: Field: Simple Field: Style: Large Bold
Space Top: 0.25
Space Bottom: 0.25

 

Sir,
First i tried to get the Total MRP Goods Sold in the voucher but it is not working, then i tried in the customised invoice (the above code) there also it is not working.

Thanks



[#Line : EI InvInfo]
Option : Global EI InvInfo
[!Line: Global EI InvInfo]
Add: Right Fields: At Beginning : Global IACode, Global IAMRP, Global IAMVAT
[Field : Global IACode]
Use: Short Name Field
Set As: $OnlyAlias:StockItem:$StockItemName
Align: Centre
Border : Thin Left Right
Width: 15
Skip: YES
[Field : Global IAMRP]
Use: Number Field
Storage: AMRP
Set As: $AMRP:StockItem:$StockItemName
Format: "NoZero,Decimals:2"
Align: Centre
Border : Thin Left Right
Skip: YES
[Field : Global IAMVAT]
Use: Number Field
Set As: $RateOfVAT:StockItem:$StockItemName
Format: "NoZero, Percentage"
Align: Centre
Border : Thin Left Right
Skip: YES

[#Form: Export Invoice]

Option : Global Export Invoice NP : @@IsSales

[!Form : Global Export Invoice NP]

Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : Global Total MRP

[Field: Global Total MRP]

Use : Global IAMVAT
Border : Totals
Set as : $$String@NumNumTotal
Set always : Yes
Skip : Yes


[System: Formula]

NumTotal : $$Number:$AMRP * $BilledQty
NumNumTotal : $$CollNumTotal:InventoryEntries@NumTotal

 

Hi,

Have you added the MRP Value in Stock Item Master. Please attach the complete code to debug or provide the solution.

 

Sir,
Attached herewith the code for your reference

Thanks

 

hai,

Find attached corrected code.

 

Thank you very much for getting my problem solved.

Thanks once again