DynDeveloper.com - Your Dynamics GP Questions, Answered

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

Your first Web Client VSTools mod

This article details your first web client mod.

Our lot in life is not 'detailed program specifications', we do 'RAD'. Rapid development.

So, in as few words as possible:

Defaulting the Checkbook in the Payables Batch Entry form

When opening the payables batch entry form, we'd like to default to Checkbook in the Payables Batch entry form. The attached VBA code will do the trick

Need an alert when a customer is created in GP with no Salesperson ID

Hi everyone,

I need to create a trigger (or a SQL alert) to notify me when a new customer is added to RM00101 without a Salesperson ID [SLPRSNID].

Is there anyone out there who can help me?

Much appreciated

Paul Chacko

GP 2016 & Microsoft Office 2010 Compatibility Issues

I am trying to upgrade our system from Microsoft 2015 to Microsoft GP 2016. I noted that Microsoft GP 2016 no longer support the Microsoft Office 2010. I am concern because I just implemented an Excel Refreshable reports that uses Office 2010. Companywide, we have no plan to upgrade to office 2016 anytime soon. Do you have any article or reference that address these kind of issues. Please help.

Thank you.

Art

PM tables Smartlist Account number

I need information from PM Apply to History and PM Paid Transaction History. I also want to get the account number in there that the transactions are posted to. There is a TRXSource field in the PM Paid Transaction History table that looks like the only possible conduit to the account number. Is there another table(s) to link to in order to get the account number?

I know it can be done from the PM Distribution History, I want the other 2 tables.

REPORTING SERVICES

Hola, tengo un reporte en reporting services y cuando se genera en el internet explorer se ve la pagina del explorarador en blanco como si no hubiese nada. Pero al exportarlo a PDF el reporte se exporta completo..

si alguien me puede dar una sugerencia para correrigir esto y que el reporte se vea igual en el explorado?, le estare muy agradecido..

Saludos,

Hello, I have a report in reporting services and when it is generated in Internet Explorer the explorer page is seen blank as if there was nothing. But when exporting to PDF the report is exported complete ..

If someone can give me a suggestion to run this and the report looks the same on the scanned ?, I will be very grateful ..

Problema con numero auto generado en la ventada de editar cheque

Cuando se intenta hacer un nuevo cheque por la ventana de editar cheques (transacciones > compras > editar Cheques) se genera el siguiente error(imagen).

ademas el numero de pago queda sin generar y en griz el campo.

When you try to create a new check through the edit window (transactions> purchases> Edit Checks), the following error is generated (image). In addition the payment number is not generated and the field in grid.

The pmControlNumberValidate stored procedure returned the following results

ade

At least one input variable contains a null value in the taPMDistributionCreate

Error: At least one input variable contains a null value in the taPMDistributionCreate

DGP po processing changed from 1 to 3 POP10600 empty of recent data

We previously matched invoices in DGP and Receipts that originated from Ariett (procurement).

A month back Finance switched the process to shipment/invoice using Ariett so now all the status is poptype 3.

Numerous reports are broken that relied on pop10600 table. When I look in the POP10600 table there is no recent data after April 4th the day we made the change.

I am not able to match PO receipts with Invoice receipts now, it the only option to now roll back to the previous posting proccess?

Thank you

Mark

Disable sales order editing after it's picked

Hi there what will be the correct way in GP to disable order editing after it's in certain status, say, sent to warehouse for picking? Appreciated very much!

How to Void a Payroll Duplicate Check?

Good evening,

I need to void the check 020904 (see below) for employee BEI001 $200.40, the problem is that is a triplicate check and the system showing the following message "There are not checks in this range to void for this checkbook id and year", additional to do a negative check to adjust, you have any other alternative maybe modifying UPR tables? Any suggestion is welcome.

Thanks