Need Help. Unable to Compute UDF Value. Compute : My2AStat505 : $GSTReciSts [System: UDF] GSTReciSts : String : 30081
In Invoice, you UDF can be associated Header Part (ie with InvNo and Date) or with Ledger Entries or with Inventries Entries, Batch etc. Make it clear
@Bidyut Banerjee i modifed a custom purchase inventory explode report(from this forum) and also created a udf in purchase voucher to store clients against whom purchases are done, i am unable to fetch the udf value in the report, kindly guide me to fetch the value to the report
There is 2 Solution for this issue 1. Add your UDF in Object Voucher Example: [#Object: Voucher] MyUDF: $MyUDF Now, You can compute or fetch this UDF 2. If you Export that Voucher which contains that UDF Then you will find out that There is a collection of UDF which you stored Example: Walk: MyUDF Compute:MyUDF:$MyUDF
; my udf field [Field: VCHorderbyNamedr] Use : Name Field Storage : VCHorderbyName Set as : $VCHorderbyName Width : 25 Table : filterledgerCLIENT, not applicable Show Table: Always ;Key : Create orderbyName Background: "Orchid2" ;association with object voucher [#Object:voucher] vchorderbyname:$vchorderbyname [Collection: PQRSalesManVouchersColl] Type:Vouchers:VoucherType Child Of:$$VchTypePurchase Belongs To:Yes ;Filter : PQRSaleManVouchers ;Filter : SalesManFilter ;computing the values thru collection [Collection:Sales AllVoucher] Source CollectionQRSalesManVouchersColl Walk:Inventory Entries Compute : PQRPartySalesMan :$vchorderbyname Compute : PQRPartyVchNo :$REFERENCE Compute : PQRPartyDate :$Date hope this is the way you guided me @Himanshu-2002 the value is still not fetching plz help
In main collection fetch UDF Values as suggested by Narayan Sir Example: [Collection: MyMainColl] Type: Vouchers: VoucherType Child of : $$VchTypePurchase Belong To: Yes Fetch: MyUDFName If this didn't work then Export that voucher in xml and Check XML Contains your UDF Or Not
And One More Thing if You compute PartyName as PartyLedgerName Then You will use PartyName as a method Name Example: ComputeartyName: $PartyLedgerName [Field: MyField] Set as :$PartyName
it is fetching in xml ok <UDF:VCHORDERBYNAME.LIST DESC="`VCHorderbyName`" ISLIST="YES" TYPE="String" INDEX="375"> <UDF:VCHORDERBYNAME DESC="`VCHorderbyName`">UDF value stored </UDF:VCHORDERBYNAME> </UDF:VCHORDERBYNAME.LIST> great learning from xml export thanks for the idea one more thing once i have added object voucher to udf it is showing incorrect storage error during voucher entry
[#Object:voucher] vchorderbyname:$vchorderbyname You cannot have SAME name as your UDF......... myvchorderbyname:$vchorderbyname
thnx @narayane @Himanshu-2002 @Amit Kamdar with your guidance and knowledge , i am in medium pace learning mode on, amit sir ur tit bit guidance has always been a guiding star for all of us and himanshu sir your knowledge of functions is my envy, hope to grasp functions like you , this part of my project is complete
Same logic .... age old logic ....... differentiation and identification. Any definitions in OBKECT is Global. (So diff name to UDF is required) Any COMPUTE in Collection is Local. (So same name can be allowed)
[Collection: PQRSalesManVouchersColl] Type:Vouchers:VoucherType Child Of:$$VchTypePurchase Belongs To:Yes Fetch:myvchorderbyname1; UDF [Collection:Sales AllVoucher] Source CollectionQRSalesManVouchersColl Walk:Inventory Entries Compute : PQRNewdisc :$myVCHorderbyName1 ;UDF this collection is fetching udfs in a report properly , now when i add data source: parent group: selected line to the main collection ,every thing other than UDF is fetched, please guide how to fetch the udf in the report collection , coz i have computed as well as made object of the UDFs, still have no answer