DynDeveloper.com

 I am attempting to match an invoice against a PO and posted shipment.   It's working fine except for the VarianceAccount.  The UNITCOST does not match the original UNITCOST on the shipment and I have defined a VarianceAccount but the variance is not getting populated in the distributions, so I am left with an unequal credit/debit.

When I do an invoice and change the unit cost through the UI, the Variance Account is populated perfectly.  Whether or not the VarianceAccount is present, doing it through eConnect doesn't seem to work quite right.

Any idea what I might be doing wrong?  My POPEnterMatchInvoiceType is shown below.

<?xml version="1.0" encoding="UTF-8"?>
<eConnect>
  <POPEnterMatchInvoiceType>
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>INV18</POPRCTNM>
        <POPMtchShpRcpt>RCPT15</POPMtchShpRcpt>
        <PONUMBER>PO15</PONUMBER>
        <QTYINVCD>1</QTYINVCD>
        <ITEMNMBR>INSTALLATION</ITEMNMBR>
        <VENDORID>JERRY</VENDORID>
        <UNITCOST>55</UNITCOST>
        <EXTDCOST>55</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>0</AUTOCOST>
        <POLNENUM>1</POLNENUM>
        <VarianceAccount>TEST-ACT2</VarianceAccount>
        <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
        <TAXAMNT>0</TAXAMNT>
        <AutoInvoice>0</AutoInvoice>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>INV18</POPRCTNM>
      <VNDDOCNM>JERRYINVOICE</VNDDOCNM>
      <receiptdate>2010-05-13</receiptdate>
      <BACHNUMB>BATCH</BACHNUMB>
      <VENDORID>JERRY</VENDORID>
      <SUBTOTAL>55</SUBTOTAL>
      <FRTAMNT>100</FRTAMNT>
      <MISCAMNT>0</MISCAMNT>
      <TAXAMNT>0</TAXAMNT>
      <PYMTRMID>Net 45</PYMTRMID>
      <AUTOCOST>0</AUTOCOST>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
      <CREATEDIST>1</CREATEDIST>
    </taPopEnterMatchInvHdr>
  </POPEnterMatchInvoiceType>
</eConnect>
 

Hi All,

I get an error while importing through eConnect for taUpdateCreateItemRcd  the error says "Cannot insert the value NULL into column 'UOFM', table TWO.dbo.IV00107; Column does not allow nulls. Insert Fails"

Following is my XML, can any one let me know am i missing something here.

<?xml version="1.0" encoding="utf-8" ?>

Hello, I'd like to use eConnect to setup tax detail and schedule records.  But I don't see a schema for this in eConnect help file.  I see a UPRCreateLocalTaxType schema with taCreateLocalTax & taCreateLocalTaxDetail but it does not look like they match the fields on the Tax Detail Maintenance screen (tools-setup-company-tax details).  Does anyone know about using eConnect to setup Tax Detail Maintenance records and Tax Schedules that are used in SOP, PM, RM transactoins?  Much appreciated.

G