Skip to Content

Importing Fixed Asset Balances

Hello:

I know that there is a window in SAP Business One that can be used to import Fixed Assets Master Data.

But, if a client wants to also import balances for each group of fixed assets, would the best way to handle this be to use B1's Data Import window to create journal entries and post the resulting journal entries?

If so, is there a danger of "doubling" the balances of fixed asset accounts from importing the Fixed Assets Master Data, as well?

Thank you!

John

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Feb 12 at 07:30 AM

    Hi John,

    Yes It is possible to import fixed asset balance through manual JE.

    Thanks,

    Satish

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 10 at 05:08 AM

    Dear John,

    Import your fixed asset in sap business one using the "Import Fixed Asset Data from Microsoft Excel" function.

    This import process doesn't create any journal Entries but it will allow you to create your Fixed Asset master data with all necessary information.

    Then you can hit the Fixed asset ledger using manual Journal Entries posting.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 04:48 AM

    Hi,

    Is the 'Import Fixed Asset Data using Microsoft Excel' not catering to the requirement? You have lot of fields like APC, Historic APC, ordinary Depreciation, Accumulated Depreciation, Capitalization date etc. which you can import.

    If not helpful, then you can try to import the Fixed Asset as 'New' and then either post the associated entries or import the entries and see if the balances work out as required in the DEMO database first.

    regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 08:03 AM

    Hi

    I think if your client is not going to use this module, he can record the journal entry with the FA balances.

    I imported the FA with Excel tool in SBO, and it was ok and easy to use.

    Kind regard

    Agustín

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 04:20 PM

    Hi:

    What about importing the journal entry? Would this be done through "Import from Excel"?

    John

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11 at 07:21 PM

    Hi:

    Is it possible to import a journal entry of fixed asset account balances, rather than importing fixed assets master data?

    The client is not going to be using the Fixed Assets module. They simply want to import this journal entry.

    Thanks!

    John

    Add comment
    10|10000 characters needed characters exceeded

  • 3 days ago

    if client don't want to use fix assets module then its ok they can import journal entries in this way they will not get automatic posting of depreciation of assets they have to manually calculate and post

    Add comment
    10|10000 characters needed characters exceeded