Troubleshooting: Unable to delete Document Numbering Format - The value of column PaymentFormatName in table Payment Method does not exist in its master file

From AutoCount Resource Center

Question: When I try to delete one of the document formats for PV-PBB and OR-PBB, system prompted error “The value of column PaymentFormatName / ReceiptFormatName in table Payment Method does not exist in its master file.”. Why?

Version: 1.8 / 1.9 / 2.0


The value of column PaymentFormatName in table Payment Method does not exist in its master file.

Cant delete docformat1.png


The value of column ReceiptFormatName in table Payment Method does not exist in its master file.

Cant delete docformat2.png


Possible Reason:

The Document Numbering Format is used by a Payment Method.


Solution:

1) Go to General Maintenance > Payment Method Maintenance, pull out the Payment Format Name, and Receipt Format Name, to find out which payment method is using format PV-PBB and OR-PBB.

Cant delete docformat3.png


2) Edit the payment method PBB, change the payment format and receipt format to other format and click on OK.

Cant delete docformat4.png


3) You should now be able to delete the document numbering format.


By: Cit Ta 220615, Lay Swan 220626, P220627



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


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