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);

14 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

Nicole Fabian

February 7, 2023 at 2:49 pm

Hello ANKIT CHAUHAN,

Thank you for the above, but how do you update lines quantity linked to multiple individual counters?

Kind regards,
Nicole.

ANKIT CHAUHAN

Blog Post Author

February 7, 2023 at 2:56 pm

Hi Nicole Fabian,

Unfortunately, I didn't understand the question.

Can you please share few screenshots? Also, whether the same operation is possible manually using SAP Business One client?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

Nicole Fabian

February 7, 2023 at 3:16 pm

Hello ANKIT CHAUHAN,

I currently have a service that creates inventory counting's that has multiple individual counters. Adding this inventory counting works 100% but now I need to update said inventory counting lines counted quantity for each individual counter.

If you look at the below image for reference, I need to update "Nicole - Counted Qty".

Kind regards,
Nicole.

ANKIT CHAUHAN

Blog Post Author

February 7, 2023 at 3:26 pm

Hi Nicole Fabian,

Kindly confirm whether the same operation is possible manually using SAP Business One client?

Also, what is the issue when using DI API?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

Nicole Fabian

February 7, 2023 at 3:53 pm

Hello ANKIT CHAUHAN,

Yes, it is possible to do the same operation in SAP.

The issue is that I cant find any examples on how to do the update? Is it possible to provide example code please?

Kind regards,
Nicole.

Nicole Fabian

February 8, 2023 at 10:06 am

Hello ANKIT CHAUHAN,

Please note that I got it right - no need to send example.

Kind regards,
Nicole.

ANKIT CHAUHAN

Blog Post Author

February 8, 2023 at 11:22 am

Hi Nicole Fabian,

I would appreciate if you can share the solution so that others are benefited.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

Nicole Fabian

February 8, 2023 at 11:26 am

Hello ANKIT CHAUHAN,

Please see example below:

Company SAP_Company = SAPConnection.diCompany;

CompanyService oCS = SAP_Company.GetCompanyService();
InventoryCountingsService oICS = (InventoryCountingsService)oCS.GetBusinessService(ServiceTypes.InventoryCountingsService);
InventoryCountingParams oICP = (InventoryCountingParams)oICS.GetDataInterface(InventoryCountingsServiceDataInterfaces.icsInventoryCountingParams);

oICP.DocumentEntry = DocEntry;

InventoryCounting oIC = oICS.Get(oICP) as InventoryCounting;

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

foreach (DataRow row in dt.Rows)
{
if (line.CounterID == CounterID && line.ItemCode == Convert.ToString(row["U_ItemCode"].ToString()) && line.WarehouseCode == Convert.ToString(row["U_Warehouse"].ToString()) && line.BinEntry == Convert.ToInt32(row["U_BinEntry"].ToString()))
{
line.CountedQuantity = double.Parse(row["U_CountedQty"].ToString().Trim(), CultureInfo.InvariantCulture);
}

if (row["U_Counted"].ToString() == "Y")
line.Counted = BoYesNoEnum.tYES;
else
line.Counted = BoYesNoEnum.tNO;

if (row["U_Freeze"].ToString() == "Y")
line.Freeze = BoYesNoEnum.tYES;
else
line.Freeze = BoYesNoEnum.tNO;
}

i++;
}

oICS.Update(oIC);

Kind regards,
Nicole.

Product Information

Inventory Counting in SAP Business SDK

Assigned Tags