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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AX 2012 R3 Recording Customer Advance on T&M Project with Multiple Funding Sources

(0) ShareShare
ReportReport
Posted on by 80

I have a situation on a Time and Material type project where I need to record a prepayment from a Customer. The recommended method is to use the Customer Advance option on the project. This works fine when there is only one Funding Source. The problem I have run into is that on this particular project, there are multiple Funding Sources involved. For Example, the Project is funded by Customer A and Customer B. The Funding Rules are set up so that this project is cost shared 50/50 between the 2 Customers. There are no Funding Limits, Billing Rules or Budgets in place with this example. Customer A gives me a $10,000 prepayment. When I try and record this using the Customer Advance option, there is no place to specify the Funding Source. If you post the advance, the system automatically splits the $10,000 advance 50/50 between the 2 Funding Sources ($5,000 from Customer A and $5,000 from Customer B) which is incorrect.

 

Question is, how do you process an advance payment from one Customer on a project which has multiple funding sources.

 

Thanks

*This post is locked for comments

I have the same question (0)
  • lally Profile Picture
    8 on at

    Hi Dave ,

    Did you find the answer .. if yes please let me know.

  • Dave Penney Profile Picture
    80 on at

    No. Not yet

  • Suggested answer
    David Massey Profile Picture
    on at

    The allocation of cash advances are based on the allocation setup at the time it is processed.  You change the allocation to be 100% to the customer you want to create the advance for and then reset the allocate rule after creating the advance.  There is some risk in modifying the allocation if other transactions are being processed at the same time.

    If the advance was create using the split allocation it requires creating a job to delete the unwanted ProjOnAccTransSale record.  You will not want to do this in SQL as the ProjOnAccTrans TotalSalesCur field will not be updated correctly.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans