Options

Adjust exchange rates grouped posting od G/L

sonjapsonjap Member Posts: 21
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.

Answers

  • Options
    ara3nara3n Member Posts: 9,256
    edited 2009-09-30
    It groups them by

    Currency Code, Posting Group,Dimension Combination, Posting Date, and "IC Partner Code"
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    sonjapsonjap Member Posts: 21
    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
  • Options
    ara3nara3n Member Posts: 9,256
    You have the info in the Customer Detail ledger.
    The "Entry Type" for "Unrealized Loss" and "Unrealized Gain"
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    sonjapsonjap Member Posts: 21
    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
  • Options
    ara3nara3n Member Posts: 9,256
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    sonjapsonjap Member Posts: 21
    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
  • Options
    ara3nara3n Member Posts: 9,256
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    sonjapsonjap Member Posts: 21
    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.
  • Options
    sonjapsonjap Member Posts: 21
    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
  • Options
    ara3nara3n Member Posts: 9,256
    you can modify the Adjust exchange report to not summarize

    and add pass fields from where the GL entry is being created.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    sonjapsonjap Member Posts: 21
    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
  • Options
    ara3nara3n Member Posts: 9,256
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    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 ?
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    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)
  • Options
    ara3nara3n Member Posts: 9,256
    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
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.