Small and medium business | Business Central, N...

Way to prevent Dimensions posting on GL/Payable Account when they were posted on Invoice header?

(1) Share

Report

Posted on by KS-29042019-0

Hello~

We used to enter purchase invoices manually and add the dimensions on the line level.

We recently implemented an OCR software to streamline invoice entry, the tool (and invoice formats) require that the dimensions are entered on the invoice header now.

We noticed that now our payables account has dimensions data and the Accounting team does not like this. Not only does it make the reporting messy, but our locations (one of our dimensions) do not owe the payables, we owe them as a company, so they would really like to prevent the invoices from posting the dimensions on the payables account, anyone know if this is possible?

Thank you!

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

YUN ZHU 99,966 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

If customized it can be done. But if customized it can be done. For example, you can clear the dimensions data on the purchase invoice before posting.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,495 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

As far as I know, it’s not possible out of the box. Customizing the system, as Yun mentioned, could make it possible. However, can they simply ignore these dimensions on the AP account?

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,292 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Agree with the previous response, only possible through customization

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,690 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You can try the below method for prevent dimension posted into the GL.

However, you will need to customize to clear the purchase header dimensions as YUN ZHU mentioned.

Before

You can see that the AP G/L is posted with Department Code: ADM on the Preview Posting.

Go to GL 5420 and set the Default Dimensions of Department Code with No Code.

Result

The error will say that Department Code must be blank.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,495 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

I don’t think that will work, as it won’t allow the order to be posted at all. My understanding is that they still need to post the order with dimensions included in the header, it's just the AP account that's not supposed to get these dimensions.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello Valentin,

I am reading between the lines of his question since he said they used to add the dimensions on the line level but now due to OCR requirement, the dimensions are entered on the invoice header.

So by removing the invoice header's dimensions after the OCR created the document and keep the lines' dimensions will be what they are doing originally.

You might be right, they may need to have the dimensions on header but not posted to AP now.

Will need more input from to understand their situation.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,495 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That makes sense! I didn't see the part about removing the header dimensions.

Was this reply helpful? Yes No