cancel
Showing results for 
Search instead for 
Did you mean: 

Batch Status

Former Member
0 Kudos

Hello All:

Need to write a SDK-DI thing to check if all the batchs in warehouse has passed its expiration date yet, if it passed the expiration, change the status of the batch from release(oibt.status = 0) to locked! (oibt.status = 2).. I can't seem to find the object for status in the BatchNum Objects. What can be done? And it seems reasonable that since Expiration is already in SBO, there should be some kind of control to take if off pick and ship when it hits expiration.

Any help will be appreciated !!!

Accepted Solutions (1)

Accepted Solutions (1)

Eneveux
Product and Topic Expert
Product and Topic Expert
0 Kudos

Bo,

If you are talking about the "Status" in the OIBT table such as 'Released, Not Accessible, Locked", that does not seem to be exposed via the BatchNumbers object.

Eddy

Former Member
0 Kudos

Thank You Mr Neveux:

I understand that status is not release to SDK. However I need to develop some automation process to change the status. What can I do?

Sincerely Yours

Eneveux
Product and Topic Expert
Product and Topic Expert
0 Kudos

Bo,

Hmmm ... that is a good question as any direct writes to the Business One Db is not supported by SAP. Everything that writes to the Business One Db needs to go through the API's but that particular property is not exposed. I do not have a method for this other than an direct write to the Db, but that is an issue as stated above. I will check to see if the Business One 2007 version exposes this property.

Eddy

Former Member
0 Kudos

Thank You Mr Neveux:

As I am also fully aware the SBO doesn't allow direct DB write, so if there are any workaround, I would really appreicated it! However until then or 2007. I have no other choice but preplan for direct DB write! Do want you to know, I have done some testing regarding the direct DB write, I am fully aware the problem it might cause, so just throw out there to see if there are any work around. It just seem to be a very standard process for the batch expiration!

Sincerely Yours

Bo Peng

former_member201110
Active Contributor
0 Kudos

Hi,

The workaround would be to automate the process through the UI API (ie your add-on would use the UI API to open and manipulate the SBO screens as if the user were performing the actions required). It's not ideal but, as you cannot write directly to the DB, it's probably your only option. In the past, I've had to use something similar to create Projects (as these aren't exposed in the DI API until 2007 either).

Kind Regards,

Owen

Former Member
0 Kudos

Hello Owen:

Thank you for you answer, I was thinking about that as well, however my initial thoughts on this is full automation process, which run without any human activity. (some kind of service application ran on sechduler that go under DI directly). I am not completely sure this will meet my need, but I will keep that in mind.

On a side note, do you know if this will be exposed in 2007?

Sincerely Yours

Bo Peng

former_member201110
Active Contributor
0 Kudos

Hi,

According to the latest 2007A build I have (141), Status is not a property of the BatchNumbers object

Kind Regards,

Owen

Former Member
0 Kudos

Thank You for the information

Answers (0)