EMIGALL - PS_RETURN

[Former Member]

I am trying to post a Tax Return in emigall. I am mocking up the data and I get the migration to run without error. I can see the records in DFMCA_RETURN and DFMCA_FORMS. The problem I have is, where did the data go with my field values? I entered 3 fields based on our form, there was no error, but I can't find the table that holds the data.

Thanks

Michael

[friedrich_keller · Accepted solution]

Hi Michael,

When you migrate a tax return, the following tables are updated: DFMCA_RETURN, DFMCA_FORMS und DFMCA_FORM_VERS.

Cheers,

Fritz

[Former Member]

Hi Fritz,

Thank you so much for that answer! We were told that the field data goes to DFMCACD_FORMSDATA. Can you tell me where the TAX_FORM_STRUCTURES update too as I can not find them in the DFMCA tables and am not sure where to look.

Thanks

Michael

[friedrich_keller]

Michael,

Can't you create an SQL trace and try to figure out which tables are updated? This is what I would do - tax returns are not necessarily my area of expertise ;o)

Kind regards,

Fritz

[Former Member]

Fritz,

I am not familiar with SQL traces but I am sure I can figure it out. I really appreciate your help, we were a little mis-led about the table and I can now stop chasing that one

Michael