Dear Experts, I want total of MRP Value i.e., MRP of an item * Qty in invoice as MRP Value. Please help me to get this detail. Thanks.
[#Form: Export Invoice] Option : Global Export Invoice NP : @@IsSales or @@IsPurchase or @@IsCreditnote or @@IsDebitnote [!Form : Global Export Invoice NP] Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : Global Total MRP [Field: Global Total MRP] Use : Global VCH IAMRP ;;VAT Border : Totals Set as : $$AsAmount@GTotalMRP Format: "NoZero,Decimals:2" Width: 15 Set always : Yes Skip : Yes [System: Formula] GTotalMRP : $$CollNumTotal:InventoryEntries:$AIMMRPAMT [#Object : Inventory entry] AIMMRPAMT1 : $$Number:$AMRP * $$Number:$BilledQty AIMMRPAMT : $$Number:$AIMMRPAMT1
The above code is for displaying in voucher, i think you have to change $AMRP to $MRP because i have define UDF, In Print you define Field and Paste Set as : $$AsAmount@GTotalMRP you will get the result