DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In

Archives

 
A very common task in SSRS is to add row headers at the top of each page. This article will teach you how to do that. 
This is different than just expanding one hidden section in a report, the client wanted to 'expand' all in the parameters. This article will explain how to achieve that. 

I'll be honest - the main reason I write these articles is because I can't remember the techniques for 5 minutes. If I blog it and put it on the menu I can always find it again. 

The topic du jour is how to refer to a report field in a formula. 

Now, I'm 100% SQL, I do everything in SQL. If it can be done there, that's what I do. 

But in this case there was an odd grouping going on in the report, and I needed to refer to a report cell in a formula. The technique is below

So... I need to move a column in SSRS to a different location. It would be nice to CTRL + X, CTRL + V... but that doesn't work. But... I have a method that's almost as good. Read on 

In an SSRS report that looks at a stored procedure, I changed some fields and when I clicked on the "Refresh Fields" button in the "Dataset Properties" window, it didn't. 

Grrrr.

Here is what fixed it for me.

A client wanted a way to automatically apply a payment to the oldest invoice with a matching amount.

If anyone can point me to documentation on how temp tables work in Dexterity, it would be awesome.

I have added a new field to a table and it works fine on the screen and database. I am trying to add it to a report and i do not see the original table on the report, just some temp tables. How do I add the new field to this temp table? 

Hi there,

There's an item in our GP showing 100 pc allocated  but can't find the actual transaction. i tried inventory reconciliation it didn't find anything. Then I update the quantity in IV00102 but when I do reconciliation the allocated qty is restored to 100 again. Does anyone have a clue what else I can do to fix this? Thank you!

Philip

I am getting an error in a call to taBRBankTransactionDist  7632 Account does not exist for Account Number String.

I have verified that the account does exist, it is active, and appears the same as all the other accounts that do work.  The error seems to be isolated to this single account.  It has the same format as all the other accounts so it isn't being caused by a blank segment.  Any suggestions on what to check?  Thanks!!

Error: Bins for the item have already been assigned for the qty fulfilled on the line

 

the following gives me error 7220 even thought i have nothing in SOP10203.  Any ideas

 

<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items xsi:nil="true" />
<taSopMultiBin_Items>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200590                     </ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<BIN>20-B-02-D      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200840                     </ITEMNMBR>
<LNITMSEQ>32768</LNITMSEQ>
<BIN>20-C-01-A      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200790                     </ITEMNMBR>
<LNITMSEQ>49152</LNITMSEQ>
<BIN>20-C-01-D      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<SOPTYPE>6</SOPTYPE>
<ITEMNMBR>7450200850                     </ITEMNMBR>
<LNITMSEQ>65536</LNITMSEQ>
<BIN>20-C-01-B      </BIN>
<UOFM>UNITE    </UOFM>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
</taSopMultiBin_Items>


<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200590                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>68.84000</UNITPRCE>
<XTNDPRCE>68.84000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-764.1.54.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>16384</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200840                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>61.47000</UNITPRCE>
<XTNDPRCE>61.47000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-758.1.54.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>32768</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200790                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>57.87000</UNITPRCE>
<XTNDPRCE>57.87000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-779.2.51.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>49152</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>6</SOPTYPE>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<LOCNCODE>CDIR       </LOCNCODE>
<ITEMNMBR>7450200850                     </ITEMNMBR>
<AutoAssignBin>0</AutoAssignBin>
<UNITPRCE>61.47000</UNITPRCE>
<XTNDPRCE>61.47000</XTNDPRCE>
<QUANTITY>1.00000</QUANTITY>
<COMMNTID/>
<PRCLEVEL/>
<ITEMDESC>DM-758.2.54.17.130                                                                                   </ITEMDESC>
<LNITMSEQ>65536</LNITMSEQ>
<DOCID>STD            </DOCID>
<SALSTERR/>
<SLPRSNID/>
<ITMTSHID/>
<IVITMTXB>2</IVITMTXB>
<TAXSCHID/>
<PRSTADCD>131            </PRSTADCD>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHONE1/>
<PHONE2/>
<PHONE3/>
<FAXNUMBR/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<FUFILDAT>1/1/1900 12:00:00 AM</FUFILDAT>
<ACTLSHIP>1/1/1900 12:00:00 AM</ACTLSHIP>
<SHIPMTHD>NLICS          </SHIPMTHD>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>UNITE    </UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items xsi:nil="true" />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined xsi:nil="true" />
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>6</SOPTYPE>
<DOCID>STD            </DOCID>
<SOPNUMBE>INV02921093          </SOPNUMBE>
<ORIGNUMB>ORD01168131          </ORIGNUMB>
<ORIGTYPE>2</ORIGTYPE>
<TAXSCHID/>
<FRTSCHID/>
<MSCSCHID/>
<SHIPMTHD>NLICS          </SHIPMTHD>
<LOCNCODE>CDIR       </LOCNCODE>
<DOCDATE>9/3/2019 12:00:00 AM</DOCDATE>
<CUSTNMBR>IRIS01         </CUSTNMBR>
<CUSTNAME>GROUPE VISUEL IRIS                                               </CUSTNAME>
<CSTPONBR>MERCH                </CSTPONBR>
<ShipToName>GROUPE VISUEL IRIS                                               </ShipToName>
<ADDRESS1>466 3ieme RUE                                                </ADDRESS1>
<ADDRESS2/>
<ADDRESS3/>
<CNTCPRSN>IRIS PLACE LE CHAINON                                        </CNTCPRSN>
<FAXNUMBR/>
<CITY>CHIBOUGAMAU                        </CITY>
<STATE>QC                           </STATE>
<ZIPCODE>G8P 2X6    </ZIPCODE>
<COUNTRY>CA                                                           </COUNTRY>
<PHNUMBR1/>
<PHNUMBR2/>
<SUBTOTAL>249.65000</SUBTOTAL>
<DOCAMNT>249.65000</DOCAMNT>
<SALSTERR/>
<SLPRSNID/>
<UPSZONE/>
<USER2ENT>pproulx        </USER2ENT>
<BACHNUMB>PK20190903     </BACHNUMB>
<PRBTADCD>PRINCIPALE     </PRBTADCD>
<PRSTADCD>131            </PRSTADCD>
<ORDRDATE>8/27/2019 12:00:00 AM</ORDRDATE>
<MSTRNUMB>3028362</MSTRNUMB>
<PYMTRMID>CO30 MS              </PYMTRMID>
<DUEDATE>8/27/2019 12:00:00 AM</DUEDATE>
<DISCDATE>1/1/1900 12:00:00 AM</DISCDATE>
<REFRENCE/>
<CURNCYID>CAD            </CURNCYID>
<RATETPID/>
<EXCHDATE>1/1/1900 12:00:00 AM</EXCHDATE>
<DYSTINCR>0</DYSTINCR>
<RTCLCMTD>0</RTCLCMTD>
<TIME1>1/1/1900 12:00:00 AM</TIME1>
<COMMNTID>ARRIVAGE       </COMMNTID>
<GPSFOINTEGRATIONID/>
<INTEGRATIONID/>
<ReqShipDate>8/27/2019 12:00:00 AM</ReqShipDate>
<UpdateExisting>1</UpdateExisting>
<QUOEXPDA>1/1/1900 12:00:00 AM</QUOEXPDA>
<QUOTEDAT>1/1/1900 12:00:00 AM</QUOTEDAT>
<INVODATE>9/3/2019 12:00:00 AM</INVODATE>
<BACKDATE>1/1/1900 12:00:00 AM</BACKDATE>
<RETUDATE>1/1/1900 12:00:00 AM</RETUDATE>
<PRCLEVEL/>
<TAXEXMT1/>
<TAXEXMT2/>
<TXRGNNUM/>
<TRXFREQU>1</TRXFREQU>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>

Hola a Todos,

He creado una Vista, la cual puedo usar desde el sql management studio, conectarla a Excel, pero no la veo para seleccionarla y utilizarla en la creación de un SmarList..

hay necesidad de algún permiso o configuración adicional para poder verla en la lista de vistas del SMARLIST GENERATOR.

 

Hello everyone
I have created a View, which I can use from the sql management studio, connect it to Excel, but I do not see it to select it and use it in the creation of a SmarList..
 
there is a need for some additional permission or configuration to be able to see it in the SMARLIST GENERATOR view list.

Hello GP Experts. I've a feeling many of you have done this already. Basically, I've been trying to post vendor invoice (not sales invoice) into GP programmatically. I understand eConnect or WebService can be used, but I've yet to see a nice guideline with example on how to do that. Note that the invoices can be Purchase Order matched invoice or non-PO (regular AP Invoice without Purchase Order). Any guidance would be great. We're a .NET shop by the way.

 

Thank you,

 

-Danny

 

I'm trying to generate XML to add a Cash Receipt.  The following XML does not cause an error, but it fails to add a cash receipt.  What am I missing? Can someone help me with the formatting?  Or maybe I'm missing some tags or something?

<eConnect>
<eConnectProcessInfo>
<ConnectionString>Data Source=192.168.33.4;Integrated Security=SSPI;Initial Catalog=WCG</ConnectionString>
</eConnectProcessInfo>
<taRMCashReceiptInsert>
<CUSTNMBR>SMSAR7044</CUSTNMBR>
<DOCNUMBR>PYMNTtest</DOCNUMBR>
<DOCDATE>09-19-2019</DOCDATE>
<ORTRXAMT>1800</ORTRXAMT>
<GLPOSTDT>09-19-2019</GLPOSTDT>
<BACHNUMB>TestCash</BACHNUMB>
<CSHRCTYP>0</CSHRCTYP>
</taRMCashReceiptInsert>
</eConnect>


  In the company we use several warehouses (locncode), and lots, however the use of lots is essential for the use of a single warehouse that acts as the main warehouse, from which transfers are made to the other warehouses. In these warehouses the use of lots is not required. There is some process or query sql through which I can unify for these warehouses all their products in a single lot.

Error: Accrue Sick Time value (ATACRSTM = 0) you have to have Sick Time Accrual Method (STMACMTH = 0)

It has been a few months since we have seen sales order that duplicate already existing master numbers. But in the recent month, we have been getting bombarded with duplicate master numbers. I have a job running, that notifies me the moment a duplicate has been created, but there is no clear fix for this. Has anyone found a way to nip this error? If you have any sql advice, that would be great as well.

Error: A unique document number could not be found. Please check setup.

I am trying to figure out how to register a database trigger from Visual Studio (C#) using VS Tools.  There is some code I want to run when a hold is removed from an SOP document.  I have registered what I thought was the trigger but it doesn't execute my code when the table is updated and the hold is removed.

Any advice or direction towards some decent documentation on this process would be greatly appreciated.

Thanks!

Lonnie

I've been able to generate XML to create an invoice (receivables), but I can't seem to find any info on posting those trxns.  Anyone know how to do it?
I saw there already was a question on removing a master lock on a PO in GP, but those scripts did not work - the PO still has the lock on it.  I'm wondering what else I can do?   GP2016