Purchase Order Wrong Net Amount

(0) Share

Report

Posted on by Adhha Adnan

412

Hi All,

I has an issue regarding Purchase Order, i already create a PO with item quantity are 60 units and unit price per unit is 8.81. So supposedly the net amount is 60x8.81 = 528.60

Somehow, system calculate net amount is 454.35. And when checking price and discount tab, there is Change of purchases -74.25 for the item.

How this happened? And how should i tackle this one?

Thank you.

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

guk1964 10,877 on at

Like (0)

Report

RE: Purchase Order Wrong Net Amount

Just be aware that this can also be changed after the PO is raised.

In December 2014 a new option was created in Dynamics AX, go to Procurement and sourcing > Setup > Procurement and sourcing parameters and on Updates tab you’ll see an option ‘Generate charges on product receipt

You can allocate charges at the time of invoicing the purchase order.

Charges can also be allocated after the purchase order invoice gets posted.

Manual charges can also generally entered on sales or purchase orders when the charge occurs on an occasional basis.

Charges can be added to both headers and line

So its not an easy question to answer how or by whom or when this was done.
Suggested answer

nmaenpaa 101,156 on at

Like (1)

Report

RE: Purchase Order Wrong Net Amount

Well, someone has added this setting for the items.

If database logging was used for item settings, you can see from there who has changed it and when. If database logging is not enabled for this table, there's no way to find out who did it. But you can enable the database logging for this field if you want. Then you would catch these changes in the future.

docs.microsoft.com/.../configure-and-manage-database-logging
kaps 106 on at

Like (0)

Report

RE: Purchase Order Wrong Net Amount

This field is updated manually unless you have any customization in place. Is you have database logs enabled check that
Adhha Adnan 412 on at

Like (0)

Report

RE: Purchase Order Wrong Net Amount

Hi,

I have checked, few items are having figure in this field.

How do i check where this figure coming from? Because from our side, we did not do any changes to the item.

Tq
Suggested answer

kaps 106 on at

Like (1)

Report

RE: Purchase Order Wrong Net Amount

Check the Purchase tab on the released product form. You should find your charges there.
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report
RE: Purchase Order Wrong Net Amount

Hi Adhha.

Your calculation is done in this form :

(QTYORDERED * PURCHPRICE) - PurchMarkup = NetAmount

454.35 = (60 * 8.81) - 74.25

The Change of purchases(PurchMarkup ) that will affect the finalization of your purchase price(NetAmount).

see this sql query :

select QTYORDERED,PURCHPRICE,LINEAMOUNT,PurchMarkup,* from PURCHLINE where purchid = 'Apo-000001904'

You can use the link below for more information about Change of purchases :

community.dynamics.com/.../purchase-order-charges-in-ax-2012-r3
Suggested answer

nmaenpaa 101,156 on at

Like (1)

Report

RE: Purchase Order Wrong Net Amount

Check the item's purchase settings on Release product details form, Purchase tab page.
Adhha Adnan 412 on at

Like (0)

Report

RE: Purchase Order Wrong Net Amount

Hi Kapil Arya,

The screenshot
kaps 106 on at

Like (0)

Report

RE: Purchase Order Wrong Net Amount

can u share the screenshot