Unknown export file format

While trying to generate Vendor Payments in a development system I repeatedly received this error. I quickly found that it was because the payment file kept loading a different class - one that was unrelated to payments.

This seems to have occurred because I sent a Production data back into development system and the module IDs don’t match.

There are two solutions:

  1. Go to the Payment method and go to the file format setup and remove the class, exit, go back in and re-add the file format.

  2. SQL (then restart AOS)

update v set v.classid = m.axid from daxprod.dbo.VENDPAYMFORMAT as v

join modelelement as m on m.name = v.classname collate SQL_Latin1_General_CP1_CI_AS

and v.classid <> m.axid

NOTE - you may need to repeat this for other payment info, such as:

update v set v.classid = m.axid from daxprod.dbo.CUSTPAYMFORMAT as v

join modelelement as m on m.name = v.classname collate SQL_Latin1_General_CP1_CI_AS

and v.classid <> m.axid

As always, I would prefer to do this inside AX and therefore I would recommend the first option.