In my custom report cam unable to get salesman name, can you please help me out. [Collection: SD Report Items] Source Collection : SD Report Walk : Inventory Entries By : VNo : $VoucherNumber By : StockItem : $StockItemName Compute : ptyname : $PartyName Aggr Compute : BQty : Sum: $BilledQty Compute : Disc : $Discount Aggr Compute : Value : Sum: $Amount Compute : Date : $Date Compute : SMName : $VCHsalesman [Collection: SD Report] Type : Vouchers : VoucherType Child Of : $$VchTypeSales Belongs To : Yes Fetch : InventoryEntries.*,VoucherNumber,VCHsalesman
I am creating in Sales Voucher, then I wanted salesman name in my custom report but I am unable to get that name, Plz help..
[Line: EI Salesman Det] Field : Medium Prompt, EI Salesman Det Local : Field : Medium Prompt : Set as : "Salesman Name : " [Field: EI Salesman Det] Use : Short Name Field Table : CMP Salesman, Not Applicable Show Table : Always Storage : VCHSalesman [System: UDF] VCHSalesman : String : 9010
My Friend....better if you post a screenshot with the placement of your FIELD.... In your collection you are walking... Inventory Entries............ is it within the Sub-Object collection Inventory Entries ??? Try..... $LedgerEntries.VchSalesman ........... Also try to objectify your UDF in [#Object : voucher]
in collection you have written Compute : SMName : $VCHsalesman where it is walking over "inventory entries" but i understand that sales man is above inventory entries so write it like this Compute : SMName : $$Owner:$VCHsalesman