Empty

[Former Member]

Hi All,

when performing reconciliation of open debit and open credit transaction that have same value (same total) but different exchange rate, the journal entry created after reconcile did not have project code.

The field is empty either in row or header of JE.

Although in the document and in the BP, the project code have been defined.

The journal entry will be as follows:

Dr. Customer

Cr. exchange rate loss

The second case, when creating delivery, the journal entry created only have one project code filled i.e. in the BP row, but 2 other rows did not have project code. In header, the project code is not empty.

How could it be happened in SBO 2005A SP 01 PL 39 ?

Please give advice.

TIA

Rajh

[former_member186095 · Accepted solution]

Hi,

In B1 2007A version, this issue also still exists. I think tt is really disappointing. What is the reason behind this issue we could not understand.

We must still manually update the project code. Even in the journal entry header, we can't find the project code.

Rgds,

[former_member583013]

Rajh,

In this statement The second case, when creating delivery, the journal entry created only have one project code filled i.e. in the BP row, but 2 other rows did not have project code. In header, the project code is not empty

I am not clear on what your mean by BP Row?

The Project Code entered in the Header does not automatically populate to the rows in the marketing document. I have always wondering about this and the answer I got from SAP Support was it was a feature where by each row can have it own project code / even be left blank.

Therefore if you want the Project Code from the document header to copy to the rows you need to create a formatted search on the Project Code column at the row level to select the project code on the Header when the ItemCode / Item Description changes.

Suda

[anna_shao]

Hi,

I could assume your first senario.

AR invoice: 100 USD with exchange rate 10.

Incoming Payment on account: 100 USD with exchange rate 11.

Then reconcile the AR invoice and Incoming Payment and a journal entry is created automaticlly with only local currency. But this journal entry has no project code.

I have to say it is a system definition, but you can update the project code in Journal Entry manually.

[Former Member]

Tks a lot for your answer.

If there are more than 200 journal entries, it will be overkill for the user to manual update. They want to generate P&L report based on project code. This project code is used to differentiate product for customers.

So, in the BP, there is a project, but why it is not be autopopulated into the journal entry resulted from automatic reconciliation into rows of shortname/BPcode and account exchange rate gain/loss.

Is it one of B1 weakness ? is the coding used by SAP developer can not do that ?

Rajh

[Former Member]

Tks a lot for your answer.

The BP row here means the shortname/Gl account code column in the journal entry row (JDT1 table).

if the journal entry created based on marketing document like invoice, there will be a shortname.

In the delivery, indeed there is no BP / shortname. The project code is also unavailable although in the marketing document, the project field is automatic filled based on BP project code (projectcod field).

How to resolve this problem ? is it resolved in 2007A version ?

Rajh

[former_member583013]

Rajh,

Once when I spoke with SAP Support regarding this they mentioned that they have a document explaining how to update the JE's using DTW.

You should contact SAP Support with this issue.

Suda