How do I Return an Invoice in Dyamics GP through eConnect or Web Services

(0) Share

Report

Posted on by RonCarter

380

We have invoice documents in GP 10.0. Recently, the accounting department has decided that when the incorrect client has been billed, we will return the invoice and create a new one. (Previously, we would issue a credit memo to the wrong client and a debit memo to the new client).

I have been pointed at taSopHdrIvcInsert, but I'm not sure what to do with it or how to save it back. Because I'm never 100% sure what fields GP really needs, I was hoping I could use eConnect or web services to get the document by number, change the SOPTYPE to 4-Return and save it back since it appears everything else should be the same.

I can then invoice the new client and save that into GP using existing processes.

*This post is locked for comments

All responses (6)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How do I Return an Invoice in Dyamics GP through eConnect or Web Services

[quote][/quote]

We have invoice documents in GP 10.0. Recently, the accounting department has decided that when the incorrect client has been billed, we will return the invoice and create a new one. (Previously, we would issue a credit memo to the wrong client and a debit memo to the new client).

I have been pointed at taSopHdrIvcInsert, but I'm not sure what to do with it or how to save it back. Because I'm never 100% sure what fields GP really needs, I was hoping I could use eConnect or web services to get the document by number, change the SOPTYPE to 4-Return and save it back since it appears everything else should be the same.

I can then invoice the new client and save that into GP using existing processes.
RonCarter 380 on at

Like (0)

Report

Re: How do I Return an Invoice in Dyamics GP through eConnect or Web Services

In addition, here is the code from WSExceptionLog, showing the XML that was submitted as a result of the C# code that I put above:

<RequestObjects> <SalesReturn xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Extensions /> <Type>Return</Type> <Date>2013-02-08T00:00:00-05:00</Date> <MasterNumber xsi:nil="true" /> <ExchangeRate xsi:nil="true" /> <ExchangeDate xsi:nil="true" /> <RequestedShipDate xsi:nil="true" /> <FreightTaxBasis xsi:nil="true" /> <MiscellaneousTaxBasis xsi:nil="true" /> <TransactionState xsi:nil="true" /> <CreatedBy>WS_WEBSERVICE</CreatedBy> <CreatedDate xsi:nil="true" /> <ModifiedDate xsi:nil="true" /> <CommissionBasedOn xsi:nil="true" /> <ActualShipDate xsi:nil="true" /> <FulfillDate xsi:nil="true" /> <QuoteDate xsi:nil="true" /> <IsIntrastatDocument xsi:nil="true" /> <IsVoided xsi:nil="true" /> <ShipCompleteOnly xsi:nil="true" /> <IntegrationSource xsi:nil="true" /> <InvoiceDate xsi:nil="true" /> <BackorderDate xsi:nil="true" /> <ReturnDate xsi:nil="true" /> <CustomerKey> <Id>RE2501</Id> </CustomerKey> <BatchKey> <Source /> <Id>RTRN20130208</Id> <CreatedDateTime>0001-01-01T00:00:00</CreatedDateTime> </BatchKey> <Commissions /> <ProcessHolds /> <Taxes /> <FreightTaxes /> <MiscellaneousTaxes /> <TrackingNumbers /> <GeneralLedgerPostingDate xsi:nil="true" /> <PostedDate xsi:nil="true" /> <Lines> <SalesReturnLine> <Extensions /> <Quantity> <Value>3.00000</Value> <DecimalDigits>5</DecimalDigits> </Quantity> <IsNonInventory xsi:nil="true" /> <IsDropShip xsi:nil="true" /> <RequestedShipDate xsi:nil="true" /> <DeleteOnUpdate xsi:nil="true" /> <TaxBasis xsi:nil="true" /> <IntegrationSource xsi:nil="true" /> <ItemKey> <Id>MMI447</Id> </ItemKey> <Taxes /> <ReturnQuantity> <ReturnedQuantity> <Value>3.00000</Value> <DecimalDigits>5</DecimalDigits> </ReturnedQuantity> </ReturnQuantity> <Components /> <Serials /> <Lots /> <Bins /> </SalesReturnLine> </Lines> <Payments /> <Distributions /> </SalesReturn> <Context xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/dynamics/2006/01"> <OrganizationKey xsi:type="CompanyKey"> <Id>2</Id> </OrganizationKey> <CultureName>en-US</CultureName> <CurrencyType>Transactional</CurrencyType> <RoleKey> <Id xmlns="http://schemas.microsoft.com/dynamics/security/2006/01">e18b321a-9548-48fb-b75a-dee0a618ddaa</Id> </RoleKey> </Context> <Policy xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Key> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </Key> <Behaviors> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>dc788b46-e2ae-4b7a-80c2-00cb40dcf76f</Id> </Key> <Name>Assign Batch Prefix</Name> <Description>Will determine if a prefix for the batch Id will be provided</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>dc788b46-e2ae-4b7a-80c2-00cb40dcf76f</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>No Prefix</Name> <Description>No prefix will be specified for the Batch Id</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>dc788b46-e2ae-4b7a-80c2-00cb40dcf76f</Id> </BehaviorKey> <Id>2</Id> </Key> <Name>Specify Prefix</Name> <Description>A prefix will be specified for the Batch Id</Description> <Parameters> <Parameter> <Key> <BehaviorOptionKey> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>dc788b46-e2ae-4b7a-80c2-00cb40dcf76f</Id> </BehaviorKey> <Id>2</Id> </BehaviorOptionKey> <Id>1</Id> </Key> <Name>Prefix</Name> <Value /> <Description>The value for the Batch Id prefix</Description> </Parameter> </Parameters> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>dc788b46-e2ae-4b7a-80c2-00cb40dcf76f</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>No Prefix</Name> <Description>No prefix will be specified for the Batch Id</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>2e873316-fee1-460e-8da1-12167013401b</Id> </Key> <Name>Calculate Unit Price Behavior</Name> <Description>Will determine whether the unit price and total amount will be automatically calculated</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>2e873316-fee1-460e-8da1-12167013401b</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Do Not Calculate</Name> <Description>Do not calculate unit price and line total amount</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>2e873316-fee1-460e-8da1-12167013401b</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Calculate</Name> <Description>Calculate unit price and line total amount</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>2e873316-fee1-460e-8da1-12167013401b</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Calculate</Name> <Description>Calculate unit price and line total amount</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>41233b06-db1a-4050-b4af-207eb2c908b3</Id> </Key> <Name>Calculate Total Amount Behavior</Name> <Description>Will determine whether the total amount on the sales line will be automatically calculated</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>41233b06-db1a-4050-b4af-207eb2c908b3</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Do Not Calculate</Name> <Description>Do not calculate line total amount</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>41233b06-db1a-4050-b4af-207eb2c908b3</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Calculate</Name> <Description>Automatically calculate total amount</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>41233b06-db1a-4050-b4af-207eb2c908b3</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Calculate</Name> <Description>Automatically calculate total amount</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>e476a157-ecf0-4dae-8cef-317dd2cfbe41</Id> </Key> <Name>Create GL Account Distributions Behavior</Name> <Description>Will determine whether the GL account distributions will provided or automatically calculated</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>e476a157-ecf0-4dae-8cef-317dd2cfbe41</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Distributions Will Be Provided</Name> <Description>Distributions will be provided</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>e476a157-ecf0-4dae-8cef-317dd2cfbe41</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Automatically Create Distributions</Name> <Description>Automatically create distributions</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>e476a157-ecf0-4dae-8cef-317dd2cfbe41</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Automatically Create Distributions</Name> <Description>Automatically create distributions</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>758c758e-13fc-42cc-a508-57a8abe04dcd</Id> </Key> <Name>Default Warehouse Behavior</Name> <Description>Will determine the default warehouseId to be used when creating a sales document</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>758c758e-13fc-42cc-a508-57a8abe04dcd</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Use Setup Value</Name> <Description>The warehouse Id will default from the customer ship-to address on the sales document header; if empty then the warehouse Id will default from Sales Order Processing Setup</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>758c758e-13fc-42cc-a508-57a8abe04dcd</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Specify Default</Name> <Description>Specify the default warehouse Id</Description> <Parameters> <Parameter> <Key> <BehaviorOptionKey> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>758c758e-13fc-42cc-a508-57a8abe04dcd</Id> </BehaviorKey> <Id>1</Id> </BehaviorOptionKey> <Id>1</Id> </Key> <Name>Default Warehouse Parameter</Name> <Value /> <Description>The default warehouse Id </Description> </Parameter> </Parameters> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>758c758e-13fc-42cc-a508-57a8abe04dcd</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Use Setup Value</Name> <Description>The warehouse Id will default from the customer ship-to address on the sales document header; if empty then the warehouse Id will default from Sales Order Processing Setup</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>16fb38cc-d635-4b5e-8235-6235fa828062</Id> </Key> <Name>Default Document Type Id Behavior</Name> <Description>Will determine the default document type Id to be used when creating a sales document</Description> <Internal>false</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>16fb38cc-d635-4b5e-8235-6235fa828062</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Use Setup Value</Name> <Description>Use default document type Id from Sales Setup</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>16fb38cc-d635-4b5e-8235-6235fa828062</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Specify Default</Name> <Description>Specify the default document type Id</Description> <Parameters> <Parameter> <Key> <BehaviorOptionKey> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>16fb38cc-d635-4b5e-8235-6235fa828062</Id> </BehaviorKey> <Id>1</Id> </BehaviorOptionKey> <Id>1</Id> </Key> <Name>Default Type Id Parameter</Name> <Value /> <Description>The default document type Id</Description> </Parameter> </Parameters> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>16fb38cc-d635-4b5e-8235-6235fa828062</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Use Setup Value</Name> <Description>Use default document type Id from Sales Setup</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>f3903ab2-6964-451e-b9be-682c6ca6a89e</Id> </Key> <Name>Create Components Behavior</Name> <Description>will determine whether kit components are being provided</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>f3903ab2-6964-451e-b9be-682c6ca6a89e</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Automatically Create Components</Name> <Description>Automatically create components</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>f3903ab2-6964-451e-b9be-682c6ca6a89e</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Components Will Be Provided</Name> <Description>Components will be provided</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>f3903ab2-6964-451e-b9be-682c6ca6a89e</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Automatically Create Components</Name> <Description>Automatically create components</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>626a4d44-dd14-4a1c-a344-69a8dac9d3a3</Id> </Key> <Name>Check Hold Behavior</Name> <Description>Will determine whether the customer's hold status will be checked when the document is created</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>626a4d44-dd14-4a1c-a344-69a8dac9d3a3</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Override Hold</Name> <Description>Override hold</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>626a4d44-dd14-4a1c-a344-69a8dac9d3a3</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Cancel Document</Name> <Description>Cancel document</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>626a4d44-dd14-4a1c-a344-69a8dac9d3a3</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Cancel Document</Name> <Description>Cancel document</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>ed4b65bd-554a-41bd-b870-86eb41670cd8</Id> </Key> <Name>Create Commissions Behavior</Name> <Description>Will determine whether commissions will be automatically created or manually provided</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>ed4b65bd-554a-41bd-b870-86eb41670cd8</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Commissions Will Be Provided</Name> <Description>Commissions will be provided</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>ed4b65bd-554a-41bd-b870-86eb41670cd8</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Automatically Create Commissions</Name> <Description>Automatically create commissions</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>ed4b65bd-554a-41bd-b870-86eb41670cd8</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Automatically Create Commissions</Name> <Description>Automatically create commissions</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>74fda1f6-b7b6-4cfe-a38b-d6ad5b39e57e</Id> </Key> <Name>Use Header Level Taxes Behavior</Name> <Description>Will determine whether detail taxes are being provided</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>74fda1f6-b7b6-4cfe-a38b-d6ad5b39e57e</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Detail Taxes Will Be Provided</Name> <Description>Detail taxes will be provided</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>74fda1f6-b7b6-4cfe-a38b-d6ad5b39e57e</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Header Taxes Will Be Provided</Name> <Description>Header level taxes will be provided</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>74fda1f6-b7b6-4cfe-a38b-d6ad5b39e57e</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Detail Taxes Will Be Provided</Name> <Description>Detail taxes will be provided</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>799cbafa-207a-4e42-8141-d9f281fc2ba9</Id> </Key> <Name>Miscellaneous Tax Behavior</Name> <Description>Will determine whether the miscellaneous amount on the document is taxable and if taxable where the miscellaneous tax schedule Id defaults from </Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>799cbafa-207a-4e42-8141-d9f281fc2ba9</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Default From Setup</Name> <Description>Default From Setup</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>799cbafa-207a-4e42-8141-d9f281fc2ba9</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Taxable</Name> <Description>Taxable</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>799cbafa-207a-4e42-8141-d9f281fc2ba9</Id> </BehaviorKey> <Id>2</Id> </Key> <Name>Nontaxable</Name> <Description>Nontaxable</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>799cbafa-207a-4e42-8141-d9f281fc2ba9</Id> </BehaviorKey> <Id>3</Id> </Key> <Name>Base On Customer</Name> <Description>Base On Customer</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>799cbafa-207a-4e42-8141-d9f281fc2ba9</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Default From Setup</Name> <Description>Default From Setup</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>5855c79b-17a8-43b6-ab4f-db52e64fd0bd</Id> </Key> <Name>Create Batch</Name> <Description>Specifies the naming method to use when a new batch is created by the web service, if the name of the batch was not supplied</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>5855c79b-17a8-43b6-ab4f-db52e64fd0bd</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Hourly</Name> <Description>The batch name will use the following format: Numeric representation of year, month, and day, followed by the letter "H" and then the hour in 24-hour format. For example, 20060710H17 represents July 10, 2006 at 5 p.m</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>5855c79b-17a8-43b6-ab4f-db52e64fd0bd</Id> </BehaviorKey> <Id>2</Id> </Key> <Name>Daily</Name> <Description>The batch name will use the following format: Numeric representation of the year, month, and day. For example, 20060710 represents July 10, 2006</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>5855c79b-17a8-43b6-ab4f-db52e64fd0bd</Id> </BehaviorKey> <Id>3</Id> </Key> <Name>Weekly</Name> <Description>The batch name will use the following format: Numeric representation of the year, followed by the letter "W", the numeric representation of the current week in the year, and finally the value specified by the Day of Week behavior. For example, 2006W2802 represents Tuesday of the 28th week of 2006</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>5855c79b-17a8-43b6-ab4f-db52e64fd0bd</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Hourly</Name> <Description>The batch name will use the following format: Numeric representation of year, month, and day, followed by the letter "H" and then the hour in 24-hour format. For example, 20060710H17 represents July 10, 2006 at 5 p.m</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>1a994c4e-c0a9-4466-aba0-e01157f78646</Id> </Key> <Name>Create Bins Behavior</Name> <Description>Create Bins Behavior</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>1a994c4e-c0a9-4466-aba0-e01157f78646</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Do Not Create</Name> <Description>Do not create</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>1a994c4e-c0a9-4466-aba0-e01157f78646</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Create</Name> <Description>Create</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>1a994c4e-c0a9-4466-aba0-e01157f78646</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Create</Name> <Description>Create</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>9a601da7-bf3a-4da2-b70f-e30f5798158f</Id> </Key> <Name>Freight Tax Behavior</Name> <Description>Will determine whether the freight amount on the document is taxable and if taxable where the freight tax schedule Id defaults from</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>9a601da7-bf3a-4da2-b70f-e30f5798158f</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Default From Setup</Name> <Description>Default From Setup</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>9a601da7-bf3a-4da2-b70f-e30f5798158f</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Taxable</Name> <Description>Taxable</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>9a601da7-bf3a-4da2-b70f-e30f5798158f</Id> </BehaviorKey> <Id>2</Id> </Key> <Name>Nontaxable</Name> <Description>Nontaxable</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>9a601da7-bf3a-4da2-b70f-e30f5798158f</Id> </BehaviorKey> <Id>3</Id> </Key> <Name>Base On Customer</Name> <Description>Base On Customer</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>9a601da7-bf3a-4da2-b70f-e30f5798158f</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Default From Setup</Name> <Description>Default From Setup</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </Key> <Name>Day of Week</Name> <Description>If the Create Batch behavior is set to Weekly, specifies the value to use in the day of the week portion of the batch name created by the web service</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Monday</Name> <Description>The value "01" representing Monday</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>2</Id> </Key> <Name>Tuesday</Name> <Description>The value "02" representing Tuesday </Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>3</Id> </Key> <Name>Wednesday</Name> <Description>The value "03" representing Wednesday</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>4</Id> </Key> <Name>Thursday</Name> <Description>The value "04" representing Thursday </Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>5</Id> </Key> <Name>Friday</Name> <Description>The value "05" representing Friday</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>6</Id> </Key> <Name>Saturday</Name> <Description>The value "06" representing Saturday</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>7</Id> </Key> <Name>Sunday</Name> <Description>The value "07" representing Sunday</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>c4f96f80-69bd-4a67-ac0f-f019fa79bb1c</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Monday</Name> <Description>The value "01" representing Monday</Description> <Parameters /> </SelectedOption> </Behavior> <Behavior> <Key> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>47105c7b-7a08-4c89-8204-f9e3538d1eb9</Id> </Key> <Name>Create Taxes Behavior</Name> <Description>Will determine whether the tax engine will be used to calculate the taxes or if the tax details will be manually provided</Description> <Internal>true</Internal> <Options> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>47105c7b-7a08-4c89-8204-f9e3538d1eb9</Id> </BehaviorKey> <Id>0</Id> </Key> <Name>Taxes Will Be Provided</Name> <Description>Taxes will be provided</Description> <Parameters /> </BehaviorOption> <BehaviorOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>47105c7b-7a08-4c89-8204-f9e3538d1eb9</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Automatically Create Taxes</Name> <Description>Automatically create taxes</Description> <Parameters /> </BehaviorOption> </Options> <SelectedOption> <Key> <BehaviorKey> <PolicyKey> <Id>07f575f9-c6c3-424c-8162-19ab5b4af372</Id> </PolicyKey> <Id>47105c7b-7a08-4c89-8204-f9e3538d1eb9</Id> </BehaviorKey> <Id>1</Id> </Key> <Name>Automatically Create Taxes</Name> <Description>Automatically create taxes</Description> <Parameters /> </SelectedOption> </Behavior> </Behaviors> <Name>Create Sales Return Policy</Name> <RootBusinessObjectName>Sales Document</RootBusinessObjectName> </Policy></RequestObjects>
RonCarter 380 on at

Like (0)

Report

Re: How do I Return an Invoice in Dyamics GP through eConnect or Web Services

We aren't using eConnect, we are using the web services, which in turn use eConnect behind the scenes, of course. Here is the code that I'm using, based off of a sample that I found on the web. First, I get the invoice, so that I know what I'm returning (item, qty, etc) and then I populate a SalesReturn object. We are using the WS for other things, like saving invoices, creating customers, and more.

var client = new DynamicsGPSoapClient();

var salesDocumentKey = new SalesDocumentKey() {Id = invoiceNumber};

var context = buildContext();

var salesInvoiceResponse = client.GetSalesInvoiceByKey(new GetSalesInvoiceByKeyRequest(salesDocumentKey, context));

var salesInvoice = salesInvoiceResponse.GetSalesInvoiceByKeyResult;

var salesReturn = new SalesReturn();

salesReturn.DocumentTypeKey = new SalesDocumentTypeKey() { Type = SalesDocumentType.Return };

salesReturn.CustomerKey = new CustomerKey { Id = salesInvoice.CustomerKey.Id };

salesReturn.BatchKey = new BatchKey() { Id = string.Format("RTRN{0}", DateTime.Today.ToString("yyyyMMdd")) };

salesReturn.Date = DateTime.Today;

salesReturn.Type = SalesDocumentType.Return;

var returnedLines = new List<SalesReturnLine>();

foreach (var invoiceLine in salesInvoice.Lines)

{

var salesReturnLine = new SalesReturnLine();

salesReturnLine.ItemKey = new ItemKey() { Id = invoiceLine.ItemKey.Id };

var salesReturnQuantity = new SalesReturnQuantities();

salesReturnQuantity.ReturnedQuantity = new Quantity(){Value = invoiceLine.Quantity.Value, DecimalDigits = invoiceLine.Quantity.DecimalDigits};

salesReturnLine.ReturnQuantity = salesReturnQuantity;

salesReturnLine.Quantity = new Quantity() { Value = invoiceLine.Quantity.Value, DecimalDigits = invoiceLine.Quantity.DecimalDigits };

returnedLines.Add(salesReturnLine);

}

salesReturn.Lines = returnedLines.ToArray();

var returnPolicyRequest = new GetPolicyByOperationRequest("CreateSalesReturn", context);

var salesReturnCreatePolicy = client.GetPolicyByOperation(returnPolicyRequest).GetPolicyByOperationResult;

var createSalesReturnRequest = new CreateSalesReturnRequest(salesReturn, context, salesReturnCreatePolicy);

client.CreateSalesReturn(createSalesReturnRequest);

Thank you again for all the time you've already put in and will put in. I appreciate it.
sandipdjadhav 18,265 on at

Like (0)

Report

Re: How do I Return an Invoice in Dyamics GP through eConnect or Web Services

Ron,

You are using eConnect. Can you post your XML file over here?.

SOP type : 4

to get your document ID goto Dynamics GP-->Transaction-->Sales Transactions entry. Select Return and see what is Doc ID.

Let me know how it goes.

Thanks

Sandip
RonCarter 380 on at

Like (0)

Report

Re: How do I Return an Invoice in Dyamics GP through eConnect or Web Services

Thank you for your reply. I have been attempting to use that and now I'm getting a validation error. When I look in the event logs, the error is

Please supply the SOPTYPE and DOCID in the taSopHdrIvcInsert if not passing a SOPNUMBE.

at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ExecStoredProcedures(String xml)

at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String ConnectionString, ConnectionStringType ConnectionType, String sXML, SchemaValidationType ValidationType, String eConnectSchema)

This is obviously downstream as the WS is calling eConnect behind the scenes. I'm confused, though. I've set the type, but there is no DOCID or SOPNUMBE (or anything close) property on the SalesReturn WS object. Do you have any insight on this?
Suggested answer

sandipdjadhav 18,265 on at

Like (0)

Report

Re: How do I Return an Invoice in Dyamics GP through eConnect or Web Services

Ron,

There is Web Method for Sales Retun.

msdn.microsoft.com/.../cc508592.aspx

Let me know how it goes.

Thanks

Sandip