Finance | Project Operations, Human Resources, ...

Relationship between custinvoicetrans and cuspackingsliptrans

(0) Share

Report

Posted on by Oguzhan

Hi,

I need relationship between custinvoicetrans and cuspackingsliptrans tables.

The table "custInvoicePackingSlipQuantityMatch" is given as a suggestion.

I noticed the "INVOICETRANSREFRECID" column in the "CUSTPACKINGSLIPTRANS" table, but it doesn't fill in "Ax" here either.

If I update this column during invoice posting, will I have any problems in the future?

Thanks,

All responses (4)

Answers (0)

Oguzhan 27 on at

Like (0)

Report

RE: Relationship between custinvoicetrans and cuspackingsliptrans

I used "Find Reference".

Thanks
Suggested answer

GirishS 27,821 Moderator on at

Like (1)

Report

RE: Relationship between custinvoicetrans and cuspackingsliptrans

Okay then, Replying to your question "If I update this column during invoice posting, will I have any problems in the future: -

You need to search where the fields are used - Is there any code which assign values to the field. You can right click on the field and select "Find Reference" - It will show all the objects which are using that field.

Also my suggestion will be instead of adding a value to standard field - create a custom field and assign values to it and you can use that custom field.

Thanks,

Girish S.
Oguzhan 27 on at

Like (0)

Report

RE: Relationship between custinvoicetrans and cuspackingsliptrans

Hİ Girish,

Thanks for the answer,

When I connect with "InventTransId", non post packingslip lines and other invoiced packing slip lines are also coming.

The invoice relationship cannot be established.

It didn't happen with "InventTransId".
GirishS 27,821 Moderator on at

Like (0)

Report

RE: Relationship between custinvoicetrans and cuspackingsliptrans

Hi Oguzhan,

Field "INVOICETRANSREFRECID" in table CUSTPACKINGSLIPTRANS has visible property set to No in the table.

I guess both custinvoicetrans and cuspackingsliptrans table has "InventTransId" field.

Have you tried adding InventTransId field as relation between the tables?

Thanks,

Girish S.