web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • StarNamer Profile Picture
    on at

    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
    Microsoft Employee on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans