Add UD field in IR table, Issue Miscellaneous Materia

Kinetic ERP
1

I need add a UD field in IR table, in the form Issue Miscellaneous Materia

2

What table is IR? I don’t believe there is a table called IR

3

Exactly, but it’s the one he uses Issue Miscellaneous Materia:
ir

4

I think you’re going to have to explain exactly what your end goal is.

There is no table “IR”, that is a view in the application made up of data from many tables.

1 Like
5

It is right.
What you want is to add a UD field created in the PartTran table so you can use it.

6

This is HIGHLY not recommended. PartTran is one of the most used tables in the system adding more burden to this table is usually a bad idea.

What problem are you trying to solve?

1 Like
7

We need to add a UD field in this form, but the only table that is there is the IR.

8

What is the purpose of the field? Where is going to go? What is it going to do logic wise? how do you plan on seeing it / working with it outside of the Issue Return screen? In other words, what problem are you trying to solve.

9

IR is a table only in your imagination and the system’s RAM. It’s a temp table you can’t extend it. It’s a hardcoded dataset.

10

For anyone reading this… I am with Jose 100%… Look PartTran usually links back to RcvDtl, ShipHead, consider adding columns to the supporting tables. Rarely if ever on PartTran, don’t kill yourself :slight_smile:

Just had to put that note in, because I see it happen all the time and then people don’t know why their system and SQL indexes are slow, or why they have a deadlock.

1 Like
11

The field is a reference that we use to mark the department to which the movement belongs, we create it in the PartTran, ReqHead and OrderHead table.
We already add it to purchase orders without a problem because it handles real tables, but since the table is IR in this form, we don’t know how to add it.

12

Use a UD Table and create link to the PartTran SysRowID and save the transaction data there and go crazy with the information linked to the transaction?

1 Like
13

Or even add a SysRowID link and Table link so you know what the table reference is then you dont need all the extended columns?

14

I think we all highly suggest you rethink this and back out and do it a different way.

1 Like