GP GL recurring entry problem!

hi, I have created the prepayment batch which will recur 11 times monthly in 
general ledger, this expenditure occurred starting from Aug, been posted on 
Nov..however, after posting it, there is just Aug expenditure bumped up while 
same journal no. showed two entries, which are duplicated and one of that is 
showing the audit trial code, the other one remains original journal no. and 
batch no.; also, the other prepayment batch i created recurring 3 months, it 
did show the aug and sep expenditures, however the oct expenditure can't be 
showed up after post. Linking with this two examples, I can't figure out why 
and how, I understand the prepayment batch will be automatically deleted 
after recurring times, but base on the entry which is showed with audit trial 
code having same journal no. with the original one, does it affect on TB or 
it counted twice in PL??? plz someone can explain this to me...thanks a lot.
0
Utf
12/10/2009 9:01:01 AM
greatplains 29623 articles. 5 followers. Follow

1 Replies
2218 Views

Similar Articles

[PageSpeed] 28

Transactions in a GL recurring batch will all have the same journal entry 
number, it is the nature of the beast. The dates will be fine if you change 
them, it just makes reporting a little fun if you are using journal entry as 
any kind of key.

Kind regards,


Leslie Vail

"Diff" wrote:

> hi, I have created the prepayment batch which will recur 11 times monthly in 
> general ledger, this expenditure occurred starting from Aug, been posted on 
> Nov..however, after posting it, there is just Aug expenditure bumped up while 
> same journal no. showed two entries, which are duplicated and one of that is 
> showing the audit trial code, the other one remains original journal no. and 
> batch no.; also, the other prepayment batch i created recurring 3 months, it 
> did show the aug and sep expenditures, however the oct expenditure can't be 
> showed up after post. Linking with this two examples, I can't figure out why 
> and how, I understand the prepayment batch will be automatically deleted 
> after recurring times, but base on the entry which is showed with audit trial 
> code having same journal no. with the original one, does it affect on TB or 
> it counted twice in PL??? plz someone can explain this to me...thanks a lot.
0
Utf
12/17/2009 9:59:02 AM
Reply:

Similar Artilces:

Going Live with GP
I plan to start using GP Sept 1. We have not transferred any historical transaction from the old accounting system. All of our Vendors, Customers, Inv Items etc. are entered and we have tested all functions of AP AR GL. Does anyone have a checklist of things to do when starting with a new GP accounting system? I understand the basics things such as Enter open invoices in AP and AR Enter open POs Enter begining GL account balances fromt the old accounting system Begining bank balances and so on. I just want to make sure that I'm not overlooking something so a check list from someone ...

Migrating data from GP to GP
Hi, I have a GP7.5 installation when all data is, and a new GP8 installation on a different server. I need to migrate inventory data from the GP7.5 to GP8. I know that i should use the integration manager. But using it means that i should know the data source structure which is GP, and this is very complex because i need to migrate all inventory module, not a few data. PS: i don't what to make an upgrade because other modules are different in the 2 installations. Does anyone have any idea on this issue? Regards, Hanady Have tried just using DTS within SQL Server choosing your 7.5 s...

problem deleting mailbox
I had some trouble with a echange mailbox. So i deleted the mailbox from the user, and created a new one again. All problems are over now, so that worked... but..... When i now go to the exchange system manager, and i go to: Servers->servername->first storage group->mailbox store->mailboxes i get a overview of all users mailboxes sizes etc... But the user from wich i deleted his mailbox and then added it again, now has 2 Mailboxes in this overview!?! is this normal? Why didn't exchange remove the old mailbox completely? it is a pretty large mailbox of about 500Mb, so now, if ...

Worksheet().Range.Calculate Problem
I am having a major problem with these two lines of code in my otherwise great reporting tool: Worksheets("Goals Tracker").Select Worksheets("Goals Tracker").Range("G3:GA712").Calculate These 2 lines freezes up my computer to the point that I can't use any other application on my computer. It takes forever (over an hour, the last time I let it run complete) to calculate one sheet in the workbook. I need to find out if there is another way to get this done faster. Any help will be appreaciated. There's no need to select the worksheet in o...

WDDK driver problem
Hi, I'm developing a WDDM driver, currently I have skeleton user mode and miniport drivers. After installation and rebooting on Win7 I'm getting the following call sequence. DriverEntry DxgkDdiAddDevice DxgkDdiQueryInterface {2564aa4f-dddb-4495-b497-6ad4a84163d7} I2C DxgkDdiQueryInterface {bf4672de-6b4e-4be4-a325-68a91ea49c9} OPM DxgkDdiStartDevice DxgkDdiQueryChildRelations DxgkDdiStopDevice DxgkDdiRemoveDevice DxgkDdiUnload I can't see any debug message that clarify the reason for choosing to use the VGA driver instead of my WDDM driver (I'm enabling VI...

GP concurrent user and SQL 2005 CAL
assuming a 10 con-current licenses being installed on 15 workstation, with 15 users in GP. How many SQL 2005 CAL is needed ? HFlo, Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server. The user CAL model will likely be more cost effective than device CALs if there are multiple devices per user (for example, a user has a laptop and handheld computer accessing SQL Server). Best regards, MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business...

MFC and IP problem
Hello, I have a simple mfc application(exe) and i want to know If it is possible to get back the IP address of a machine which is to connect has my PC by ethernet and to show it in a IP case in my MFC application. Thank you Not very clear what are you talking about. Do you want to know the local IP address? or may be address of different PC in the same LAN? <john.ambou@free.fr> wrote in message news:1144920653.682354.258970@z34g2000cwc.googlegroups.com... > Hello, > > I have a simple mfc application(exe) and i want to know If it is > possible to get back the IP address ...

Problems with network printers
Having some issues with publisher in a networked environment. The user will create a publication from one location, save it, open it in a different location, and print to the printer assigned to the original location. I was told that this was due to embedding. Printers are pushed down from printer scripts assigned through GP. Any help on this issue would be REALLY appreciated.. Thank you.. :) -Eric The user should not simply click the Printer icon. The user should open the print dialog (File, Print) and select the desired printer from the list. If the desired printer is not i...

Contract Administration problem
Hi I am setting up Contract Admin for the first time. However, having done all setups and on entering a new contract via Transactions>Contract Admin>Contract Entry Update and selecting "New" I get the following mesage :- "A valid document number could not be found" I cannot find anything on knowledgebase. Any ideas or suggestions would be gratefully received. Rod Found the following: Please make a backup before deleting any records. This my be caused by a bad record in the SVC00608 (Contract Site Header) table. Execute the following script in SQL against t...

Array problem? List comparison?
Hey, Let me set up what I'm trying to do. I have 3 columns with the following data. A: 10, 20, 30 B: X, Y, Z C: 28, 8, 1 Now, I have a last column, D, which I'm trying to figure out the correct formula for. I want D to return the following: Look at column A, find the smallest number that's greater than the adjacent cell in column C, and then return the adjacent cell in column B. So, in this example, column D should read: D: Z, X, X I can't figure this out. I think it has to do with arrays, but I'm not too sure. If anyone has any insight on how to ...

Questions about GP Client upgrade configuration
I'm getting ready to install a Service pack for GP7.5 and my ultimate goal is to get ready to upgrade to GP8.0. However right now upgrades are very tedious and below is the whole story. All the users/clients are identical! Let me describe what we have done in the past to upgrade and what I want in the future. In the past we sat down at each client machine performed the install. Then we logged in as an administrator (Ethoseries required this I think) so the product can finish loading what it needs. Again we do both steps on every client. In the future what I would like to do is in...

Fabrication and GP
I need to know how to process a transaction in GP. We are a sales - distribution center. We do some light fabrication. We need to find a way in GP to take one part or more parts, do fabrication work with them, then put them back into the system as a new part. For example, we take drum rollers and send them to a local fabricator who drills holes in them, inserts "brushes", then sends them back to us as a brush roller. They charge us for labor and the additional material and we have a new part. Currently, we either treat it as a parts sale / purchase. That part is clean, but a...

Problem with Retail Realm Price Matrix
hey everyone, we have a cash and carry store and we installed RR Customer price matrix(CPM) with RMS. the problem is as soon as we install CPM our transaction screen becomes very slow especially when there are more than 15 items in the transaction which in our case is always. does anybody else had the same problem with this utilitie and how did they solve this problem. thank you in advance I have not used this addon but have you tried contacting Retail Realm to see what they say? Rob "Shoby" <Shoby@discussions.microsoft.com> wrote in message news:B35243EC-6C05...

Payroll GP 10.0
Got this from a client and not sure what they are doing, but never heard of this any help would be great. As I am reviewing the Payroll Deduction Journal from the payroll I just ran yesterday, I have identified 5 employees whose deductions & benefits did not calculate. I happen to be one of the 5. There is $$$$$ that did not come off my pay as deductions; including my 401K. The common denominator seems to be when employee changes are made, deductions & benefits are made inactive; even though those benefits & deductions have no part in the changes being made. Pardon me, ...

Outlook 2000
I am managing an Exchange 2003 Server that hosts several companies and email domains. I have one company/domain where only the Outlook 2000 users are missing OAB entries. All Outlook 2003 users are working correctly. From ESM I have updated and rebuilt RUS, and have also rebuilt the Offline Address List for that domain. None of which has made a difference. Can anyone point me in another direction? Any help is greatly appreciated. Thanks! Kurt Is it possible that you have an OAB version 3a which can be used by Outlook 2003 but not 2000, and not an OAB version 2 which can be used...

GP 9 Upgrade and SQL Server 2000 sp4
per microsoft's documentation sql server sp4 must be installed before upgrading to GP 9. does anyone know if the sql server sp 4 install is necessary for the GP 9 upgrade? microsoft's documentation indicated that all service packs for GP 8 must be installed before upgrading to GP 9, but after speaking with support, they said the GP 8 service packs aren't necessary. bottom line: i'd like to avoid the sql sp4 install if necessary as i had to rebuild my test server after installing sp4 last week. thank you. Since the database requirements for GP 9.0 list SQL 2000 SP 4 a...

problem inserting photo in publisher
when i insert photo from file the photo is blank in publisher Based on Publisher 2000; I'd look at View, Picture display and/or Control Panel Display, Settings, Advanced, Troubleshoot tab, and lower the acceleration setting. -- Don Vancouver USA "jj" <jj@discussions.microsoft.com> wrote in message news:8B473DE7-5794-409E-821B-0B0BD18A8E10@microsoft.com... > when i insert photo from file the photo is blank in publisher How are you inserting the photo? -- JoAnn Paules MVP Microsoft [Publisher] "jj" <jj@discussions.microsoft.com> wrote in ...

Upgrading from GP 9 to GP 10
While trying to upgrade from GP 9 to GP 10, I get an error when selecting the instance of the already installed GP 9: "Index was outside the bounds of the array". Any ideas? ...

Child Window and SetFocus problem.
Hi, I have a Dialog based GUI application. I later on create some child windows(CWnd based) on the surface of my dialog (which look like 3d circles) and allow the user to drag them around. My problem is that when a user click on one of the circles, I do an explicit SetFocus() for that window and then handle all its input etc.... But then if i now leave this window in a selected state and now Alt tab to some other application, and try to come back to my app, it hangs and doesnt paint itself. The same problem can happen if i use the Menu and choose an option which results in another dial...

Balance problems
To start I manually enter all transactions. I'm having troble with balances on the screen everthing is good then when I go to print I get a very different running balance. It started a couple month ago. I even started from scratch and after balancing last months checking account it is doing the same thing. I have been using money for many years and this is the first time I've seriously thought of changing programs In microsoft.public.money, tvan wrote: >To start I manually enter all transactions. I'm having troble with balances >on the screen everthing is good then wh...

MS CRM integration to GP
Hello Can any one update me wheather the mutiple company databases can be integrated to MSCRM. The senario is this. a company has mutiple entities using GP 7.5 and unique sql databases,require to integrate mscrm with gp. The integration that is supplied by MS only allows you to integrate with 1 company DB. You could probably use some of the components that are provided, but you will need to develop some of the integration logic yourself to address this. Matt On Sat, 24 Jan 2004 05:34:31 -0800, "ramki@loayoman.com" <anonymous@discussions.microsoft.com> wrote: >Hello &g...

error in GP
When I try to generate a Historical Aged Trial Balance my computer freezes then gives me this error message. "The stored procedure pmHistoricalAgedTrialBalance returned the following results DBMS:208, GP:0 This is path I use to get to the report: Reports/Purchasing/Trial Balance/Historical Aged Trial Balance. We have been having problems with other reports because of the change from 2005 to 2006. I appreciate the assistance. ------=_NextPart_0001_AF5FCF35 Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi Jason, This is Lisa. Thank you for your inquiry on the Historica...

problem with CString
How can i convert a CString to an array of characters fro CString m_sResult t char aResult[100] I have tried doing aResult[]=m_sResult aResult=m_sResult strcpy(aResult, m_sResult) none of this methods worked, so i was wondering what kind of convesion do i need to to? am i skipping some important step? The reason why i want to do this is because i would like to accept an input from an edit box and pass this information to a .c file. strcpy(aResult, m_sResult); should have worked are you sure it didn't? "francis" <anonymous@discussions.microsoft.com> wrote in message n...

Can anyone help with my problem?
I have a problem, I have two drop down boxes both with three values i (The values are stored on a separate worksheet). I want to multiply a independant value by a value determined by what is in the drop dow boxes. E.g. Independant value*Value in drop down 1*Value in Drop down 2 However the values in the drop down boxes are words not numbers but need them to be equivalent to different numbers e.g. value one in dro down 1 is 2.5, how can I get them to be classed as numbers in th formula whilst appearing as words and what formula would I need -- ExcelGu --------------------------------------...

HOTMAIL Problem
Dear Sir, I have exch. 2003 but each time I send to any hotmail, it doesn't arrive then later it gives me a message : This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. mmajai2@hotmail.com THEN : later, another message confirm the Undelivery of message What shoul I do? Mahmoud Metwally Ali wrote: > Dear Sir, > I have exch. 2003 but each time I send to any hotmail, it doesn't arrive > then later it gives me a message ...