Bill Dotson
Reputable Poster
We're having some fun trying to get some sales orders into our system via XML Interop. We've run into a couple of funky things we can't figure out. I'm hoping someone here has run into the same issues and figured them out.
1. Direct sales orders (doc type SD) automatically create direct Purchase Orders (doc type OD). However, when the PO is created through XML Interop, certain values are not populated as they would be if the sales order is entered into JDE manually. Specifically, the columns F4301.PHORBY, F4301.PHUSER and F4311.PDTORG are not getting populated. Normally, these are populated with user ID of the person who entered the order. However, via XML Interop, these columns are blank. We are passing a user ID in Begin Doc.
2. Some of our items are coded as stocking type U, which means "Use up." When we place an order manually through JDE, we can place orders for U items, up to the amount on-hand. This usually results in a warning, but the user is still able to place the order. However, via XML Interop, we get an error message stating that the item is over-committed, even though we have more on-hand than the quantity on the order.
Any other advice about using XML Interop is also appreciated. For some reason, we thought that JDE would treat orders via this method just like any other order. Not sure what made us think that . . . but it sure seems like there are lots of quirks to this method.
1. Direct sales orders (doc type SD) automatically create direct Purchase Orders (doc type OD). However, when the PO is created through XML Interop, certain values are not populated as they would be if the sales order is entered into JDE manually. Specifically, the columns F4301.PHORBY, F4301.PHUSER and F4311.PDTORG are not getting populated. Normally, these are populated with user ID of the person who entered the order. However, via XML Interop, these columns are blank. We are passing a user ID in Begin Doc.
2. Some of our items are coded as stocking type U, which means "Use up." When we place an order manually through JDE, we can place orders for U items, up to the amount on-hand. This usually results in a warning, but the user is still able to place the order. However, via XML Interop, we get an error message stating that the item is over-committed, even though we have more on-hand than the quantity on the order.
Any other advice about using XML Interop is also appreciated. For some reason, we thought that JDE would treat orders via this method just like any other order. Not sure what made us think that . . . but it sure seems like there are lots of quirks to this method.