Macola Progression 7.6: Understand item_release_no and build_qty 1

[alanmak77]

Hi. I am a application developer and I am new to Macola.

I am currently working on a custom order tracking app which will integrate with Macola OE module. This custom app collects all the order information (Header, Line, Comment etc) and will generate an order in Macola.

I think I have the list of tables/fields that I need to populate. I am down to the last two fields that I do not know where the data is coming from. They are

build_qty in the iminvtrx_sql table

and

item_release_no in the oeordline_sql table

If anyone knows what they are and what value I need to assign to those fields, please let me know. I checked the Macola documentation and help files, also searched this forum and online but I couldn't find anything.

I appreciate your help in advance.

Thank you.

 

[alanmak77]

Sorry, it's oeordlin_sql, not oeordline_sql.

 

[dgillz]

The item_release_no in oeordlin_sql for a new order is 1, always. This will get incremented by Macola as partial shipments are made against that record in the oeordlin_sql.

What type of record are you adding to the iminvtrx_sql table? I need to know that first.

If you use the wisys objects you can develop programs fr Macola much more quickly and you don't need to reverse engineer the database, you just pass the objects the proper variables and away you go. You really need to look at this.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[alanmak77]

Thank you for the reply. I really appreciate your help.

Partial shipment makes sense. However I can see the item_release_no in some of the rows are 0. What would cause that?

The type of records adding to the iminvtrx_sql table is the same as using the order line page to enter a line. We don't keep track of components so all the items are finished goods. The source will be O (O/E) and the doc_type will be A (allocation). Hope this is what you needed to know.

We have looked into using the wisys objects but at this point we are only doing OE integration so the cost can not be justified. We will consider when we are doing other integrations in the future.

 

[dgillz]

If you just want to do OE integration the cost for Wisys is $7200. You could write this in minutes. LIterally. You don't even need to be a developer.

The item_release_no of zero could be a order type Q (quote). But I really don't know. I do not have any of them in any of my databases.

I can't really help you with the build qty either at least not without a ton of research. Maybe someone else will chime in.



Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[alanmak77]

We were looking into buying their SDK and it costs a lot more than $7200, but it includes more than just the OE module.

Anyways thanks for the help. We will need to do tons of testing to ensure everything works the way it supposes to be.

 

[dgillz]

You are right, you'd need the Agility designer $3600 plus each user that needed to use the interface would need a user license. This is independant of the # of Macola users you have.

However if you wrote a program that just ran in the background to bring in new orders, then it is $7,200 total.

And yes the SDK can do a lot more than just OE, you just mentioned that as your requirement.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html