Skip to Content

FMS Based on BP Series or BP Group

Hello Guys,

Is it possible to put FMS based on the BP Series or BP Group?

This is my Scenario:

I have an group of Vendors in an group called A and It's Itemcode Series starts with A0001

If an particular vendor is selected from this series, A service item(SER0001) should automatically populate in the item No in row level of A/P Invoice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 28 at 02:33 PM

    Hi Deepak Ramesan,

    Here below the solution for the FMS:

    Declare @BPGroup nvarchar(15)
    SET @BPGroup = (select GroupCode from OCRG Q1 where Q1.GroupCode=(select GroupCode from OCRD where OCRD.CardCode=$[OPCH.CardCode]))
    IF @BPGroup=101 SELECT  'SER000' + $[$38.0.0]  
    

    You still need to change the '101' by the GroupCode of the service item.

    The above code offers you idea that I hope will help you.

    Thank you,

    Aziz

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 24 at 11:13 AM

    Hi Deepak,

    Yes it is feasible by using the variable $[$38.0.0].

    Thank you,

    Aziz El Mir

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25 at 02:46 PM

    Thanks for your response...

    If possible can you explain in little bit details...

    Add comment
    10|10000 characters needed characters exceeded