Recommended maximum amount of lines on Invoices

(0) Share

Report

Posted on by Michelle

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

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Michelle 90 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Michelle 90 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Michelle 90 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Recommended maximum amount of lines on Invoices

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Recommended maximum amount of lines on Invoices

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates