90 Minds Community

I was asked by a large client on v2014 Adv using Sage FAS with the FAS Link if I could improve the link / integration. They are using A/P Invoice Data Entry to record the fixed asset purchases and entering the Asset Template field on the Invoice line. That creates the link to FAS and at some point ends up creating the new fixed assets in there. It will send the amount, the invoice date, and a few other pieces of info to FAS. 

However as heavy FAS users, they are complaining the link doesn't send other info to FAS that they have to manually add, such as the Vendor No, Vendor Name, other vendor info. Also they want it to use a "Start Date" instead of Invoice Date for when the depreciation starts. Also they want to send their own Fixed Assets number based on their scheme instead of FAS creating it.

I looked at the FAS Link code and then decided it would be a better idea to ask if anybody knows of a company / individual who has already done this type of customization before. Even if it accomplishes some of what they need that would be great. Anybody know of one?

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Interested in any solutions you find as I have a similar situation

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

So sad that these interfaces are never improved once they are initially cobbled together and throw at the wall.  If they want us to sell cross product solutions, Sage needs to step their game up.  I literally cringed when someone asks about the HRMS to Sage PR link...

Diane Coffman is back working with enhancements.  Maybe she could take a look at this perennial problem.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 03-29-2019 16:32
From: Wayne Schulz
Subject: Looking for FAS Link Enhancement / Improvement

Interested in any solutions you find as I have a similar situation

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

I do not know of anyone except that PSG for FAS might have done something already.  The only issue that I see with their request is wanting to create the Key record (FAS System Number).  They can use the Asset ID (non-key field) for their purpose.  Good Luck.

------------------------------
Andrew Crane
Net at Work
------------------------------

It would not be a stretch to add UDF's desired for update to the Asset record that would be captured during data entry in AP Invoice (or PO) data entry.  When the asset is created the Asset history record in AP contains the new asset System ID which is needed for importing data to update existing assets within the SFA module.  You could easily export the additional asset data fields from Sage APInvoiceHistoryAsset for use to import into SFA.  This would be two steps but would be a decent solution that would not require customization to SFA and the interface.  Otherwise you need to get the SFA PSG and Sage 100 development working together.  That is a tall order.

------------------------------
alan niergarth
Velosio LLC
------------------------------