Finding PostingAccounts in Tables

?Hello Folks,
Under Tools>Setup>Posting>Posting Accounts. where there is a list of all the 
accounts to post the transactions, which I am trying to find in the Tables 
as well. I

I can spot a Table under Company SY01100 but that displays the data in a 
different way,

Also when I copied this table from A to B ; In A it has all the account #s 
but in B it is all Blank.
Should I be looking somewhere else?

please help
Regards,
 

0
viol
9/20/2010 2:13:23 PM
greatplains 29623 articles. 6 followers. Follow

4 Replies
793 Views

Similar Articles

[PageSpeed] 0

Hi Viol-8-r,

If you are looking for the GL Master files then you are looking in the wrong 
place. The Master files themselves are in GL00101 and the index file is 
gl00105.

The ytd transaction open table is GL20000 and the history table is GL30000. 

Kind regards,

Leslie

"viol-8-r" wrote:

> ?Hello Folks,
> Under Tools>Setup>Posting>Posting Accounts. where there is a list of all the 
> accounts to post the transactions, which I am trying to find in the Tables 
> as well. I
> 
> I can spot a Table under Company SY01100 but that displays the data in a 
> different way,
> 
> Also when I copied this table from A to B ; In A it has all the account #s 
> but in B it is all Blank.
> Should I be looking somewhere else?
> 
> please help
> Regards,
>  
> 
0
Utf
9/21/2010 12:25:03 PM
Are you trying to copy a chart of accounts from one company to the other?

"viol-8-r" wrote:

> ?Hello Folks,
> Under Tools>Setup>Posting>Posting Accounts. where there is a list of all the 
> accounts to post the transactions, which I am trying to find in the Tables 
> as well. I
> 
> I can spot a Table under Company SY01100 but that displays the data in a 
> different way,
> 
> Also when I copied this table from A to B ; In A it has all the account #s 
> but in B it is all Blank.
> Should I be looking somewhere else?
> 
> please help
> Regards,
>  
> 
0
Utf
9/21/2010 12:32:06 PM
Hi Leslie,
Thanks for your reply. No, I am trying to copy the default posting accounts 
setup as you there is one posting setup and then posting accounts , gets 
picked up at the time of posting the transactions like if there an Inventory 
transfer; what posting accounts will get picked up.

The chart of accounts are already there.


"Leslie Vail" <LeslieVail@discussions.microsoft.com> wrote in message 
news:229DC541-FDD2-4D2B-A86C-CC1200FC8165@microsoft.com...
> Are you trying to copy a chart of accounts from one company to the other?
>
> "viol-8-r" wrote:
>
>> ?Hello Folks,
>> Under Tools>Setup>Posting>Posting Accounts. where there is a list of all 
>> the
>> accounts to post the transactions, which I am trying to find in the 
>> Tables
>> as well. I
>>
>> I can spot a Table under Company SY01100 but that displays the data in a
>> different way,
>>
>> Also when I copied this table from A to B ; In A it has all the account 
>> #s
>> but in B it is all Blank.
>> Should I be looking somewhere else?
>>
>> please help
>> Regards,
>>
>> 
0
viol
9/21/2010 1:56:36 PM
Hi Lelie,
Thanks for your reply but as such there is no GL00101 in GP and I did copy 
GL00105 but my posting account Under Tools>Setup>Posting>Posting Accounts is 
still empty in my new company where as,  I do have data in the main company. 
It is not under Financial but under Administration.

"Leslie Vail" <LeslieVail@discussions.microsoft.com> wrote in message 
news:6A323070-68FF-46F0-8A34-513FFB6D5FCD@microsoft.com...
> Hi Viol-8-r,
>
> If you are looking for the GL Master files then you are looking in the 
> wrong
> place. The Master files themselves are in GL00101 and the index file is
> gl00105.
>
> The ytd transaction open table is GL20000 and the history table is 
> GL30000.
>
> Kind regards,
>
> Leslie
>
> "viol-8-r" wrote:
>
>> ?Hello Folks,
>> Under Tools>Setup>Posting>Posting Accounts. where there is a list of all 
>> the
>> accounts to post the transactions, which I am trying to find in the 
>> Tables
>> as well. I
>>
>> I can spot a Table under Company SY01100 but that displays the data in a
>> different way,
>>
>> Also when I copied this table from A to B ; In A it has all the account 
>> #s
>> but in B it is all Blank.
>> Should I be looking somewhere else?
>>
>> please help
>> Regards,
>>
>> 
0
viol
9/21/2010 2:03:22 PM
Reply:

Similar Artilces:

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table?? ...

PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee exactly the same funcitonality that you have on a Excel spread sheet either by converting it to a java applet or something else . Any hel would be much appreciate -- Message posted from http://www.ExcelForum.com ...

Pivot Table question #4
Hi I have spreadsheets that take data via a pivot table from an OLAP cube that is held on a terminal server. The spreadsheets hold figures entered by me and figures obtain from the pivot table. I want to enable the automatic update on the pivot table but the pivot table is sorted by a project number obtained from the OLAP cube. My problem is if a new project is added to the OLAP cube then it is automatically selected from the drop down list. I want to be able to turn this off so that it only selects the project I have previously chosed. For example if I have selected the filter nu...

table and form not calculated in synch
Help says to open a piviot table but I am having trouble making my columns add up to total for each indivudual ID. The totals are being calculated only in th e form view which does not up date the original table and does not transfer to a report. How can I get a feild to calculate specific feilds so that I can run these reports? ...

Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different tables that are created dynamically by a query. The data for these will change but I would like to simply pull the data from these tables to create a report. The tables have the following information: 1. Company Info (name, address) 2. Customer Info (address, name, etc) 3. Customer Order (products, price, other info) 4. Invoice Info (ID, GST #, etc) I realize I could have created a table with relationships but the data above is dynamic as there are 4 different companies and based upon user inp...

print folder in table style
Hello all, My CU wants to print a list of files in a folder. He use Outlook 2002. Click Other Shortcuts -> My computer -> choose a folder -> Click the print icon on toolbar -> choose Table Style -> print preview The header and footer can be printed properly. However the content is blank. I mean: there is no file in the list. I can print properly at my side. However at the CU side, there are 2000 users encounter the same problem. And there are four kinds of printer. All have this problem. Any suggestion? Thanks! ...

GP Extender Tables Question (GP9)
I have created an Extender window with 3 Fields (let’s just say price 1, price 2, price 3). I can see where it got created in table EXT40100, field User_Defined_Prompts_1 etc and I can also see where the data is stored in EXT00103. What I don’t see is where the prompts from EXT40100 are in its own rows so that you can link them to EXT00103 for reporting purposes. I know I can hard code the flags to their proper values in Crystal or set up my own custom table to do it but I would have thought that Extender will have a table like that. Am I just not seeing it? -- Pieter The prompts ...

Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to include them after refreshing. Is there any way of setting the pivot table to include the entire database regardless of its continuously growing size? Right now, as I add a new row of data I must delete my old Pivot table and create a new one from scratch. Is this normal? You can use a dynamic range that grows/contracts with your data. Debra Dalgleish explains it all at: http://www.contextures.com/xlNames01.html#Dynamic David.c.h wrote: > > As I add new rows of data to my data base, my pivot table wil...

Macro: Find matching DATA, copy correspondently values into another list
Okey guys - please advise me on this. (There was unfortunately no quick response to my latest problem - and I begun to swim... However - that brought me out on deep VBA-water...again - and now need a life buoy (metaphorical spoken)). The core of my macro problem is to look for all the values in column A (Range A5:A??) in Sheet "BOARD" (not bored!!!) that match values in another list placed in column A in sheet "LIST". When finding the match I will copy correspondent celle.value in column D / sheet "BOARD" into column B in sheet "LIST" - this w...

Turn on Automatic Formula Fill in Table
I turned off the 'automatically fill th column with this formula' option in Excell 2007 but I can't see how to turn it on again. Can anyone point me in teh right direction? TIA Excel 2007 Excel Options > Proofing > AutoCorrect Options > Autoformat As You Type > Fill formulas in tables to create calculated columns ...

How to Find Record if Exists, Add if not?
How to Find Record if Exists, Add if not? I have a form where user will enter the vendor ID, which is a unique ID. They enter it off a long list of information listing many vendors and it's hard to know if the vendorID already exists in the database, until they tab through all the fields and get the duplicate record error. Then they press Esc and do a search on that vendorID to pull up the existing record to update. VendorID format is similar to this A123456789ST (Usees a prefix, Vendor FEIN, State abbrev.) I want to automate this. when they enter the VendorID, I want it to s...

Finding data
Hi all, first post here at these forums :) I have a question/ problem that hopefully someone can answer for me. If anyone has the time, could they have a look at the attachment, i was easier that trying to explain it. But in a nutshell it involve finding data within sheets and totaling them on another sheet. The problem is that in my real world example, I will have 40 sheets and 100 rows of data, so performing it manually is out of th question. cheers, and thanks for your time. Charli +------------------------------------------------------------------- |Filename: help1.zip ...

ADO Find method
I would like to know if there is a way to use the ADO Find method to find one of several values for a single column. See the following example: rstOpenJobProcess.Find "[proc#] = '940' or '941'" I would like to search for proc# '940' or '941'. I want to avoid using a like statement in the criteria (such as [proc#] Like '94*') because I may use '942' for something else in the future that I would not want to search for. Is there a way to use the Find method in this way? Alternatively, is there a clever workaround? Th...

Redefining a table range with a macro
Hello, I need help creating code to redefine a table within a macro. I used the macro recorder to creata a table with the same name but to point to another locations. ActiveWorkbook.Names("Table1").Delete ActiveWorkbook.Names.Add Name:="Table1", RefersToR1C1:= _ "='Sheet1'!R3C28:R12C37" How do I make this dynamic, so the starting point, #of rows and # of columns are defined by variables? Help is much appreciated. Regards, OMER On May 21, 4:57=A0pm, OMER <O...@discussions.microsoft.com> wrote: > Hello, > ...

Checkbox column in a table
Hi Everyone, I am a newbie in MS Access. I want to write a query for altering a table such that the new column added should be of type checkbox (which can be done by the design by going to Lookup tab in the design form). So when I open up the table that particular column should be like all filled with checkboxes. (By Default it will be Textboxes). And also how to give a default value to the checkbox ? Please help me out... ! On Tue, 25 Sep 2007 12:52:20 -0700, Cormalado <Cormalado@discussions.microsoft.com> wrote: >Hi Everyone, > >I am a newbie in MS Access. I want to w...

Adding two fields to a table
I current have the following code which works perfectly now: [CODE]CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me. List12 & """)", dbFailOnError[/CODE] I would however like to add another field's information named (Lnd_Desc) as well in the same row of table (Input). What should my syntax look like for that one. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1 INSERT INTO [Input] ([Loc_Desc], [Other Column]) VALUES (""" & Me.List12 & ...

Advanced find and seeing full path to mail
When doing an advanced find Outlook only show the sub- folder it is in. How do you get it to list the full path. Listing a sub-folder can be very hard if there are folders with the same name. This is with Outlook 2000. ...

Asked before cannot find question or answer anymore "Caracter mess
When I am using Word I have no problem typing this caracter ? (question mark). however if I type this in OOUTLOOK, than it appears like this É or like this _ It has just done it lately, so I must have changed a setting unknowingly. Can someone please help to get the question mark ? back again... thank you. By the way this time I have checked the "Notify me of repies" Verify your keyboard language and layout settings in Regional and Language option in Control Panel. For more details see; http://www.msoutlook.info/question/16 -- Robert Sparnaaij [MVP-Outlook] Coauthor, C...

WHY: duplicated entries in suppliers table after using QSimport
hello after using QSimport to populate the items table, i've noticed that there are a lot of duplicate entries being created in the supplier table. There are 254 only distinct supplier names, but there are 654 suppliers total. When you look at the suppliers which are present more than once, you notice (i am 99% sure) that all of the ones that get duplicated are had to be truncated to 30 characters, the max data length for that field. i checked and they are not being duplicated because they are misspelled or even because of trailing spaces in the supplier name 1) would it be harmfu...

Find a "9" within a range using a function (T/F)
I need to try to cobble together a function nest or whatever I have to do, which will tell me if the number 9 exists anywhere within a range of cells. The 9 could be just one character of a larger number (i.e. 1496), or it could be just a nine. I know that I could use filtering or use the find feature with the dialog box, but I need a formula instead. Also, I just need to know a true or false; I don't need to know where the nine is or any other info. I just need to know if it is there. I'm stumped. Any ideas? Thanks in advance! -- RMC,CPA Hi! Try this: =SUMPRODUCT(--(ISNUMBE...

Pivot Table Calculated Formula If statement
Hi all, In a pivot table I am trying to add this formula: In the insert calculated field-->Formula field i type =IF('FIELD NAME'="STRING TO COMPARE", 1,0) Any Idea why this does not work? The calculated field operates on a sum of the field, and the sum of a text string is zero. The zero result won't equal the "String to compare", so the calculated field will return a zero. Perhaps you could do the calculation in the source data instead, and add that field to the pivot table. Dan McCollick wrote: > Hi all, > In a pivot table I am trying to a...

Data display incomplete after creating Pivot Table
I have created pivot table from spreedsheet. One of the fields "additional comments" doesn't display fully in the pivot report. I have tried increasing column widths and row widths. I have also tried using Alt+enter as suggested in some of other discussion forum. Nothing is working so far. Any help appreciated. Thank you! Hi komal. I have just put up a file for you at:- http://www.pierrefondes.com/ It is item number 36 towards the top of my home page. It works OK for me. Check out the file. I hope that it helps in some way. If my comments have h...

Creation of New Database and Exporting Tables from an existing Dat
I am splitting 10 existing tables statewise. Each such split table will have a distinct name. Eg: In case of Family table, it will have the name of the Tables as, Family Karnataka, FamilyAndhrapradesh etc. I have opened 25 new / different Databases with the respective names of the states - such as Karnataka, Andhra Pradesh etc. Now, I want to copy these split tables to the respective databases. Such as FamilyKarnataka to the database of Karnataka and FamilyAndhraPradesh to the database Andhra Pradesh. Please duide me... S Haresha Babu Sr Manager (IT) Syndicate Bank ...

Find User Object based on Logon Name
I need to find the location of the user object in AD based on the Logon Name IE: I have: JDoe123 (the logon name) I need: LDAP://cn=JohnDoe,ou=users,ou=aaa,ou=bbb,ou=ccc,DC=xxx thanks! By the way - a clarification: i dont know what ou the object is in, so i can not assume it lives in ou=users,ou=aaa,ou=bbb,ou=ccc,DC=xxx "pk" <pk@discussions.microsoft.com> wrote in message news:1F6CD335-545E-48DE-80DB-0E2E351AA177@microsoft.com... >I need to find the location of the user object in AD based on the Logon >Name > > IE: > I have: > ...