SerialNumbers

[Former Member]

Hi all,

I want to update the field DistNumber in table OSRN via DI.

I want to do this : DistNumber = SysNumber

It's possible to do this with DI ?

I'm use SAP B1 8.81 PL 09

Thanks for your response.

Best regards,

Michael

[Former Member]

Hi Michael,

DistNumber can never be the same as SysNumber because one is VarChar and the other is integer.

Thanks,

Gordon

[Former Member]

Hi Gordon,

I know that but i want to put the sysnumber in the DistNumber with a cast or other with DI.

It's possible. If yes, how can i do that ?

Thanks.

Michael

[Former Member]

What is the background of this request?

[Former Member]

When we create a good receipt, the serial number was created automatically. We have check "Automatic Serial Number Creation" in the general settings form.

So the field Serial Number as empty and we want to put the sysNumber into this field.

Is it possible ?

Thanks.

Michael

[Former Member]

If Serial Number is empty, have you tried FMS to bring the sysNumber here?

[Former Member]

Hi,

We can't use FMS because we don't open the Serial Number details form

The user create a good receipt. The "Serial Numbers - Setup" form appears.

The user enter a Mfr Serial No. and the Serial Number then he click Update and OK

So we want to change the value of Serial Number enter by user by the SysNumber.

This is valid only when we create a good receipt.

Thanks,

Michael

i try this to modify but it'snot work :

oDoc = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oPurchaseDeliveryNotes)

ret = oDoc.GetByKey(docEntry)

If ret = True Then

Dim nb As Integer = oDoc.Lines.SerialNumbers.Count

oDoc.Lines.SetCurrentLine(0)

oDoc.Lines.SerialNumbers.SetCurrentLine(0)

Dim tmp As String = oDoc.Lines.SerialNumbers.SystemSerialNumber.ToString()

oDoc.Lines.SerialNumbers.ManufacturerSerialNumber = "PRGM" 'oDoc.Lines.SerialNumbers.SystemSerialNumber.ToString()

oDoc.Update()

End If

Edited by: Michael LECLERCQ on Dec 15, 2011 5:56 PM