cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Value too long in property 'Currency'

Go to solution
Former Member

on ‎09-10-2014 7:38 AM

0 Kudos

Hi SCN,

Im trying to upload AR Open Balance using DTW, But I encountered an error such Value too long in property 'Currency' And when I checked the template I used, I only used 3 values, which was PHP. How can I resolve this?

Regards,

Mahj

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎09-11-2014 10:56 PM
0 Kudos

Hi Mahj,

Try this:

ParentKeyLineNumItemDescriptionPricePriceAfterVATCurrencyAccountCode
DocNumLineNumDscriptionPricePriceAfVATCurrencyAcctCode
9000000010SERVICE MAINTENANCE FOR THE MONTH OF NOVEMBER 20114939.24939.2PHP19121104
9000000020SERVICE MAINTENANCE FOR THE MONTH OF SEPTEMBER 20132074.482074.48PHP19121104
9000000030SERVICE MAINTENANCE FOR THE MONTH OF JULY 201493351.393351.3PHP19121104
9000000040SERVICE MAINTENANCE FOR THE MONTH OF AUGUST 201493351.393351.3PHP19121104
9000000050SERVICE MAINTENANCE FOR THE MONTH OF JULY 201450909.0950909.09PHP19121104
9000000060SERVICE MAINTENANCE FOR THE MONTH OF AUGUST 201450909.0950909.09PHP19121104
9000000070SERVICE MAINTENANCE FOR THE MONTH OF MAY 2014131007131007PHP19121104
9000000080SERVICE MAINTENANCE FOR THE MONTH OF JUNE 2014131007131007PHP19121104
Show replies
Show replies
Former Member
‎09-12-2014 3:25 AM
0 Kudos

I uploaded it correctly by copying all its detail and paste in on another template. Thank you for all your help. Appreciate it a lot!

Answers (3)

Answers (3)

Former Member
‎09-10-2014 7:47 AM
0 Kudos

Hi,

Use 'Y' Or 'N' for property field.

ragards,

raviraj

Show replies
Show replies
former_member186712
Active Contributor
‎09-10-2014 7:45 AM
0 Kudos

Hi Mahj,

If you have empty column in your template, remove them and try again.

Regards,

Augusto


Show replies
Show replies
Former Member
‎09-10-2014 8:35 AM
0 Kudos

I tried this but nothing works

kothandaraman_nagarajan
Active Contributor
‎09-10-2014 7:41 AM
0 Kudos

Hi,

Please post your template here to check.

Thanks & Regards,

Nagarajan

Show replies
Show replies
Former Member
‎09-10-2014 7:53 AM
0 Kudos
ParentKeyLineNumItemCodeItemDescriptionQuantityShipDatePricePriceAfterVATCurrencyRateAccountCodeUseBaseUnitsSupplierCatNumCostingCodeProjectCodeBarCodeVatGroupHeight1Hight1UnitHeight2Height2UnitLengh1Lengh1UnitLengh2Lengh2UnitWeight1Weight1UnitWeight2Weight2UnitFactor1Factor2Factor3Factor4BaseTypeBaseEntryBaseLineVolumeVolumeUnitWidth1Width1UnitWidth2Width2UnitAddressTaxCodeTaxTypeTaxLiableBackOrderFreeTextShippingMethodCorrectionInvoiceItemCorrInvAmountToStockCorrInvAmountToDiffAcctWTLiableDeferredTaxMeasureUnitUnitsOfMeasurmentLineTotalTaxPercentagePerRowTaxTotalConsumerSalesForecastExciseAmountCountryOrgSWWTransactionTypeDistributeExpenseShipToCodeRowTotalFCCFOPCodeCSTCodeUsageTaxOnlyUnitPriceLineStatusLineTypeCOGSCostingCodeCOGSAccountCodeChangeAssemlyBoMWarehouseGrossBuyPriceGrossBaseGrossProfitTotalBasePriceCostingCode2CostingCode3CostingCode4CostingCode5ItemDetailsLocationCodeActualDeliveryDateExLineNoRequiredDateRequiredQuantityCOGSCostingCode2COGSCostingCode3COGSCostingCode4COGSCostingCode5WithoutInventoryMovementAgrementNoAgreementRowNumberShipToDescription
DocNumLineNumItemCodeDscriptionQuantityShipDatePricePriceAfVATCurrencyRateAcctCodeUseBaseUnSubCatNumOcrCodeProjectCodeBarsVatGroupHeight1Hght1UnitHeight2Hght2UnitLength1Len1Unitlength2Len2UnitWeight1Wght1UnitWeight2Wght2UnitFactor1Factor2Factor3Factor4BaseTypeBaseEntryBaseLineVolumeVolUnitWidth1Wdth1UnitWidth2Wdth2UnitAddressTaxCodeTaxTypeTaxStatusBackOrdrFreeTxtTrnsCodeCEECFlagToStockToDiffWtLiableDeferrTaxunitMsrNumPerMsrLineTotalVatPrcntVatSumConsumeFCTExciseAmtCountryOrgSWWTranTypeDistribExpShipToCodeTotalFrgnCFOPCodeCSTCodeUsageTaxOnlyPriceBefDiLineStatusLineTypeCogsOcrCodCogsAcctChgAsmBoMWGrossBuyPrGrossBaseGPTtlBasPrOcrCode2OcrCode3OcrCode4OcrCode5TextLocCodeActDelDateExLineNoPQTReqDatePQTReqQtyCogsOcrCo2CogsOcrCo3CogsOcrCo4CogsOcrCo5NoInvtryMvAgrNoAgrLnNumShipToDesc
9000000011SERVICE MAINTENANCE FOR THE MONTH OF NOVEMBER 20114939.20PHP119121104
9000000021SERVICE MAINTENANCE FOR THE MONTH OF SEPTEMBER 20132074.48PHP119121104
9000000031SERVICE MAINTENANCE FOR THE MONTH OF JULY 201493351.30PHP119121104
9000000041SERVICE MAINTENANCE FOR THE MONTH OF AUGUST 201493351.30PHP119121104
9000000051SERVICE MAINTENANCE FOR THE MONTH OF JULY 201450909.09PHP119121104
9000000061SERVICE MAINTENANCE FOR THE MONTH OF AUGUST 201450909.09PHP119121104
9000000071SERVICE MAINTENANCE FOR THE MONTH OF MAY 2014131007.00PHP119121104
9000000081SERVICE MAINTENANCE FOR THE MONTH OF JUNE 2014131007.00PHP119121104
9000000091SERVICE MAINTENANCE FOR THE MONTH OF JULY 2014131007.00PHP119121104
9000000101SERVICE MAINTENANCE FOR THE MONTH OF AUGUST 2014131007.00PHP119121104
9000000111SERVICE MAINTENANCE FOR THE MONTH OF JUNE 2014148512.00PHP119121104
9000000121SERVICE MAINTENANCE FOR THE MONTH OF JULY 2014148512.00PHP119121104
9000000131SERVICE MAINTENANCE FOR THE MONTH OF AUGUST 2014148512.00PHP119121104
9000000141SERVICE MAINTENANCE FOR THE MONTH OF NOVEMBER 200914500.00PHP119121104
Former Member
‎09-10-2014 8:56 AM
0 Kudos

Hi Nagarajan,

Did you find my template wrong? Is there any possible error I put onto?

kothandaraman_nagarajan
Active Contributor
‎09-10-2014 9:01 AM
0 Kudos

Hi,

Please check SAP note 1135341 - How to import service invoices for foreign
customers

Thanks & Regards,

Nagarajan

Former Member
‎09-10-2014 9:06 AM
0 Kudos

it's asking for a username and password.

kothandaraman_nagarajan
Active Contributor
‎09-10-2014 9:08 AM
0 Kudos

Hi,

Yes  you need S-user ID and password to access.

Thanks & Regards,

Nagarajan

Former Member
‎09-10-2014 9:19 AM
0 Kudos

you mean my log in access?

kothandaraman_nagarajan
Active Contributor
‎09-10-2014 9:21 AM
0 Kudos

Hi,

Yes. Please check your communication link for above notes.

Ask a Question