Adjust exchange rates grouped posting od G/L

sonjap

Hi all

We have a problem analyzing the adjust exchange rates posted in G/L. It is grouped somehow and we can not find which transactions are grouped in one posting in G/L. We tried to chech through detailed vendor,customer ledger entries bit it shows all transactions that were posted after adjust exchange rates was run. Does anyone knows how is Navision grouping the unrealized forex from detailed customer, vendor ledger entries when posting in G/L.

ara3n

It groups them by

Currency Code, Posting Group,Dimension Combination, Posting Date, and "IC Partner Code"

sonjap

Thanks for your reply.

But there are a lot of transactions. Probably they are grouped by date also?

Our customer wants a report in which there will be shown G/L postings with details. Let's say there is Unralized forex 1000 (posted on G/L).This 1000 are consisted of 500 for customer A and 500 for customer B. This should also be shown in the report. I guess it is not possible?

Regards,
Sonja

ara3n

You have the info in the Customer Detail ledger.
The "Entry Type" for "Unrealized Loss" and "Unrealized Gain"

sonjap

Thanks Rashid.

I know that but my question was. If you check value entry table you will see the same amounts in G/L and you can check where they are coming from. Here is different: yes we have specified information in detailed cust.ledger entries but if you navigate it you will see every transaction posted by adjust exchange rates batch job and not only the one that are connected with that particular unrealized forex. So I am asking how can I be sure that the reflection in G/L is correct?

Regards,
SOnja

ara3n

The link isn't there.

You could write a processing report that creates a new dimension. SourceEntry and set it to "Entry No."
Run this report before the Adjust exchange report.
This report will create a new dimension for all the subledger entries.
Then when you run the report it will create a separate GL entries per each entry.

sonjap

Thank you once again. We' ll try first to make some report. We'll try to make connection G/L with detailed ledger entries by the filters Posting date, dimension combination etc. and if this can not be done than we'll have to implement your procedure. But since you have been analyzing this in more detail, what is your oppinion, can this kind of report be done only by filtering on after all the dimensions has to be attached?

Regads,
Sonja

ara3n

Once you attach a new dimension, There will be one GL entry for each detail vendor/customer ledger entry.
So writing a report to see the entries related to each other shouldn't be a problem.

sonjap

So, according you there is no way to generate this report without attaching a dimension?

Actually, can we prepare this report without adding the dimension?

Thanks.

sonjap

Maybe I wasn' t really clear in my previous question. I just wanted to ask if this is the only solution? Because we allready have a lot of dimensions and we don't wan't to add another just for this purpose.
Hope to hear from you.

Thanks & regards,
SOnja

ara3n

you can modify the Adjust exchange report to not summarize

and add pass fields from where the GL entry is being created.

sonjap

Thanks Rashed. We decided anyway to use the procedure with the dimensions since it looks more safe and for each detailed vendor ledger entry there is separate G/L entry.

Thank you once again.

Regards,
Sonja

ara3n

That's good news. And I'm glad it all worked out well.
I've suggested this to MS that there should be a link between Cust/Vendor subledger and GL Entry.

julkifli33

so any possibilities, that we can know for this revaluation
let say 10000 USD is for INV001,INV002,INV003
i need to know by document number
what we can do to get this ?

julkifli33

ara3n wrote:

you can modify the Adjust exchange report to not summarize

and add pass fields from where the GL entry is being created.

any clue by "not summarize" ??
i also want to do reval by detail (per document)

ara3n

the steps to modify the report will be this.


Modify table 331. Add a new field called DocumentNo.

Then change the PK of the table and add DocumentNo at the end of the key.

Currency Code,Posting Group,Dimension Entry No.,Posting Date,IC Partner Code

to

Currency Code,Posting Group,Dimension Entry No.,Posting Date,IC Partner Code,DocumentNo

Modify report 595

Add a paramater DocumentNo to function AdjExchRateBufferUpdate

Change line

OK := AdjExchRateBuffer.GET(CurrencyCode2,PostingGroup2,DimEntryNo,Postingdate2,ICCode);

to

OK := AdjExchRateBuffer.GET(CurrencyCode2,PostingGroup2,DimEntryNo,Postingdate2,ICCode,DocumentNo);

Add the following line

  AdjExchRateBuffer."Posting Date" := Postingdate2;
  AdjExchRateBuffer."IC Partner Code" := ICCode;
  //MOD01 Start
  AdjExchRateBuffer.DocumentNo  := DocumentNo
  //MOD01 End
  AdjExchRateBuffer.INSERT;

Change the code where this function is called in the report and pass the document No.


Change function HandlePostAdjmt and add

AdjExchRateBuffer2.GET( at the of the line the documentNo

add the following code

        SETRANGE("IC Partner Code",AdjExchRateBuffer2."IC Partner Code");
       //MOD01 Start
      SETRANGE("DocumentNo",AdjExchRateBuffer2."DocumentNo");
      //MOD01 End        
TempDimBuf.RESET;

hopefully this will get you started