Microsoft Dynamics AX (Archived)

Change Net Amount at Purchase Order Lines

(0) Share

Report

Posted on by benjamin84

2,065

Dear All,

I want ask about change/amend net amount at purchase order lines.

i buy some item, the quantity is 205, unit is liter.
unit price is 4.480146341

but we using 2 decimal, so the net amount = 918.40

our agreement with vendor is, the net amount is 918.43

i tried to typed the net amount manually, but its just make unit price blank.

how to amend the net amount without make unit price empty ?

i already make purchase agrement, but i still dont get net amount my user want ( 918.43 )

is there any work-around to correct the net amount without make unit price blank

Thank you

*This post is locked for comments

All responses (14)

Answers (0)

benjamin84 2,065 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi Guy,

yes, we already did that too, its not pretty that why our manager don't want approve our PO.

we currently using charges on purchase.

thank you
Guy Terry 28,638 Super User 2024 Season 2 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi benjamin

Have you thought of using the 'Price unit' field for your requirement. It's not pretty, but it's effective:
benjamin84 2,065 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

HI Ludwig,

if I type manually the net amount, my unit price went blank automatically. and our setting is 2 decimal. that's why I must make a work around for this requirement.

thank you
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi benjamin84,

The charge code might help.

However, I am wondering why you can't simply enter the quantity and a line amount.

Best regards,

Ludwig
benjamin84 2,065 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi Ludwig,

actually what my user want is just request at purchase order line, the net amount stated 919.43.

my user only need that.

do charges code you mentioned above could fit my user request ?

or I just use charges on purchase instead ?

thank you
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi benjamin84,

If you make use of a charge code similar to the following one, then the price difference is simply added to your inventory value of the items your purchase.

Making use of a charge code similar to this one...

... records your price difference as an expense on account 600120 in the example.

From what you explained above, I would personally go for the first option that posts the difference amount on the item (DR: Inventory account CR: Vendor summary account).

However, your price difference seems pretty small and thus not 'material' from an accounting perspective. Therefore, it should also be ok if you want to expense it by making use of a charge code similar to the second one I posted (DR: Expense account, CR: Vendor summary account)

Probably have a chat with your accountants to decide what code to use best.

Best regards,

Lduwig
benjamin84 2,065 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi Ludwig,

could you explain more, I only understand basic accounting, not depth level.

thank you
benjamin84 2,065 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi Mahmoud,

so its mean, if only create additional expense 1.03 only right ?

what effect that will be happen ?

could you explain with more detail, I understand accounting stuff, but not in depth level.

thank you
benjamin84 2,065 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

Hi Ludwig,

for 'your inventory value will be affected. ' => its just effect to quantity for those PO only right ? ,

so, its safe right ? its just make an additional expense for 1.03 only right ?

thank you
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: Change Net Amount at Purchase Order Lines

what do you mean with the effect and any type of effect?

simply if you use charges on a purchase, your effect on ledger accounts for purchase and expense