DynDeveloper.com

I just completed an upgrade of a VS Tools modification from GP 2010 to GP 2013, and I thought I'd write down the steps in case anyone was having any difficulty. All in all, not to hard.

Hi ,

I am looking to get the following fields in my SmartList for Posted GL Transactions

Batch Number

APPROVL   (Approval)  

APPRVLDT  (Approval Date

APRVLUSERID  (Batch Approved By)

I know system stores this information in SY00500 when batch is in unposted status but it is removed a soon as the batch is posted

I will like to know what table(s) this information is stored in after the Batch is posted

Any help is greatly appreciated

Thanks,

Iqbal

sorry but i new user in GP 

i have a cuestion (sorry with my english but a speak only spanish and i try to write my questions)

i have one one Purchase order when i try to work this one messages appears :::

"You can not open this purchase order until you save on a lot of shopping. Selections another purchase order"

How can i put a lot of shopping

Edit 9/16/15 View the main article for this error here 

I am having to insert a PM Transaction with sales taxes using eConnect 2010.  This is a modification to an existing AP Invoice import--I just need to add the sales taxes.

I have created a tax detail ID with 0% rate, and am able to manually enter transactions with various sales tax amounts using the tax ID.

When I attempt to import a PM transaction with taPMTransactionTaxInsert, I get:

Edit 9/16/15 View the main article for this error here 

Error Number = 313  Stored Procedure= taPMTransactionInsert  Error Description = Tax table detail does not equal the tax amount

 This error is triggered by the taPMTransactionInsert proc using the following code.  I have traced the taPMTransactionTaxInsert procedure, and far as I can tell, the PM10500 record is being written properly, so when taPMTransactionInsert queries PM10500, the data should match the XML values I'm sending in for the header.

Edit 9/16/15 View the main article for this error here 

Do I have something wrong in the transaction header?

    select @TAXAMNT = isnull(sum(TAXAMNT), 0.00)
          from   PM10500 (nolock)
          where  DOCTYPE = @I_vDOCTYPE
                 and VCHRNMBR = @I_vVCHNUMWK
                 and BKOUTTAX <> 1

          if ( @TAXAMNT <> @I_vTAXAMNT )
            begin
                select @O_iErrorState = 313

                exec @iStatus = taUpdateString
                  @O_iErrorState,
                  @oErrString,
                  @oErrString output,
                  @O_oErrorState output
            end

<eConnect xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">
  <PMTransactionType>
    <eConnectProcessInfo xsi:nil=\"true\" />
    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />
    <taUpdateCreateVendorRcd xsi:nil=\"true\" />
    <taCreateVendorAddress_Items xsi:nil=\"true\" />
    <taPMTransactionTaxInsert_Items>
      <taPMTransactionTaxInsert>
        <VENDORID>GHDIN</VENDORID>
        <VCHRNMBR>11</VCHRNMBR>    <---- My bug!
        <DOCTYPE>1</DOCTYPE>
        <BACHNUMB>MXAP0906-13</BACHNUMB>
        <TAXDTLID>APTAX</TAXDTLID>
        <TAXAMNT>1</TAXAMNT>
        <PCTAXAMT>1</PCTAXAMT>
        <TDTTXPUR>12.22</TDTTXPUR>
        <TXDTTPUR>12.22</TXDTTPUR>
      </taPMTransactionTaxInsert>
    </taPMTransactionTaxInsert_Items>
    <taPMDistribution_Items>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>V0000560</VCHRNMBR>
        <VENDORID>GHDIN</VENDORID>
        <DISTTYPE>6</DISTTYPE>
        <DistRef>test interface modification</DistRef>
        <ACTNUMST>000-2111-00</ACTNUMST>
        <DEBITAMT>12.22</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>V0000560</VCHRNMBR>
        <VENDORID>GHDIN</VENDORID>
        <DISTTYPE>10</DISTTYPE>
        <DistRef>test interface modification</DistRef>
        <ACTNUMST>000-2111-00</ACTNUMST>
        <DEBITAMT>1</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>V0000560</VCHRNMBR>
        <VENDORID>GHDIN</VENDORID>
        <DISTTYPE>2</DISTTYPE>
        <DistRef>test interface modification</DistRef>
        <ACTNUMST>000-2100-00</ACTNUMST>
        <CRDTAMNT>13.22</CRDTAMNT>
      </taPMDistribution>
    </taPMDistribution_Items>
    <taAnalyticsDistribution_Items xsi:nil=\"true\" />
    <taPMTransactionInsert>
      <BACHNUMB>MXAP0906-13</BACHNUMB>
      <VCHNUMWK>V0000560</VCHNUMWK>
      <VENDORID>GHDIN</VENDORID>
      <DOCNUMBR>11</DOCNUMBR>
      <DOCTYPE>1</DOCTYPE>
      <DOCAMNT>13.22</DOCAMNT>
      <DOCDATE>2010-09-06</DOCDATE>
      <TAXSCHID>AP</TAXSCHID>
      <PRCHAMNT>12.22</PRCHAMNT>
      <CHRGAMNT>13.22</CHRGAMNT>
      <TRXDSCRN>IN10601: test interface modification</TRXDSCRN>
      <TAXAMNT>1</TAXAMNT>
      <TEN99AMNT>12.22</TEN99AMNT>
      <MDFUSRID>MAXADMIN</MDFUSRID>
      <CREATEDIST>0</CREATEDIST>
    </taPMTransactionInsert>
    <taMdaUpdate_Items xsi:nil=\"true\" />
  </PMTransactionType>
</eConnect>