Microsoft Dynamics AX (Archived)

Project Budget for Non-Stock Item

(0) Share

Report

Posted on by kumar.tripathi

Dear Member,

Please help to understand the system behaviour for Non-Stock item in Project budget.

Scenarios - we have fixed priced project for that we have project budget

we created purchase order from Item requirement for Non- Stock item ----> Purchase receipt ( At the time of purchase receipt system consumed the budget) ---> post purchase invoice ( At the time of invoice system again consumed the budget) . for same Item and same PO system consumed the budget twice.

Can any one help to explain the reason why system consumed budget twice. how we can correct

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Hi kumar,

I noticed that there are some hotfixes available on LCS that are not even included in CU13.

Tipp: Get a hold on a developer who can take a look at the issue and asses, which of the hotfixes might overcome the problem.

If he/she does not find a suitable fix then you can either open a support case or try to fix the problem yourself with a code modification depending on the urgency of this matter.

Best regards,

Ludwig
kumar.tripathi 75 on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Thanks for reply, We are using AX2012R3 CU13
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Hi kumar,

You are right. This does not seem to be correct.

What AX2012 version do you operate?

If you are running an older one check LCS for available hotfixes.

There are many available for project budgets.

See e.g. fix.lcs.dynamics.com/.../Results;dm=0&v=3_5_7_4_1_16_15&i=2_1_3_4&ct=1_3_5_4_2_6&ft=1_2_3&cu=&pi=&pm=&pc=&rd=&d=&envId=&permission=&x=0&y=0

Best regards,

Ludwig
kumar.tripathi 75 on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Thanks for reply, Issue is not with voucher AX is posting correct voucher.

Let me describe the steps what we did.

Local Currency = SAR and PO currency – USD

Exchange Rate – SAR= USD – 3.75

1-    Select Non-Stock item with Cost price =35000

2-    Create Project Quotation and select the NON-Stock Item

3-    Quotation transfer to Project for that project we have Project budget =59,400

4- We have created PO from Item Requirement, Purchase Price =15,000 USD

5-    Post PO receipt

6- After Posting receipt system got consumed the budget

7-    After Posting an PO Receipt validate Budget Balance. ( System has consumed the budget from Quotation Cost )

8-    Post Purchase Invoice for USD 4050

9-    After Invoice Posting validate Project Budget Balance ( System has consumed Twice )

Please review the screen shot and help us to solve this issue. We are getting this issue only for Non-Stock Item.

Thanks for your help, wait for your reply.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Hello Kumar,

The voucher that ends with 21839 is reversed in the voucher that ends with 21840.

This is something I would expect AX doing.

Where do you see the double counting?

Best regards,

Ludwig
kumar.tripathi 75 on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

As per your Suggestion, Please review the screen shot and can replicate the same.

Thanks for your help.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Hello kumar,

I am interested in screenprints that show the project postings, the budget / consumed budget and the item transaction that consumed the budget twice.

Would be great if you could upload those.

Many thanks and best regards,

Ludwig
kumar.tripathi 75 on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Hi Ludwig,

Thanks for reply, we are using AX2012R3, we have budget only for Project, for non stock item GL budget was there in 2018 but there is no GL budget in 2019.

Which print screen should i need to share with you which can be relevant for your understanding.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Project Budget for Non-Stock Item

Hi,

It sounds strange that your budget is consumed twice. Can you share details and some screenshots?

Also let us know the AX2012 version you operate and whether you use project budgets and/or ledger budgets.

Many thanks

Ludwig