on 03-24-2014 8:03 PM
Estimados tengo el siguiente dilema
El campo doctotal y doctotalSy me dan un monto
y si sumo los items de la inv1 me da otro monto
son centavos, pero es para un layout de factura y no debe haber diferencias
alguien con el mismo problema alguna vez??
en este ejemplo doctotal 23.37 *6.96(tipo de cambio)=162.65
y en la inv1
el total es 162.62
tengo tres centavos de diferencia
DocTotal | DocTotalFC | DocTotalSy | DocEntry | DocNum | DocType | CANCELED | Handwrtten | Printed | DocStatus | InvntSttus | Transfered | ObjType | DocDate | DocDueDate | CardCode | CardName | Address | NumAtCard | VatPercent | VatSum | VatSumFC | DiscPrcnt | DiscSum | DiscSumFC | DocCur | DocRate | DocTotal | DocTotalFC | PaidToDate | PaidFC | GrosProfit | GrosProfFC | Ref1 | Ref2 | Comments | JrnlMemo | TransId | ReceiptNum | GroupNum | DocTime | SlpCode | TrnspCode | PartSupply | Confirmed | GrossBase | ImportEnt | CreateTran | SummryType | UpdInvnt | UpdCardBal | Instance | Flags | InvntDirec | CntctCode | ShowSCN | FatherCard | SysRate | CurSource | VatSumSy | DiscSumSy | DocTotalSy | PaidSys | FatherType | GrosProfSy | UpdateDate | IsICT | CreateDate | Volume | VolUnit | Weight | WeightUnit | Series | TaxDate | Filler | DataSource | StampNum | isCrin | FinncPriod | UserSign | selfInv | VatPaid | VatPaidFC | VatPaidSys | UserSign2 | WddStatus | draftKey | TotalExpns | TotalExpFC | TotalExpSC | DunnLevel | Address2 | LogInstanc | Exported | StationID | Indicator | NetProc | AqcsTax | AqcsTaxFC | AqcsTaxSC | CashDiscPr | CashDiscnt | CashDiscFC | CashDiscSC | ShipToCode | LicTradNum | PaymentRef | WTSum | WTSumFC | WTSumSC | RoundDif | RoundDifFC | RoundDifSy | CheckDigit | Form1099 | Box1099 | submitted | PoPrss | Rounding | RevisionPo | Segment | ReqDate | CancelDate | PickStatus | Pick | BlockDunn | PeyMethod | PayBlock | PayBlckRef | MaxDscn | Reserve | Max1099 | CntrlBnk | PickRmrk | ISRCodLine | ExpAppl | ExpApplFC | ExpApplSC | Project | DeferrTax | LetterNum | FromDate | ToDate | WTApplied | WTAppliedF | BoeReserev | AgentCode | WTAppliedS | EquVatSum | EquVatSumF | EquVatSumS | Installmnt | VATFirst | NnSbAmnt | NnSbAmntSC | NbSbAmntFC | ExepAmnt | ExepAmntSC | ExepAmntFC | VatDate | CorrExt | CorrInv | NCorrInv | CEECFlag | BaseAmnt | BaseAmntSC | BaseAmntFC | CtlAccount | BPLId | BPLName | VATRegNum | TxInvRptNo | TxInvRptDt | KVVATCode | WTDetails | SumAbsId | SumRptDate | PIndicator | ManualNum | UseShpdGd | BaseVtAt | BaseVtAtSC | BaseVtAtFC | NnSbVAt | NnSbVAtSC | NbSbVAtFC | ExptVAt | ExptVAtSC | ExptVAtFC | LYPmtAt | LYPmtAtSC | LYPmtAtFC | ExpAnSum | ExpAnSys | ExpAnFrgn | DocSubType | DpmStatus | DpmAmnt | DpmAmntSC | DpmAmntFC | DpmDrawn | DpmPrcnt | PaidSum | PaidSumFc | PaidSumSc | FolioPref | FolioNum | DpmAppl | DpmApplFc | DpmApplSc | LPgFolioN | Header | Footer | Posted | OwnerCode | BPChCode | BPChCntc | PayToCode | IsPaytoBnk | BnkCntry | BankCode | BnkAccount | BnkBranch | isIns | TrackNo | VersionNum | LangCode | BPNameOW | BillToOW | ShipToOW | RetInvoice | ClsDate | MInvNum | MInvDate | SeqCode | Serial | SeriesStr | SubStr | Model | TaxOnExp | TaxOnExpFc | TaxOnExpSc | TaxOnExAp | TaxOnExApF | TaxOnExApS | LastPmnTyp | LndCstNum | UseCorrVat | BlkCredMmo | OpenForLaC | Excised | ExcRefDate | ExcRmvTime | SrvGpPrcnt | DepositNum | CertNum | DutyStatus | AutoCrtFlw | FlwRefDate | FlwRefNum | VatJENum | DpmVat | DpmVatFc | DpmVatSc | DpmAppVat | DpmAppVatF | DpmAppVatS | InsurOp347 | IgnRelDoc | BuildDesc | ResidenNum | Checker | Payee | CopyNumber | SSIExmpt | PQTGrpSer | PQTGrpNum | PQTGrpHW | ReopOriDoc | ReopManCls | DocManClsd | ClosingOpt | SpecDate | Ordered | NTSApprov | NTSWebSite | NTSeTaxNo | NTSApprNo | PayDuMonth | ExtraMonth | ExtraDays | CdcOffset | SignMsg | SignDigest | CertifNum | KeyVersion | EDocGenTyp | ESeries | EDocNum | EDocExpFrm | OnlineQuo | POSEqNum | POSManufSN | POSCashN | EDocStatus | EDocCntnt | EDocProces | EDocErrCod | EDocErrMsg | EDocCancel | EDocTest | EDocPrefix | CUP | CIG | DpmAsDscnt | Attachment | AtcEntry | SupplCode | GTSRlvnt | BaseDisc | BaseDiscSc | BaseDiscFc | BaseDiscPr | CreateTS | UpdateTS | SrvTaxRule | AnnInvDecR | Supplier | Releaser | Receiver | AgrNo | IsAlt | AltBaseTyp | AltBaseEnt | PaidDpm | PaidDpmF | PaidDpmS | U_NUMEROJD | U_TIPODOC | U_TIPOCOM | U_NIT | U_RAZSOC | U_CODCTRL | U_NROAUTOR | U_CODFORPI | U_NROTRAM | U_NROPOL | U_BOLBSP | U_ICE | U_EXENTO | U_ESTADOFC | U_FACANU | U_SERIECOD | U_FECHALIM | U_FechaEmision | U_Autorizacion | U_Cotizacion | U_Solicitante | U_Tbaja | U_IUE | U_NRO_FACT | U_NRO_GUIA | U_Observacion | U_FARRIBO | U_TELEFONO | U_CONCODIGO | U_TSINDESC | U_DESCTOTAL | U_TCONDESC | U_Descuento | U_BASADOENOFERTA | U_ACTDATOS | U_WITHCC | U_CCFACANU | U_Literal |
23.370000 | 0.000000 | 162.650000 | 1377 | 101188 | I | N | N | Y | C | O | N | 13 | 2014-03-24 00:00:00.000 | 2014-03-24 00:00:00.000 | CG0001 | AGROPECUARIA JIBOTA SA | BOLIVIA | 1184 | 0.000000 | 3.040000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | USD | 1.000000 | 23.370000 | 0.000000 | 23.370000 | 0.000000 | 10.500000 | 0.000000 | 101188 | NULL | Basado en Ofertas de ventas 1416. Basado en Pedidos de cliente 1303. Basado en Entregas 1275. | Facturas clientes - CG0001 | 4671 | 1138 | -1 | 1135 | 12 | -1 | Y | Y | -5 | NULL | Y | N | I | B | 0 | 0 | X | 0 | N | NULL | 6.960000 | L | 21.140000 | 0.000000 | 162.650000 | 162.650000 | P | 73.080000 | 2014-03-24 00:00:00.000 | N | 2014-03-24 00:00:00.000 | 0.000000 | 4 | 0.000000 | 3 | 54 | 2014-03-24 00:00:00.000 | NULL | I | NULL | N | 27 | 7 | N | 3.040000 | 0.000000 | 21.140000 | 7 | - | NULL | 0.000000 | 0.000000 | 0.000000 | NULL | BOLIVIA | 0 | N | 719 | NULL | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 0 | NULL | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | N | N | N | N | 0 | NULL | NULL | N | N | N | N | NULL | N | N | 23.370000 | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | NULL | N | NULL | NULL | NULL | 0.000000 | 0.000000 | N | NULL | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | NULL | N | 0.000000 | 0.000000 | 0.000000 | 120102000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | -1 | NULL | 2014 | NULL | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | -- | O | 0.000000 | 0.000000 | 0.000000 | N | 0.000000 | 23.370000 | 0.000000 | 162.650000 | NULL | 0 | 0.000000 | 0.000000 | 0.000000 | 1 | Y | 1 | NULL | NULL | 1 | N | NULL | NULL | NULL | NULL | N | NULL | 8.82.075.11 | 25 | Y | N | N | N | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | R | NULL | N | N | Y | O | NULL | NULL | 0.000000 | NULL | NULL | Y | N | NULL | NULL | -1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | N | N | 1 | NULL | NULL | 0 | NULL | NULL | NULL | N | NULL | NULL | N | 1 | NULL | N | N | NULL | NULL | NULL | N | 0 | 0 | 0 | NULL | NULL | NULL | NULL | N | NULL | NULL | NULL | N | NULL | NULL | NULL | C | NULL | C | NULL | NULL | N | N | NULL | NULL | NULL | N | NULL | NULL | NULL | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 113512 | 113521 | N | NULL | NULL | NULL | NULL | NULL | N | -1 | NULL | 0.000000 | 0.000000 | 0.000000 | NULL | 7 | 1 | 148222029 | AGROPECUARIA JIBOTA SA | EE-01-8D-15-3F | 760400116663 | N/A | n/a | n/a | n/a | 0.000000 | 0.000000 | V | n/a | 0000001 | 2014-04-21 00:00:00.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 72164566 | S | 23.370000 | 0.000000 | 23.370000 | 0.00 | NULL | NULL | N | N | NULL |
DocEntry | LineNum | TargetType | TrgetEntry | BaseRef | BaseType | BaseEntry | BaseLine | LineStatus | ItemCode | Dscription | Quantity | ShipDate | OpenQty | Price | Currency | Rate | DiscPrcnt | LineTotal | TotalFrgn | OpenSum | OpenSumFC | VendorNum | SerialNum | WhsCode | SlpCode | Commission | TreeType | AcctCode | TaxStatus | GrossBuyPr | PriceBefDi | DocDate | Flags | OpenCreQty | UseBaseUn | SubCatNum | BaseCard | TotalSumSy | OpenSumSys | InvntSttus | OcrCode | Project | CodeBars | VatPrcnt | VatGroup | PriceAfVAT | Height1 | Hght1Unit | Height2 | Hght2Unit | Width1 | Wdth1Unit | Width2 | Wdth2Unit | Length1 | Len1Unit | length2 | Len2Unit | Volume | VolUnit | Weight1 | Wght1Unit | Weight2 | Wght2Unit | Factor1 | Factor2 | Factor3 | Factor4 | PackQty | UpdInvntry | BaseDocNum | BaseAtCard | SWW | VatSum | VatSumFrgn | VatSumSy | FinncPriod | ObjType | LogInstanc | BlockNum | ImportLog | DedVatSum | DedVatSumF | DedVatSumS | IsAqcuistn | DistribSum | DstrbSumFC | DstrbSumSC | GrssProfit | GrssProfSC | GrssProfFC | VisOrder | INMPrice | PoTrgNum | PoTrgEntry | DropShip | PoLineNum | Address | TaxCode | TaxType | OrigItem | BackOrdr | FreeTxt | PickStatus | PickOty | PickIdNo | TrnsCode | VatAppld | VatAppldFC | VatAppldSC | BaseQty | BaseOpnQty | VatDscntPr | WtLiable | DeferrTax | EquVatPer | EquVatSum | EquVatSumF | EquVatSumS | LineVat | LineVatlF | LineVatS | unitMsr | NumPerMsr | CEECFlag | ToStock | ToDiff | ExciseAmt | TaxPerUnit | TotInclTax | CountryOrg | StckDstSum | ReleasQtty | LineType | TranType | Text | OwnerCode | StockPrice | ConsumeFCT | LstByDsSum | StckINMPr | LstBINMPr | StckDstFc | StckDstSc | LstByDsFc | LstByDsSc | StockSum | StockSumFc | StockSumSc | StckSumApp | StckAppFc | StckAppSc | ShipToCode | ShipToDesc | StckAppD | StckAppDFC | StckAppDSC | BasePrice | GTotal | GTotalFC | GTotalSC | DistribExp | DescOW | DetailsOW | GrossBase | VatWoDpm | VatWoDpmFc | VatWoDpmSc | CFOPCode | CSTCode | Usage | TaxOnly | WtCalced | QtyToShip | DelivrdQty | OrderedQty | CogsOcrCod | CiOppLineN | CogsAcct | ChgAsmBoMW | ActDelDate | OcrCode2 | OcrCode3 | OcrCode4 | OcrCode5 | TaxDistSum | TaxDistSFC | TaxDistSSC | PostTax | Excisable | AssblValue | RG23APart1 | RG23APart2 | RG23CPart1 | RG23CPart2 | CogsOcrCo2 | CogsOcrCo3 | CogsOcrCo4 | CogsOcrCo5 | LnExcised | LocCode | StockValue | GPTtlBasPr | unitMsr2 | NumPerMsr2 | SpecPrice | CSTfIPI | CSTfPIS | CSTfCOFINS | ExLineNo | isSrvCall | PQTReqQty | PQTReqDate | PcDocType | PcQuantity | LinManClsd | VatGrpSrc | NoInvtryMv | ActBaseEnt | ActBaseLn | ActBaseNum | OpenRtnQty | AgrNo | AgrLnNum | CredOrigin | Surpluses | DefBreak | Shortages | U_TIPOOC | U_OCLISTAV | U_NOrden | U_codigo_catg | U_cliente_mercaderia | U_desc_catalogo | U_cant_min_catalogo | U_MOTIVO | U_Stock | U_TIPOENVIO | U_PROCEDENCIA |
1377 | 0 | -1 | NULL | 1275 | 15 | 1389 | 0 | O | 50A14TRP | ENGRANAJE | 1.000000 | 2014-03-24 00:00:00.000 | 1.000000 | 4.940000 | USD | 0.000000 | 0.000000 | 4.940000 | 0.000000 | 4.940000 | 0.000000 | NULL | 01-IM | 12 | 0.000000 | N | 410101000 | Y | 2.230000 | 4.940000 | 2014-03-24 00:00:00.000 | 0 | 1.000000 | N | CG0001 | 34.390000 | 34.390000 | O | NULL | 13.000000 | IVA | 5.680000 | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | 4 | 0.000000 | NULL | 0.000000 | NULL | 1.000000 | 1.000000 | 1.000000 | 1.000000 | 1.000000 | Y | 1275 | NULL | 0.740000 | 0.000000 | 5.140000 | 27 | 13 | 0 | NULL | NULL | 0.740000 | 0.000000 | 5.140000 | N | 0.000000 | 0.000000 | 0.000000 | 2.800000 | 19.490000 | 0.000000 | 0 | 4.940000 | NULL | N | NULL | IVA | Y | NULL | Y | N | 0.000000 | NULL | -1 | 0.000000 | 0.000000 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.740000 | 0.000000 | 5.140000 | PZA | 1.000000 | S | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | NULL | 0.000000 | 0.000000 | R | NULL | NULL | 1 | 2.230000 | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | BOLIVIA | 0.000000 | 0.000000 | 0.000000 | I | 5.680000 | 0.000000 | 39.530000 | Y | N | N | -5 | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | N | N | 0.000000 | 0.000000 | 1.000000 | NULL | -1 | 510101000 | N | 2014-03-24 00:00:00.000 | NULL | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | Y | NULL | 0.000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2.230000 | 2.230000 | PZA | 1.000000 | N | NULL | NULL | NULL | NULL | N | 0.000000 | NULL | -1 | 0.000000 | N | N | N | NULL | NULL | NULL | 0.000000 | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | NN | NULL | NULL | NULL | NULL | NULL | NULL | OTROS | 21.00 | NULL | NULL | ||||||||
1377 | 1 | -1 | NULL | 1275 | 15 | 1389 | 1 | O | 50A17TRP | ENGRANAJE | 1.000000 | 2014-03-24 00:00:00.000 | 1.000000 | 6.770000 | USD | 0.000000 | 0.000000 | 6.770000 | 0.000000 | 6.770000 | 0.000000 | NULL | 01-IM | 12 | 0.000000 | N | 410101000 | Y | 2.450000 | 6.770000 | 2014-03-24 00:00:00.000 | 0 | 1.000000 | N | CG0001 | 47.110000 | 47.110000 | O | NULL | 13.000000 | IVA | 7.780000 | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | 4 | 0.000000 | NULL | 0.000000 | NULL | 1.000000 | 1.000000 | 1.000000 | 1.000000 | 1.000000 | Y | 1275 | NULL | 1.010000 | 0.000000 | 7.040000 | 27 | 13 | 0 | NULL | NULL | 1.010000 | 0.000000 | 7.040000 | N | 0.000000 | 0.000000 | 0.000000 | 4.430000 | 30.830000 | 0.000000 | 1 | 6.770000 | NULL | N | NULL | IVA | Y | NULL | Y | N | 0.000000 | NULL | -1 | 0.000000 | 0.000000 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.010000 | 0.000000 | 7.040000 | PZA | 1.000000 | S | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | NULL | 0.000000 | 0.000000 | R | NULL | NULL | 1 | 2.450000 | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | BOLIVIA | 0.000000 | 0.000000 | 0.000000 | I | 7.780000 | 0.000000 | 54.150000 | Y | N | N | -5 | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | N | N | 0.000000 | 0.000000 | 1.000000 | NULL | -1 | 510101000 | N | 2014-03-24 00:00:00.000 | NULL | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | Y | NULL | 0.000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2.450000 | 2.450000 | PZA | 1.000000 | N | NULL | NULL | NULL | NULL | N | 0.000000 | NULL | -1 | 0.000000 | N | N | N | NULL | NULL | NULL | 0.000000 | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | NN | NULL | NULL | NULL | NULL | NULL | NULL | OTROS | 15.00 | NULL | NULL | ||||||||
1377 | 2 | -1 | NULL | 1275 | 15 | 1389 | 2 | O | RC50-1EK | CADENA | 0.600000 | 2014-03-24 00:00:00.000 | 0.600000 | 13.450000 | USD | 0.000000 | 0.000000 | 8.070000 | 0.000000 | 8.070000 | 0.000000 | NULL | 01-IM | 12 | 0.000000 | N | 410101000 | Y | 8.850000 | 13.450000 | 2014-03-24 00:00:00.000 | 0 | 0.600000 | N | CG0001 | 56.200000 | 56.200000 | O | NULL | 13.000000 | IVA | 15.460000 | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | 4 | 0.000000 | NULL | 0.000000 | NULL | 1.000000 | 1.000000 | 1.000000 | 1.000000 | 1.000000 | Y | 1275 | NULL | 1.210000 | 0.000000 | 8.390000 | 27 | 13 | 0 | NULL | NULL | 1.210000 | 0.000000 | 8.390000 | N | 0.000000 | 0.000000 | 0.000000 | 2.900000 | 20.180000 | 0.000000 | 2 | 13.450000 | NULL | N | NULL | IVA | Y | NULL | Y | N | 0.000000 | NULL | -1 | 0.000000 | 0.000000 | 0.000000 | 0.600000 | 0.600000 | 0.000000 | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.210000 | 0.000000 | 8.390000 | METROS | 1.000000 | S | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | NULL | 0.000000 | 0.000000 | R | NULL | NULL | 1 | 8.850000 | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | BOLIVIA | 0.000000 | 0.000000 | 0.000000 | I | 9.280000 | 0.000000 | 64.590000 | Y | N | N | -5 | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | N | N | 0.000000 | 0.000000 | 0.600000 | NULL | -1 | 510101000 | N | 2014-03-24 00:00:00.000 | NULL | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | Y | NULL | 0.000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5.310000 | 5.310000 | METROS | 1.000000 | N | NULL | NULL | NULL | NULL | N | 0.000000 | NULL | -1 | 0.000000 | N | N | N | NULL | NULL | NULL | 0.000000 | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | NN | NULL | NULL | NULL | NULL | NULL | NULL | OTROS | 38.68 | NULL | NULL | ||||||||
1377 | 3 | -1 | NULL | 1275 | 15 | 1389 | 3 | O | CL50-1TRP | SEGURO | 1.000000 | 2014-03-24 00:00:00.000 | 1.000000 | 0.550000 | USD | 0.000000 | 0.000000 | 0.550000 | 0.000000 | 0.550000 | 0.000000 | NULL | 01-IM | 12 | 0.000000 | N | 410101000 | Y | 0.190000 | 0.550000 | 2014-03-24 00:00:00.000 | 0 | 1.000000 | N | CG0001 | 3.810000 | 3.810000 | O | NULL | 13.000000 | IVA | 0.630000 | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | NULL | 0.000000 | 4 | 0.000000 | NULL | 0.000000 | NULL | 1.000000 | 1.000000 | 1.000000 | 1.000000 | 1.000000 | Y | 1275 | NULL | 0.080000 | 0.000000 | 0.570000 | 27 | 13 | 0 | NULL | NULL | 0.080000 | 0.000000 | 0.570000 | N | 0.000000 | 0.000000 | 0.000000 | 0.370000 | 2.580000 | 0.000000 | 3 | 0.550000 | NULL | N | NULL | IVA | Y | NULL | Y | N | 0.000000 | NULL | -1 | 0.000000 | 0.000000 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | N | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.080000 | 0.000000 | 0.570000 | PZA | 1.000000 | S | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | NULL | 0.000000 | 0.000000 | R | NULL | NULL | 1 | 0.190000 | N | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | BOLIVIA | 0.000000 | 0.000000 | 0.000000 | I | 0.630000 | 0.000000 | 4.380000 | Y | N | N | -5 | 0.000000 | 0.000000 | 0.000000 | NULL | NULL | NULL | N | N | 0.000000 | 0.000000 | 1.000000 | NULL | -1 | 510101000 | N | 2014-03-24 00:00:00.000 | NULL | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | Y | NULL | 0.000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0.190000 | 0.190000 | PZA | 1.000000 | N | NULL | NULL | NULL | NULL | N | 0.000000 | NULL | -1 | 0.000000 | N | N | N | NULL | NULL | NULL | 0.000000 | NULL | NULL | NULL | 0.000000 | 0.000000 | 0.000000 | NN | NULL | NULL | NULL | NULL | NULL | NULL | OTROS | 109.00 | NULL | NULL |
Hola
Si operas cantidad por precio después de descuento, redondeas y sumas ¿sale el mismo monto que el total del documento?
¿Cuántos dígitos tienes definidos en cantidades e importe?
Los problemas de redondeo los soluciono habitualmente forzando el cálculo en el formato.
Un saludo
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Saludos,
Creo que su inconveniente esta en la multiplicacion con la tasa de cambio. El flujo que he podido confirmar de SAP es: (precio unitario * tasa de cambio) * numero de unidades, todo esto sin redondear en ningun momento.
Mi recomendación sería tomar el campo Line Total, ya sea en moneda local o de sistema, para evitar este inconveniente.
Espero serle de ayuda,
Atte. Rosa
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.