[Beat Bucher]

Up

0

Down

::

Hi Howard,

I guess you’ve already tried the “in-private” mode of your Browser? if not, give it a try.. Remember that Chrome & Edge are both chromium-based browser and pretty much share the same engine under the hood..

Why not try to use FireFox to see if you get the same error? if you run into the same issue, you can assume that something in your Windows system is preventing those video links to get properly displayed… it can be anything from a faulty DivX library to some obscure graphic card library (yes, Graphic drivers can cause this kind of errors).

[Beat Bucher]

Up

0

Down

::

Hi Samantha,

How do you process the SOP transaction e-mailing? are you sending them as a whole batch or individually from the SOP Entry form by using the print dialog form ?

I assume that you’re using Word Templates to e-mail out your invoices? or are there any other 3rd-party tools involved (like Adobe Acrobat or similar GP add-ons for e-mailing) ?

This kind of error messages are tough to debug, but not impossible. Have you tried to read thru this document / Article from Microsoft ? Dynamics GP Email Troubleshooting Guide – Dynamics GP | Microsoft Learn

Beat

learn.microsoft.com

Content Issue

Content Issue

[Beat Bucher]

Up

0

Down

::

Hi @drewrosen ,

Not sure if you got that ever sorted out or resolved.. but it was my recalling that Azure does not allow for e-mailing out of SQL or SSRS.. that’s an imposed limitation by Microsoft on the non-Enterprise subscriptions of Azure.. They want you to pay for something that was natively built-in to SQL server..

Beat (aka GP Geek)

[Beat Bucher]

Up

0

Down

::

Hi @tracyyaklyvich

I believe Microsoft released a Hotfix in January 2023 about some issues related to Workflows in GP. This is build 18.5.1635 and you may want to look if you could apply it in a TEST environment and see if it resolves your problem.

https://learn.microsoft.com/en-us/dynamics/s-e/gp/mdgp2018_patchreleases_377

[Beat Bucher]

Up

0

Down

::

Hi Eddie,

To complement on what Kerry replied.. Unless you’re a Microsoft Partner and have a NFR license of GP as part of your partnership, there is unlikely a way you could have purchased your GP without going thru a reselling VAR / Partner.

Microsoft has your registered partner on file and you just have to ask them which one it is.. It happens sometime in companies that the person that was responsible for the management of GP licenses/maintenance contrat has left and didn’t provide the next person all the information, leaving them in the dark as to what their support includes.

Customers can change partners any time if not happy with the provided service by their current VAR. The new VAR would have to get some papers signed by the customer to officialize the transfer to the new partner. Even with a registered VAR, you’re not obligated to use them to perform your upgrade. You can go with any independent consultant you feel confortable with.

Request several quotes for your update..

HTH,

Beat

[Beat Bucher]

Up

0

Down

::

See if that one works..

PA-PM_SQL_View.txt 3 KB Text File - Click to view

• Copy Download Link

SELECT PH.[Customer Number] ,CUS.[Customer Name] ,PH.[Contract Number] ,PH.[Contract ID] ,PH.[Project ID] ,PH.[Project Name] ,PH.[Project Number] ,PH.[Project Class ID] ,PH.[Project Type] ,PH.[Accounting Method] ,PH.[Status] ,PH.[Department] ,PH.[Estimator ID] ,PH.[Project Manager ID] ,PH.[Business Manager ID] ,PH.[Location ID] ,PH.[Salesperson ID] ,'Purchasing' AS 'Transaction Type' ,ATR.[Journal Entry] ,RCT.[PAVIDN] 'Transaction Number' ,RCT.[ITEMNMBR] 'Master Record' ,POP.VENDNAME 'Master Record Detail' ,POP.REFRENCE 'Reference' ,POP.VNDDOCNM AS 'Vendor Doc Number' ,'� AS 'Submodule Reference' ,POL.PONUMBER AS 'PO Number' ,CASE POP.POPTYPE WHEN 1 THEN 'Shipment' WHEN 2 THEN 'Invoice' WHEN 3 THEN 'Shipment / Invoice' WHEN 4 THEN 'Return' WHEN 5 THEN 'Return w / Credit' WHEN 6 THEN 'IV Return' WHEN 7 THEN 'IV RETURN w / Credit' WHEN 8 THEN 'In - Transit Inventory' END AS 'Receipt Type' ,APP.APFRDCNM 'Receipt Paid WITH CHECK Number' ,APP.DOCDATE AS 'Check Paid Date' ,POP.[GLPOSTDT] ' TRANSACTION Date' ,RCT.[PACOSTCATID] 'Cost Category' ,AC.[Account Number] AS 'COGS Account' ,AC.[Account Description] AS 'COGS ACCT Desc' ,CASE WHEN POP.POPTYPE IN ( 5 ,4 ,6 ,7 ) THEN RCT.[PABase_Qty] * - 1 ELSE RCT.[PABase_Qty] END AS 'Quantity' ,RCT.[UOMSCHDL] AS 'U OF M' ,CASE WHEN POP.POPTYPE IN ( 5 ,4 ,6 ,7 ) THEN RCT.[PABase_Unit_Cost] * - 1 ELSE RCT.[PABase_Unit_Cost] END 'UNITCOST' ,RCT.[PATOTALOVERH] 'Total Overhead' ,CASE WHEN POP.POPTYPE IN ( 5 ,4 ,6 ,7 ) THEN RCT.[PAShipmentExtCost] * - 1 ELSE RCT.[PAShipmentExtCost] END AS 'Extended Cost' ,CASE WHEN POP.POPTYPE IN ( 5 ,4 ,6 ,7 ) THEN RCT.[PAShipmentExtCost] * - 1 ELSE RCT.[PAShipmentExtCost] END 'Total Cost' ,CASE WHEN POP.POPTYPE IN ( 5 ,4 ,6 ,7 ) THEN POP.[SUBTOTAL] * - 1 ELSE POP.[SUBTOTAL] END AS 'Total OF Invoice' ,RCT.[PAORIGBILLRATE] 'Billing Rate Per Unit' ,RCT.[PAORIACCRREV] 'Recognized Revenue' ,RCT.[PABilled_QtyN] 'Billed Quanitity' ,RCT.[PA_Billed_Profit_Amount_] 'Billed Profit' ,RCT.[PABilled_Amount] 'Total Billed' ,RCT.[PABilledProfitPercentage] AS 'Billed Frieght' ,RCT.[PABilled_Discount] 'Billing Discount' ,RCT.[PABilling_StatusN] 'Billing Status' FROM [PAProjects] PH LEFT JOIN [Customers] CUS ON PH.[Customer Number] = CUS.[Customer Number] LEFT JOIN [PA31102] RCT ON PH.[Project Number] = RCT.[PAPROJNUMBER] LEFT JOIN [PA31101] RCH ON RCT.[PAVIDN] = RCH.PAVIDN LEFT JOIN [POP30300] POP ON RCT.PAVIDN = POP.POPRCTNM LEFT JOIN [POP30310] POL ON RCT.PAVIDN = POL.POPRCTNM AND RCT.RCPTLNNM = POL.RCPTLNNM AND RCT.ITEMNMBR = POL.ITEMNMBR LEFT JOIN ( SELECT * FROM PM30300 WHERE APTODCNM IN ( SELECT TOP 1 (APTODCNM) FROM PM30300 GROUP BY APTODCNM ) ) AS APP ON POP.VNDDOCNM = APP.APTODCNM AND POP.VENDORID = APP.VENDORID LEFT JOIN '� [PM30300] APP ON POP.VNDDOCNM = APP.APTODCNM AND POP.VENDORID = APP.VENDORID LEFT JOIN [Accounts] AC ON RCT.PACogs_Idx = AC.[Account Index] LEFT JOIN [AccountTransactions] ATR ON ATR.[Journal Entry] = ( SELECT TOP 1 ATR.[Journal Entry] WHERE RCT.PAVIDN = ATR.[Originating Document Number] AND RCT.PACogs_Idx = ATR.[Account Index] ) WHERE RCT.[PAVIDN] IS NOT NULL AND POP.[GLPOSTDT] IS NOT NULL AND POP.POPRCTNM 'RCT100153'

Expand

[Beat Bucher]

Up

0

Down

::

Christine,

Since you’re quite new to this position (and likely GP), you may not know yet the full extend of the community power and all the shared support..

Have a look at this blog site from a respected GP expert that’s been around the community for 20+ years: Victoria Yudin | Receivables SQL Code

This site is a treasure chest for GP users (and fans), and if you have someone that can help you with creating SQL views in your system, then you’ll be in heaven with her scripts. You can use those scripts both in SmartList Designer or Builder (eOne), or even use them directly in Excel refreshable workbooks.

Good luck!

victoriayudin.com

[Beat Bucher]

Up

0

Down

::

Hey “That CanadianGuy”…

As Jo stated, it’s a very bad idea to change the GP table schema and field definitions.. at every next upgrade you run the risk to scrap your customizations as the table might get recreated in the process of upgrading.

Another alternative to use the eOne Extender product is GP PowerTools and the developer module.. With modifier you can add new fields into existing forms and populate the data with a code logic in GPPT. I agree that it requires more programing skills than using Extender, which is also easier to query data from later on.

[Beat Bucher]

Up

0

Down

::

Pam,

I concur with David, as renewing the SSL cert could well throw the entire Web client into a limbo and would require a re-install of the whole Web Client Server.. I have seen this happen in the past, so wouldn’t be surprised.