Product Information

ANKIT CHAUHAN

February 10, 2017 1 minute read

Inventory Counting in SAP Business SDK

About Inventory Counting:

Inventory counting (also known as Stock Taking/Stock Counting) helps you to keep track of your inventory.

Inventory counting is crucial to any company that manages an inventory, be it perpetual or periodic. By matching the actual inventory to the quantities saved in the database, companies can adjust existing inventory records, detect unusual or unacceptable discrepancies, and improve inventory management.

After creating an Inventory Counting document to record the counting results, you must post the inventory changes to effect the adjustments in the system. For this, you need to create an Inventory Posting document based on the Inventory Counting document.

For more details on Inventory Counting, you can refer to following link:

http://help.sap.com/saphelp_sbo92/helpdata/en/06/2b155358d8ff07e10000000a423f68/content.htm?frameset=/en/44/c4c1cd7ca22e17e10000000a114a6b/frameset.htm&current_toc=/en/b1/8fe14910cf46b9b2ff2de2f315e5a2/plain.htm&node_id=1658&show_children=false

Using Inventory Counting in SAP Business One SDK:

Inventory Counting is exposed as a service type Object (InventoryCountingsService) in SAP Business One SDK.

Add an Inventory Counting Document using DI API:

SAPbobsCOM.CompanyService oCS = (SAPbobsCOM.CompanyService)oCompany.GetCompanyService();
SAPbobsCOM.InventoryCountingsService oICS = oCS.GetBusinessService(SAPbobsCOM.ServiceTypes.InventoryCountingsService);
SAPbobsCOM.InventoryCounting oIC = oICS.GetDataInterface(SAPbobsCOM.InventoryCountingsServiceDataInterfaces.icsInventoryCounting);
DateTime dt = DateTime.Now;
oIC.CountDate = DateTime.Now;
SAPbobsCOM.InventoryCountingLines oICLS = oIC.InventoryCountingLines;
SAPbobsCOM.InventoryCountingLine oICL = oICLS.Add();
oICL.ItemCode = "A00001";
oICL.CountedQuantity = 4;
oICL.WarehouseCode = "01";
oICL.Counted = SAPbobsCOM.BoYesNoEnum.tYES;
SAPbobsCOM.InventoryCountingParams oICP = oICS.Add(oIC);

Update an Inventory Counting Document using DI API:

SAPbobsCOM.CompanyService oCS = oCompany.GetCompanyService();
SAPbobsCOM.InventoryCountingsService oICS = (SAPbobsCOM.InventoryCountingsService)oCS.GetBusinessService(SAPbobsCOM.ServiceTypes.InventoryCountingsService);
SAPbobsCOM.InventoryCountingParams oICP = (SAPbobsCOM.InventoryCountingParams)oICS.GetDataInterface(SAPbobsCOM.InventoryCountingsServiceDataInterfaces.icsInventoryCountingParams);
oICP.DocumentEntry = 1;
SAPbobsCOM.InventoryCounting oIC = oICS.Get(oICP) as SAPbobsCOM.InventoryCounting;
SAPbobsCOM.InventoryCountingLine line = oIC.InventoryCountingLines.Item(0);
line.CountedQuantity = 2;
oICS.Update(oIC);

Remove the lines/rows from an Inventory Counting Document using DI API:

SAPbobsCOM.CompanyService oCS = SBOCompany.GetCompanyService();
SAPbobsCOM.InventoryCountingsService oICS = (SAPbobsCOM.InventoryCountingsService)oCS.GetBusinessService(SAPbobsCOM.ServiceTypes.InventoryCountingsService);
SAPbobsCOM.InventoryCountingParams oICP = (SAPbobsCOM.InventoryCountingParams)oICS.GetDataInterface(SAPbobsCOM.InventoryCountingsServiceDataInterfaces.icsInventoryCountingParams);
SAPbobsCOM.InventoryCountingLine oICl;
oICP.DocumentEntry = 1;
SAPbobsCOM.InventoryCounting oIC = oICS.Get(oICP) as SAPbobsCOM.InventoryCounting;

int i = 0;

while ((i < oIC.InventoryCountingLines.Count))
{
    oICl = oIC.InventoryCountingLines.Item(i);

    if ((oICl.CountedQuantity == 0))
    {
        oIC.InventoryCountingLines.Remove(i);
    }

    i = (i + 1);
}              
oICS.Update(oIC);

Close an Inventory Counting Document using DI API:

SAPbobsCOM.CompanyService oCS = SBOCompany.GetCompanyService();
SAPbobsCOM.InventoryCountingsService oICS = (SAPbobsCOM.InventoryCountingsService)oCS.GetBusinessService(SAPbobsCOM.ServiceTypes.InventoryCountingsService);
SAPbobsCOM.InventoryCountingParams oICP = (SAPbobsCOM.InventoryCountingParams)oICS.GetDataInterface(SAPbobsCOM.InventoryCountingsServiceDataInterfaces.icsInventoryCountingParams);
SAPbobsCOM.InventoryCountingLine oICl;
oICP.DocumentEntry = 1;
SAPbobsCOM.InventoryCounting oIC = oICS.Get(oICP) as SAPbobsCOM.InventoryCounting;
oICS.Close(oICP);

6 Comments

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

Manikandan. D

December 4, 2017 at 7:39 am

Dear Ankit,

Thank you, Its very useful

Former Member

May 24, 2018 at 11:53 am

Dear Ankit,

Is there an option to save inventory counting as draft? Or is it only possible via SAP B1 Client?

Kind Regards,

Atilla

Rahul Jain

November 13, 2020 at 1:06 pm

Hello Aniket,

InventoryCountingsService is available in Di Server ? Please update

Regards,

Rahul Jain

ANKIT CHAUHAN

Blog Post Author

November 13, 2020 at 3:16 pm

Hi Rahul Jain,

Yes, you can use InventoryCountingsService in DI Server.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

Nicole Fabian

October 18, 2022 at 6:53 am

Hello ANKIT CHAUHAN ,

How do you add and update a inventory counting with multiple counters?

Kind regards,
Nicole.

ANKIT CHAUHAN

Blog Post Author

October 19, 2022 at 8:14 am

Hi Nicole Fabian,

Refer to the following sample code:

InventoryCountingsService countingService = (InventoryCountingsService)oCompany.GetCompanyService().GetBusinessService(ServiceTypes.InventoryCountingsService);
InventoryCounting countingDoc = (InventoryCounting)countingService.GetDataInterface(InventoryCountingsServiceDataInterfaces.icsInventoryCounting);
countingDoc.CountDate = DateTime.Today;
countingDoc.CountingType = CountingTypeEnum.ctMultipleCounters;
countingDoc.Remarks = "AddInventoryCountingWtihMultipleCounters by DI SDK" + DateTime.Today;

// Add 2 Team Counters
var teamCounter1 = countingDoc.TeamCounters.Add();
teamCounter1.CounterID = 1; // user id/employee id
teamCounter1.CounterType = CounterTypeEnum.ctUser;

var teamCounter2 = countingDoc.TeamCounters.Add();
teamCounter2.CounterID = 2;
teamCounter2.CounterType = CounterTypeEnum.ctEmployee;

// Add 1 Individual Counter
var individualCounter1 = countingDoc.IndividualCounters.Add();
individualCounter1.CounterID = 2;
individualCounter1.CounterType = CounterTypeEnum.ctUser;

{
    // counted qty of 1st team counter = 1
    InventoryCountingLine line = countingDoc.InventoryCountingLines.Add();
    line.ItemCode = "I001";
    line.ItemDescription = "I001";
    line.WarehouseCode = "02";
    line.Counted = BoYesNoEnum.tYES;
    line.CounterID = 1;
    line.CounterType = CounterTypeEnum.ctUser;
    line.MultipleCounterRole = MultipleCounterRoleEnum.mcrTeamCounter;
    line.CountedQuantity = 1;
}

{
    // counted qty of 2nd team counter = 2
    InventoryCountingLine line = countingDoc.InventoryCountingLines.Add();
    line.ItemCode = "I001";
    line.ItemDescription = "I001";
    line.WarehouseCode = "02";
    line.Counted = BoYesNoEnum.tYES;
    line.CounterID = 2;
    line.CounterType = CounterTypeEnum.ctEmployee;
    line.MultipleCounterRole = MultipleCounterRoleEnum.mcrTeamCounter; 
    line.CountedQuantity = 2;
}

{
    // counted qty of 1st individual counter = 3
    InventoryCountingLine line = countingDoc.InventoryCountingLines.Add();
    line.ItemCode = "I001";
    line.ItemDescription = "I001";
    line.WarehouseCode = "02";
    line.Counted = BoYesNoEnum.tYES;
    line.CounterID = 2;
    line.CounterType = CounterTypeEnum.ctUser;
    line.MultipleCounterRole = MultipleCounterRoleEnum.mcrIndividualCounter;
    line.CountedQuantity = 3;
} 

try
{
    countingService.Add(countingDoc);
}
catch (Exception ex)
{
    string strEx = ex.ToString();
}

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

Product Information

Inventory Counting in SAP Business SDK

Assigned Tags