This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I cannot use applied to / apply to to link Bill Credit &lt;-&gt; Bill  &lt;-&gt; Bill Payment because there is no link between the Bill and any Bill Payment.

<@U4TPAFXEC> Can you try this?
```SELECT
	LinkType,
	BUILTIN.DF( LinkType ) AS LinkTypeDescription,
	PreviousType,
	PreviousDoc,
	BUILTIN.DF( PreviousDoc ) As PreviousDocTrainID,
	NextType,
	NextDoc,
	BUILTIN.DF( NextDoc ) As NextDocTrainID
FROM 
	PreviousTransactionLineLink 
WHERE 
	( NextDoc = 70195722 ) 
	OR ( PreviousDoc = 70195722 )```
For the NextDoc / PreviousDoc values, enter the ID of a Bill Credit.

For me, that query shows the bills that the credit was applied to.

What it doesn't show is the bill that the credit came from. (In other words, it doesn't show why the vendor gave the credit in the first place.) I see similar behavior on the AR side of things, so maybe this isn't surprising.

That query is very generic. So you can plug in any transaction ID that you want, and regardless of its type, it should yield clues as to where it came from and went to, so to speak.

the problem is I can do that, and get Bill &lt;-&gt; Bill Credit

and I can do the same with Bill  and Bill Payment and get Bill &lt;-&gt; Bill Payment

I get Bills in #1 that dont’ appear in #2

even though NS obviously has a link, because the BC shows on a BP in the UI

This occurs when Bill is fully paid by BCs

That seems really odd.

In the example I gave, that credit was applied to two bills. For one bill, a portion of the credit paid it off entirely. For the second bill, the remaining balance of the credit was applied, along with another credit, and an actual payment.

Not exactly the same scenario, but still kind of a mess.

I wonder if I have to go through multiple “hops” e.g. to get from A to C I have to go via D/B/E