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

[Former Member]

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.

[Former Member]

I've added new node to ma xsl transformation: <QueryParams>, where i tried to define a chart of account key in receiver system.

btw,

how can i define a key in sender system, if the following node in message has empty attribute 'L':

 <b1im:Receiver xmlns:b1im="urn:com.sap.b1i.sim:b1imessage">
  <sim:M xmlns:sim="urn:com.sap.b1i.sim:entity" L="" U="" G="11060310511843109180C0A8060D30CF" O="1" /> 

[Former Member]

I solved my issue by adding Key Expansion, where receiver account code is defined.

[former_member204601]

Hi, could you give me more information about your solution?, I have the same problem but using sales employees

thanlks

oscar

[Former Member]

I used Ext BIU - WritePolicy to change update method, but i'm getting error 'The updating business object doesn't exist'..

Guys, I will appreciate for any suggestion!