What is Dex_row_id?
The DEX_ROW_ID is also used for Dexterity’s Optimistic Concurrency Control (OCC), which is how two users can update the same record of data at the same time as long as they don’t change the same field. This takes the original page locking or current row level locking and provides the equivalent of field level lock.
How do you open a closed period in the Great Plains?
Reopen the closed period. To do this, use the appropriate method: In Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 2010, click Microsoft Dynamics GP, point to Tools, point to Setup, point to Company, and then click Fiscal Periods.
What is Dex row ID?
From a pure SQL Server perspective, the DEX_ROW_ID is an INT type column with the IDENTITY property assigned to it.
Do both the general journal and general ledger have reference columns?
A reference column to identify where information can be traced back to appears: in both the general ledger and general journal. To post information from the general journal would be to: update individual account balances in the general ledger.
How do you close a period in dynamics?
Before you can use the Financial period close workspace, you must configure the process using the Financial period close configuration page. (Click General ledger > Period close > Financial period close configuration.)
What is a quick journal entry in Great Plains?
Quick Journals are used to enter transactions that are entered on a regular basis. What makes them “quick” is that once setup, only the amounts needs to be entered on new entries. You can create a template of typical transactions in the Quick Journal Setup window.
How can I post my journal in GP?
As shown in the video, the steps are as follows:
- Open the Quick Journal Entry window.
- Enter a unique Journal ID number.
- The Quick Journal Setup will open.
- Enter the Description, Source Document, Reference, and Offset Account number for this Journal ID.
- Click the “Save” button.
- Close the Quick Journal Setup window.
What is the difference between a general ledger and a general journal?
Key Takeaways. The journal consists of raw accounting entries that record business transactions, in sequential order by date. The general ledger is more formalized and tracks five key accounting items: assets, liabilities, owner’s capital, revenues, and expenses.
What is the difference between chart of accounts and general ledger?
The chart of accounts in accounting is a list of account numbers and names. The general ledger is a summary of all transactions per ledger account, which includes details of the dates, description and amount of these.
Does Great Plains create general journal entries in GL 10000?
However, it does not appear that great plains creates entries in the GL 10000 table like it does if you just create a standard General Journal entry. How does Great Plains handle the General Journal Entries that are reoccurring?
How to get account number from gl10110 data table?
What you want to do is link to the GL00100 or GL00105 table on the ACTINDX in GL10110. That will get you the account number or name or whatever other info you need. what data table contains every single transaction regardless of type?
Where is the distribution reference in the gl10001 table?
The distribution reference is in the GL10001 table for unposted transactions. The field is called DSCRIPTN. Is there a table that shows the user ID of the person who created a G/L account?
What is the difference between gl10110 and gl10000?
GL10110 is a summary table that only includes posted transactions. Unposted GL transactions will be in tables GL10000 (header) and GL10001 (detail). You can use my All GL Transactions view and filter for ‘Work’ transactions to see these. Great site!