04/25/2024
Headlines

Dynamics GP

Get Installed Features from Dynamics DB Query

Vincent Stefanetti01 mins

— List of Company IDs select CMPANYID, INTERID, CMPNYNAM from DYNAMICS..SY01500 — List of Product Versions for Company specified by Database select U.*, C.INTERID, C.CMPNYNAM from DYNAMICS..DU000020 U join Dynamics..SY01500 C on C.CMPANYID = U.companyID where C.INTERID = ‘TWO’ — Enter desired Company DB name order by U.PRODID — List of Product Versions for System…

Read More

Exact MAX Support – Dynamics GP Data Mart Currency Errors – MR CU13

Vincent Stefanetti01 mins

 Exact MAX Support Dynamics GP Data Mart Currency Errors and Data Mart The official Knowledgebase article from MicroSoft is here: mbs2.microsoft.com/…/KBDisplay.aspx To install the Data Mart in Management Reporter you need to assign both a functional currency and an ISO code to each of your companies in Dynamics GP. Here are the steps: A Functional Currency…

Read More