Distribution, Manufacturing, and Internet Modules

[imexvet]

I already had an alternate answer on this using an extended solution.

I have been playing with the panel customizer to see if stock lookups can be done as part of a line item entry. I note that none of the inventory data files are present in the list.

Is there any point going done this path? Can such a field be included either by adding a table or making an external link? (I dont know enough to be even dangerous yet!) If so what direction should I head in?

TIA Bob

[DFeller]

Quantity available is already shown when your cursor is in the qty ordered field, and if you click the inventory inquiry button you can see stock for all warehouses.

Dawn

[imexvet]

Hi Dawn

Yes I am aware of that.

If using the inventory inquiry popup button it takes our sales staff too long to check. They had been relying on the "Qty Avail" text at the base of the window, but with running WO's (shortage rpt etc) and needing that to reflect PO + WO + stock etc, SO assumes that every released WO is available to sell to the customer.

There is a Sage extended solution to resolve that problem but the boss doesnt feel it is worth the expense.

Tnxs for your comment..

Cheres Bob

[connex]

It is possible to use scripting do a query to retrieve it how you like if from the line detail panel AND INCLUDE the items just entered without leaving that panel. It involves saving the current order, executing the query and returning to the same panel.

Let me know if you need help with that.

[bpoole]

You could add a button to the lines tab using customerizer and have that button execute a script to retrieve the info for the item on the active line (the one the cursor is in) using an ODBC call back to the databsae.  You could format, calculate the data how ever you need it, then present it in a vbpopup window, html or hta doc.

Although I am   not how that is much quicker than clicking on the item inquiry button in the So entry screen.

 I did something similar to allow users to search for an item based on strings in the extended description and select the item from an hta window, then returned the select item into the line entry field.