Recent content by Wolf6

Hi barbola. Just a quick thought. Did you run the grant.sql statement against the company and dynamics DBs after your upgrade? Scott

Hi Tom. There are some knowledgebase articles on the CustomerSource site about this issue. Search on the following numbers 852594 861268 Scott

What is the user that you are connecting with? If it's other than sa, check that the permissions on the table(s) are correct. During the upgrade some tables are dropped and recreated and the security is reset for the GP users only. Scott

Hi Ivan. Check the module setup. Be sure that under contract that the "Auto Create Contract from SOP" box is checked. Scott

Hello ieaston. I assume that you are using Contract Administration from the Field Service Series. The table you are looking for is SVC00608. You can find the table descriptions under Tools->Resource Descriptions->Tables. I usually print a copy of each list and keep it in a binder. Good Luck Scott

Also look at I.B.I.S. inc. They have a rental module that integrated with the Microsoft service modules. Scott

We have used the Service Call Management modules since release 4. back then the report writer in Great Plains would not cross modules. Our solution was a crystal report. You can get any or all of the notes fields on an invoice. As we are still on release 6 and I have stayed away from building...

SKarasik, what note are you looking for? Transaction or item?

At one point there was a group for the field service modules on MSN. It was created by Jeff Bakko, who was at the time and may still be part of the Field Service technical support group at Microsoft (Great Plains). The last post was on 2/10/2003. I will post a message to see if there is anyone...

See the following Techknowledge Error "Violation of PRIMARY KEY Constraint PKRM30301 Cannot Insert Duplicate Key" When Running Paid Transaction Removal in Receivables Management http://www.greatplains.com/techknowledge/techknowledge.asp?id=32359&target=CS

This usually occurs when a posting is interrupted and the same transaction exists in both the open and history tables. Run a query against both the RM20101 and the RM30101 tables for each customer. Compare the results to see if this is true. If it is true then you should be able to delete the...

Check the joins in your Crystal Report. Are you joining tables that are outside of the standard SOP header and lines (SOP30200 and SOP30300)? If you are, and your joins are set to equal "=" then it is possible that the invoice will not show/print if there is data missing in these...

Hi. I think I have the solution that you are looking for. First, on the Sales Transaction Entry Window there are many notes fields that are visible. The only one that is linked to the record in the SOP10100 table is the one that follow the Document No. If you want to enter notes on a sales...

Hi, If I understand your question, you are looking for the note text from an item record. I can help with eEnterprise SQL server tables only, I am not familiar with Great Plains in other databases. I am also assuming that you are using Sales Order Processing (SOP). In order to do this you will...

This can be done by setting up an item in inventory using the Services use type. These parts must be entered into the Additional Charges area of the service call. No inventory adjustments are made and no cost information will be retained on the call or the SOP Invoice. You may need to create...