Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Qty_to_ship default to 0

Status
Not open for further replies.

Xannidax

Programmer
Oct 22, 2024
2
We are integrating wisys to our macola,
And we noticed that wisys looks at the qty ordered and qty to ship to calculate the remainder, but in macola the order entry process defaults the ship to the qty ordered so if qty order = 2 then it check balances qty_to_ship to 2 and in wisys thats what we see.

In wisys we have a grid under the order scanning where it shows the items missing to be scanned and the logic it follows is show as long as qty shipped is less than qty ordered.

We are thinking there is a way to default those qty to 0 or tap into the calculation table for the @txtRemender in wisys
 
Is this an out of the box WiSys app/grid or something you made? When I’m checking if a line has been shipped or not I use select_cd on oeordlin. If it’s “S” then it’s shipped and the qty_to_ship is the quantity shipped. If it’s blank then the line is not yet shipped and you can say qty shipped is zero. My suggestion would be to look there instead.
 
Progression, ES or Macola 10? You should never ask a question without providing this info. Also, you should state your specific version for example Progression 7.9.340.

That said, for Progression, look in OE Setup->additional OE Setup and make sure the checkbox "default qty to ship = qty ordered" is NOT checked.

In ES/Macola 10, this would be under System->Package Settings->Distribution->Order Entry

After this change, the qty to ship will populate to the qty ordered if there is sufficient qty available. So if the order is for 10 and 100 are available, the qty to ship would be 10. If only 7 were available, the qty to ship would be 7.

Is this the behavior you are looking for?
 
Hi, thank you.
Its macola 10 and I kind of figured it out.
I added a sql query so that as soon as we open the order in wisys the app it will update the qty_to_ship to 0 on the oeordline if status = 4 on the oeordhdr
then it change status to 7 adding ord_dt_shipped and pre_select_status. All withing same transaction

not sure if im missing anything else.(added a picture for reference)
 

Attachments

  • image.jpg
    image.jpg
    3.1 MB · Views: 2
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top