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

excel invoice posting

(1) Share

Report

Posted on by Sheejo

i am a newbie here. I’m a NAV user. I have created a tessarect program which extracts purchase transaction information from Vendor invoices automatically and populates it to a spreadsheet.
I wanted to know whether there is any process which is available to post the invoices from the spreadsheet. Also is there a way to link the invoices with purchase orders.
Thank you for your time.

All responses (3)

Answers (0)

Srdjan Grandic 95 on at

Like (0)

Report

RE: excel invoice posting

Posted Purchase Invoices have a field called Order No. which refers to the Purchase Order document which was used to post the invoice. Same applies for the Purchase Receipt as well as sales documents. Credit Memos have the field Return Order No.
ManishS 78 on at

Like (0)

Report

RE: excel invoice posting

You need to customized this into the system. You can use Excel Buffer to read the spreadsheet.
Suggested answer

Marco Mels on at

Like (0)

Report

RE: excel invoice posting

Hello,

I will leave this to the community to answer if there are solutions to achieve this.

Thanks.