cancel
Showing results for 
Search instead for 
Did you mean: 

Oinv vs Inv1

martin_romano3
Explorer
0 Kudos

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

DocTotalDocTotalFCDocTotalSyDocEntryDocNumDocTypeCANCELEDHandwrttenPrintedDocStatusInvntSttusTransferedObjTypeDocDateDocDueDateCardCodeCardNameAddressNumAtCardVatPercentVatSumVatSumFCDiscPrcntDiscSumDiscSumFCDocCurDocRateDocTotalDocTotalFCPaidToDatePaidFCGrosProfitGrosProfFCRef1Ref2CommentsJrnlMemoTransIdReceiptNumGroupNumDocTimeSlpCodeTrnspCodePartSupplyConfirmedGrossBaseImportEntCreateTranSummryTypeUpdInvntUpdCardBalInstanceFlagsInvntDirecCntctCodeShowSCNFatherCardSysRateCurSourceVatSumSyDiscSumSyDocTotalSyPaidSysFatherTypeGrosProfSyUpdateDateIsICTCreateDateVolumeVolUnitWeightWeightUnitSeriesTaxDateFillerDataSourceStampNumisCrinFinncPriodUserSignselfInvVatPaidVatPaidFCVatPaidSysUserSign2WddStatusdraftKeyTotalExpnsTotalExpFCTotalExpSCDunnLevelAddress2LogInstancExportedStationIDIndicatorNetProcAqcsTaxAqcsTaxFCAqcsTaxSCCashDiscPrCashDiscntCashDiscFCCashDiscSCShipToCodeLicTradNumPaymentRefWTSumWTSumFCWTSumSCRoundDifRoundDifFCRoundDifSyCheckDigitForm1099Box1099submittedPoPrssRoundingRevisionPoSegmentReqDateCancelDatePickStatusPickBlockDunnPeyMethodPayBlockPayBlckRefMaxDscnReserveMax1099CntrlBnkPickRmrkISRCodLineExpApplExpApplFCExpApplSCProjectDeferrTaxLetterNumFromDateToDateWTAppliedWTAppliedFBoeReserevAgentCodeWTAppliedSEquVatSumEquVatSumFEquVatSumSInstallmntVATFirstNnSbAmntNnSbAmntSCNbSbAmntFCExepAmntExepAmntSCExepAmntFCVatDateCorrExtCorrInvNCorrInvCEECFlagBaseAmntBaseAmntSCBaseAmntFCCtlAccountBPLIdBPLNameVATRegNumTxInvRptNoTxInvRptDtKVVATCodeWTDetailsSumAbsIdSumRptDatePIndicatorManualNumUseShpdGdBaseVtAtBaseVtAtSCBaseVtAtFCNnSbVAtNnSbVAtSCNbSbVAtFCExptVAtExptVAtSCExptVAtFCLYPmtAtLYPmtAtSCLYPmtAtFCExpAnSumExpAnSysExpAnFrgnDocSubTypeDpmStatusDpmAmntDpmAmntSCDpmAmntFCDpmDrawnDpmPrcntPaidSumPaidSumFcPaidSumScFolioPrefFolioNumDpmApplDpmApplFcDpmApplScLPgFolioNHeaderFooterPostedOwnerCodeBPChCodeBPChCntcPayToCodeIsPaytoBnkBnkCntryBankCodeBnkAccountBnkBranchisInsTrackNoVersionNumLangCodeBPNameOWBillToOWShipToOWRetInvoiceClsDateMInvNumMInvDateSeqCodeSerialSeriesStrSubStrModelTaxOnExpTaxOnExpFcTaxOnExpScTaxOnExApTaxOnExApFTaxOnExApSLastPmnTypLndCstNumUseCorrVatBlkCredMmoOpenForLaCExcisedExcRefDateExcRmvTimeSrvGpPrcntDepositNumCertNumDutyStatusAutoCrtFlwFlwRefDateFlwRefNumVatJENumDpmVatDpmVatFcDpmVatScDpmAppVatDpmAppVatFDpmAppVatSInsurOp347IgnRelDocBuildDescResidenNumCheckerPayeeCopyNumberSSIExmptPQTGrpSerPQTGrpNumPQTGrpHWReopOriDocReopManClsDocManClsdClosingOptSpecDateOrderedNTSApprovNTSWebSiteNTSeTaxNoNTSApprNoPayDuMonthExtraMonthExtraDaysCdcOffsetSignMsgSignDigestCertifNumKeyVersionEDocGenTypESeriesEDocNumEDocExpFrmOnlineQuoPOSEqNumPOSManufSNPOSCashNEDocStatusEDocCntntEDocProcesEDocErrCodEDocErrMsgEDocCancelEDocTestEDocPrefixCUPCIGDpmAsDscntAttachmentAtcEntrySupplCodeGTSRlvntBaseDiscBaseDiscScBaseDiscFcBaseDiscPrCreateTSUpdateTSSrvTaxRuleAnnInvDecRSupplierReleaserReceiverAgrNoIsAltAltBaseTypAltBaseEntPaidDpmPaidDpmFPaidDpmSU_NUMEROJDU_TIPODOCU_TIPOCOMU_NITU_RAZSOCU_CODCTRLU_NROAUTORU_CODFORPIU_NROTRAMU_NROPOLU_BOLBSPU_ICEU_EXENTOU_ESTADOFCU_FACANUU_SERIECODU_FECHALIMU_FechaEmisionU_AutorizacionU_CotizacionU_SolicitanteU_TbajaU_IUEU_NRO_FACTU_NRO_GUIAU_ObservacionU_FARRIBOU_TELEFONOU_CONCODIGOU_TSINDESCU_DESCTOTALU_TCONDESCU_DescuentoU_BASADOENOFERTAU_ACTDATOSU_WITHCCU_CCFACANUU_Literal
23.3700000.000000162.6500001377101188INNYCON132014-03-24 00:00:00.0002014-03-24 00:00:00.000CG0001AGROPECUARIA JIBOTA SABOLIVIA11840.0000003.0400000.0000000.0000000.0000000.000000USD1.00000023.3700000.00000023.3700000.00000010.5000000.000000101188NULLBasado en Ofertas de ventas 1416. Basado en Pedidos de cliente 1303. Basado en Entregas 1275.Facturas clientes - CG000146711138-1113512-1YY-5NULLYNIB00X0NNULL6.960000L21.1400000.000000162.650000162.650000P73.0800002014-03-24 00:00:00.000N2014-03-24 00:00:00.0000.00000040.0000003542014-03-24 00:00:00.000NULLINULLN277N3.0400000.00000021.1400007-NULL0.0000000.0000000.000000NULLBOLIVIA0N719NULLN0.0000000.0000000.0000000.0000000.0000000.0000000.00000010NULL0.0000000.0000000.0000000.0000000.0000000.000000NULLNULLNULLNNNN0NULLNULLNNNNNULLNN23.370000NULLNULL0.0000000.0000000.000000NULLNNULLNULLNULL0.0000000.000000NNULL0.0000000.0000000.0000000.0000001N0.0000000.0000000.0000000.0000000.0000000.000000NULLNULLNULLNULLN0.0000000.0000000.000000120102000NULLNULLNULLNULLNULLNULLNULL-1NULL2014NULLN0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000--O0.0000000.0000000.000000N0.00000023.3700000.000000162.650000NULL00.0000000.0000000.0000001Y1NULLNULL1NNULLNULLNULLNULLNNULL8.82.075.1125YNNNNULLNULLNULLNULLNULLNULLNULL00.0000000.0000000.0000000.0000000.0000000.000000RNULLNNYONULLNULL0.000000NULLNULLYNNULLNULL-10.0000000.0000000.0000000.0000000.0000000.000000NN1NULLNULL0NULLNULLNULLNNULLNULLN1NULLNNNULLNULLNULLN000NULLNULLNULLNULLNNULLNULLNULLNNULLNULLNULLCNULLCNULLNULLNNNULLNULLNULLNNULLNULLNULLN0.0000000.0000000.0000000.000000113512113521NNULLNULLNULLNULLNULLN-1NULL0.0000000.0000000.000000NULL71148222029AGROPECUARIA JIBOTA SAEE-01-8D-15-3F760400116663N/An/an/an/a0.0000000.000000Vn/a00000012014-04-21 00:00:00.000NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL72164566S23.3700000.00000023.3700000.00NULLNULLNNNULL
DocEntryLineNumTargetTypeTrgetEntryBaseRefBaseTypeBaseEntryBaseLineLineStatusItemCodeDscriptionQuantityShipDateOpenQtyPriceCurrencyRateDiscPrcntLineTotalTotalFrgnOpenSumOpenSumFCVendorNumSerialNumWhsCodeSlpCodeCommissionTreeTypeAcctCodeTaxStatusGrossBuyPrPriceBefDiDocDateFlagsOpenCreQtyUseBaseUnSubCatNumBaseCardTotalSumSyOpenSumSysInvntSttusOcrCodeProjectCodeBarsVatPrcntVatGroupPriceAfVATHeight1Hght1UnitHeight2Hght2UnitWidth1Wdth1UnitWidth2Wdth2UnitLength1Len1Unitlength2Len2UnitVolumeVolUnitWeight1Wght1UnitWeight2Wght2UnitFactor1Factor2Factor3Factor4PackQtyUpdInvntryBaseDocNumBaseAtCardSWWVatSumVatSumFrgnVatSumSyFinncPriodObjTypeLogInstancBlockNumImportLogDedVatSumDedVatSumFDedVatSumSIsAqcuistnDistribSumDstrbSumFCDstrbSumSCGrssProfitGrssProfSCGrssProfFCVisOrderINMPricePoTrgNumPoTrgEntryDropShipPoLineNumAddressTaxCodeTaxTypeOrigItemBackOrdrFreeTxtPickStatusPickOtyPickIdNoTrnsCodeVatAppldVatAppldFCVatAppldSCBaseQtyBaseOpnQtyVatDscntPrWtLiableDeferrTaxEquVatPerEquVatSumEquVatSumFEquVatSumSLineVatLineVatlFLineVatSunitMsrNumPerMsrCEECFlagToStockToDiffExciseAmtTaxPerUnitTotInclTaxCountryOrgStckDstSumReleasQttyLineTypeTranTypeTextOwnerCodeStockPriceConsumeFCTLstByDsSumStckINMPrLstBINMPrStckDstFcStckDstScLstByDsFcLstByDsScStockSumStockSumFcStockSumScStckSumAppStckAppFcStckAppScShipToCodeShipToDescStckAppDStckAppDFCStckAppDSCBasePriceGTotalGTotalFCGTotalSCDistribExpDescOWDetailsOWGrossBaseVatWoDpmVatWoDpmFcVatWoDpmScCFOPCodeCSTCodeUsageTaxOnlyWtCalcedQtyToShipDelivrdQtyOrderedQtyCogsOcrCodCiOppLineNCogsAcctChgAsmBoMWActDelDateOcrCode2OcrCode3OcrCode4OcrCode5TaxDistSumTaxDistSFCTaxDistSSCPostTaxExcisableAssblValueRG23APart1RG23APart2RG23CPart1RG23CPart2CogsOcrCo2CogsOcrCo3CogsOcrCo4CogsOcrCo5LnExcisedLocCodeStockValueGPTtlBasPrunitMsr2NumPerMsr2SpecPriceCSTfIPICSTfPISCSTfCOFINSExLineNoisSrvCallPQTReqQtyPQTReqDatePcDocTypePcQuantityLinManClsdVatGrpSrcNoInvtryMvActBaseEntActBaseLnActBaseNumOpenRtnQtyAgrNoAgrLnNumCredOriginSurplusesDefBreakShortagesU_TIPOOCU_OCLISTAVU_NOrdenU_codigo_catgU_cliente_mercaderiaU_desc_catalogoU_cant_min_catalogoU_MOTIVOU_StockU_TIPOENVIOU_PROCEDENCIA
13770-1NULL12751513890O50A14TRPENGRANAJE1.0000002014-03-24 00:00:00.0001.0000004.940000USD0.0000000.0000004.9400000.0000004.9400000.000000NULL01-IM120.000000N410101000Y2.2300004.9400002014-03-24 00:00:00.00001.000000NCG000134.39000034.390000ONULL13.000000IVA5.6800000.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.00000040.000000NULL0.000000NULL1.0000001.0000001.0000001.0000001.000000Y1275NULL0.7400000.0000005.14000027130NULLNULL0.7400000.0000005.140000N0.0000000.0000000.0000002.80000019.4900000.00000004.940000NULLNNULLIVAYNULLYN0.000000NULL-10.0000000.0000000.0000001.0000001.0000000.000000NN0.0000000.0000000.0000000.0000000.7400000.0000005.140000PZA1.000000S0.0000000.0000000.0000000.0000000.000000NULL0.0000000.000000RNULLNULL12.230000N0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000001BOLIVIA0.0000000.0000000.000000I5.6800000.00000039.530000YNN-50.0000000.0000000.000000NULLNULLNULLNN0.0000000.0000001.000000NULL-1510101000N2014-03-24 00:00:00.000NULLNULLNULLNULL0.0000000.0000000.000000YNULL0.000000NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL2.2300002.230000PZA1.000000NNULLNULLNULLNULLN0.000000NULL-10.000000NNNNULLNULLNULL0.000000NULLNULLNULL0.0000000.0000000.000000NNNULLNULLNULLNULLNULLNULLOTROS21.00NULLNULL
13771-1NULL12751513891O50A17TRPENGRANAJE1.0000002014-03-24 00:00:00.0001.0000006.770000USD0.0000000.0000006.7700000.0000006.7700000.000000NULL01-IM120.000000N410101000Y2.4500006.7700002014-03-24 00:00:00.00001.000000NCG000147.11000047.110000ONULL13.000000IVA7.7800000.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.00000040.000000NULL0.000000NULL1.0000001.0000001.0000001.0000001.000000Y1275NULL1.0100000.0000007.04000027130NULLNULL1.0100000.0000007.040000N0.0000000.0000000.0000004.43000030.8300000.00000016.770000NULLNNULLIVAYNULLYN0.000000NULL-10.0000000.0000000.0000001.0000001.0000000.000000NN0.0000000.0000000.0000000.0000001.0100000.0000007.040000PZA1.000000S0.0000000.0000000.0000000.0000000.000000NULL0.0000000.000000RNULLNULL12.450000N0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000001BOLIVIA0.0000000.0000000.000000I7.7800000.00000054.150000YNN-50.0000000.0000000.000000NULLNULLNULLNN0.0000000.0000001.000000NULL-1510101000N2014-03-24 00:00:00.000NULLNULLNULLNULL0.0000000.0000000.000000YNULL0.000000NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL2.4500002.450000PZA1.000000NNULLNULLNULLNULLN0.000000NULL-10.000000NNNNULLNULLNULL0.000000NULLNULLNULL0.0000000.0000000.000000NNNULLNULLNULLNULLNULLNULLOTROS15.00NULLNULL
13772-1NULL12751513892ORC50-1EKCADENA0.6000002014-03-24 00:00:00.0000.60000013.450000USD0.0000000.0000008.0700000.0000008.0700000.000000NULL01-IM120.000000N410101000Y8.85000013.4500002014-03-24 00:00:00.00000.600000NCG000156.20000056.200000ONULL13.000000IVA15.4600000.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.00000040.000000NULL0.000000NULL1.0000001.0000001.0000001.0000001.000000Y1275NULL1.2100000.0000008.39000027130NULLNULL1.2100000.0000008.390000N0.0000000.0000000.0000002.90000020.1800000.000000213.450000NULLNNULLIVAYNULLYN0.000000NULL-10.0000000.0000000.0000000.6000000.6000000.000000NN0.0000000.0000000.0000000.0000001.2100000.0000008.390000METROS1.000000S0.0000000.0000000.0000000.0000000.000000NULL0.0000000.000000RNULLNULL18.850000N0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000001BOLIVIA0.0000000.0000000.000000I9.2800000.00000064.590000YNN-50.0000000.0000000.000000NULLNULLNULLNN0.0000000.0000000.600000NULL-1510101000N2014-03-24 00:00:00.000NULLNULLNULLNULL0.0000000.0000000.000000YNULL0.000000NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL5.3100005.310000METROS1.000000NNULLNULLNULLNULLN0.000000NULL-10.000000NNNNULLNULLNULL0.000000NULLNULLNULL0.0000000.0000000.000000NNNULLNULLNULLNULLNULLNULLOTROS38.68NULLNULL
13773-1NULL12751513893OCL50-1TRPSEGURO1.0000002014-03-24 00:00:00.0001.0000000.550000USD0.0000000.0000000.5500000.0000000.5500000.000000NULL01-IM120.000000N410101000Y0.1900000.5500002014-03-24 00:00:00.00001.000000NCG00013.8100003.810000ONULL13.000000IVA0.6300000.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.000000NULL0.00000040.000000NULL0.000000NULL1.0000001.0000001.0000001.0000001.000000Y1275NULL0.0800000.0000000.57000027130NULLNULL0.0800000.0000000.570000N0.0000000.0000000.0000000.3700002.5800000.00000030.550000NULLNNULLIVAYNULLYN0.000000NULL-10.0000000.0000000.0000001.0000001.0000000.000000NN0.0000000.0000000.0000000.0000000.0800000.0000000.570000PZA1.000000S0.0000000.0000000.0000000.0000000.000000NULL0.0000000.000000RNULLNULL10.190000N0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000001BOLIVIA0.0000000.0000000.000000I0.6300000.0000004.380000YNN-50.0000000.0000000.000000NULLNULLNULLNN0.0000000.0000001.000000NULL-1510101000N2014-03-24 00:00:00.000NULLNULLNULLNULL0.0000000.0000000.000000YNULL0.000000NULLNULLNULLNULLNULLNULLNULLNULLNULLNULL0.1900000.190000PZA1.000000NNULLNULLNULLNULLN0.000000NULL-10.000000NNNNULLNULLNULL0.000000NULLNULLNULL0.0000000.0000000.000000NNNULLNULLNULLNULLNULLNULLOTROS109.00NULLNULL

Accepted Solutions (1)

Accepted Solutions (1)

agustin_marcoscividanes
Active Contributor
0 Kudos

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

martin_romano3
Explorer
0 Kudos

tengo 2 decimales en cantidades y 4 decimales en importes

cantidad * precio

20 * 1.77 = 35.40

35.40 *6.96

246.38

eso me da en la inv1

en la oinv me da 246.40

ahi esta la diferencia

Former Member
0 Kudos

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

Former Member
0 Kudos

Lo que debes comparar es el valor neto total con el neto de cada una de las líneas . Si esto te cuadra calcula tu el impuesto.

Answers (0)