GL10001 table Issue - GP 9.0

Hi,

This is the 2nd time within 6-7 months period, we experienced that GL10001 
detail file getting truncated. All Header GL10000 records were intact. Do not 
know what causing it. I think its getting cleared while posting the batches. 
I cheked the audit log sy05000 even though it says the General Enry batch 
XXXXXXXX has finished posting but no records were found in GL20000. Is there 
any way to find out what causing it or where to search for possible log of 
any kind. 

Appreciate your help.

Thanks

 
0
Utf
1/21/2010 8:14:07 PM
greatplains 29623 articles. 3 followers. Follow

1 Replies
961 Views

Similar Articles

[PageSpeed] 12

Hi,

This is intermittently occuring, with the GL Header intact and GL20000 does 
not have the same JE, I would recommend:

1.  Conduct an audit of all computers with GP ensuring the correct 
version/build is in place and the same fo all.
2.  Perform a SQL Maintenance (MSDGP>>Maintenance>>SQL) under GP application 
for GL Transaction Work under this company.  DO THIS ONLY WHEN YOU ARE THE 
ONLY USER IN GP AND ASK ALL USERS TO LOGOUT TO BE SAFE.
3.  Run gant.sql script to resfresh SQL permission for DYNGRP user role 
which will roll down down to all GP users.

Let us know how you go!

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

"kk" <kk@discussions.microsoft.com> wrote in message 
news:B68DF7D4-1A6E-4A4E-B57E-85645C58B96C@microsoft.com...
> Hi,
>
> This is the 2nd time within 6-7 months period, we experienced that GL10001
> detail file getting truncated. All Header GL10000 records were intact. Do 
> not
> know what causing it. I think its getting cleared while posting the 
> batches.
> I cheked the audit log sy05000 even though it says the General Enry batch
> XXXXXXXX has finished posting but no records were found in GL20000. Is 
> there
> any way to find out what causing it or where to search for possible log of
> any kind.
>
> Appreciate your help.
>
> Thanks
>
> 

0
Dencio
1/22/2010 12:03:47 AM
Reply:

Similar Artilces:

Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel? Thanks in advance Hi Leungkong, > Can I use VBA to update Access table or Query from Excel? Of course, using ADO or DAO. See: http://www.erlandsendata.no/english/index.php?d=envbadacexportado Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Hi Jan, Thanks. I think ADO is what I want. But I am not only want to export from excel to access. I want to edit some data in access table. For example, Access has a table "ProductList" I want to use Excel to call the product by "Pro...

Displaying Yes/No as Yes or No instead of -1 and 0 01-21-10
Hi, I know that I've done this before, but now I can't remember how I did it... In my form, I want my Yes/No combo box to display Yes or No instead of -1 or 0 after the choice is made. I'm remembering something about column widths, but so far no luck. Thanks for your help! on the Porperty Sheet you can set Format to Yes/No laura.dodge wrote: >Hi, I know that I've done this before, but now I can't remember how I >did it... > >In my form, I want my Yes/No combo box to display Yes or No instead of >-1 or 0 after the choice is made. I'm rem...

Customer deposit possible in POS 1.0?
Hello, I have MS POS 1.0 and am wondering if there is the ability to have a customer pay a deposit on an item that is not in stock. For instance, they order an expensive widget and we'd like to take a 50% deposit (or all their money at that time) before we order it so that we aren't stuck holding something we normally don't stock/sell. Is it better to just charge the full amount at time of sale or can we put in a deposit and charge a certain percentage? I'm using MS POS 1.0 for 1 register. Thanks. ~Allen Allen, MSPOS doesn't have support for taking deposits on tran...

MS skips to CRM v3.0
Announcement has been made that the next version of MSCRM will be dubbed CRM v3.0. http://www.eweek.com/article2/0,1895,1833971,00.asp Matt Parks MVP - Microsoft CRM For those of you who attended TechEd2005 this year, there were a number of very good sessions on MSCRM, including two session covering v.next. These session were recorded and are available for viewing here: BAP436: Deep Dive into the Next Version of Microsoft Business Solutions CRM Speaker: William Patterson This session dives deep into the next generation of Microsoft CRM. Gain a strong understanding of the changes i...

Multiple tables
Hi, I would like to generate a pivot table from many subtables. For example, there are 12 tables of accounts managment. Each table represents the changes in the acounts in each month. I would like to create a pivot table or subtotals to summerize the data from all the tables in one table. Is it possible? Thanks, Iris. ...

128 row limit for importing tables
I have many Word documents, containing Tables of 5 to 6 hundred rows, which I want to layout in book format in Publisher. I've tried "Insert Text File", copy and paste, converting to other formats (html, excel, xml) - but none have overcome this 128 row limit.... Anyone got any work arounds for this? I'm aware I can split the tables into several tables all less than 128 rows - but that's a time-consuming pain... I was amazed to come across this limitation - both in Pub 2002 and 2003 beta! 128 rows is not a huge table!! (BTW table is only 3 columns wide) any ideas ap...

SELECT DISTINCT (multiple columns/tables)
SELECT tblModules.MonicsID, tblAddresses.BankID, tblModules.PAnalyst FROM tblAddresses INNER JOIN tblModules ON tblAddresses.AddrID = tblModules.AddrID WHERE (((tblModules.PAnalyst) Is Not Null)); I want to select DISTINCT values from MonicsID and BankID. Example values are like these: MonicsID BankID APS BANK1 APS BANK1 APS BANK2 PBM BANK1 PBM BANK1 PBM BANK1 So the "records" I want are: APS BANK1 APS BANK2 PBM BANK1 Does "DISTINCT" work on multiple colmns from multipl...

Endnote/Cite write, as well as database issues
Hello all- Is anyone using Endnote 7 on the mac and Office X? I have found some stability issues, as well as issues connecting to certain databases- e.g. Blackwell does not have a direct filter, you have to go through other steps. I am all ears (actually eyes) to talk with someone about this because I am writing my dissertation and think that the steep learning curve is worth it. Email : sethhalvorson@gmail.com ...

RMS 2.0 sp1 ->sp2
I have HQ and SO running on sp1. Once I upgrade to Sp2 and create and export a new store at the SO side I get no cashier exist at the login screen. I know un and pw are right but I am locked out. I am rolling out 7 stores trying to use master store database for deployement. Anyone have any ideas? did u upgrade the DB as well? "Mark" <Mark @discussions.microsoft.com> wrote in message news:49BC7035-FDC7-457A-ADEF-3FF92FBD78BE@microsoft.com... >I have HQ and SO running on sp1. Once I upgrade to Sp2 and create and >export > a new store at the SO side I get no cashi...

table with multiple fields with lookup to same table
I will relate my issue to the Northwinds sample db. I would like my "orders" table to contain fields for the products in the order (let's say 3 products) that would have a lookup to the products table. Can anyone please tell me how I could do this, or explain what other method to use. =?Utf-8?B?SiBEYXZl?= <J Dave@discussions.microsoft.com> wrote in news:9A4A008E-8FE9-4F4B-BD09-E200657BBA77@microsoft.com: > I will relate my issue to the Northwinds sample db. I would like > my "orders" table to contain fields for the products in the order > (let's...

Pivot table question #3
Thanks for any help. I want to make a pivot table on 2 fields. The y-axis has the "birth year" (ie 1990), and the x-axis has the "years of life" (ie 4). The inner data is the number of people/records/etc alive born at that year, that many years in. I would like the pivot table to sum the number of records (this pivot table is based on a query which has the birth years and years of life) for each year that they are alive. Something like this: x-axis: 0,1,2,3,4,5 y-axis:1988,1990,1991 data(for example): 8,7,6,6,5,5 9,9,9,9,9,6 5,3,3,2,2,1 The data would have a birth y...

Table name as a parameter
Ok, I'm fairly new to MS Access and have 12 tables I need to reference in a query. Each table has the same type of information, just a different month (i.e. each table is a capture of Monthly sales for a set group of items for that month). What I was wanting to do is pass the table name as a parameter the user defines to compare 1 table to another table. I need to be able to compare a table the user defines to another table the user defines. Any suggests is greatly appreciated. The basic problem is your design. You should not have 12 tables, one for each month. You should ha...

Need help with tables
I have a table created where one of my fields in called "Completed" with a Yes/No command option. I would like to know if there is a way that when I check that box, the whole record can be automatically transferred to another table where I can store records that are "completed". Essentially I would have two tables, one with records where the "Completed" check box is not checked and another table where the "completed" box is checked. I'm fairly new to Access so I cannot figure this one out. Any help or suggestions would be very much app...

how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it possible?
how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it possible? "Daniel" <softwareengineer98037@yahoo.com> wrote in message news:%23g11DbDOGHA.2176@TK2MSFTNGP10.phx.gbl... > how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it > possible? No -- the xml declaration is not represented in the XML Infoset. Cheers, Dimitre Novatchev ...

Generating a table of figures and table of tables using 'insert caption'
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Hi, <br><br>I have set up a template in Word 2008 for some scientists to use. They want to insert captions using the 'Insert', 'Caption...' option for tables and figures, rather than using the style sheet 'figure caption' and 'table caption' that I set up so that the captions can be picked up by the cross-reference function. <br><br>Is there a way for my figure caption and table caption styles to be picked up by the cross-reference function? <br><br>Al...

Two Excel tables in MS Query
How can I link two tables in two Excel-files, in MS Query and result view in PivotTable? ---------------------------------------------------------------------- I can link two tables in one Excel-file. ActiveSheet.PivotTableWizard SourceType:=xlExternal, SourceData:=Array( _ "SELECT `TKG_DATA$`.YEAR, `TKG_DATA$`.MONTH, `TKG_DATA$`.DAY, `TKG_DATA$`.TIME, `TKG_DATA$`.`INC/OUT`, `TKG_DATA$`.`C59/170`, `TKG_DATA$`.`C46/158`, `TKG_DATA$`.`C356/137`, `TKG_DATA$`.`C355/358`, `TKG" _ , _ "_DATA$`.`C354/357`, `TKG_DATA$`.`C32/142`, `TKG_DATA$`.`C30/116`, `TKG_D...

Automatically update field in table
Hi I have two fields [First Name] and [Surname] which I would like to automatically be updated into a third field [Mentor]. I need to store these names in both formats as I have this dbase linked to others which use the information in different ways. Can anybody help me? See: Calculated fields at: http://allenbrowne.com/casu-14.html The article explains how to use the AfterUpdate event procedure of the dependent controls to update the target one. However, I don't believe this is a valid scenario for doing this. You might be much better of to create a *query* for others to u...

Printing Tables in Outlook
Can anyone help? When I create a table in an Outlook message and use shading within the table, when I print out the table the shading doesn't print. It does if I use Word and print out the same table, but not through Outlook. Any suggestions? Thanks In article <A4AF7275-4DC2-417A-9343-E0C32F86FECD@microsoft.com>, old_oak66 <oldoak66@discussions.microsoft.com> wrote: > Can anyone help? When I create a table in an Outlook message and use shading > within the table, when I print out the table the shading doesn't print. It > does if I use Word and print o...

Problem with Word table in Excel
Hope someone can help. Here's my problem. I want to easily double the amounts in each row of a column in a Microsoft Word table. I exported the table to Excel, inserted a column (column B) next to the one I wanted to work with, and typed the formula =A1*2. I then copied it to the rest of the cells in the B column. Of course, it worked. All the numbers in the A column were doubled in the corresponding B-column cells. But when I went to copy the doubled B-column numbers into the A column, I got a circular reference error. Problem is that I'm copying the formula, not the actu...

Printed Quote
Curious is anyone has any samples of a printed quote using SRS? What other options for printed quotes are there? Hi, Our Advanced quote and order processing module allows you to quickly and easily create and print quotes in Microsoft CRM. Regards, David Smooha 516 609-5010 http://www.dynamicscrmaddons.com/AdvancedQuotes.asp "dmn8" wrote: > Curious is anyone has any samples of a printed quote using SRS? > > What other options for printed quotes are there? ...

LNESTAT in GL10001
LNESTAT is 5 or 0 for inventory transaction in GL10001. What are the possible value for the column and what do each of the value mean? Thanks ...

how do you insert pictures into tables?
I want to make a table with the first row being the "Header". On the next row, I want to be able to insert a picture in the cell that will automatically format the cell to the size of the picture. Does that make sense? I basically want a placeholder for the picture but I want it INSIDE the table and I can not get it to do that. Thanks so much for your help and suggestions! With your cursor in the cell, fill, fill effects, picture tab. This will put the picture in the cell, Publisher does not automatically format the image to the cell size. You can manually resize the cell....

lookup tables across two workbooks
Hi I have two workbooks to which i wish to do a lookup for. The first wookbook contains totals via subtotals as below A1 0741.702.113 B1 $250.00 C1 EXPENSES A5 0745.753.112 B5 $2510.00 C5 BANK FEES The other workbook contains a vlookup to get the dollar amount from the first workbook and inserts into the second workbook.(column 2) It appears it doesn't work because the first workbook is total made up of subtotals with the other rows being hidden. Do i have to use the vlookup combined with match etc?? or maybe the format is the problem?? Thankyou in advance Darr...

Matrix Add-in for MS POS 2.0
Hello All: We have a women's clothing boutique and we have to enter item #'s. However, it does not seem that MS POS has a Matrix Item type. Is there an add-in I can purchase or work around for this? This is a multi-part message in MIME format. ------=_NextPart_000_0423_01C7CA45.7B650280 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: quoted-printable Luis, None yet. Maybe next year sometime, but don't hold you breath. =20 Move up to the RMS product and there are quite a few including MS' = built-in attempt. --=20 Jeff=20 Check Point So...

Missing record in GL10001 table...
Hi guys!! For example, I has some batch with a lot trx on GL module. If I try to print the Print List of this batch, the details record are missing, and sometimes, when I insert a new trx, show me the error message: duplicate record. If I select the table GL10000, i see the journal header, but if I select the table GL10001, the records are missing. What happen? My Great Plains version is 6.0 (Colombia version) wih SP12. Thanks for all and excuse my poor English ...