Importing Fixed Asset Balances

[former_member594505]

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

[former_member588507 · Accepted solution]

Hi John,

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

Thanks,

Satish

[Abdul]

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

[former_member594505]

Hi:

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

John

[former_member588507]

Yes you can import JE's from Excel but it's available in 9.3.

Thanks,

Satish

[agustin_marcoscividanes]

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

[former_member594505]

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

[jitin_chawla]

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

[dinesh-pn]

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