Skip to Content

Dear All,

About Fixed Assets in SAP Business One 9.0

How to work on Fixed Assets Master Data?

Asset Master Data

1) Create Assets Master Data (financial < Fixed Assets <Assets Master Data)

2) Better if you mention the Location of Assets in Assets Master Data.

3) Use OITM (Item Master) & ITM7 (Item Depreciation Param) to upload Fixed Assets Master Data Templates.

4) Create Asset Class / Depreciation Areas/ Depreciation type/ Useful Life of Assets, etc as imp details.

How to create / Upload Opening Balance of Fixed Assets?

Assets Opening Balance can be uploaded in two ways, either from A/P Invoice or from Capitalization = Opening Balance with

Depreciation (for old Assets maintaining in SAP better is capitalization as it will not effect vendor balance) and for New Assets go for

A/P Invoices.

1) AssetValue Date is the Capitalization Assets Date = The Date of Assets Purchase by the company.

2) Use OACQ (header file) and ACQ1 (Line Level file) to upload OB.

3)OACQ format as below:

    DocEntry = Internal key

    DocNum= Capitalization Document number

    Series= Internal key of series

    PostingDate= Opening balance Date (yyyymmdd)

    DocumentDate= YYYYMMDD

    Status= P (posted)

    AssetValueDate=  capitalization/ Asset Purchase Date (depreciation will start from this date)   

    DepreciationArea= * (star) for all Areas

    Reference = Put Location of Assets (If Required to get Location wize report)

4)ACQ1 format as below:

    ParentKey    (DocEntry)    = Internal key as in header format

    LineNum= Keep 0(Zero) if mentaining different document or Keep 0,1,2,3,4,5,…..ect if only one capitalization Document.

    DocEntry= Capitalization Document Number (keep Same Number if Mentaining many Assets in one Document.

    LineNumber = same as above second point in ACQ1

    AssetNumber= Asset Master Code Number

    Quantity = Qty of Asset

    TotalLC= Value of Asset (should be in number format)

Thanks & Regards,

Sachin Gautam

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply