web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Issue with Billings Tr...
Microsoft Dynamics SL (Archived)

Issue with Billings Transaction Load - currency mismatch?

(0) ShareShare
ReportReport
Posted on by Mark Fineman 420

Hi we just recently switched our project expense billing methods to not use allocator.

We have a UK database with base currency GBP and are using a new Billing Rule which will pull directly from the expenses.

The project we have in question is billing in USD with expenses booked in GBP.

When we run Billings Transaction Load, we get an error message stating "Process Complete.  0 Project Transactions moved to the unbilled detail table.  14 rejected due to billing exceptions.  Some transactions were not loaded due to a currency mismatch."

What would be the cause of this?  Nothing looks amiss on the project and in the billing setup.

thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mark Fineman Profile Picture
    Mark Fineman 420 on at

    I figured this out.  New rate tables and types need to be defined for Project Allocator.  I created a USD based rate type to enter in billing rates in a foreign currency.  Since we have selected the “Activate Foreign Currency Billing” check box in Project Controller Setup (PA.SET.00) the currency field in Rate Type Definition (PA.RTM.00) was available and I entered USD.  I setup a rate table as well (in Rate Table Definition (AL.RTD.00)) containing the USD rate type, but the rate table can only contain rate types that are assigned to either the base currency and one foreign currency.  Next I updated Multi Level Rate Entry (AL.RAT.00) with the new rates.  And then updated allocation methods to include the new rate types in Allocation Method Setup (PA.MET.00).  But, much like the Rate Tables, the Allocation Method can only contain Rate Types that are either assigned to the base currency or to one foreign currency.

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,487 on at

    Hi Mark

    I'm currently experiencing the same error, but am using the 'Percentage Complete' (Fixed Price) revenue recognition type.. do you know if multi-currency billing be used with projects that recognise revenue using 'Percentage Complete' ?

    thanks!

    James

  • Mark Fineman Profile Picture
    Mark Fineman 420 on at

    Hi James,

    I'm pretty sure it can.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans