JIT Purchasing JavaScript Math Not Calculating Correctly #447

New Issue

2026-06-29T08:38:13Z

rob commented

2026-06-29 08:38:13 +00:00

When using JIT Purchasing, for example, we often have an old DO that we need To-Order 1 piece only (assume we were shorted one piece by supplier). We still see the 1 remaining piece in To-Order column, thus JIT tells us to order 1 piece. on the SKU's sub-line with the customer DO #, we change it from 300 to 299, so we can automagically adjust the DO qty and remove that 1 piece from the JIT purchasing system since it's not needed anymore.

It seems to be assuming the Avail qty is zero on all lines, even when it is not zero. Is the formula making that assumption?

The backend still works, so we we type 299 on the DO sub-line and save changes, those misc 1 piece to-ships go away, but the javascript changes the to ship to qty to the original DO qty

To-Ship minus Avail Qty should equal To-Order.

Can the JS also change the DO# sub-line row when we change Ordered field qty? Right now it just changes to top level SKU/Title row. This would also make things less confusing when using.

When using JIT Purchasing, for example, we often have an old DO that we need To-Order 1 piece only (assume we were shorted one piece by supplier). We still see the 1 remaining piece in To-Order column, thus JIT tells us to order 1 piece. on the SKU's sub-line with the customer DO #, we change it from 300 to 299, so we can automagically adjust the DO qty and remove that 1 piece from the JIT purchasing system since it's not needed anymore. It seems to be assuming the Avail qty is zero on all lines, even when it is not zero. Is the formula making that assumption? The backend still works, so we we type 299 on the DO sub-line and save changes, those misc 1 piece to-ships go away, but the javascript changes the to ship to qty to the original DO qty To-Ship minus Avail Qty should equal To-Order. Can the JS also change the DO# sub-line row when we change Ordered field qty? Right now it just changes to top level SKU/Title row. This would also make things less confusing when using.

Sign in to join this conversation.

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: rob/pms3#447