cancel
Showing results for 
Search instead for 
Did you mean: 

Update LineStatus of an open order

Former Member
0 Kudos

Hello All,

I created a Matrix Form showing open items. I use a Select statement to load my UserTable with data "FROM ORDR INNER JOIN RDR1 ON ORDR.DocEntry = RDR1.DocEntry". Now I need to update the LineStatus to close the item from the original Order. How can I update the Original Order.

Note: Using VB6 for SBO6.5

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Laura,

unfortunately the DI object model for order lines (and all documents) misses a 'Close' method' (and this doesn't really make sense to me because there is such a function for the order header...) even in version 2004A. I did a similar functions in version 2004A using an external stored procedure and it works fine.

Let me know if you need more details

Hope this is helpful for you

Cheers

Former Member
0 Kudos

Can you give me more information, I don't quite understand? Again I am trying to close out an item in an open order, not just close the order.

Are you trying to tell me that in Version 2004A, I may be able to change the LineStatus but not in Version 6.5. If I got that right, we should be upgrading to Version 2004 in a couple of months. Can you please help me code that?

Former Member
0 Kudos

NO, I'm telling you that you actually can't do that just using the SDK (you'll run into the same problem in version 2004A). As far as I know, if you want to close an order line you must implement some external sql processing.

Former Member
0 Kudos

How can I do that? Can you show me some examples?

Former Member
0 Kudos

I'll send you a code example, just write to: enrico.rizzo@itstech.it

Regards

Former Member
0 Kudos

Thank you so much for helping me. I got my program to work, thanks to your advice.

I tried to email you but it was return, "(reason: 550 <enrico.rizzo@itstech.it>: User unknown in local recipient table)".

I still would like to have some sample codes for reference. Can you please email me at lquinons@brewersewing.com