How to import FA begining balance

selece28selece28 Member Posts: 316
Hi Nav masters,
I'm a new navision technical and currently learning about Fixed Assetv(FA)
My client want me to pull out their FA data from current Database and insert into new clean Database as a begining balance.

The things that i know is i need to create 3 dataports.
1. for export import the FA master.
2. for export the FA depreciation book.
3. for import the FA depreciation book into FA Journal and post it

My question is. What fields do i need to export for FA master and FA depreciation book?
Is there any list of standard field in FA that MUST be exported?
I'm afraid i miss some of the important fields.

Thanks in advance
______________

Regards,
Steven

Comments

  • idiotidiot Member Posts: 651
    FA Master Fields:
    No.
    Description
    FA Class Code
    FA Subclass Code
    Global Dimension 1 Code
    Global Dimension 2 Code
    Location Code
    FA Location Code
    Serial No.
    Picture
    FA Posting Group

    I would take these as primary fields required.

    For Depreciation Books will depend on exactly how they want the data to be, just net book value or showing acquisition & depreciation separately.
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • selece28selece28 Member Posts: 316
    OK, thanks for the reply. I think i got most of this covered.
    But do we need to insert 1 depreciation book on the time we import FA master for each FA masters?
    ______________

    Regards,
    Steven
Sign In or Register to comment.