Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

B1iSN, b1 to B1, Chart of Accounts, always 'add' instead of 'update'

Hi all!

I'm working on different scenarios where Business Partners, Items and Chart of Accounts have to be integrated between few SAP Business One systems.

I'm using B1iSN.

My Business Partners and Items scenarios are working fine (on add and on update event)

But Chart of Accounts always going to be add, even really it has been updated.

http://screencast.com/t/jIP6eSpCWpev

I didn't include AccountCode field into my integration scenario, because it is system field and it is generated by the system.

below is part of B1i message, payload, object role = 'R' (receiver):

<b1im:Payload ObjectTypeId="Z.B1.8.8_CoA" ObjectRole="R">
	<BOM xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent">
		<BO>
			<AdmInfo>
				<Object>1</Object>
				<Version>2</Version>
			</AdmInfo>
			<ChartOfAccounts>
				<row>
					<Name>Cash at Bank - Checking (HO, USA, GA )</Name>
					<CashAccount>tYES</CashAccount>
					<BudgetAccount>tNO</BudgetAccount>
					<ActiveAccount>tYES</ActiveAccount>
					<DataExportCode/>
					<FatherAccountKey>Cash and Equiv</FatherAccountKey>
					<ExternalCode/>
					<RateConversion>tYES</RateConversion>
					<TaxLiableAccount>tYES</TaxLiableAccount>
					<TaxExemptAccount>tNO</TaxExemptAccount>
					<AccountType>at_Other</AccountType>
					<LoadingType>tNO</LoadingType>
					<LoadingFactorCode/>
					<AcctCurrency>$</AcctCurrency>
					<Protected>tNO</Protected>
					<ReconciledAccount>tNO</ReconciledAccount>
					<LiableForAdvances>tNO</LiableForAdvances>
					<ForeignName/>
					<Details>23</Details>
					<ProjectCode/>
					<RevaluationCoordinated>tNO</RevaluationCoordinated>
					<LockManualTransaction>tNO</LockManualTransaction>
					<FormatCode>112000000100101</FormatCode>
					<DefaultVatGroup/>
					<AllowChangeVatGroup>tYES</AllowChangeVatGroup>
					<Category>0</Category>
					<TransactionCode/>
					<LoadingFactorCode5/>
					<LoadingFactorCode2/>
					<LoadingFactorCode3/>
					<LoadingFactorCode4/>
					<PlanningLevel/>
					<DatevAccount>0</DatevAccount>
					<DatevAutoAccount>tNO</DatevAutoAccount>
					<DatevFirstDataEntry>tYES</DatevFirstDataEntry>
				</row>
			</ChartOfAccounts>
		</BO>
	</BOM>
</b1im:Payload>

Please, advice, how can I indicate to the system, that it should be updated, but not added?

Thanks in advance.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question