cancel
Showing results for 
Search instead for 
Did you mean: 

How to update Historical APC and Netbook Value of Asset Master Data in DTW?

former_member183402
Participant
0 Kudos

Hi all,

Is it possible to update Historical APC and Netbook Value of Asset Master Data in DTW? I use SAP B1 9.2 PL10

I tried to check the templates of Asset Master Data but I failed to get the above fields

Please anyone can help me

Accepted Solutions (0)

Answers (2)

Answers (2)

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert

Hi schadrack,

Recently, I was checking an issue with Fixed Asset Master Data in SAP Business One Version 10.0 and it was possible to update Historical APC in Fixed Assets Master Data.

Check whether the DI Code provided below helps or not:

try
{
    SAPbobsCOM.CompanyService oCompanyService = oCompany.GetCompanyService();
    SAPbobsCOM.FixedAssetItemsService oFixedAssetItemsService = (SAPbobsCOM.FixedAssetItemsService)oCompanyService.GetBusinessService(SAPbobsCOM.ServiceTypes.FixedAssetItemsService);
    SAPbobsCOM.FixedAssetValuesParams objParam = (SAPbobsCOM.FixedAssetValuesParams)oFixedAssetItemsService.GetDataInterface(SAPbobsCOM.FixedAssetItemsServiceDataInterfaces.faisFixedAssetValuesParams);
    objParam.ItemCode = "FA00001";
    objParam.DepreciationArea = "DP01";
    objParam.FiscalYear = "2021";
    SAPbobsCOM.FixedAssetEndBalance objEndBalance = (SAPbobsCOM.FixedAssetEndBalance)oFixedAssetItemsService.GetDataInterface(SAPbobsCOM.FixedAssetItemsServiceDataInterfaces.faisFixedAssetEndBalance);
    objEndBalance.HistoricalAPC = 230;
    oFixedAssetItemsService.UpdateAssetEndBalance(objParam, objEndBalance);
}
catch(Exception ex)
{
    MessageBox.Show(ex.ToString());    
}

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

former_member183402
Participant
0 Kudos

Hi ANKIT,

In 9.2 PL10 the above codes can run, but they do not update HistoricalAPC, they don't display an error.

Nothing they affect in asset master data

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert

Hi schadrack,

Can you please help to try the same in SAP Business One Version 10.0? I am pretty sure that it worked in that version.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

JesperB1
Advisor
Advisor
0 Kudos

Hello,

Just to add to what Ankit has already put in here - some linkedin articles published by the support organization:

Support Spotlight: How to Import Fixed Assets Legacy Data into SAP Business One

Support Spotlight: How to Reconcile Fixed Assets Account Balance with Fixed Assets Net Book Value

And the article with plenty of Fixed Assets Resources:

Support Spotlight: Fixed Assets Resources for You!

There is plenty of help to be had within those articles that are written by one of the absolute experts within SAP Business One Global Support - Ivy Zhang.

More articles and blogs from support on most topics, including HANA, Integration, InterCompany etc:

https://blogs.sap.com/tag/b1-support-spotlight/

I hope that will help,

Jesper

Thiago_Moura
Explorer
0 Kudos

Hello, Ankit!

There is a way to update that info using Service Layer?

I opened a new question yesterday about that, but i found just your answer about DI API.

Thanks!

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi thiago_moura,

I will check it and come back to you.

We really appreciate your patience till the time.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi schadrack and thiago_moura,

The following requests work fine for me in Service Layer:

To get the value:

POST /b1s/v1/FixedAssetItemsService_GetAssetEndBalance
{
    "FixedAssetValuesParams": {
        "ItemCode": "TEST1",
        "FiscalYear": "2023",
        "DepreciationArea": "GAAP"
    }
}

To update the value:

POST /b1s/v1/FixedAssetItemsService_UpdateAssetEndBalance

{
    "FixedAssetEndBalance": {
        "HistoricalAPC": 125.0
    },
    "FixedAssetValuesParams": {
        "ItemCode": "TEST1",
        "FiscalYear": "2023",
        "DepreciationArea": "GAAP"
    }
}

Kind regards,

ANKIT CHAUHAN

SAP Business One Support