Aged Payables Report - Functional Currency Issue

SUGGESTED

I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This is giving us the incorrect functional currency because it is using the currency rates associated to the documents after March 31.

  • 0
    SUGGESTED

    In AP Options / Processing tab, test changing the two 'Aged unapplied' options.

    Apart from that, I don't think you will find any solutions within report criteria or setups.

    For an immediate fix you can export to Excel and modify the rates on the effected documents.
    In the Aged Parables report selection criteria you can show applied detials - may also assist in separating these out.

    If this is an ongoing issue I suggest the report may need modification - but will be complex