cancel
Showing results for 
Search instead for 
Did you mean: 

DI:Batch-Numbers Object only adds BatchNumbers to table OIBT

kurt_huwiler
Participant
0 Kudos

The PurchaseDeliveryNotes-Object has a BatchNumbers object. With this BatchNumbers- Object it is possible to add BatchNumbers to Items and this Information that will be written to the table OIBT. That works fine.

Doing the opposite, that means getting Items from stock, I use the DeliveryNotes-Object which has as well the BatchNumbers object. This will not remove the BatchNumbers Information from the table OIBT. It’s just doing the opposite, it will as well add Batch Numbers to the table OIBT.

This seems to me like being a mistake in the BusinessLogic of the DeliveryNotes-Object

My question:

Why is DeliveryNotes->Lines>BatchNumbers not removing Batch Numbers from table OIBT ?

The lines of code used for the DeliveryNotes-Object

-


Dim sbo_bns As New SAPbobsCOM.BatchNumbers

Dim sbo_dn As SAPbobsCOM.Documents

Dim lReturnCode As Long

Set sbo_dn = sbo_cx.GetBusinessObject(Object:=oDeliveryNotes)

With sbo_dn

.DocDueDate = VBA.Date

.CardCode = "C00001"

With .Lines

.ItemCode = “BI100").StringValue

.Quantity = 2

.ShipDate = VBA.Date

.WarehouseCode = "01"

.Price = 10.5

With .BatchNumbers

.BatchNumber = "Bnr20.1019"

.Quantity =2

End With

End With

lReturnCode = .Add

End With

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hoi Kurt

Sorry SAP guys, but I think the SBO model of batches submitted by SBO 6.5 is absolutely insufficient for practical use! The batch object has just ONE usefull method: Add. But in real business life we have to sell batches as well as storing them to our warehoses...

So, Kurt, the only way to work with batches is to write directly into the relevant tables of SBO, that are:

OIBT: Batch list and batch balance

IBT1: Batch transactions

OSRD: Transactions concerning "batched" items, but item quantity of transaction is still not bound to a batch

We have built an SBO-6.2-AddOn (without any batch object!) working with batches, that means working with OIBT, IBT1 and OSRD; it's running well.

kurt_huwiler
Participant
0 Kudos

Hi Res

Thank you for your advise.

It seems I need to do the same additional effort to "sell" batched items. How ugly.

With regards

Kurt

Former Member
0 Kudos

Patch 15 has alot of functionality added to batches

(one of which being able to use an existing Batch)

Maybe in installing this patch would solve your problems

though i know that patch 15 is not available to the public yet but if your a partner i would suggest contacting SDK marketplace.

Hope this helps

denis

Former Member
0 Kudos

Denis,

Do you have any documentation about the new functionality of the BatchNumbers Object?

I've got the patch 23 for SBO 6.5 and it also updates the sapbobscom65.dll version 6.50.53.23

By any chance do you have any document about the new functionality on this object, because I need this functionality to avoid the manipulation of batches through SQL Stored Procedures.

Thanks

Kind Regards,

L. Iván Juárez A.