CustInvoiceTrans to InventTrans

(0) Share

Report

Posted on by bankk

6,603

Hello:

I'm trying to find the relationship between CustInvoiceJour and finding the unique InventTrans row. I'm currently going through InventTransOriginSalesLine from CustInvoiceJour, then using InventTransOriginSalesLine.InventTransOrigin to link to InventTrans.InventTransOrigin. For some Sales order it works but in some instances I'm getting multiple rows back. What am I missing here?

Thank you.

*This post is locked for comments

All responses (3)

Answers (1)

bankk 6,603 on at

Like (0)

Report

RE: CustInvoiceTrans to InventTrans

Hi Mariano,

So far just using InventTransId seems to be bringing back the correct results but I need to further review my results.
Mariano Gracia on at

Like (0)

Report

RE: CustInvoiceTrans to InventTrans

It is not enought looking for InventTransId because a single line can be in many invoices, filter InventTransTable by InventTransId, InvoiceId and voucher
Verified answer

syed baber 11,627 on at

Like (0)

Report

RE: CustInvoiceTrans to InventTrans

Hi KBanh,

Add the following join as well:

InventTransOriginSalesLine.SalesLineInventTransId= InventTransOrigin.InventTransId.

The field InventTransId is unique for each sales order line.

Please verify and let me know if you have further queries.

Thanks,

Baber.