Hi Irfaan

please consider the attached KBA to resolve your query.

Kind Regards

Bennie SPE07 SPE01. CANNOT INSERT VALUE NULL INTO COLUMN IACCBLNCACCOUNTYPE TABLE..ETBLACCBLNC’ ERROR PROCESSING INVOICE.pdf

Thanks for the reply Bennie,

However, look at my settings, they are as per your instructions in the document.

But I am still getting the same error.

Hi Irfaan

Please confirm the following:

1. Sage Evolution version (check under Hep | about)?

2. Operating System version of the PC where this error is observed on?

3. MS SQL version: 

Hi Irfaan

It could be caused by a lot of things. We need to understand accounts that are affected by the supplier invoice transaction 

1. Supplier control > Check if the SINV Transaction type is set up correctly. If the supplier belongs to a group, check if the group has the correct control account. If the account is not visible, check in the venclass table that there are no ledger control IDs that are not valid

2. GRN Accrual > Check if the GRV Transaction account has a valid transaction type set up

3. Purchase variance > Check if there is a default and valid purchase variance accounts on your Inventory defaults or sales order defaults. f the stock belongs to a Stock group, check if there is a valid purchase variance account both in the front end and on the grptbl table

Thanks all, the issue is resolved.

HI Irfaan

Glad to hear but now you made me curious 

Can you please advise what you did to fix it?

Blessings!

Bennie