HELLO EVERYONE, I CREATED AN EXTRA COLUMN IN VOUCHER AND PRINT SCREEN, WHICH WILL SHOW PER ITEM RATE BY DIVIDING VALUE OF ITEM BY ITS PRICE ANYONE CAN PLEASE CORRECT MY CODE AND ALSO MAKE ITS VALUE AVAILABE IN THE PRINT INVOICE THIS IS MY CODE [#Line : EI Column One] Add : Right Field: At Beginning: PERRATETITLE [Field: PERRATETITLE] Use : Name Field Set as: "Per Item Rate" Skip: Yes Width:10 Align: Center [#Line : EI Inv Info] Add: Right Field: At Beginning: PERRATE [Field: PERRATE] Use: Rate Price Field Set as: #VCHVALUE / #VCHRATE ; ( THIS IS NOT WORKING ) Width:10 Align: Center Set Always: Yes Skip: Yes StorageIR [System:udf] PIR:Rate:30120 ; ( confliction ) [#Line: EXPINV Column1] Add : Left Field : After : EXPINV DescTitle: PRATET [Field: PRATET] Use : ShortName Field Info : $$LocaleString:"PER ITEM RATE" Border : THIN LEFT Align : CENTER Style : Small Width : 8 [#Line: EXPINV InvDetails] Add: Field : After : EXPINV Desc: PRATE [Field: PRATE ] Use : ShortName Field Style : Small Align : Left Border : THIN LEFT Width : 8 Set as : $PIR Set Always : Yes please also make it available in print
You are referring the WRONG Field.......... as per your Invoice Data setup, find the MRP Field name and use that. The Conflict in UDF is because the number is out of range.......... make it e.g. 1115
Set as: #VCHVALUE / #VCHRATE THIS IS NOT WORKING BUT Set as: #VCHVALUE + #VCHRATE THIS IS WORKING I RENAMED THE "RATE" IN VOUCHER BY "MRP" ACTUALLY IT IS " VCH RateTitle " THIS FIELD
So if you renamed it......... Do not understand .......... Rate X Qty = Total....... now you want ........... Total / Rate = per Rate ......... Please do explain..........does not make any accounting or computational sense to me.............
YES SIR YOU ARE RIGHT Rate X Qty = Total (Provided by tally) Total / Rate = PER RATE ( I want as extra column in invoice)
SIR, IS THIS HELPFULL ?????? Qty * Rate(MRP) - Discount = Total Total / Rate = Per Rate Per rate is never be calculated is only shown.
42500/- -- Total ....... divide by Rate 500/- and you get 85....... which would be QUANTITY only. i.e. 100 Qty less 15% Discount = 85 Qty. If the nomenclature you are using is PER RATE........ then per rate would have been actually 425/-. i.e. 500/- less 15% Discount = 425/- Anyways .........as per your needs.......the FIELD VCH Rate is a "Rate Price Field", so you need to convert that in Number........$$Number:#VCHRate
SO SORRY SIR MY MISTEK THIS WILL BE : Qty * Rate(MRP) - Discount = Total Total / QTY = Per Rate SIR THANK YOU SO MUCH THIS FUNCTION WORKED CORRECTLY, I M GETTING ALL THE DETAILS I WANT. HEARTILY INDEBTED FOR YOUR SINCERE HELP
Good... and please do not use ALL CAPS when typing....it is considered rude, shouting and ill mannered. Please type in normal. ALL CAPS is not good as per internet communication etiquette. Thank You.