Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Recommended maximum amount of lines on Invoices

(0) ShareShare
ReportReport
Posted on by 90

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

  • Michelle Profile Picture
    90 on at
    RE: Recommended maximum amount of lines on Invoices

    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

  • André Arnaud de Calavon Profile Picture
    293,289 Super User 2025 Season 1 on at
    RE: Recommended maximum amount of lines on Invoices

    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?

  • Michelle Profile Picture
    90 on at
    RE: Recommended maximum amount of lines on Invoices

    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

  • André Arnaud de Calavon Profile Picture
    293,289 Super User 2025 Season 1 on at
    RE: Recommended maximum amount of lines on Invoices

    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?

  • Michelle Profile Picture
    90 on at
    RE: Recommended maximum amount of lines on Invoices

    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

  • Verified answer
    André Arnaud de Calavon Profile Picture
    293,289 Super User 2025 Season 1 on at
    RE: Recommended maximum amount of lines on Invoices

    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.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,289 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,068 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans