Dear Experts, I have a code for exporting the sales vouchers from excel to tally, in that i need Batch Name, Mfg Date & Exp Date. I changed the code as bellow and Batchname & Mfg Date is importing to tally but Exp date is getting error Please help me to solve this problem My Code: 10800 : INSERT COLLECTION OBJECT: Batch Allocations 10810 : SET TARGET: Batch Allocations[1] 10820 : SET VALUE : GodownName : $Column18;"Main Location" 10821 : Set Value : BatchName : $Column19 10822 : Set Value : MfdOn : $Column20 10823 : Set Value : EXPIRYPERIOD : $Column21 10830 : SET VALUE : ActualQty : -($$TgtObject$$AsQty:##Qtys)) 10840 : SET VALUE : BilledQty : -($$TgtObject$$AsQty:##Qtys)) 10850 : SET VALUE : Rate : ($$AsAmount:$Column10) /($$TgtObject$$AsQty:##Qtys)) 10860 : SET VALUE : Amount : $$AsAmount:$Column10 Error: Function: 'Sales Import LABEL' : 10823 : Action execution failed!
you mean 10823 : Set Value : EXPIRYPERIOD : $$Date:$Column21 Like the above Sir? But it is also not working
SALINVDATE : $$Date($$StringPart:$SCPDVchDate:8:2) + "-" + + ($$StringPart:$SCPDVchDate:5:2)+ "-" + + ($$StringPart:$SCPDVchDate:0:4))
I tried the above and it is also showing the same error, I tried like below also getting the same error 10823 : Set Value : EXPIRYPERIOD : $$DateRange:$Column21$$TgtObject:$Date):True Error:Function: Sales Import Label: 10823:Action Execution Failed!
refer following foumula for better understanding DualExpPeriod : $$SPrintf@ToDateFormat@ExpFromDt@ExpStrToDt
Try This... Variable : VExpiryDate : String 100 : Set : VExpiryDate : $Column21 110 : SetValue : EXPIRY PERIOD : $$DateRange##VExpiryDate):##VExpiryDate (Or) Variable : VExpiryDateTemp : String Variable : VExpiryDate : Due Date 100 : Set : VExpiryDateTemp : $Column21 110 : Set : VExpiryDate : $$DateRange##VExpiryDateTemp):$Date ;;; OR $$Owner:$Date 120 : SetValue : EXPIRY PERIOD : $$Tgtobject:##VExpiryDate (Or) Variable : VExpiryDateTemp : String Variable : VExpiryDate : Due Date 100 : Set : VExpiryDateTemp : $Column21 110 : Set : VExpiryDate : $$DateRange##VExpiryDateTemp):##VExpiryDateTemp 120 : SetValue : EXPIRY PERIOD : $$Tgtobject:##VExpiryDate