My Products
Help
andretvard
CONTRIBUTOR ***

See Invoiced Quantity on Purchase Receipt?

by andretvard (Updated ‎29-09-2020 09:37 by andretvard )

Hi

 

We are trying to create Customer Invoices by attaching Purchase Receipt lines to the invoices. 

The problem is that when a Purchase Receipt line is already attached to another invoice we get errors like "The PO Receipt Line with order number 005092 and line number 136 doesn't exist in the look-up table".

 

We you do the same in the client such Purchase Receipt lines just do not appear in the look-up table, and on those that do appear there you can see the original quantity as well as the quantity attached to other invoices.

 

We would like to do  a similar control via API but we are not sure is it is possible. The Purchase Receipt lines do not appear to have the Invoiced Quantity field and the look-up table seems not to be available in the API.

 

Do you maybe have any other suggestions on how we can se that it is not possible to attach the invoice receipt line to the customer invoice?

 

Thank you

 

vnet.png

3 REPLIES 3

by Magnus Johnsen

Hi,

Can you please send us the JSON as well as the full URL that you send your request to?

andretvard
CONTRIBUTOR ***

by andretvard

Hi

Below you can find the request details.

But my question is not about why the error occurs - it is clear, because the purchase receipt line is already attached to another invoice.

The question is how we can see that the purchase receipt line is already attached to another invoice BEFORE we send it to API.

 

URL: supplierInvoice/201682
StatuseCode: 400 BadRequest
Response Body: {"message":"Error updating supplier invoice. The PO Receipt Line with order number 006332 and line number 1 doesn't exist in the look-up table."}
ipp-request-id: 5fa62ffc-f025-4d2d-a449-9baa03a997ef
JSON: 

 

{"documentType":{"value":"Invoice"},"hold":{"value":true},"addPOReceiptLines":[{"poReceiptNumber":{"value":"006331"},"poReceiptLineNumber":{"value":2}},{"poReceiptNumber":{"value":"006331"},"poReceiptLineNumber":{"value":3}},{"poReceiptNumber":{"value":"006332"},"poReceiptLineNumber":{"value":1}}]}

 

by Magnus Johnsen

Hi,

As of now, there is no possibility to check this before adding the line.

If you have a need for this, please post it in the ideas part of the forum so that the development team can review it.

 

Thank you.