DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In

Archives

 

This article contains sample XML for the eConnect PAContractType transaction. The code includes a sample Project, and three budget lines

 

This article contains the VB.NET code to create a PA Contracts, along with a sample Project and Budget lines

The code requires three tables, the SQL to create the tables is below the article. It also requires data access code to access the tables. That code is also at the bottom. 

This article contains a short, working code example for getting a list of vendors from GP using eConnect out

The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

Note that this article is specific to eConnect out

The solution was to edit the app.config file as shown below.

This is a working XML example of sending the POPEnterMatchInvoiceType schema. It includes no tax, but has freight and freight tax.

In order to recreate this you'll need to key a PO, the key a Shipment document against that PO. This Enter/Match will import the vendor invoice for the shipment. 

This is a WORKING XML document that shows how to code the POPEnterMatchInvoice type with a Freight Amount, Freight Tax, and Manual Distributions

This article is a complete working example of a grid that has a detail table in batch editing mode. We show the data population and the BatchEditCommand being used to update the database.

Hello,

I am trying to delete a line item for an existing Purchase Order using eConnect. Skimming through the eConnect XML Node Reference I found that the '<taSopLineDelete>node exists (which seems to handle deleting Sales Order lines)  -  but I can't find an equivalent for a Purchase Order. The node '<taPopPoDelete>' appears to only handle deleting the entire Purchase Order.

I have tried to pass variations of the '<taPoLine>' node to eConnect but it always seems to add/update the line. I'm not certain what combination of properties I would need to pass in order to tell eConnect to remove the line. I have been setting the 'UpdateIfExists' flag to true, perhaps I need to be using Document Exchange instead (set this flag to false)?

I'm sure I could probably remove the record via a direct sql call, but I know that the POP10110 record is referenced from a few other tables and don't want to end up with a mess on my hands.

Any ideas?

I am currently trying to retrieve all active vendors from a particular company using eConnectOut.  I am able to retrieve a majority of the vendors but some of the newly created vendors are not being exported.

 

Here is the code I am currently using to do this.  Any information is greatly appreciated.

01.01.eConnectType myEConnectType = new eConnectType();
02.02.
03.03.// Create a RQeConnectOutType schema object
04.04.RQeConnectOutType myReqType = new RQeConnectOutType();
05.05.
06.06.// Create an eConnectOut XML node object
07.07.eConnectOut myeConnectOut = new eConnectOut();
08.08.
09.09.//SETUP: Vendor Name and ID Retrieval
10.10.myeConnectOut.DOCTYPE = "Vendor";
11.11.myeConnectOut.OUTPUTTYPE = 1;
12.12.myeConnectOut.FORLIST = 1;
13.13.myeConnectOut.ACTION = 1;
14.14.myeConnectOut.WhereClause = "VENDSTTS  = 1";
15.15.
16.16.// Add the eConnectOut XML node object to the RQeConnectOutType schema object
17.17.myReqType.eConnectOut = myeConnectOut;
18.18.
19.19.// Add the RQeConnectOutType schema object to the eConnect document object
20.20.RQeConnectOutType[] myReqOutType = { myReqType };
21.21.myEConnectType.RQeConnectOutType = myReqOutType;
22.

I'm getting the following eConnect error.  Can anyone help me figure out why?  The XML I'm sending is below

ERROR: Error updating EnterMatchInvHdr for PO - NLNPO0002951 - Sql procedure error codes returned: 

Error Number = 4807  Stored Procedure= taPopEnterMatchInvHdr  Error Description = No Freight Tax schedule, but a freight tax value was passed in

Error Number = 4810  Stored Procedure= taPopEnterMatchInvHdr  Error Description = No Misc Tax schedule, but a misc tax value was passed in

 

<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <POPEnterMatchInvoiceType>
    <eConnectProcessInfo xsi:nil="true"/>
    <taRequesterTrxDisabler_Items xsi:nil="true"/>
    <taUpdateCreateItemRcd xsi:nil="true"/>
    <taUpdateCreateVendorRcd xsi:nil="true"/>
    <taCreateVendorAddress_Items xsi:nil="true"/>
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <TAXDTLID>LAWRENCEVILLE</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>484</ACTINDX>
        <ACTNUMST>00-99999-1002-021-00000</ACTNUMST>
        <TAXAMNT>0.27</TAXAMNT>
        <TAXPURCH>75.73</TAXPURCH>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <TAXDTLID>LAWRENCEVILLE</TAXDTLID>
        <TAXTYPE>1</TAXTYPE>
        <ACTINDX>19655</ACTINDX>
        <ACTNUMST>00-90001-3012-065-00000</ACTNUMST>
        <TAXPURCH>75.73</TAXPURCH>
        <FRTTXAMT>0.25</FRTTXAMT>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <TAXDTLID>LAWRENCEVILLE</TAXDTLID>
        <TAXTYPE>2</TAXTYPE>
        <ACTINDX>418</ACTINDX>
        <ACTNUMST>00-90001-3012-010-00000</ACTNUMST>
        <TAXPURCH>75.73</TAXPURCH>
        <MSCTXAMT>0.26</MSCTXAMT>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true"/>
    <taAnalyticsDistribution_Items xsi:nil="true"/>
    <taPopEnterMatchLotInsert_Items xsi:nil="true"/>
    <taPopEnterMatchSerialInsert_Items xsi:nil="true"/>
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <POPMtchShpRcpt>NLNRCT0007083</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>NLNPO0002951</PONUMBER>
        <QTYINVCD>2.00</QTYINVCD>
        <ITEMNMBR>CT2KIT51264BF160B</ITEMNMBR>
        <VENDORID>CDW</VENDORID>
        <VNDITNUM>CT2KIT51264BF160B</VNDITNUM>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>1</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items/>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>NLNRCT0007105</POPRCTNM>
      <VNDDOCNM>test14565</VNDDOCNM>
      <receiptdate>01/03/2018</receiptdate>
      <BACHNUMB>TAP-01/09/2018</BACHNUMB>
      <VENDORID>CDW</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <TAXAMNT>0.27</TAXAMNT>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>LAWRENCEVILLE</TAXSCHID>
      <FRTSCHID>LAWRENCEVILLE</FRTSCHID>
      <MSCSCHID>LAWRENCEVILLE</MSCSCHID>
      <FRTTXAMT>0.25</FRTTXAMT>
      <MSCTXAMT>0.26</MSCTXAMT>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true"/>
  </POPEnterMatchInvoiceType>
</eConnect>

Error: Tax Schedule (TAXSCHID) does not exist in the TX00101 Table

I'm uploading PO data into GP using eConnect.  Part of this upload is header taxes, freight, and misc.  All the data is uploading, but the TYPE is not being set correctly.  They all show TAX.  But if you look at the XML, the TAXTYPE is set correctly for each line. 

TaxType=0=Regular
TaxType=1=Freight
TaxType=2=Misc

I then found out that setting the <FRTAMNT> and <MISCAMNT> will create the types I want, but I need those account string assigned to that FREIGHT line.  That is why I created 3 TAX lines in the XML.

Am I missing something in the Tax Lines?  Or the Header Line? 

<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <POPEnterMatchInvoiceType>
    <eConnectProcessInfo xsi:nil="true"/>
    <taRequesterTrxDisabler_Items xsi:nil="true"/>
    <taUpdateCreateItemRcd xsi:nil="true"/>
    <taUpdateCreateVendorRcd xsi:nil="true"/>
    <taCreateVendorAddress_Items xsi:nil="true"/>
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>32004</ACTINDX>
        <ACTNUMST>00-82034-6060-015-00000</ACTNUMST>
        <TAXAMNT>2.00</TAXAMNT>
        <TAXPURCH>32.50</TAXPURCH>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>1</TAXTYPE>
        <ACTINDX>31553</ACTINDX>
        <ACTNUMST>00-82034-6030-010-00000</ACTNUMST>
        <TAXPURCH>32.50</TAXPURCH>
        <FRTTXAMT>1.00</FRTTXAMT>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>2</TAXTYPE>
        <ACTINDX>31554</ACTINDX>
        <ACTNUMST>00-82034-6030-017-00000</ACTNUMST>
        <TAXPURCH>32.50</TAXPURCH>
        <MSCTXAMT>1.50</MSCTXAMT>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true"/>
    <taAnalyticsDistribution_Items xsi:nil="true"/>
    <taPopEnterMatchLotInsert_Items xsi:nil="true"/>
    <taPopEnterMatchSerialInsert_Items xsi:nil="true"/>
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <POPMtchShpRcpt>NLNRCT0007037</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>NLNPO0002538</PONUMBER>
        <QTYINVCD>2.00</QTYINVCD>
        <ITEMNMBR>88011-99</ITEMNMBR>
        <VENDORID>CDW</VENDORID>
        <VNDITNUM>88011-99</VNDITNUM>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>1</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items/>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>NLNRCT0007120</POPRCTNM>
      <VNDDOCNM>test123cpt1</VNDDOCNM>
      <receiptdate>12/17/2017</receiptdate>
      <BACHNUMB>TAP-01/11/2018</BACHNUMB>
      <VENDORID>CDW</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <FRTAMNT>1.00</FRTAMNT>
      <MISCAMNT>1.50</MISCAMNT>
      <TAXAMNT>2.00</TAXAMNT>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>LAWRENCEVILLE</TAXSCHID>
      <Purchase_Freight_Taxable>1</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>1</Purchase_Misc_Taxable>
      <FRTSCHID>LAWRENCEVILLE</FRTSCHID>
      <MSCSCHID>LAWRENCEVILLE</MSCSCHID>
      <FRTTXAMT>1.00</FRTTXAMT>
      <MSCTXAMT>1.50</MSCTXAMT>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true"/>
  </POPEnterMatchInvoiceType>
</eConnect>

 

 

In this screen shot, I want the FREIGHT Line to contain the Account String from one of those TAX lines.  Same with the MISC Line.

Hi, 

I am trying to do a return sales through econnect. Also I want to inventory transfer to take place in  proper site in respective bin. I have copied my xml structure below. But the inventory transfer takes in in default bin. But I want to take it the bin I want not in the default bin. Also the quantity gets added twice in default bin. Can you please help me?

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SOPTransactionType>
    <taSopLineIvcInsert_Items>
      <taSopLineIvcInsert>
        <SOPTYPE>4</SOPTYPE>
        <CUSTNMBR>AMAZ01</CUSTNMBR>
        <DOCDATE>2018-01-16</DOCDATE>
        <LOCNCODE>SJ_RETURNS</LOCNCODE>
        <ITEMNMBR>IBAT40XRP</ITEMNMBR>
        <UNITPRCE>143.7</UNITPRCE>
        <XTNDPRCE>287.4</XTNDPRCE>
        <QUANTITY>2</QUANTITY>
        <PRCLEVEL>FOBUSA</PRCLEVEL>
        <QTYONHND>2</QTYONHND>
        <DOCID>R</DOCID>
        <SOPNUMBE>RTN00000000018274</SOPNUMBE>
      </taSopLineIvcInsert>
    </taSopLineIvcInsert_Items>
    <taSopMultiBin_Items>
      <taSopMultiBin>
        <SOPTYPE>4</SOPTYPE>
        <ITEMNMBR>IBAT40XRP</ITEMNMBR>
        <BIN>100TRI_RETURNS</BIN>
        <QUANTITY>2</QUANTITY>
        <CreateBin>1</CreateBin>
        <USRDEFND1>Check the bin set to 100 tri</USRDEFND1>
        <SOPNUMBE>RTN00000000018274</SOPNUMBE>
      </taSopMultiBin>
    </taSopMultiBin_Items>
    <taSopHdrIvcInsert>
      <SOPTYPE>4</SOPTYPE>
      <DOCID>R</DOCID>
      <LOCNCODE>SJ_RETURNS</LOCNCODE>
      <DOCDATE>2018-01-16</DOCDATE>
      <TRDISAMT>0</TRDISAMT>
      <CUSTNMBR>AMAZ01</CUSTNMBR>
      <CSTPONBR>PRIYAdfdg</CSTPONBR>
      <SUBTOTAL>287.4</SUBTOTAL>
      <DOCAMNT>287.4</DOCAMNT>
      <BACHNUMB>PRITEST110</BACHNUMB>
      <SOPNUMBE>RTN00000000018274</SOPNUMBE>
    </taSopHdrIvcInsert>
  </SOPTransactionType>
</eConnect>

Thanks

Priya

Hi we are trying to add some product properties (brand name, primary category, size code, etc) to IV00101 table but seems other than the ITEMDESC all other text fields are limitting size to CHAR(11) or CHAR(15). For our particular product (vehicle tires) 11 characters are way less than enough. We are looking to about 31 characters. What shall I do with the properties? Many thanks!
I am trying to let our AP Team know about duplicate documents before an upload into GP-2013 is attempted.  This will save time with our accounting team to capture these duplicates early in the process.

What GP tables will I need to query, for both PO (POP tables?) and NonPO (PM tables?) documents?  And these GP documents may be paid, posted, or not posted. 

A stored procedure is preferred.  But am willing to look at other alternatives.

If you need more info, let me know.

Thanks,

Chris

Hi,

I need some help converting seconds into hours in the SQL query below.

select i.itemid as "TicketID",
i.Status,
i.SubmitDate,
i.ClosedDateTime as "Closed",
i.totaltime as "Effort", --in seconds, needs to be converted to days, minutes, hours
i.Summary,
u.fullname as "Requester",
s.fullname as "Assigned To",
i.ItemOwnerName as "Team",
i.fullincidentrequesttype as "IT Categorization",
i.closetypename as "Resolution Type",
i.divisionname as "Division"

from VCG_IncidentRequest_Grid_View i

inner join VCG_Users u on u.OID=i.requester
inner join vcg_users s on s.OID=i.assignedto

Could someone with SQL skills help please?

Thanks

Paul Chacko

I need to match the fee items to the invoice for each project invoice.   I found the table pa05200 shows each fee item for the project and if the PAAmount_Billed=0 then that fee item has not been billed.    I cannot find a table that will link the document number of the invoice to the fee items on the invoice.   For instance, if a project has 6 fee items, an invoice was produced in November for 3 of the items and then another invoice in December for the remaining 3 items.   What table will show which item appeared on which invoice?

Thanks!

Hi,

I am trying to fulfill an order via econnect which is already allocated. I want to fulfillment date & actual ship date to be different in the  header  of the order. But somehow it  does not change. It is same as fulfillment date. Can you please help. Below is the  xml structure 

 

<?xml version="1.0" encoding="utf-8"?>
    <SOPTransactionType>
        <taSopLineIvcInsert_Items>
            <taSopLineIvcInsert>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>ORD00000094207</SOPNUMBE>
                <CUSTNMBR>SNOWJ01</CUSTNMBR>
                <DOCDATE>2018-01-26</DOCDATE>
                <LOCNCODE>NJ_305VET</LOCNCODE>
                <ITEMNMBR>MELT25EB</ITEMNMBR>
                <UNITPRCE>6.70000</UNITPRCE>
                <XTNDPRCE>6.7000000000</XTNDPRCE>
                <QUANTITY>1.00000</QUANTITY>
                <COMMENT_1>TESTPRIY</COMMENT_1>
                <PRCLEVEL>FOBUSA</PRCLEVEL>
                <ITEMDESC>25-LB Premium Enviro-Blend Ice Melter w/CMA - Resealable Bag</ITEMDESC>
                <ADDRESS1>305 VETERANS BOULEVARD</ADDRESS1>
                <CITY>CARLSTADT</CITY>
                <STATE>NJ</STATE>
                <ZIPCODE>07072</ZIPCODE>
                <COUNTRY>United States of America</COUNTRY>
                <ReqShipDate>Monday, January 1, 1900</ReqShipDate>
                <FUFILDAT>Friday, January 26, 2018</FUFILDAT>
                <ACTLSHIP>Monday, January 1, 1900</ACTLSHIP>
                <UpdateIfExists>1</UpdateIfExists>
                <UOFM>EACH</UOFM>
            </taSopLineIvcInsert>
 
            <taSopLineIvcInsert>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>ORD00000094207</SOPNUMBE>
                <CUSTNMBR>SNOWJ01</CUSTNMBR>
                <DOCDATE>2018-01-26</DOCDATE>
                <LOCNCODE>NJ_305VET</LOCNCODE>
                <ITEMNMBR>SJBLZD</ITEMNMBR>
                <UNITPRCE>8.95000</UNITPRCE>
                <XTNDPRCE>8.9500000000</XTNDPRCE>
                <QUANTITY>1.00000</QUANTITY>
                <COMMENT_1>TESTPRIY</COMMENT_1>
                <PRCLEVEL>FOBUSA</PRCLEVEL>
                <ITEMDESC>SNOW BROOM W/ICE SCRAPER</ITEMDESC>
                <ADDRESS1>305 VETERANS BOULEVARD</ADDRESS1>
                <CITY>CARLSTADT</CITY>
                <STATE>NJ</STATE>
                <ZIPCODE>07072</ZIPCODE>
                <COUNTRY>United States of America</COUNTRY>
                <ReqShipDate>Monday, January 1, 1900</ReqShipDate>
                <FUFILDAT>Friday, January 26, 2018</FUFILDAT>
                <ACTLSHIP>Monday, January 1, 1900</ACTLSHIP>
                <UpdateIfExists>1</UpdateIfExists>
                <UOFM>EACH</UOFM>
            </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
 
        <taSopUserDefined>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>ORD00000094207</SOPNUMBE>
            <USRTAB09>jostr</USRTAB09>
        </taSopUserDefined>
 
        <taSopHdrIvcInsert>
            <SOPTYPE>2</SOPTYPE>
            <DOCID>STD</DOCID>
            <SOPNUMBE>ORD00000094207</SOPNUMBE>
            <TAXSCHID>NJ</TAXSCHID>
            <FRTSCHID>NJ</FRTSCHID>
            <MSCSCHID>NJ</MSCSCHID>
            <SHIPMTHD>PPD_GROUND_RES</SHIPMTHD>
            <TAXAMNT>0.99000</TAXAMNT>
            <DOCDATE>2018-01-26</DOCDATE>
            <TRDISAMT>0.78000</TRDISAMT>
            <CUSTNMBR>SNOWJ01</CUSTNMBR>
            <CUSTNAME>SnowJoe.com - DS PPD</CUSTNAME>
            <CSTPONBR>TESTPRIY</CSTPONBR>
            <ShipToName>SnowJoe.com - (DS PPD)</ShipToName>
            <ADDRESS1>305 VETERANS BOULEVARD</ADDRESS1>
            <CITY>CARLSTADT</CITY>
            <STATE>NJ</STATE>
            <ZIPCODE>07072</ZIPCODE>
            <COUNTRY>United States of America</COUNTRY>
            <SUBTOTAL>15.65000</SUBTOTAL>
            <DOCAMNT>15.86000</DOCAMNT>
            <SLPRSNID>E_SJ</SLPRSNID>
            <USER2ENT>test1</USER2ENT>
            <BACHNUMB>PICKED-DS</BACHNUMB>
            <PRBTADCD>MAIN</PRBTADCD>
            <MSTRNUMB>1189672</MSTRNUMB>
            <PYMTRMID>COD</PYMTRMID>
            <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
            <DYSTINCR>0</DYSTINCR>
            <RTCLCMTD>0</RTCLCMTD>
            <FREIGTBLE>1</FREIGTBLE>
            <MISCTBLE>1</MISCTBLE>
            <UpdateExisting>1</UpdateExisting>
            <PRCLEVEL>CASH01</PRCLEVEL>
        </taSopHdrIvcInsert>
    </SOPTransactionType>
</eConnect>

 

Thanks

Priya

In Tools>Utilities>Inventory>Change Decimal places we get the following message: You can't complete this procedure while  a stock count is being processed. We have not done a stock count in 6 weeks and we have cleared activity table and SY00800. The Stock Count Tables are empty except for the Stock Count History Tables (IV30700 and IV30701) We need to be able to correct a mistake in the quantity decimal places for a special order item. Does anyone have any idea what the issue could be?