Can someone explain to me how the QTYYTD value gets written, in the Part Sales table? Monthly, we run a report showing product sales, month-to-date and...
There is a way to do this with a BOM and Shop Order. We used to do something similar to this, but that was back 5 years ago. I don't know if MAX still...
Matthews, Gerald
jerry.matthews@...
May 1, 2006 5:36 pm
16238
If the BOM won't do it, Shop Orders do. We do that with shop orders frequently. Kathy Nelson De Groot, Inc. ... From: max_users@yahoogroups.com...
The quantity YTD fields (all YTD fields) are driven by the sales order. While logically, it is not possible to have MTD without YTD values, it is technically...
The BOM module still operates this way. It is referred to as "by-product" logic. It works for shop order issues and repetitive transactions. Rick MMS ... ...
I havent seen much yet on the forum, so I was curious if many of you have upgraded to the 4.0 version yet and if so, what do you think of it and how did it go...
I am just working on the conversion of 8.5 reports to version 11 and have not resolved this issue yet: I am starting to test Crystal Reports XI with my custom...
Longley, Kevin
kwlongley@...
May 2, 2006 4:37 pm
16243
Is there a way to print credit memo's with the line item prices, as well as the order total? Thanks - Bob...
That issue has been around for a long period of time. The date in the Key_61 field is hosed, so the parent - component -effective date will not work. I...
I got it to work this morning using the following formula in Crystal 11 - it would not work consistently in version 8.5. I use the formula to create a key_61...
Longley, Kevin
kwlongley@...
May 3, 2006 11:36 am
16246
Hi everyone. I'm trying to connect MAX and UPS Worldship, and I've run into a big problem that won't let me use a dynamic connection to MAX. In other words,...
I wouldn't give up on the ODBC connection if that is what you want to use. We currently use a connection Worldship to MAX via ODBC, and it works pretty well....
Oh, an additional note: I am accessing a "View" I created in the MAX database instead of accessing the tables directly. Barry Sampson Midwest Technologies ...
Barry, Hot dog. I'm glad you spoke up. I've been hopeful that someone else on this list is doing the same thing. As for my roadblock, the "connect" button...
Just a note of caution for you - last week Tech Support told me that if I create anything in the Max database that it would void our support agreement with...
We've recently tried to do this to. You can use ODBC to pull data from MAX into Worldship, but not the other way around. Our UPS technical contact told us...
Rob, can you give me more detail about how you've setup the integration? It sounds like you, too, are making a good connection to the Pervasive ODBC, so maybe...
Rob, I'm just trying to pull info into Worldship, for the "pop" effect. At this point, I'm just trying to prove to myself that this silly connection will...
From what I understand of triggers, the Tech Support positions may be because a trigger can cause a MAX transaction to fail. Putting a trigger on a table adds...
Matthews, Gerald
jerry.matthews@...
May 3, 2006 2:03 pm
16256
Lawrence, To automatically run batch programs or export routines, we have successfully used Automate [http://www.networkautomation.com/]. Reasonably priced...
Rob has a good point. Are you importing or exporting information into Worldship? I am currently exporting tracking information to a general "shipping"...
Rob, yes. At the point of selecting fields from both databases, the "Connect" button never becomes available. This is odd to me because I can select...
Wow! This is a very active thread! We are importing MAX shipping info into Worldship also. It has been a great time saver. One thing we haven't mastered is...
Can you guys tell me more about how your UPS Worldship installs look? Maybe its with the Worldship configuration. Also, what version of Pervasive are you...
We are on Pervasive 8.x. It worked fine with the 2000i version as well. I went to the WorldShip PC to check things out. When I select a field directly from...
Hmmmmmmmmmmmm. Okay. I somehow stumbled upon this view you guys keep mentioning. UPS_Data is what mine is called - what's yours called? - and I can now...
Good, sounds like you are on track. If you don't know where the view came from, I'd definitely check to see what the SQL statement is behind the view. In PCC,...
Barry, Yeah, as soon as I found the view, I checked it out on the SQL side. Interestingly enough, the syntax was slightly off, and was easy to fix. I guess it...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
