Skip to Content

Formula help in Purchase Order document

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 16 at 01:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded