DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Archives

 
Styling the RadDropDownList

Short article on styling the Telerik RadDropDownList

 
Telerik ASP.NET RadDropdownList 'top 25' code example

Some drop down lists are just a few items, but some might have potentially thousands of items, and that... too much for a mobile ASP.NET application. 

The code below will retrieve the 'top 25' items
SQL Syntax for Comparing two dates from a single row that would expose different posting periods

In GP we are always looking for subledger transactions that posted in different periods than the GL Journal entry.

Example - I have a complex SQL view that combines sub-ledger cash transactions and the Journal Entry that was created. In theory all cash receipts posted in a certain month should have corresponding Journal Entries in the same month.

I need to compare DepositGLPostingDate to ReceiptGLPostingDate - just for different periods (months). Example below. 

If the dates are different but in same month - I don't want to see them - make sense? 
Question about Transactions in Dynamics GP

Hi everyone,

Thanks for taking the time to read this. I have a couple of questions about Dynamics GP and hope someone with experience can help me out:

  1. How do inventory transactions type 2 (VAR) work?

  2. What happens with variations in the inventory count plan?

If anyone has advice, examples, or resources to share, I’d greatly appreciate it. Any help is welcome.

Thanks in advance!

Cheers,

 

Eric
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Anchored Marriage
3