Anything marked with a λ requires access to either CustomerSource or PartnerSource.
Dynamics GP 2013 Implementation
Dynamics GP 2010 Implementation
Using credit cards to pay vendors in Dynamics GP
SQL view for Payables GL distributions in Dynamics GP
SQL view for all posted GL transactions in Dynamics GP
Year end close in Dynamics GP
Sales Transaction Entry GL distributions in Dynamics GP
SQL view to show AP apply information in GP
SQL view for Payables payment apply detail in GP
Granting access to a new SmartList in Dynamics GP
SQL view with all SOP line items in Dynamics GP
SQL view for unposted checks in Dynamics GP
SQL view for rolling 12 months of sales by item by site in Dynamics GP
Dynamics GP sales amounts and quantities for rolling 12 months
Updating Dynamics GP data directly in SQL
Did you know you can change Void dates on Payables transactions?
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP
SQL code to show top X percent of vendor data
Discount from Packt Publishing
Refreshable Excel report for historical GL trial balance in Dynamics GP
Refreshable Excel report for monthly GL budget in Dynamics GP
Victoria Yudin: Hi Cory,
I am not aware of a script to accomplish...
Cory Wolin: We have about 6000 assets we need to delete before...
Victoria Yudin: Hi Kimberly,
Try adding them to the SELECT list a...
Kimberly Watson: Hi Victoria!
This is amazing! thank you!!! Is the...
Victoria Yudin: Magid,
One way to do this would be to first creat...
Majid: The query i have only shows those periods in which...
Victoria Yudin: Hi Magid,
Sorry, I am not quite clear on what you...
A Simple Way to Track Changes to Master Records in GP – DYNAMICS ZR: […] The third solution I’ll present is usi...
Majid: Hi Victoria,
i have this query which i made appar...
parnola99: Hi Victoria, we are on Dynamics 2018 and I'm tryin...
Recent Blog Comments