Project transaction show wrong cost from purchase order

(0) Share

Report

Posted on by John.Holbrook

I have created a project Purchase order, project type time and material, I have created a purchase order from the project for a purchase category.

Purchase line is qty 1 unit price $100.00, Two way matching only.

The invoice is for $96.00 and is posted against the PO.

The project transactions show a cost of $100.00 not $96.00.

Can anyone explain why?

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jon,

Do you use standard costs?

If not then your settings might cause this behavior, which can usually be fixed by running an inventory recalculation.

Best regards

Ludwig

Was this reply helpful? Yes No
John.Holbrook on at

Like (0)

Report

Ludwig, I am not using inventory, just purchase categories.

Was this reply helpful? Yes No
Pravasti AK 2,985 on at

Like (0)

Report

Hi John,

From a tax perspective this is too early and can lead to problems with tax authorities especially in cases where prepayment invoices are posted earlier than the final purchase vendor invoice for example due to long transportation times.that prepayments can only be deducted once the payment is made.

Was this reply helpful? Yes No
John.Holbrook on at

Like (0)

Report

Kavitha, there are no prepayments, the goods were received but only two way matching on a purchase category so the PO was not received just invoice posted for $96.00, the issue I have is the project transactions are showing a cost value of $100.00

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi John,

Are there any charges posted with the category? If this is not the case, can you share some screenshots that illustrate the issue?

Many thanks

Ludwig

Was this reply helpful? Yes No
John.Holbrook on at

Like (0)

Report

Ludwig - No charges.

Sorry can't seem to be able to add screenshots.

The process is simple

Create a project PO

1 PO line for a purchase category with a unit price of $100

Confirm the PO

post an invoice against the PO for a value of $96

the project transactions show a cost value of $100

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report

Hi John,

Invoice proposal: If this is marked, all transactions which are incorporated in invoice proposal to bill the customer can be adjusted. We need to cancel the invoice proposal and re-create it again with the adjusted project transactions. This is applicable for time & material projects only.

Invoiced: If this is marked, transactions with Invoiced status can be adjusted.

Was this reply helpful? Yes No
John.Holbrook on at

Like (0)

Report

Kavitha

This has nothing to do with invoicing the customer from the project.

This is a PO and posting the vendor invoice against the purchase order.

The displayed cost of the purchase is incorrect in the project

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi John.Holbrook,

AX should pick up the $96 and not the $100 if the invoice is posted with $96.

Not sure what is wrong there. Maybe some 'hidden' charges that you overlooked, some taxes, ... ?

Can you replicate the issue for other charge categories or is only one charge category affected?

Did this issue happen one time only or does it happen all the time?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report

the reason of wrong calculation is wrong setup.

1st : check the sales tax code properties

path : GL – Setup – sales tax- sales tax code

2nd: at sales tax group.

check the use tax checkbox, if it is not checked

(or)

The above error is due to same PO Invoice number is used in other transaction.

user might have create two number sequence but the prefix/Postfix might be similar to both number sequence.

for example :

In this case number has created two different number sequence one for project invoice and other for purchase invoice.

example :

PO invoice :- PINV/16/######

Project invoice :- PINV/16/######

Now in this case user has to change the prefix in one of the number sequence and then it will work fine.

Was this reply helpful? Yes No