B1iSN changes JE currency

[Former Member]

Hello Team,

I have successfully installed the SAPBO 8.8 To Be honest PL10 and B1iSN. The installation appears to be fine. I'm getting a behavior that is a issue for me, please let me know if i am wrong.

When i add a JE in a subsidiaries and the system run the consolidation but interchange the System currency by the Local Currency.

EX: if the Debit on the Sender company is USD 500 (Local Currency) and DOP 18000 (System Currency) the JE added automatically to the Receiver company(Same rules for currency) says debit 18000 on the Local Cur and 18000 * rate in the system instead of add the USD 500 in the LC and DOP 18000 in the SC.

[Former Member]

SAP ROCKS!!

[Former Member]

Hi,

Welcome you post on the forum.

Do you mean both systems have the same LC as USD and SC as DOP?

Thanks,

Gordon

[Former Member]

Thks for the Reply Gordon.

Yes both companies have LC --> USD

SC--> DOP

Exaple of the issue :

1, Original JE its 45 USD (LC) 1757 DOP (SC)

After been sent in the other company i recieve:

1757USD (LC) 68523DOP (SC)

Thaks for any help you can give me

Edited by: GARG23 on Mar 3, 2011 2:58 AM

[Former Member]

Please see part of the xml generated from the monitoring tool message log.

**********************************************

- <JournalEntries_Lines>

- <row>

<Line_ID>0</Line_ID>

<AccountCode>_SYS00000000003</AccountCode>

<Debit>0.000000</Debit>

<Credit>45.000000</Credit>

<FCDebit>0.000000</FCDebit>

<FCCredit>0.000000</FCCredit>

<FCCurrency />

<DueDate>20110302</DueDate>

<ShortName>_SYS00000000003</ShortName>

<ContraAccount>_SYS00000000003</ContraAccount>

<LineMemo />

<ReferenceDate1>20110302</ReferenceDate1>

<ReferenceDate2 />

<Reference1 />

<Reference2 />

<ProjectCode />

<CostingCode />

<TaxDate>20110302</TaxDate>

<BaseSum>0.000000</BaseSum>

<TaxGroup />

<DebitSys>0.000000</DebitSys>

<CreditSys>1757.810000</CreditSys>

<VatDate />

<VatLine>tNO</VatLine>

<SystemBaseAmount>0.000000</SystemBaseAmount>

<VatAmount>0.000000</VatAmount>

<SystemVatAmount>0.000000</SystemVatAmount>

<GrossValue>0.000000</GrossValue>

<AdditionalReference />

<CheckAbs>0</CheckAbs>

<CostingCode2 />

<CostingCode3 />

<CostingCode4 />

<TaxCode />

<TaxPostAccount>tpa_Default</TaxPostAccount>

<CostingCode5 />

<LocationCode>0</LocationCode>

<ControlAccount>_SYS00000000003</ControlAccount>

<EqualizationTaxAmount>0.000000</EqualizationTaxAmount>

<SystemEqualizationTaxAmount>0.000000</SystemEqualizationTaxAmount>

<TotalTax>0.000000</TotalTax>

<SystemTotalTax>0.000000</SystemTotalTax>

<WTLiable>tNO</WTLiable>

<WTRow>tNO</WTRow>

<PaymentBlock>tNO</PaymentBlock>

<BlockReason>0</BlockReason>

</row>

- <row>

<Line_ID>1</Line_ID>

<AccountCode>_SYS00000000003</AccountCode>

<Debit>45.000000</Debit>

<Credit>0.000000</Credit>

<FCDebit>0.000000</FCDebit>

<FCCredit>0.000000</FCCredit>

<FCCurrency />

<DueDate>20110302</DueDate>

<ShortName>_SYS00000000003</ShortName>

<ContraAccount>_SYS00000000003</ContraAccount>

<LineMemo />

<ReferenceDate1>20110302</ReferenceDate1>

<ReferenceDate2 />

<Reference1 />

<Reference2 />

<ProjectCode />

<CostingCode />

<TaxDate>20110302</TaxDate>

<BaseSum>0.000000</BaseSum>

<TaxGroup />

<DebitSys>1757.810000</DebitSys>

<CreditSys>0.000000</CreditSys>

<VatDate />

<VatLine>tNO</VatLine>

<SystemBaseAmount>0.000000</SystemBaseAmount>

<VatAmount>0.000000</VatAmount>

<SystemVatAmount>0.000000</SystemVatAmount>

<GrossValue>0.000000</GrossValue>

<AdditionalReference />

<CheckAbs>0</CheckAbs>

<CostingCode2 />

<CostingCode3 />

<CostingCode4 />

<TaxCode />

<TaxPostAccount>tpa_Default</TaxPostAccount>

<CostingCode5 />

<LocationCode>0</LocationCode>

<ControlAccount>_SYS00000000003</ControlAccount>

<EqualizationTaxAmount>0.000000</EqualizationTaxAmount>

<SystemEqualizationTaxAmount>0.000000</SystemEqualizationTaxAmount>

<TotalTax>0.000000</TotalTax>

<SystemTotalTax>0.000000</SystemTotalTax>

<WTLiable>tNO</WTLiable>

<WTRow>tNO</WTRow>

<PaymentBlock>tNO</PaymentBlock>

<BlockReason>0</BlockReason>

</row>

</JournalEntries_Lines>

</BO>

</BOM>

</b1im:Payload>

- <b1im:Payload ObjectTypeId="B1.8.8_JE" ObjectRole="R">

- <BOM>

- <BO>

- <AdmInfo>

<Object>30</Object>

<Version>2</Version>

</AdmInfo>

- <JournalEntries>

- <row>

<ReferenceDate>20110302</ReferenceDate>

<TaxDate>20110302</TaxDate>

<VatDate />

<Series>39</Series>

<StampTax>tNO</StampTax>

<AutoVAT>tNO</AutoVAT>

<DueDate>20110302</DueDate>

<Memo>*18:</Memo>

<Reference />

<Reference2 />

<TransactionCode />

<ProjectCode />

<Indicator />

<UseAutoStorno>tNO</UseAutoStorno>

<StornoDate />

<ReportEU>tNO</ReportEU>

</row>

</JournalEntries>

- <JournalEntries_Lines>

- <row>

<AccountCode>_SYS00000000003</AccountCode>

<Debit>0.000000</Debit>

<Credit>1757.810000</Credit>

<ShortName>_SYS00000000003</ShortName>

<ReferenceDate1>20110302</ReferenceDate1>

<ReferenceDate2 />

<TaxDate>20110302</TaxDate>

<BaseSum>0.000000</BaseSum>

<TaxGroup />

<VatLine>tNO</VatLine>

<DueDate>20110302</DueDate>

<ContraAccount>_SYS00000000003</ContraAccount>

<LineMemo />

<Reference1 />

<Reference2 />

<ProjectCode />

<CostingCode />

<CostingCode2 />

<CostingCode3 />

<CostingCode4 />

<CostingCode5 />

<VatDate />

<AdditionalReference />

<FederalTaxID />

</row>

- <row>

<AccountCode>_SYS00000000003</AccountCode>

<Debit>1757.810000</Debit>

<Credit>0.000000</Credit>

<ShortName>_SYS00000000003</ShortName>

<ReferenceDate1>20110302</ReferenceDate1>

<ReferenceDate2 />

<TaxDate>20110302</TaxDate>

<BaseSum>0.000000</BaseSum>

<TaxGroup />

<VatLine>tNO</VatLine>

<DueDate>20110302</DueDate>

<ContraAccount>_SYS00000000003</ContraAccount>

<LineMemo />

[Former Member]

Hi Gordon,

I found the way to edit the XSL files, by default the value debit = debitSys, the same for credit, i changed to debit = debit and credit = credit and now is working as i need it. Let me know if with your experience the modifications could cause a problem later.

Warms Regards,

[Former Member]

This should be fine. The common scenario is debit = debitsys. Since you have special case, you can customize the map.

[Former Member]

Thanks for your help!!

[Former Member]

The best way to say thanks on the forum is follow the [forum rule|http://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement].