link a BOL to invoice numbers

[mjbasecamp]

We are using Macola Progression 7.7.4 with SQL Server 2000. Is there a "link" in the datatbase tables between the bol_no and the inv_no. I see that the inv_no shows up in the OEORDHST_SQL table but what if you have multiple invoices for an order?
Thanks!

 

[randva]

I do not believe there is any link at all between BOL's and invoices.

Before posting invoices at the end of the day, we use an access query that inserts pro numbers from the bol into one of the user defined fields on the order header. The info is then available on the order header in oeordhst.

The only issue is that the pro number will still remain on the order header of any order that had backorders. (It will of course get overwritten at a later day when the backorder ships.)

I'm not sure what other information you would want from the BOL.

 

[dgillz]

What tables are you trying to join? Or are you saying that both the bol_no and the inv_no fields are in the same table?

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

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