on 03-25-2012 6:29 AM
i am trying to migrate transaction date to the ordr table through the dtw one error is comming ie.
set property value failed: value must be a whole number in property 'importfilenum' of document 65171
.
Hi,
To DTW sales order, you have to include RDR1 for line. DocTotal is no need. It can be calculated from line file.
Thanks, Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Seenu....
Please be sure that the date format in DTW Template should be YYYYMMDD.....
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, i changed the sales order date in the form of yyyymmdd but still one error is comming...ie.
Set property value failed ..value must be a whole number in property import file num of doc 65171.. could u please tell me the reason...
here is the file what i imported to the sap
DocNum | DocType | Handwrtten | Printed | DocDate | DocDueDate | CardCode | CardName | Address | NumAtCard | DocCur | DocRate | DocTotal | Ref1 | Ref2 | Comments | JrnlMemo | GroupNum | DocTime | SlpCode | TrnspCode | Confirmed | ImportEnt | SummryType | CntctCode | ShowSCN | Series | TaxDate | PartSupply | ObjType | ShipToCode | Indicator | LicTradNum | DiscPrcnt | PaymentRef | DocTotalFC | Form1099 | Box1099 | RevisionPo | ReqDate | CancelDate | BlockDunn | Pick | PeyMethod | PayBlock | PayBlckRef | CntrlBnk | MaxDscn | Project | FromDate | ToDate | UpdInvnt | Rounding | CorrExt | CorrInv | DeferrTax | LetterNum | AgentCode | Installmnt | VATFirst | VatDate | OwnerCode | FolioPref | FolioNum | DocSubType | BPChCode | BPChCntc | Address2 | PayToCode | ManualNum | UseShpdGd | IsPaytoBnk | BnkCntry | BankCode | BnkAccount | BnkBranch | BPLId | DpmPrcnt | isIns | LangCode | TrackNo | PickRmrk | ClsDate | SeqCode | Serial | SeriesStr | SubStr | Model | UseCorrVat |
246 | I | 20091214 | 20091214 | C42000 | Mashina Corporation | 400 Range Road New Delhi - 110 005 IN | NULL | INR | 1 | 2059 | 246 | NULL | Based On Sales Quotations 238. | Sales Orders - C42000 | 2 | 5 | 5 | Y | NULL | N | NULL | N | 5 | 20091412 | Ship To | 0 |
hi Mr Seedu,
your thread is duplicated. i have already replied from this thread: http://scn.sap.com/thread/3150468
Please note: do not duplicate your thread with the same question.
i will quote my reply from your other thread.
hi Mr. Seenu,
you may try this
NumAtCard - if null dont put the word "Null" for null Values use the character "\"
Ref2 - if null dont put the word "Null" for null Values use the character "\"
ImportEnt - if null dont put the word "Null" for null Values use the character "\"
CntctCode - if null dont put the word "Null" for null Values use the character "\"
hope this will be helpful to you,
regards,
Fidel
hi Seenu,
its better if you can post even 2 lines of your template for us to see it..
regards
Fidel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi... Thanks for replying to me.. here is the another problems
I am trying to import to the sales order transation date through the dtw it is showing the error like
Set property value failed ..value must be a whole number in property import file num of doc 65171.. could u please tell me the reason...
here is the file what i imported to the sap
DocNum | DocType | HandWritten | Printed | DocDate | DocDueDate | CardCode | CardName | Address | NumAtCard | DocCurrency | DocRate | DocTotal | Reference1 | Reference2 | Comments | JournalMemo | PaymentGroupCode | DocTime | SalesPersonCode | TransportationCode | Confirmed | ImportFileNum | SummeryType | ContactPersonCode | ShowSCN | Series | TaxDate | PartialSupply | DocObjectCode | ShipToCode | Indicator | FederalTaxID | DiscountPercent | PaymentReference | DocTotalFc | Form1099 | Box1099 | RevisionPo | RequriedDate | CancelDate | BlockDunning | Pick | PaymentMethod | PaymentBlock | PaymentBlockEntry | CentralBankIndicator | MaximumCashDiscount | Project | ExemptionValidityDateFrom | ExemptionValidityDateTo | WareHouseUpdateType | Rounding | ExternalCorrectedDocNum | InternalCorrectedDocNum | DeferredTax | TaxExemptionLetterNum | AgentCode | NumberOfInstallments | ApplyTaxOnFirstInstallment | VatDate | DocumentsOwner | FolioPrefixString | FolioNumber | DocumentSubType | BPChannelCode | BPChannelContact | Address2 | PayToCode | ManualNumber | UseShpdGoodsAct | IsPayToBank | PayToBankCountry | PayToBankCode | PayToBankAccountNo | PayToBankBranch | BPL_IDAssignedToInvoice | DownPayment | ReserveInvoice | LanguageCode | TrackingNumber | PickRemark | ClosingDate | SequenceCode | SequenceSerial | SeriesString | SubSeriesString | SequenceModel | UseCorrectionVATGroup |
DocNum | DocType | Handwrtten | Printed | DocDate | DocDueDate | CardCode | CardName | Address | NumAtCard | DocCur | DocRate | DocTotal | Ref1 | Ref2 | Comments | JrnlMemo | GroupNum | DocTime | SlpCode | TrnspCode | Confirmed | ImportEnt | SummryType | CntctCode | ShowSCN | Series | TaxDate | PartSupply | ObjType | ShipToCode | Indicator | LicTradNum | DiscPrcnt | PaymentRef | DocTotalFC | Form1099 | Box1099 | RevisionPo | ReqDate | CancelDate | BlockDunn | Pick | PeyMethod | PayBlock | PayBlckRef | CntrlBnk | MaxDscn | Project | FromDate | ToDate | UpdInvnt | Rounding | CorrExt | CorrInv | DeferrTax | LetterNum | AgentCode | Installmnt | VATFirst | VatDate | OwnerCode | FolioPref | FolioNum | DocSubType | BPChCode | BPChCntc | Address2 | PayToCode | ManualNum | UseShpdGd | IsPaytoBnk | BnkCntry | BankCode | BnkAccount | BnkBranch | BPLId | DpmPrcnt | isIns | LangCode | TrackNo | PickRmrk | ClsDate | SeqCode | Serial | SeriesStr | SubStr | Model | UseCorrVat |
246 | I | 20091214 | 20091214 | C42000 | Mashina Corporation | 400 Range Road New Delhi - 110 005 IN | NULL | INR | 1 | 2059 | 246 | NULL | Based On Sales Quotations 238. | Sales Orders - C42000 | 2 | 5 | 5 | Y | NULL | N | NULL | N | 5 | 20091412 | Ship To | 0 |
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.