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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Project Module: Is Funding Source assigned when a transaction is posted?

(0) ShareShare
ReportReport
Posted on by 1,212

AX 2012 CU7 Project Management & Accounting: 

Problem: I have billable project transactions (timesheets & vendor invoices) that cannot be invoiced but need to be invoiced.  When attempting a project invoice proposal, eligible transactions are displayed on the screen after I click search, but when I try to generate the invoice proposal, AX tells me "No invoice transactions."  These billable transactions are stuck.  I need to bill them. 

Investigating the problem determined that: 
(A) the funding source on the related project contract was changed from customer 1 to customer 2 after timesheets and vendor invoices were posted against the project. (These customers are duplicates, so #one was labeled "do not use" in favor of #2). 

(B) these transactions have a linetype "milestone" yet the project contract has no billing rules against it and the project is a time & material project. 

Question 1: How can I change the funding source on these transactions?  Changing it on the contract doesn't help.  Even when I go back to the project contract and change the funding source to add back the original customer, AX still throws the "No invoice transactions" message.  

Question 2: How can I confirm that a funding source on a project contract is assigned to a transaction when that transaction is posted and not when an invoice proposal is generated?  Can I see this in a table somewhere?  

Question 3: Where is the linetype coming from? 

Ideas? 

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Howard,

    You mentioned that you have setup milestone on-account transactions.

    So what kind of project type is your project linked to (fixed price or time and material)?

    I assume that it might be a fixed price project.

    If so, individual transactions are typically not charged to the customer - otherwise it would be a time and material project.

    You rather invoice your customer the milestone payments that have been setup.

    Can you verify your Project type first and let us know?

    Ludwig

  • howalker Profile Picture
    1,212 on at

    The project is a time and material project.  There are no billing rules created for this project contract.  There are no on-account transactions created for this project.  These are reasons why I don't understand why the linetype "milestone" appears on the eligible transactions.

  • André Arnaud de Calavon Profile Picture
    306,118 Super User 2026 Season 1 on at

    Hi Howard,

    I faced this situation before except for the milestone setup. The funding source can be changed in the table directly; then you can invoice the transactions.

    Tables affected are e.g. ProjEmplTransSale and ProjCostTransSale which contains the funding source reference. Note that this is a foreign key relation based on a record ID. So you need to know which value needs to be used to reference the new funding source.

    Unfortunately you cannot change the funding source using the Adjustment function.

    What "linetype" are you referring to? Do you mean the "Line property" field?

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans