Skip to Content
0
Apr 06, 2013 at 12:56 PM

DTW import salesOrder - rounding issue

73 Views

Hi all,

Im trying to import some SO trough DTW (header + lines)

header:

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;DownPaymentAmount;DownPaymentPercentage;DownPaymentType;DownPaymentAmountSC;DownPaymentAmountFC;VatPercent;ServiceGrossProfitPercent;OpeningRemarks;ClosingRemarks;RoundingDiffAmount;ControlAccount;InsuranceOperation347;ArchiveNonremovableSalesQuotation

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;DpmAmnt;DpmPrcnt;Posted;DpmAmntSC;DpmAmntFC;VatPercent;SrvGpPrcnt;Header;Footer;RoundDif;CtlAccount;InsurOp347;IgnRelDoc

13300071;dDocument_Items;;;20130401;20130401;K030208;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Line:

ParentKey;LineNum;ItemCode;ItemDescription;Quantity;ShipDate;Price;PriceAfterVAT;Currency;Rate;DiscountPercent;VendorNum;SerialNum;WarehouseCode;SalesPersonCode;CommisionPercent;TreeType;AccountCode;UseBaseUnits;SupplierCatNum;CostingCode;ProjectCode;BarCode;VatGroup;Height1;Hight1Unit;Height2;Height2Unit;Lengh1;Lengh1Unit;Lengh2;Lengh2Unit;Weight1;Weight1Unit;Weight2;Weight2Unit;Factor1;Factor2;Factor3;Factor4;BaseType;BaseEntry;BaseLine;Volume;VolumeUnit;Width1;Width1Unit;Width2;Width2Unit;Address;TaxCode;TaxType;TaxLiable;BackOrder;FreeText;ShippingMethod;CorrectionInvoiceItem;CorrInvAmountToStock;CorrInvAmountToDiffAcct;WTLiable;DeferredTax;MeasureUnit;UnitsOfMeasurment;LineTotal;TaxPercentagePerRow;TaxTotal;ConsumerSalesForecast;ExciseAmount;CountryOrg;SWW;TransactionType;DistributeExpense;ShipToCode;RowTotalFC;CFOPCode;CSTCode;Usage;TaxOnly;UnitPrice;LineStatus;LineType;COGSCostingCode;COGSAccountCode;ChangeAssemlyBoMWarehouse;GrossBuyPrice;GrossBase;GrossProfitTotalBasePrice;CostingCode2;CostingCode3;CostingCode4;CostingCode5;ItemDetails;LocationCode;ActualDeliveryDate;ExLineNo;RequiredDate;RequiredQuantity;COGSCostingCode2;COGSCostingCode3;COGSCostingCode4;COGSCostingCode5;WithoutInventoryMovement;AgrementNo;AgreementRowNumber;ShipToDescription;U_***

DocNum;LineNum;ItemCode;Dscription;Quantity;ShipDate;Price;PriceAfVAT;Currency;Rate;DiscPrcnt;VendorNum;SerialNum;WhsCode;SlpCode;Commission;TreeType;AcctCode;UseBaseUn;SubCatNum;OcrCode;Project;CodeBars;VatGroup;Height1;Hght1Unit;Height2;Hght2Unit;Length1;Len1Unit;length2;Len2Unit;Weight1;Wght1Unit;Weight2;Wght2Unit;Factor1;Factor2;Factor3;Factor4;BaseType;BaseEntry;BaseLine;Volume;VolUnit;Width1;Wdth1Unit;Width2;Wdth2Unit;Address;TaxCode;TaxType;TaxStatus;BackOrdr;FreeTxt;TrnsCode;CEECFlag;ToStock;ToDiff;WtLiable;DeferrTax;unitMsr;NumPerMsr;LineTotal;VatPrcnt;VatSum;ConsumeFCT;ExciseAmt;CountryOrg;SWW;TranType;DistribExp;ShipToCode;TotalFrgn;CFOPCode;CSTCode;Usage;TaxOnly;PriceBefDi;LineStatus;LineType;CogsOcrCod;CogsAcct;ChgAsmBoMW;GrossBuyPr;GrossBase;GPTtlBasPr;OcrCode2;OcrCode3;OcrCode4;OcrCode5;Text;LocCode;ActDelDate;ExLineNo;PQTReqDate;PQTReqQty;CogsOcrCo2;CogsOcrCo3;CogsOcrCo4;CogsOcrCo5;NoInvtryMv;AgrNo;AgrLnNum;ShipToDesc;U_ICD_DOSSIERNR

13300071;1;zz-09-02;***;1;20120401;;1564.02;;;;;;;;;;;tNO;;;;;6V;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1564,02;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;OR-2013/00196-VI

this shows up in SAP in the unit price as 1.564,000 EUR, and in the gross price 1.657,840 EUR, and in total (LC) as 1.564,000 EUR

Since these are big SO, this rounding shows up in the total amount.

any idea's on how to solve this?

Regards

Frederik