Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

oeordlin_sql shipped_date questions

oeordlin_sql shipped_date questions

oeordlin_sql shipped_date questions

Progression 7.9.310. I have been reading and had a few questions about shipped_dt. When there is a date present on a line item, is that enough to allow it to be moved to "Shipped" status and invoiced and moved to the OELINHST table, or are there other checks that are involved? We are attempting to reimburse warranty parts' via a negative qty with a MISC item_no on the same order as the part, using the SDK. Manually doing it in Macola has no issues and the $$ always comes out right in the end. However, to get it to post automatically, we need it show a shipped_dt from our Wisys and Wisys does not like shipping a Negative QTY (which is understandable). If shipped_dt for those refund lines were inserted via another Wisys grid or SQL would that be enough for the system to accept or are there other checks Macola goes through before changing the status to "7 -Shipped"?

RE: oeordlin_sql shipped_date questions

In oeordlin_sql there is a column 'select_cd' that is set to 'S' when it is shipped. I'm guessing your MISC item is a non-stocked, non-controlled, or a phantom item therefore there wouldn't be an inventory transaction.

Your best bet if you're going to do this with a Wisys grid is to use the OE Confirm Ship object and have it ship the MISC item. I've never tried to ship a negative quantity so your mileage may vary.

RE: oeordlin_sql shipped_date questions

Thank you for the information, that is exactly what I was looking for, will try it now.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close