Total Amount is 0 when adding Purchase Receipt lines to Supplier Invoice

[andretvard]

Hi

We noticed that sometimes we get Total Amount is 0 when adding Purchase Receipt lines to Supplier Invoice. It happens often but not always. And it happens when invoices created both via API and in the client and seems to depend on Purchase Receipt.

Example JSON:

{
  "documentType": {
    "value": "Invoice"
  },
 
  "hold": {
    "value": true
  },
  
  "supplierReference": {
    "value": "20200929-001"
  },
  
  "supplierNumber": {
    "value": "50005"
  },
  
  "addPOReceiptLines": [
    {
      "poReceiptNumber": {
        "value": "00185"
      },
      "poReceiptLineNumber": {
        "value": 1
      }
    }
  ],
  
}

Apparently there is some logic behind. Could you please explain us what we should do?

Thank you! 

--------------

This is how it looks when Total Amount is 0 and invoice is created via API (it is only possible to create a parked invoice but it is impossible to remove the Hold afterwards due to missing total amount)

This is how it looks when Total Amount is 0 and invoice is created in the client (it is not possible to save the invoice without Hold checkbox)

And this is how it looks when invoice was created via API with another Purchase Receipt line:

[Yıldırım]

Hello,

Can you please share a print screen from the Purchase Receipt (Header / Lines visible) that you reference in the Supplier Invoice and it gets totalAmount:0 ?  

- How Purchase Receipt has been created ? 
- Do you get the same result when Purchase Receipt is manually linked to Supplier Invoice in the UI ?

[andretvard]

Here is an example from production.

Invoice has 1 line

Here is the related Purchase Receipt. It was created manually in the client.

I tried creating a new invoice with the same PR line in the client and I got the same result:

[Yıldırım · Accepted solution]

Hello, 
this is not related to API operation but Financials ERP Company settings. 

Supplier Invoice requires Validation for Document Totals on entry since this feature has been enabled on your company.

Supplier ledger preferences / ScreenId=AP101000

Once it's enabled, following fields become active and the user needs to enter Validation Amount in the supplier invoice.

Please consult this configuration with Integration's ERP Consultant to make sure whether this is intended setup or can be disabled. 

Otherwise, one can send 

  "amount": {
    "value": 0
  },

In the Header part of the JSON. This value should match the "Detail Total" of the Invoice (Purchase Receipt Total if Added / Linked to the Invoice)

[andretvard]

Yes, indeed the customer had it on in one of the companies and we only need to send the total amount in the API call.

Thank you for the explanations!

[Yıldırım]

You're welcome Andre 👍