I'm calling the browse method and trying to find an order by number. This code takes around 4-5 minutes. Are these method really that slow?
var view = OpenView("OE0520");
view.Browse("ORDNUMBER = 5555555555", true);
thanks!
OK, so fields like QTONHANDA on the items you can't return using this method so I'd still need the normal view/browse then?
That's a computed field, CS0120 won't return it. Get QOH from ICILOC, you'll need LOCATION, too.
Do you know what tables I can find TAMOUNT1 & SHINETWTX
I can't get these from CS0120 and I'm not familiar yet w/ Sage 300 to figure out what table. My guess would order details for taxes? Loop and look for a certain line item type?
SHINETWTX: OEORDH and OESHIH
TAMOUNT1: OEAUDD, OECRDD, OECRDH, OEORDH, OEORDD, OEINVH, OEINVD
whoa, I need all those tables to get the tax amount?
No, you just need the right one. Do you want the order, the shipment, or the invoice version, and the header or detail version? I assume in your case it's OEORDH, the total on the order header.
Ah, ok. Yes order details for both. I was using OE0520
OE0520 is the header. OE0500 is the detail. You should visit this page and get the AOM for your version support.na.sage.com/.../viewContent.do
Welcome to the jungle
haha, I don't see a tamount1 field in the OEORDH table. It says it's calculated. So, trying to figure out how I can get it with CS0120. My guess is find all the line items and add up all their taamount1 fields
Oops, you're right. D'oh! I was working with views all day (I love Orchid Extender!), I forgot SQL ain't the same all the time.
*Community Hub is the new name for Sage City