Create A Purchase Order In Dynamics GP
Aug 25, 2011My main question is what fields are required for creating a PO using the web services. I keep getting an exception, so I feel like im leaving some info out. [code]
View 1 RepliesMy main question is what fields are required for creating a PO using the web services. I keep getting an exception, so I feel like im leaving some info out. [code]
View 1 RepliesI am trying to create a purchase order in Dynamics GP 2010 using the webservices. I get the following error VendorItemNumber not setup for ItemKey First off, I am not sure what that error actually means. Second off, I am not sure why I am getting it. My code is below.
Public Sub PO()
Dim context As Context
Dim purchaseOrderKey As PurchaseTransactionKey
Dim vendorKey As VendorKey
[code]....
I'm making a printable Purchase Order form using Crystal Report. This report retrieves data from two tables. Example, I have fields PONumber,DateofPO,Airline,DateofFlight,ETA,ETD from a table called tblFlight. I have fields PassengerName and Rate on another table called tblPassenger. Each PONumber can have multiple passengers. How can I get it so that I'll just be generating one PO that shows the multiple passengers while the rest of the items show only once? I've placed the PONumber and DateofPO on the PageHeader and the rest of the items on the Details section. But right now, on the Details section, if I have 3 passengers, the other fields also show 3 times on the report. Also, I'm considering to make a query but I have a conditional statement on my query, a WHERE clause that retrieves data dynamically. My problem is I'm not sure where to put the query, will it be on the .rpt or just on the Form? NOTE: I'm coding my SQL queries on the application itself, not inside the server, so no stored procedures/functions for me here.
View 1 Repliesi apologize if this isnt up to your developer lingo, i really do lack proper developer/English skills)Just for starters this request is 100% genuine...im not some student trying to get you guys to finish my project, this is purely for educational and personal information for myself.Scenario: (brief)(i am using Visual Studio 2010)I am wanting to build a project that generates a printable purchase orders report and retreieves and save the entered details to a access Database (MDB).
In the purchase order application im trying to develop i want a user to be able to select existing clients from n table in the access DB. in which will then fill a portion of the CLIENT detail section in the application. i want to then be able to uses these client details to create a unquie purchase order ID containing all client details aswell as the purchase order list for that client this such as products and labor or whatever is inputted in the fields. (I have attached a screen shot of a brief example of the form layout, might give you more idea. - screen shot made in VISIO)
[Code]...
if a byte value can go up to 255 and two bytes are used to determine the length of packet payload data, how would I convert the two bytes to create one integer value?
State.buffer[13] = 5 and State.buffer[14] = 67
Dim PacketLengthHigh As Integer = state.buffer(13)
Dim PacketLengthLow As Integer = state.buffer(14)
[code]....
My requirement is to create dynamic text boxes during run time.it shld b like this: when i click a button a text box shld b created and upon entering a value it shld be saved in access database.
View 3 RepliesI'm working on a web portal for customers that will connect to Microsoft Dynamics. I don't want to make Dynamics CRM directly a internet facing deployment (IFD), so I'd like to use a separate database that the web interface interacts with and then use web services to move the data between the web portal database and Dynamics CRM. I'm just looking for thoughts on whether this is the best way to proceed and whether there are any good code examples, etc. that I can look at for implementing this? I saw Microsoft has a Customer Portal but it looks like it requires (at a cursory glance) an IFD deployment - which I don't want.
View 4 RepliesI am want to apply gradient color on textbox background in active report. For this I use graphics and use following code:
Dim a As New System.Drawing.Drawing2D.LinearGradientBrush(New RectangleF(0, 0, Me.Width, Me.Height), color1, color2, mode)
Dim g As Graphics = Me.CreateGraphics
g.FillRectangle(a, New RectangleF(0, 0, Me.Width, Me.Height))
g.Dispose()
It works well in forms but in report not able to get object of Graphics by Me.CreateGraphics.
I need to stop all running workflows associated to an incident (and those with a name that begins with "Auto_").
However, I can't seems to find any documentation on how to stop workflow programmatically and I can't find how they are stored in the DB.
I am trying to create a program to order pizza what i have is a textbox to input the customers name, i have a masked textbox for the phone number, a group of two radio buttons for pick up or delivery with if delivery is selected a rich text box appears to input an address, a group of 3 radio buttons for pizza size s,m,l and then also a list box with 10 items for toppings what i want is when i hit the order button for the selected buttons and inputted info to generate a order summary on another form.
View 1 RepliesI'm a total beginner and want to know how one would purchase vb.net?
View 3 RepliesI would like to learn to be a Visual Basic Programmer. What software and where would I purchase VB to start off? Also, can anyone suggest good training books for newcomers?
View 10 RepliesI am using Excel 2003 and I am wanting to create a simple macro in order to run a for loop and then have the information output the numbers to cells.
Sub ForTest(i As Integer, j As Integer)
For x = i To j
y = Rnd
Next x
End Sub
This is my code. Now how can I print my x values to the A column and print my y values to the b column so that they line up as a pair of coordinate points.
I'm trying to create a website that can help a user purchase items from other websites. What would be the best way to go about doing this? I know most of the sites I'm using are sending their information using FORM:POST, but I'm having trouble finding the exact POST packet in fiddler (I'm assuming it's encrypted?), and know that a lot of the sites are using login credentials, so that complicates things a bit.
[Code]...
Im thinking of developing software that a user will purchase in modules.So they would buy the basic package, then if they want this feature, they purchase that and then they install that onto the basic package.
View 12 RepliesI'm stuck when trying to create the simplest partial class in order to access a table property. I have a LINQ auto generated DataContext with:
[Code]...
I'm working on a sales system. I have a form which consist of all the following information (item code, item name, item price, quantity of item) which is display using a data grid. Data input by user using text box and all this information will be stored in a database (sales database) I'm using ms access 2007. the grand total will be displayed in a text box. And amount paid will be input in a text box too, my major problem now is how to I create a receipt that will have all this information of the purchase. I have a receipt button. How to get the reciept done.
View 3 Repliesi m new to programming sector... i m creating a code to populate columner entries of a purchase / sales register. [code]
View 6 RepliesI need to create a console application that lets a user enter 20 names and then it sorts them out alphabetically in order and then displays them.
Module Module1
Sub Main()
Const names As Integer = 20
Dim index As Integer
[code]....
I have a combo box bound to a datasource. I need to change one combo box (of many) to order the items in descending order.I'm guessing I could order the collection in the dataset, but that will mean all my combo boxes will be reordered?
View 2 RepliesI have a databound Datagridview. The DGV is bound to a datatable of a strongly typed DataSet created using the wizard. Is there any way to re order the columns before displaying them eg: the Columns are displayed in the DGV in this other Col4, Col6, Col3, Col1,Col5, Col2
But I want to it to show as Col1, Col2, col3, Col4, Col5, Col6?
I realise that the display order followed the Column order in the database table and by extension, the datatable. I have re-arranged the columns in the Database but the Datatable still retains the old order.
This might not be so 'VB' as it is 'SQL using VB' I have an application with a built in MS Access DB. I have a table that has a column full of integers, I shoot the DB a SQL "order by 'column name' " string and it returns the table ordered by my column of integers.BUT it returns them like this, and I want them like this
0 6
1 5
2 4
[code]....
How do I get the OrderBY to do a descending list starting with the highest number?
I'm working on the exercise page 73 (VB 2010 in 24 hours). It's basically a form with 2 text boxes, 2 text labels and a command button. It's really simple and uses this loop to cycle through the items, and tell me the name of them in a Messagebox
[Code]...
When i try to install the Visual Studio 6.0 in Vista , am getting following error message,"setup was unable to create a DCOM user account in order to register 'C:programs FilesMicrosoft Visual StudioCommonToolsVS-Ent98Vanalyzrvalec.exe"
View 1 RepliesI have a textbox and when the cursor blinks on this textbox I want the user to press a combination of keyboard keys in order to display the tooltip of the textbox. How can I create a keyborad "shortcut" for the above?
View 5 RepliesI tried using this code I got from MSDN, but it doesn't do anything. What I am trying to do is have the user click the "Purchase" button in my app that will open a web browser to the web page on our site where they can purchase the application after their demo period has expired. If this is not the correct code?
Code:
' open internet browser to www.Cootsware.comspeedmaster.html
Private Declare Function ShellExecute _
Lib "shell32.dll" _
[CODE]....................
I have to order a table following a logical order but I cannot find the appropriate ORDER BY clause.To simplify I have 2 fields field1 and field2
1 record : field1 contains �2� and field2 contains �1�
2 record : field1 contains �1� and field2 contains �2�
3 record : field1 contains �2� and field2 contains �2�
[code].....
I have 2 datagrids. One to show Product information and another for Product purchase details entry. Both share the same dataset. The dataset (ds) is filled up with columns from 2 table
ProductMstrTbl : ProductID, ProductName..
ProductDetailsTbl: ProductID, PurchaseDate, Amt, BalanceQty..
DataSet(ds) : ProductID, ProductName, PurchaseDate, Amt, BalanceQty.
The problem is that: Showing from dataset or entering new records into the dataset is no problem, but am not able to save the modified dataset into DataBase. SqlCommandBuilder failed to generate the corresponding INSERT, UPDATE command as the dataset has multiple base tables.
using LINQ to NHibernate does anybody know how to use group by and order by in the same expression. I am having to execute the group by into a list and then order this, seem that I am missing soemthing here ?
Example:-
Private function LoadStats(...) ...
Dim StatRepos As DataAccess.StatsExtraction_vwRepository = New DataAccess.StatsExtraction_vwRepository
return (From x In StatRepos.GetAnswers(Question, Questionnaire) _
[code]....
I got next function: The input ArrayList results is ordered correctly.The return value returnList is completly unordered.I think to problem is the HashTable isn't ordered correctly.Is there a way I can order the Hashtable or should I sort the returnList on someway?I want to order or sort on a field.
[Code]...