Announcements
Hi guys
Does anyone know what the Microsoft recommended number of lines on an invoice is?
e.g. on a purchase invoice / pending vendor invoice
and also on a PO.
Thank you
Michelle
Hi Andre
It has been difficult to reproduce this issue. We have had a few calls with MS on this.
Sometimes the users get it as soon as they confirm an inbound load. They do use advance warehousing. I'm not sure where the PO distribution are 'falling over'. They do have multiple PO's split across invoices, and then some lines with partial receipts and partial quantities spread across multiple invoices. I do not think it is because of this as this is standard.
There is a custom job updating PO prices to match shipping files, and sometimes this would cause distribution errors (due to charges allocated to all lines I think) and other times no errors.
I got error on error posting 2 large invoices (1300+ lines and 2000+ lines), but when I split it up into multiple invoices I got no errors on posting. This makes no sense and it just shows me this error is random. I have tried to find a pattern, but no success yet.
I do think this is due to custom code as mentioned before, as I have also not seen this at any other client but this one.
Kind regards
Michelle
HI Michelle,
I have not encountered this error myself before. Usually, a receipt is not adjusted after posting the invoice. Are you able to find out the scenario and reproduction steps?
Hi Andre
That sounds great.
The distribution error is not due to anything wrong in the system I believe. I think it is caused by customizations.
We are busy investigating this.
The error is:
PostingNumber: AF00066S21Item: 0236916The purchase order or product receipt was corrected after the vendor invoice was created. All accounting distributions must be re-created to reflect any changes to the purchase order's or product receipt's accounting distributions.Update completedAn error occurred during update
Kind regards
Michelle
Hi Michelle,
Unfortunately, the larger invoices are indeed slow. Just recently, I had an interaction with Microsoft and others where we mentioned that the posting of sales orders and purchase orders need improvement.
Can you elaborate on the endless distribution errors?
Hi Andre
Thank you very much for confirming.
These large invoices with 1000 - 2000 lines are just extremely slow and endless distribution errors.
Thank you for your reply again.
Kind regards
Michelle
Hi Michelle,
There is no recommendation. It all depends on the business. I have seen invoices having over 3000 lines and invoices with just 1 or 2 lines.
André Arnaud de Cal...
293,289
Super User 2025 Season 1
Martin Dráb
232,068
Most Valuable Professional
nmaenpaa
101,156
Moderator