Skip to Content
0

Formula help in Purchase Order document

Feb 14 at 04:30 PM

35

avatar image

9.3 PL7 (SQL VERSION)

On my purchase order document, I have a formula field that shows the BP catalog number if one exists. This is the formula I'm using
if isnull({oscn.substitute})
Then
{por1.itemcode}
Else
{oscn.substitute}

It works fine if a stock item only has one BP catalog no listed.
But if the stock item has a Customer & a supplier catalog number then I end up with two lines being printed out on the document.

Can anyone advise how I can update the script to only print where the oscn.cardcode = oitem.cardcode
So I only get the matching supplier BP number on the Purchase Order?

I've attached screen shots to show what I mean as might be easier to understand.

Thanks,
Eoin

1402-1.png1402-2.png1402-3.png1402-4.png

1402-1.png (29.9 kB)
1402-2.png (19.1 kB)
1402-3.png (24.8 kB)
1402-4.png (27.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Eoin Lappin Feb 16 at 01:24 PM
0

Solved this by creatigna new field on the doc lines & added a formatted search to look at the oscn table.

Then in the crystal report (PO) added the if statement base don the filed on the line.

All working now & closing the question. Thanks.

Share
10 |10000 characters needed characters left characters exceeded