Jump to content


Photo

Getting Back Orders Out of MoM


  • Please log in to reply
1 reply to this topic

#1 corebiz

corebiz

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 23 September 2009 - 11:27 AM

Here is what i'm trying to do.

We do pulls 4 times a day on the mom foxpro databases.

We do one pull that checks for orders shipped. Another that gets inventory levels.

We need to add a third on that checks for backorders.

My Question for you guys is where is this stored if an order goes to back order? I'm guessing part of it is in the Box or CMS table. But I'm sure there is one more to get items that are back ordered.

I'm guessing in the box table Status = N and Auxstatus = B would mean back order but i want to confirm this.

Any have any ideas on this?

Thanks

#2 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 23 September 2009 - 03:33 PM

The easiest solution is to check the Items table for an item_state of "BO"
David Seibold
Wild Horses, Inc.
Operations Manager




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users