Unbalanced Transaction 5012

[simonsimonian]

Hi! I am trying to create an AR Invoice through SDK. We've been doing that for 2+ years already and it never failed until yesterday. All of a sudden we got the "5012 Unbalanced Transaction" error in our SDK code when adding the AR invoice (of type SAPbobsCOM.BoObjectTypes.oInvoices)

The AR Invoice contains about 200 inventory items, no freight. All tax lines are marked with the "EX" tax-exempt code. The resulting journal entry should look like this:

Accounts-REceivable $yy.yy (debit)

Sales-category1 $xx.xx (credit)

Sales-category2 $xx.xx (credit)

...

Sales-categoryN $xx.xx (credit)

That simple! And it worked thousands of times before....

When I look at the items that should go on this AR Invoice, I am not noticing anything unusual.

We're using SAP 2007A PL47

"Block Unbalanced Journal Entry" is UN-checked

Any suggestions?

thanks

Simon

[simonsimonian]

Owen, correct, it happens though DTW as well.

I dont want to post it manually because the invoice is pretty big.. over 200 items.

Anyone has any idea? is this a product bug?

Edited by: Simon Simonian on Oct 8, 2009 9:33 AM

[Former Member]

Hi All,

In B1 2007 PL 46 i had the same problem. with DTW or DI API.

Try to clean up the SM_OBS_DLL and after that you got the same error, report it to SAP:

Regards,

J.

[former_member201110]

Hi Simon,

The DTW uses the DI API so it does sound like a DI API bug. It would be worth testing on the latest patch if that is an option for you.

Kind Regards,

Owen

[Former Member]

Hi Janos,

Did you solved this issue? I just have the same problem with SAP Business One 2007 A (8.00.181) SP: 00 PL: 47

Here my oJournalEntry XML before Add.

You can see that Debit sum is equal to Credit sum (highlited with red)

<?xml version="1.0" encoding="UTF-16"?>

<BOM>

  <BO>

  <AdmInfo>

  <Object>30</Object>

  </AdmInfo>

  <OJDT>

  <row>

  <BatchNum>0</BatchNum>

  <TransId>0</TransId>

  <BtfStatus>O</BtfStatus>

  <TransType>-1</TransType>

  <BaseRef/>

  <RefDate>20140104</RefDate>

  <Memo>AS400-89532</Memo>

  <Ref1/>

  <Ref2/>

  <CreatedBy>0</CreatedBy>

  <LocTotal>0.000000</LocTotal>

  <FcTotal>0.000000</FcTotal>

  <SysTotal>0.000000</SysTotal>

  <TransCode/>

  <OrignCurr/>

  <TransRate>0.000000</TransRate>

  <BtfLine>0</BtfLine>

  <TransCurr/>

  <Project/>

  <DueDate/>

  <TaxDate>20140104</TaxDate>

  <PCAddition>N</PCAddition>

  <FinncPriod>0</FinncPriod>

  <DataSource>N</DataSource>

  <UpdateDate/>

  <CreateDate/>

  <UserSign>0</UserSign>

  <UserSign2>0</UserSign2>

  <RefndRprt>N</RefndRprt>

  <LogInstanc>0</LogInstanc>

  <ObjType>30</ObjType>

  <Indicator/>

  <AdjTran>N</AdjTran>

  <RevSource>N</RevSource>

  <StornoDate/>

  <StornoToTr>0</StornoToTr>

  <AutoStorno>N</AutoStorno>

  <Corisptivi>N</Corisptivi>

  <VatDate/>

  <StampTax>N</StampTax>

  <Series>1543</Series>

  <Number>0</Number>

  <AutoVAT>N</AutoVAT>

  <DocSeries>0</DocSeries>

  <FolioPref/>

  <FolioNum>0</FolioNum>

  <CreateTime>0</CreateTime>

  <BlockDunn>N</BlockDunn>

  <ReportEU>N</ReportEU>

  <Report347>N</Report347>

  <Printed>N</Printed>

  <BaseTrans>0</BaseTrans>

  <U_MIGSAP_KEY/>

  <U_YVA_RENDI/>

  <U_YVA_NUMREN>0</U_YVA_NUMREN>

  <U_YVA_ANULADO/>

  </row>

  </OJDT>

  <JDT1>

  <row>

  <TransId>0</TransId>

  <Line_ID>0</Line_ID>

  <Account>12121</Account>

  <Debit>0.000000</Debit>

  <Credit>0.000000</Credit>

  <SYSCred>0.000000</SYSCred>

  <SYSDeb>0.000000</SYSDeb>

  <FCDebit>0.000000</FCDebit>

  <FCCredit>863.420000</FCCredit>

  <FCCurrency>USD</FCCurrency>

  <DueDate>20140104</DueDate>

  <SourceID>0</SourceID>

  <SourceLine>0</SourceLine>

  <ShortName>C10211220550</ShortName>

  <IntrnMatch>0</IntrnMatch>

  <ExtrMatch>0</ExtrMatch>

  <ContraAct>C10211220550</ContraAct>

  <LineMemo>AS400-89532</LineMemo>

  <Ref3Line/>

  <TransType>-1</TransType>

  <RefDate/>

  <Ref2Date/>

  <Ref1/>

  <Ref2>89532</Ref2>

  <CreatedBy>0</CreatedBy>

  <BaseRef/>

  <Project/>

  <TransCode/>

  <ProfitCode/>

  <TaxDate/>

  <SystemRate>0.000000</SystemRate>

  <MthDate/>

  <ToMthSum>0.000000</ToMthSum>

  <UserSign>0</UserSign>

  <BatchNum>0</BatchNum>

  <FinncPriod>0</FinncPriod>

  <RelTransId>-1</RelTransId>

  <RelLineID>-1</RelLineID>

  <RelType>N</RelType>

  <LogInstanc>0</LogInstanc>

  <VatGroup/>

  <BaseSum>0.000000</BaseSum>

  <VatRate>0.000000</VatRate>

  <Indicator/>

  <AdjTran>N</AdjTran>

  <RevSource>N</RevSource>

  <ObjType>30</ObjType>

  <VatDate/>

  <PaymentRef/>

  <SYSBaseSum>0.000000</SYSBaseSum>

  <MultMatch>0</MultMatch>

  <VatLine>N</VatLine>

  <VatAmount>0.000000</VatAmount>

  <SYSVatSum>0.000000</SYSVatSum>

  <Closed>N</Closed>

  <GrossValue>0.000000</GrossValue>

  <CheckAbs>0</CheckAbs>

  <LineType>0</LineType>

  <DebCred/>

  <SequenceNr>0</SequenceNr>

  <StornoAcc/>

  <BalDueDeb>0.000000</BalDueDeb>

  <BalDueCred>0.000000</BalDueCred>

  <BalFcDeb>0.000000</BalFcDeb>

  <BalFcCred>0.000000</BalFcCred>

  <BalScDeb>0.000000</BalScDeb>

  <BalScCred>0.000000</BalScCred>

  <IsNet>Y</IsNet>

  <DunWizBlck>N</DunWizBlck>

  <DunnLevel>0</DunnLevel>

  <DunDate/>

  <TaxType>0</TaxType>

  <TaxPostAcc>N</TaxPostAcc>

  <StaCode/>

  <StaType>0</StaType>

  <TaxCode/>

  <ValidFrom>19000101</ValidFrom>

  <GrossValFc>0.000000</GrossValFc>

  <LvlUpdDate/>

  <U_BPP_CTAD/>

  <U_BPP_CTAPAT/>

  <U_BPP_DCCD>0</U_BPP_DCCD>

  <U_BPP_DCPR>N</U_BPP_DCPR>

  <U_INFOPE01/>

  <U_INFOPE02/>

  <U_INFOPE03/>

  <U_InfoCo01/>

  <U_YVA_TIENDA/>

  <U_YVA_UNDTRANS/>

  <U_YVA_FECDOC/>

  <U_HYP_Status>3</U_HYP_Status>

  <U_HYP_BofEx400>89532</U_HYP_BofEx400>

  <U_HYP_Closed>N</U_HYP_Closed>

  </row>

  <row>

  <TransId>0</TransId>

  <Line_ID>0</Line_ID>

  <Account>12311</Account>

  <Debit>0.000000</Debit>

  <Credit>0.000000</Credit>

  <SYSCred>0.000000</SYSCred>

  <SYSDeb>0.000000</SYSDeb>

  <FCDebit>431.710000</FCDebit>

  <FCCredit>0.000000</FCCredit>

  <FCCurrency>USD</FCCurrency>

  <DueDate>20140203</DueDate>

  <SourceID>0</SourceID>

  <SourceLine>0</SourceLine>

  <ShortName>C10211220550</ShortName>

  <IntrnMatch>0</IntrnMatch>

  <ExtrMatch>0</ExtrMatch>

  <ContraAct>C10211220550</ContraAct>

  <LineMemo>LT-268302</LineMemo>

  <Ref3Line/>

  <TransType>-1</TransType>

  <RefDate/>

  <Ref2Date/>

  <Ref1/>

  <Ref2>268302</Ref2>

  <CreatedBy>0</CreatedBy>

  <BaseRef/>

  <Project/>

  <TransCode/>

  <ProfitCode/>

  <TaxDate/>

  <SystemRate>0.000000</SystemRate>

  <MthDate/>

  <ToMthSum>0.000000</ToMthSum>

  <UserSign>0</UserSign>

  <BatchNum>0</BatchNum>

  <FinncPriod>0</FinncPriod>

  <RelTransId>-1</RelTransId>

  <RelLineID>-1</RelLineID>

  <RelType>N</RelType>

  <LogInstanc>0</LogInstanc>

  <VatGroup/>

  <BaseSum>0.000000</BaseSum>

  <VatRate>0.000000</VatRate>

  <Indicator/>

  <AdjTran>N</AdjTran>

  <RevSource>N</RevSource>

  <ObjType>30</ObjType>

  <VatDate/>

  <PaymentRef/>

  <SYSBaseSum>0.000000</SYSBaseSum>

  <MultMatch>0</MultMatch>

  <VatLine>N</VatLine>

  <VatAmount>0.000000</VatAmount>

  <SYSVatSum>0.000000</SYSVatSum>

  <Closed>N</Closed>

  <GrossValue>0.000000</GrossValue>

  <CheckAbs>0</CheckAbs>

  <LineType>0</LineType>

  <DebCred/>

  <SequenceNr>0</SequenceNr>

  <StornoAcc/>

  <BalDueDeb>0.000000</BalDueDeb>

  <BalDueCred>0.000000</BalDueCred>

  <BalFcDeb>0.000000</BalFcDeb>

  <BalFcCred>0.000000</BalFcCred>

  <BalScDeb>0.000000</BalScDeb>

  <BalScCred>0.000000</BalScCred>

  <IsNet>Y</IsNet>

  <DunWizBlck>N</DunWizBlck>

  <DunnLevel>0</DunnLevel>

  <DunDate/>

  <TaxType>0</TaxType>

  <TaxPostAcc>N</TaxPostAcc>

  <StaCode/>

  <StaType>0</StaType>

  <TaxCode/>

  <ValidFrom>19000101</ValidFrom>

  <GrossValFc>0.000000</GrossValFc>

  <LvlUpdDate/>

  <U_BPP_CTAD/>

  <U_BPP_CTAPAT/>

  <U_BPP_DCCD>0</U_BPP_DCCD>

  <U_BPP_DCPR>N</U_BPP_DCPR>

  <U_INFOPE01/>

  <U_INFOPE02/>

  <U_INFOPE03/>

  <U_InfoCo01/>

  <U_YVA_TIENDA/>

  <U_YVA_UNDTRANS/>

  <U_YVA_FECDOC/>

  <U_HYP_Status>3</U_HYP_Status>

  <U_HYP_BofEx400>268302</U_HYP_BofEx400>

  <U_HYP_Closed>N</U_HYP_Closed>

  </row>

  <row>

  <TransId>0</TransId>

  <Line_ID>0</Line_ID>

  <Account>12311</Account>

  <Debit>0.000000</Debit>

  <Credit>0.000000</Credit>

  <SYSCred>0.000000</SYSCred>

  <SYSDeb>0.000000</SYSDeb>

  <FCDebit>431.710000</FCDebit>

  <FCCredit>0.000000</FCCredit>

  <FCCurrency>USD</FCCurrency>

  <DueDate>20140305</DueDate>

  <SourceID>0</SourceID>

  <SourceLine>0</SourceLine>

  <ShortName>C10211220550</ShortName>

  <IntrnMatch>0</IntrnMatch>

  <ExtrMatch>0</ExtrMatch>

  <ContraAct>C10211220550</ContraAct>

  <LineMemo>LT-268303</LineMemo>

  <Ref3Line/>

  <TransType>-1</TransType>

  <RefDate/>

  <Ref2Date/>

  <Ref1/>

  <Ref2>268303</Ref2>

  <CreatedBy>0</CreatedBy>

  <BaseRef/>

  <Project/>

  <TransCode/>

  <ProfitCode/>

  <TaxDate/>

  <SystemRate>0.000000</SystemRate>

  <MthDate/>

  <ToMthSum>0.000000</ToMthSum>

  <UserSign>0</UserSign>

  <BatchNum>0</BatchNum>

  <FinncPriod>0</FinncPriod>

  <RelTransId>-1</RelTransId>

  <RelLineID>-1</RelLineID>

  <RelType>N</RelType>

  <LogInstanc>0</LogInstanc>

  <VatGroup/>

  <BaseSum>0.000000</BaseSum>

  <VatRate>0.000000</VatRate>

  <Indicator/>

  <AdjTran>N</AdjTran>

  <RevSource>N</RevSource>

  <ObjType>30</ObjType>

  <VatDate/>

  <PaymentRef/>

  <SYSBaseSum>0.000000</SYSBaseSum>

  <MultMatch>0</MultMatch>

  <VatLine>N</VatLine>

  <VatAmount>0.000000</VatAmount>

  <SYSVatSum>0.000000</SYSVatSum>

  <Closed>N</Closed>

  <GrossValue>0.000000</GrossValue>

  <CheckAbs>0</CheckAbs>

  <LineType>0</LineType>

  <DebCred/>

  <SequenceNr>0</SequenceNr>

  <StornoAcc/>

  <BalDueDeb>0.000000</BalDueDeb>

  <BalDueCred>0.000000</BalDueCred>

  <BalFcDeb>0.000000</BalFcDeb>

  <BalFcCred>0.000000</BalFcCred>

  <BalScDeb>0.000000</BalScDeb>

  <BalScCred>0.000000</BalScCred>

  <IsNet>Y</IsNet>

  <DunWizBlck>N</DunWizBlck>

  <DunnLevel>0</DunnLevel>

  <DunDate/>

  <TaxType>0</TaxType>

  <TaxPostAcc>N</TaxPostAcc>

  <StaCode/>

  <StaType>0</StaType>

  <TaxCode/>

  <ValidFrom>19000101</ValidFrom>

  <GrossValFc>0.000000</GrossValFc>

  <LvlUpdDate/>

  <U_BPP_CTAD/>

  <U_BPP_CTAPAT/>

  <U_BPP_DCCD>0</U_BPP_DCCD>

  <U_BPP_DCPR>N</U_BPP_DCPR>

  <U_INFOPE01/>

  <U_INFOPE02/>

  <U_INFOPE03/>

  <U_InfoCo01/>

  <U_YVA_TIENDA/>

  <U_YVA_UNDTRANS/>

  <U_YVA_FECDOC/>

  <U_HYP_Status>3</U_HYP_Status>

  <U_HYP_BofEx400>268303</U_HYP_BofEx400>

  <U_HYP_Closed>N</U_HYP_Closed>

  </row>

  </JDT1>

  </BO>

</BOM>

[Former Member]

Hi guys,

We are also getting this unbalanced transactions, we tried to upload it using DTW but no good, still same error Unbalanced Transaction. Same here, we are doing this everyday and this is the first time we encounter this issue. Any fix for this?

You can also check this note number for reference: 1389043 - DI_Unbalanced Transaction error received when adding FC JE

SBO 2007A SP01 PL06

Regards

[former_member201110]

Hi Simon,

Unfortunately, the DI API does sometimes throw up error messages that don't relate to the actual problem. If you try and load the same invoice manually or via something like the DTW do you get the same error message?

Kind Regards,

Owen