USE EXCEL FIRST COLUMN FOR PARTY NAME & SECOND FOR GSTN DATA ROW FROM 2 [Function:GSTN MODIFY] Variable:NIT_GSN:String Variable:NIT_PARTYnAME:String Variable : RowIndex : Number:2 010 : Open File : ##VCHFilepathEnter : Excel : Read 020 : While : NOT $$IsEmpty:$$FileReadCell:##RowIndex:1 030: Set:NIT_GSN :IF $$IsEmpty:$$FileReadCell:##RowIndex:2 THEN "" ELSE $$FileReadCell:##RowIndex:2 040: Set: NIT_PARTYnAME:$$FileReadCell:##RowIndex:1 050: START PROGRESS : 1000000: "UPDATING GSTN" : @@CmpMailName : "UPDATING GSTN ..."+ $$NewLine + "GSTN NO.:"+ $$String:##NIT_PARTYnAME 055: Modify Object: (ledger, ##NIT_PARTYnAME).GSTRegistrationType@DEFINERTYPE 060: Modify Object: (ledger, ##NIT_PARTYnAME).PartyGSTIN:##NIT_GSN 070 : INCREMENT : RowIndex 080: Show Progress:##RowIndex 090: End Progress 100: End While [System:Formulas] DEFINERTYPE:IF $$IsEmpty:##NIT_GSN Then "Unregistered" else "Regular"
Dear sir How to update custom UDF in ledger ? In this code I made this change Delete line 055 Change 060 line 060: Modify Object: (ledger, ##NIT_PARTYnAME). myudfstorage:##NIT_GSN But not change in ledger. Please help
This is my code And Excell file Attached Code: [#Part :LedOtherDetails] Add : Line : hkledtransport [Line : hkledtransport] Fields : Short Prompt, ledtransport Local : Field : Short Prompt : info : "Transport- :" [Field : ledtransport] Use : name Field Setas : " " Storage : ledtransportname [system : udf] ledtransportname : string : 10006 /* ;;USE EXCEL FIRST COLUMN FOR PARTY NAME & SECOND FOR GSTN DATA ROW FROM 2 */ [Function:GSTN MODIFY] Variable:NIT_GSN:String Variable:NIT_PARTYnAME:String Variable : RowIndex : Number:2 010 : Open File : "excel file hktransportlist.xlsx full path with file name" : Excel : Read 020 : While : NOT $$IsEmpty:$$FileReadCell:##RowIndex:1 030: Set:NIT_GSN :IF $$IsEmpty:$$FileReadCell:##RowIndex:2 THEN "" ELSE $$FileReadCell:##RowIndex:2 040: Set: NIT_PARTYnAME:$$FileReadCell:##RowIndex:1 050: START PROGRESS : 1000000: "UPDATING GSTN" : @@CmpMailName : "UPDATING GSTN ..."+ $$NewLine + "GSTN NO.:"+ $$String:##NIT_PARTYnAME 060: Modify Object: (ledger, ##NIT_PARTYnAME).ledtransportname:##NIT_GSN 070 : INCREMENT : RowIndex 080: Show Progress:##RowIndex 090: End Progress 100: End While
update this line working fine my side 060: Modify Object: (ledger, ##NIT_PARTYnAME).ledtransportname.ledtransportname:##NIT_GSN