My Products
Help
andretvard
CONTRIBUTOR ***

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

by andretvard (Updated ā€Ž15-04-2021 16:51 by Yıldırım VISMA )

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)

 

vnet3.png

 

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)

 

vnet1.png

 

 

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

vnet2.png

5 REPLIES 5

by Yıldırım (Updated ā€Ž29-09-2020 15:28 by Yıldırım VISMA )

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
CONTRIBUTOR ***

by andretvard

Here is an example from production.

 

Invoice has 1 line

vnet5.png

 

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

vnet4.png

 

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

vnet6.png

 

Accepted solution
Yıldırım
VISMA

by Yıldırım (Updated ā€Ž30-09-2020 14:15 by Yıldırım VISMA )

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
SL_preferences.png

 





 

 

 

 

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


Validation.png

 

 

 

 

 

 

 

 

 

 

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
CONTRIBUTOR ***

by 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!

by Yıldırım

You're welcome Andre šŸ‘