HTML Status Bar Add "On Order" QTY

(0) Share

Report

Posted on by Community Member

I am trying to update my HTML Status Bar.
I have it displaying our Current Available "On Hand" Stock. but i cannot figure out how to add the "On Order" amount.

when we create our PO's it updates the On Order QTY in the SOManager, but i can't seem to figure out how to pull this data and place it in the Status HTML Bar.

below is an image of what i am trying to do.. Currently we have 0 Stock on this item but we have 12 on order that i cannot seem to figure out how to get to appear.

Below is some of the script i am using... it is not complete because its very long but the Available "QuantityOnHand" works and I can't see anything different that would make "Entry.QuantityOnOrder" not work... i also tried changing it to "Entry.Item.QuantityOnOrder" and also "TransactionEntry.QuantityOnOrder", both caused the "On Order" text to disappear from the Status HTML bar.

-------------------------------------------------------------------------------------------------------------------------------

    Set QSRules = qsBridge.RequestQSRules()
    Dim OnOrder

    OnOrder = " "




            If Not Entry Is Nothing Then
                OnHand = "Available: " & Entry.Item.QuantityOnHand
                          If Not Entry Is Nothing Then
                OnOrder = "On Order: " & Entry.QuantityOnOrder
                End If




            txtOnOrder.innerText = OnOrder


</script>

<div id="txtOnOrder"></div>

-------------------------------------------------------------------------------------------------------------------------------

any thoughts?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

Just wondering if you got this issue resolved?

PS. I like your red background on the status.htm

Danny

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks,

No I haven’t been able to figure it out yet.

I haven’t looked at the code at all since I posted on here. I have been preoccupied.

All I know is I have tried several different ways, and some put the “on order” text on the bar but leave the qty at 0 and some don’t show the “on order” text at all.

So I know it’s mostly right but I just can’t get it to pull the quantity that is “on order”.

Was this reply helpful? Yes No
Suggested answer

Jeff @ Check Point ... 13,382 on at

Like (0)

Report

Without looking, I think the On-Order is a calculated field. Look at the item table to see if there an On-Order column.

Was this reply helpful? Yes No
NickZnavor 715 on at

Like (0)

Report

the field is calculated with the following query:

SELECT SUM(QuantityOrdered - QuantityReceivedToDate) AS OnOrderQty FROM PurchaseOrderEntry INNER JOIN PurchaseOrder ON PurchaseOrderEntry.PurchaseOrderID = PurchaseOrder.ID AND PurchaseOrderEntry.StoreID = PurchaseOrder.StoreID WHERE PurchaseOrder.Status <> 2 AND (PurchaseOrder.POType <> 3 AND PurchaseOrder.POType <> 5) AND ItemID = 3923

by replacing the ItemID with your desired item, it will return the number you want.... but I would have to look at the whole script to add the sql statement to it and test and make sure its working

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

.

Was this reply helpful? Yes No