Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

AX2012 Vendor invoice quantity tolerances

Posted on by 288,459 Super User

Hi All,

Imaging the next situation: A company orders several products (T-shirts, multiple products, colors, sizes). In the far east they sometimes do not really count the shirts, but based on a weight the ship the shirts.

So when ordering 1000 shirts it is possible that you will receive between 997 or 1003.

Imaging the product receipt is 997. The vendor still invoices 1000 shirts with a unit price of 3.54 and a discount of 3%. Three-way match is enabled.

In this case you need a solution where:

- based on tolerances the AP clerk may post the invoice even if we have not got all products.

- easy way of handling this differences.

When entering 997 as invoice quantity, some rounding differences occurs when filling the unit price. Due to separate posting of the discount (another ledger account), directly filling the line amount is not possible.

We are thinking of customization.This because of the high volume of vendor invoices they have to process. The concepts at this moment are:

- Setup quantity tolerances like the price tolerances.

- In the vendor invoice we need an additional field for the "document invoice quantity". This field will trigger the calculation for line amount. The standard quantity field will be used for handling the inventory.

We still have to verify the feasability of this concept.

Do you have similar issues, requirements? Or do you have some experience with this requirement or some other ideas?

Please share your thoughts.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans