Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How do we disable the ...
Microsoft Dynamics AX (Archived)

How do we disable the validation which produces the message "The sign on Quantity and Net amount have to be the same" on Supplier/Vendor invoices?

(0) ShareShare
ReportReport
Posted on by StarNamer

In D365 for Finance and Operations, is there a way to disable the validation of Supplier/Vendor Invoices which generates the message "The sign on Quantity and Net amount have to be the same" when a negative Unit price is entered?

In the recycling business, it is normal that some products have positive value and others have negative value, i.e. they cost more to process than the actual value that can be extracted. We quite regularly get deliveries with mixed positive and negative valued items and hence need to enter invoices with both positive and negative prices; all quantities should be positive since all items are received stock. Modifying the business process to split the invoices according to item is probably not an option.

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How do we disable the validation which produces the message "The sign on Quantity and Net amount have to be the same" on Supplier/Vendor invoices?

    Hi Derek,

    I am not an expert in the metal and waste processing business but I have seen specialized ISV solutions that are available for AX/D365FO.

    Have you already checked them and whether they have a good and smart solution for this business requirement?

    To get started, probably have a look at the MS App source.

    Best regards,

    Ludwig

  • StarNamer Profile Picture
    StarNamer on at
    RE: How do we disable the validation which produces the message "The sign on Quantity and Net amount have to be the same" on Supplier/Vendor invoices?

    We are looking at this but it's not really consistent with our existing practice. The point is that we actually have stock/inventory which should have negative value.

    The business is basically metal and related waste processing. Some items, e.g. most scrap metal, have a positive value, e.g. e.g. 1 ton of scrap iron may be worth £130. Others, have negative value, e.g. 1 ton of old electrical items may cost £30 to process, so is valued at negative £30. A supplier may deliver a load which includes both items, hence the invoice will show weights of various items, but the values may vary between positive and negative. Our existing legacy system had no problem, even if we had totally negative supplier invoices.

    We'd like to be able to reproduce this, but it seems the closest we can get is to use negative weights for some items, so the 'unit price' is positive and hence the net amount is negative. What we really need is the option to have a negative 'unit price' as we anticipate there may be problems if price variations mean that an item's unit price switches sign! E.g. if a better recovery process is used and the cost of processing old electrical items, for example, becomes less that the value of the material recovered.

    Surely we can't be the only business which uses both positive and negative unit pricing?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How do we disable the validation which produces the message "The sign on Quantity and Net amount have to be the same" on Supplier/Vendor invoices?

    Hi Derek,

    Can't you make use of positive and negative quantities?

    Multiplying them with a positive price results either in a positive or negative value.

    Changing this logic and allowing negative prices has considerable effects on the inventory valuation and closing process.

    This is something, I would not recommend modifying.

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans