My Products
Help
gordana_jlmwms
PARTNER

Supplier invoice with Purchase order connect error

by gordana_jlmwms

Insert Supplier invoice for final recording for invoice 21. Error: Error creating supplierInvoice. Purchase order 000244 with line number 14 cannot be found in the look-up table.

 

what does this mean?

5 REPLIES 5
gordana
CONTRIBUTOR *

by gordana

order line 14 has the same status as the other lines .

 

 

 

gordana_1-1732712995134.png

 

by Oskar Jansson (Updated ‎03-12-2024 11:22 by Oskar Jansson VISMA )

Hi,

Thank you for your question! Could you specify what you want to do and with which endpoints you have tried? Is 1651653 a stock item? Do you get the same error if you try with non-stock items? And has this worked for you before?

gordana
CONTRIBUTOR *

by gordana

1651653 is inventory. Stock item? can ask customer.

This is the first time I work with purchase order connection to supplier invoice.

by Oskar Jansson

I recommend trying this in the UI first, if you haven't already. Once it works in the UI, please write the workflow using the Screen IDs. This will make it easier for me to assist you with how to do this using the API.

The information below comes from the UI documentation on adding a purchase order to supplier invoice, and on how to use Link Line. My first thought is that the “require receipts” could be the cause for this “cannot be found in the look-up table”- error.
UiDoc.png

 

gordana
CONTRIBUTOR *

by gordana

Hi,

object I am working with is SupplierInvoice.

If I have a connection to purchase orders, I take value on the invoice header "ddPurchaseOrder" like

AddPurchaseOrder
{
poOrderNumber = new PoOrderNumber
{
value = i.PurchaseOrderNo
}

 

and on the invoice row "linkLine"

new LinkLine()
{
purchaseNumber = new PurchaseNumber
{
value = item.PurchaseOrderNo
},
purchaseLineNbr = new PurchaseLineNbr { value = int.Parse(item.PurchaseOrderLineNo) }

};

 

 

endpoint

https://integration.visma.net/API/controller/api/v1/supplierInvoice

RestRequest(Method.POST);