Bank Giro TroubleShooting: Maybank (MAS) Export Giro Payment Error - Failed to enabled constraints. One or more rows contain values violating non-null, unique…

From AutoCount Resource Center
Jump to navigation Jump to search

Question : When I inquiry Maybank (MAS) Export Giro Payment, it shows me error message : Failed to enabled constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Mbb giro1.png

And sometimes it prompts another error: These columns don’t currently have unique values.

Mbb giro2.png

Possible Reason :

Some of the documents have 2 payment methods.

Solution :

1) Go to G/L > Cash Book Entry, filter the type PV.

Mbb giro3.png

2) Filter date range from 11/01/19 to 13/01/19.

Mbb giro4.png

3) Right click on grid header and select column chooser, then drag out Payment Method.

Mbb giro5.png

4) Drag and drop Doc. No. to grouping area so that it will group by this column.

Mbb giro6.png

5) Look into row details and find out the row that shows Count = 2, means this document has 2 payment methods.

Mbb giro7.png

6) Click on (+) to expand it, then double click on the document to open it.

Mbb giro8.png

7) This document has 2 same payment methods – MAYBANK, edit and make it to one because you don’t need 2 same payment methods.

Mbb giro9.png

Mbb giro10.png

8) Now you should able to successfully inquiry Maybank (MAS) Export Giro Payment.

Mbb giro11.png

By : Soh Wee 190125, Lay Swan 200505, P200507

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations