We have had recently come across a query which says, “Is it possible to import Fixed Asset with Linked Expenses?”. The answer is “Yes. It is possible“.But now the next question would shoot at us is “How ?”

New Stuff: How to set minimum and maximum length of Site Code

I would like to cite a minimal entry expense import example, the data for which could be exported from the FXDASSETS table after it was loaded.

LAYOUTFAS CODLOF Reference No
LAYOUTFAS CPY Company No
LAYOUTFAS FCY Financial site No
LAYOUTFAS DES Description No
LAYOUTFAS AASREF Asset No
LAYOUTFAS FLGLIKAAS Asset link No
LAYOUTFAS FLGLOFMAI Principal expense No
LAYOUTFAS DATVCR Invoice Date No
LAYOUTFAS AMTNOTCUR Inv Amt -Tax No
LAYOUTFAS RATCUR Currency Rate No
LAYOUTFAS RATVAT Invd VAT rate No
LAYOUTFAS DATIMP Posted Date No
LAYOUTFAS GACACN PCG nature No
LAYOUTFAS GAC PCG acct No

I think this can be helpful for the user in achieving the Import with Linked Expense.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.