Open Forum

Using an existing Sl table as a pvlist in an unrelated screen

  • 1.  Using an existing Sl table as a pvlist in an unrelated screen

    Posted 09-26-2018 01:03 PM
    I have a third party solution for Fixed Assets that I want to use the SubAcct table as the pvlist for the location of the asset. How do I use SubAcct_all as the pv for a field in that screen

    ------------------------------
    Sandria Williamson
    Systems Multi Services
    KINGSTON
    ------------------------------


  • 2.  RE: Using an existing Sl table as a pvlist in an unrelated screen

    SILVER CONTRIBUTOR
    Posted 09-27-2018 08:27 AM
    Hi Sandria,

    Does your subaccount = location?

    I use Plumbline FA (formerly Progressive) and can set the locations to whatever I want them to be.  If your subaccount = location, I would just populate the location table using your subaccount as the location ID.

    Hope this makes sense.  Let me know if this doesn't solve your issue.

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Controller
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 3.  RE: Using an existing Sl table as a pvlist in an unrelated screen

    Posted 09-28-2018 07:39 AM
    The actual locations are the cost centers used in Sub Accounts. The FA product does not have a location table so the users free type the location in a user field that poses a problem. So we would like to give them the SubAcct table as a PV

    ------------------------------
    Sandria Williamson
    Systems Multi Services
    KINGSTON
    ------------------------------



  • 4.  RE: Using an existing Sl table as a pvlist in an unrelated screen

    BRONZE CONTRIBUTOR
    Posted 09-28-2018 10:32 AM
    Sandria,

    What "location" field are you speaking of in the Assets Screen?  We use Fixed Assets at my company and there is a "Current Location ID" that looks into a Location table maintained in Asset Locations (FA.220.00).  This screen allows you to create a lookup table that is used in the assets screen.  While it's technically possible to change the PV to look at the Subs, rather than this table, it is not something I would recommend because processes within the code of FA may look to this table for information and if it's empty then they may fail.  It would be best to populate this Locations table with the values you want to be able to select.

    Joe

    mOXAuVbjS7cvDyEsgL4p_FA Locations.png


    ------------------------------
    Joe Miller
    Director of Systems Architecture
    Harrison, Walker & Harper
    Paris TX
    ------------------------------



  • 5.  RE: Using an existing Sl table as a pvlist in an unrelated screen

    Posted 10-01-2018 11:06 AM
    We are using the Adaptable Solutions Fixed Asset Module it does not have a location table

    ------------------------------
    Sandria Williamson
    Systems Multi Services
    KINGSTON
    ------------------------------



  • 6.  RE: Using an existing Sl table as a pvlist in an unrelated screen

    SILVER CONTRIBUTOR
    Posted 10-01-2018 11:15 AM
    Hi Sandria,

    Do you have any table that you aren't using the you could call location?

    I've never heard of a FA program not having a location as a table....just doesn't seem right....

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Controller
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 7.  RE: Using an existing Sl table as a pvlist in an unrelated screen

    Posted 10-02-2018 12:57 AM
    Hi Sandria,

    I am from Adaptable Solutions, we are now called Adaptable Consulting. Please email me directly and I'll look at what we can do to help you - j.deyell@adaptable.co.nz

    Many thanks,
    John.

    ------------------------------
    John Deyell
    Business Consultant
    Adaptable Consulting Limited
    Auckland
    ------------------------------