|
|
1. Item Stock in other Sites
Item stock in other available sites if the sales order for a particular item and site does not have ..
Answers: 1
|
2. Stock Movement
Stock Movement Query Which includes(Date if Item Purchased, Qty on hand based on the between dates g..
|
3. Outstanding Invoices / Amounts
I am trying to find a script to give me a listing of all outstanding invoices. I could probably figu..
Answers: 2
|
4. How to get and update a manufacturing order
Manufacturing Orders are not accessible via eConnect, but I want to display Manufacturing Orders by ..
Answers: 1
|
5. Aged Trial Balance Report
What tables are used to pull the data for Aged Trial balance report of recivable..
Answers: 1
|
6. Get information from the DYNAMICS database
How can I bring data from the DYNAMICS database into, say, a query from the TWO database? My primar..
Answers: 1
|
7. Extract Distribution for each SOP10200/30300 line
I'm trying to show how each line of an invoice (SOP) contributes to the total distribution for that ..
Answers: 2
|
8. Create scheduled script to update standard/current cost of kit inventory records
Great site! You are really helping to promote better use of Dynamics GP.
This request is for use..
Answers: 2
|
9. Set up chart of accounts
I just installed GP 10 and would like to run a SQL script to set up the chart of accounts. I have o..
Answers: 2
|
10. List of Error Messages?
We keep on getting a MD-GP error, "An error occurred with this document. 17" We have no idea what it..
Answers: 1
|
11. How to get list of unposted transactions in Payables
I processed the Remove Transaction History function in Payables for one Vendor. When I try to delet..
|
12. Changing Vendor ID's with SQL command
Is there a list of Tables that contain the Vendor ID? I need to change some Vendor ID's with a SQL ..
Answers: 1
|
13. GL Lock up when new client is installed
Just installed a new client on a laptop and, as often happen, the GL has locked up and wont let us p..
|
14. AP Check Stub Information
Is there a way to reprint the Check Stub information of an AP check including any credits that might..
|
15. Generate a customer ID for GP
Which stored procedure can be used to create a unique GP customer ID? If there is not one, is there ..
|
16. Pay Sale Order
When a customer pay sale order where is save this information (what tables)..
|
17. Inventory Usage
I need a script that shows the last usage date for an all Inventory items. I need to pull the last d..
Answers: 1
|
18. Picking Tickets
I am attempting to improve a process in our company. Currently we have hardware that reports to a p..
Answers: 1
|
19. purchase receipts
Dear all,
I need queries related Purchase receipts.
i want purchase receipts happend so far, with ..
Answers: 1
|
20. Get All Positions (Titles) in specific department
I want a script that gets all titles by department ID.
There is a table for Positions and one for d..
Answers: 3
|
21. NEED COLUMN OF INVENTORY DETAILS TO ROW(IV00102)
My problem is Inventory Table(IV00102).there is available qtyonhnd correspond itemnmbr in column wis..
|
22. GL Transactions (unposted & posted)
Need a SQL query to fetch all GL transactions (unposted & posted) from one GP database (one company)..
|
23. Pull GL Coding and all invoices Paid
I would like to run a script that will pull of invoice paid in a given time and bring the Check #, I..
|
24. All Posting Batches information
I am using GP10 all batches display in one screen so we can approval from there.
Now i need informa..
Answers: 587
|
25. GL sub select statement
I am looking for a script that will give me the following:
From the GL transactions, I am looking f..
|
26. No of short items
How to get the number of short items(raw materials)..
|
27. Latest Delivery Date of Short Items(Raw materials)
Latest Delivery Date of Short Items(Raw materials)..
|
28. Integration with preactor
Do any one have scripts to Integrate with preactor..
|
29. Quantity on Hand
I need help to find the quantity on hand for an item number..
Answers: 1
|
30. Payment Apply
I have a million bucks that I want to apply to 2000 different payment vouchers, Please assist me wit..
|
31. How to update Item Class Accounts
I have list of all item classes (approx 100 classes) and their respective accounts. How can I update..
Answers: 2
|
32. Export of Invoices / Credit Notes (Sales Transactions)
Looking to create an export of the invoice data, both header and item data, of a batch of invoices c..
|
33. Inventory Quantity sold previous year compared to current year
I would like to quickly compare each sales item in the database total sales from previous year to cu..
|
34. merge customer records
I have some customers that were imported from an external source improperly. Unfortunately I don't h..
|
35. Resources vs. Project Entered Time Against
I have a request to find out the top 10 of our project accounting resources who have entered time ag..
|
36. Customer Sales and Receipts for a week
Displays Customer Sales and Receipts Analysis for weekly,monthly and yearly..
|
37. Customer Sales and Receipts Analysis group by customer class
Display Customer Sales and Receipts - Weekly ,Monhly and Yearly group by customer class...
|
38. GENERAL LEDGER ACCOUNTS
where we assigned the General Ledger Account for inventory module.please give brief description abou..
|
39. GL brief explanation
can any one share with me the notes of GL logic and concepts..
|
40. Apply sales Documents
Why we go for Apply Sales Documents under Sales Transaction...
|
41. Get List of Companies a User has Access to
A SQL command that I can fill a dataset with that will be a list of all companies (all basic informa..
|
42. Delete batch after invoices printed
Using GP v 7, have batches that the invoice has been printed. Then notified that batch was incomple..
|
43. Run Reconcile from SQL
Running reconcile from Windows schedule often fails. I'd like to have a script to run the process f..
|
44. Assigning specific Paycodes to all Employees in Payroll Module
I want to add/assign specific type of Paycodes to all or some employees in Microsoft Dynamics GP, Pa..
|
45. GP Dashboard
Hello All,
I would like to create a summary page for GP in asp.net. Kind of GP dashboard.
Cou..
|
46. Customer Brought Forward Balance and payment details
Query for getting for a Customer for a Date Range :-
Brought Forward Balance
Total Debits
Total ..
|