Invoice capture - Line transfer

(3) Share

Report

Posted on by bcbeats

Is it possible to transfer invoice lines into D365 when using the Cost invoice type and the settings are for an Invoice journal in D365?

I can't find any documentation on transferring fields from Invoice capture into D365. We've managed to successfully run PO Invoices and match them in D365 - but since the purchase info is set up at the PO stage we expect this to work. For Cost invoices, we want to create the lines once - select the Expense type and have the lines ready to go on the Invoice journal in D365 after we transfer. Any ideas or documentation you could point me to?

On a related note, we can pull Expense types into Invoice capture. But when we try to load Item numbers it always comes up blank. I can get past this by creating configurations to fill this out in Invoice capture, but can't manually type an Item number in. Ideas?

It seems like a half-built solution.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

For cost invoice in Invoice capture, that has to be a NON_PO Invoice, currently the cost invoice goes to invoice journal only.

Right now the line description are not coming, however MS is working on the feedback, hence suggest to create MS ticket and ask them for roadmap planning, this will help.

Was this reply helpful? Yes No
Suggested answer

MuthukumaranAX 2,903 on at

Like (1)

Report
Copy link

Link copied!

Hi,

In D365 settings, you can map either vendor invoice or cost invoice for "Invoice journal". Based on this setup in D365, Invoice capture tool will be process and transfer the data to respective forms.

You can also transfer invoice lines to cost invoice but ensure you have enable necessary fields in "Manage configuration group" in Invoice capture tool.

We are using invoice journals for cost invoice (NON-PO), but we observed with the current version all the invoice lines are grouped and a single entry is created in invoice journal.

Was this reply helpful? Yes No
Suggested answer

bcbeats 50 on at

Like (0)

Report
Copy link

Link copied!

We switched to Cost invoice = Vendor Invoice and set up posting profiles for new procurement categories so that we can bring the invoice lines over and post. This is great for non-PO invoices with lots of lines.

The cost invoice to invoice journal is header only, so the lines are meaningless in invoice capture if using that setup.

Was this reply helpful? Yes No
DP-05111319-0 2 on at

Like (0)

Report
Copy link

Link copied!

@bcbeats I have a question for you. I have implemented the cost invoices in the same way as you did. Via the procurement categories so they follow the same path as the PO invoices via pending vendor invoices.

But we have another issue, there is no way to get your own line description in the financial ledger.

How did you fix this? Or does the readabillity of the ledger is no issue where you implemented.

For example, you can now only use the default ledger descriptions, but via this setup you cannot use the vendor automations AND get your own description at line level. For example, you want to add a period of the costs, so the financial controller can directly see what costs are posted and to which period they should go.

Was this reply helpful? Yes No