Splitting of tax in Supplier/Vendor Invoices

(1) Share

Report

Posted on by Phil Matthews

Good afternoon,

We have a scenario where we will need to split a Vendor Invoice Line, because some of the line content is taxable, and some is not. The Vendor Invoice Line is linked to a Purchase Order Line which is created from a Purchase Requisition (and based on a Procurement Category), but the end user is not aware of how the line should be split until the line is received.

For example:

Purchase Requisition created for Procurement Category ABC with a line quantity of 5.
Purchase Requisition goes through workflow, is approved, and then converted to a Purchase Order and confirmed.
The PO is received and it is then established that a qty of 4 are taxable and a qty of 1 is not.
Two separate receipts are generated for a qty of 4 and a qty of 1.
The Vendor Invoice is generated from the Purchase Order, but it only shows 1 line with a quantity of 5.

At present they are manually splitting the line on the Purchase Order before receipting and this does return the desired outcome. However, it also means that the Purchase Order must be resubmitted to the approval workflow and so creates an unacceptable delay in waiting for the Purchase Order to be reapproved and requires an unacceptable amount of manual intervention.

The end user has ruled out manual adjustment of the tax because it is too vulnerable to mistakes.

What should be the process here?

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (3)

Sort by

Suggested answer

AR-01121610-0 4,973 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hy Phil,

best practice would be to have the PR & PO created as it will be invoiced, means 2 lines with two different item tax codes. No effort with receipt and invoice.

Otherwise the PO has to be changed, which causes manual intervention.

To avoid effort because of rerun the PO Workflow, there are some options within the Procurement Policies to have seperate Workflow route in case of a required reapproval. You can find details here this blog post.

Hopw this helps.

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi,

There is no OOB process that you can proceed with for one line.

Was this reply helpful? Yes No
Verified answer

Ramit Paul 22,805 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

This is the concept of Breakdown of voucher, which is available in Invoice journal (Cost invoice), however not in PO invoice, I echo with Andreas Raithel, you can explore the reapproval policy which will cut down your waiting time.

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,055 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Phil,

I think the easiest way will be to override the Tax amount using sales tax adjustment feature based on actual tax applied by vendor for the invoice.

I am assuming you are most clear on applicable tax when invoice is received.

Was this reply helpful? Yes No