Skip to Content
avatar image
Former Member

Fixed Asset Mode

Hi Experts,

I have enabled FA and trying to import from excel however not successful. SAP document shows Fixed Asset should be changed to transfer mode but this option is not shown in my company.

SAP version details are SAP B1 : 9.0 PL 04

Please advise.

Deepak Magar

My setting.jpg (40.2 kB)
SAP Doc.jpg (73.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Jul 31, 2013 at 11:21 AM

    Hi:

    I have checked your import file and I do not fully understand the business process:

    If you import and asset with no APC, it means that you have not done any acqusition yet for it, so How come is that you know the start depreciation date?

    Inlude at least in your selection all columns that I mentioned before

    If it is a new asset, which is what it seems to me, then: leave blank the columns that in the Help file does not say are mandatory for new assets

    I have noticed that in some columns you are using the description of filed rather than the code: Code should be used

    Dep Area: 'Main Books' (Is this the code? it looks to me the description)

    Asset Class:'Office Equipment' ((Is this the code? it looks to me the description)

    For date fileds , you should use same format date in excel that date format used in your Business One

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 11, 2013 at 04:46 AM

    Hi Deepak

    you may check below link.

    http://scn.sap.com/docs/DOC-42467

    but it is for Indian Localization and I think you are trying for Austria Location..

    Regards

    Deepak Tyagi

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 12, 2013 at 11:46 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2013 at 10:53 AM

    Please do a check list that you have all these columns: if no value, set 0

    Item No.

    Dep Area

    Dep start date

    Useful life

    Remaining life

    Depreciation type

    APC

    Accumulated ordinary Dep

    Jose Antonio

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2014 at 05:55 PM

    Please Deepak Magar for wich stored procedure we must create the exception !

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mohamed,

      Please check if there is any Stored Procedure related to Item master and make it exception.

      Thanks

      Deepak