# of transactions does not equal

I would like to know...if this just applies to version 7...or version 8...or 
both...and  IF there is REALLY going to be a fix offered.

As per usual this is one of the many confusing technical articles I have 
access to through the maintenience plan.........

we are on Version 8 With the latest service pack...and are receiving this 
error when posting payables batches????

Updating to version 9...is not an option....


TechKnowledge Content 
Issue Summary:

Error Verifying Batch Total And Transactions In POP

Issue Detail:

Receiving two errors when trying to post or print an edit list of a shipment 
batch in POP. The errors are Actual batch total does not equal the control 
batch total and Actual transaction number does not equal the control 
transaction number. POP batches do not require the control totals for amounts 
or transactions. Here are the steps to recreate: 1. In Posting Setup, choose 
the Purchasing as the Series and All as the Origin. 2. Mark Verify Number of 
Trx and Verify Batch Amounts. 3. Save changes. 4. Choose Purchasing as the 
Series again and Receivings Trx Entry as the Origin. You will notice the 
field are not available but have check marks. 5. Enter a purchase order. 6. 
Enter a shipment receipt in a batch. 7. Print an edit list of the batch. 
Results: You receive the errors. Expected Results: You should not receive the 
errors. The batch does still post but the error message tells the user that 
you can not post it. I also tried this on 5.5 and 5.0 and they work fine.

Status of Resolution:

This problem report is scheduled for release in the next version of the 

Scheduled for Release 7.0.

This article was TechKnowledge Document ID: 23085


• Microsoft Business Solutions–Great Plains Purchase Order Processing, when 
used with: 
    Microsoft Business Solutions–Great Plains 8.0 

 Back to the top 

TamiFarrelly (100)
7/31/2006 4:30:02 PM
greatplains 29623 articles. 6 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 53


Similar Artilces:

Transaction to read when no actual transaction
I have an account called 'Honda accord'. It is an asset account that has a loan associated with it. The loan account is 'Honda loan.' I imported a transaction into Honda accord and says i have 1 transaction to read. I have view all dates/transactions selected and nothing comes up. The box to the left says i still have a transaction to read and I cant find the darn thing. Any Ideas???? -- Stephen and Erica Chenelle In microsoft.public.money, Stephen & Erica Chenelle wrote: >I have an account called 'Honda accord'. It is an asset account that has a >...

Paid Transaction Removal not removing some transactions
When running Paid Transaction Removal two transactions for an account were not removed to history while seemingly identical transactions in another account were. As I understand the rules of paid transaction removal, a transaction will be removed if it meets the following criteria. 1. If it's an invoice it must be fully paid. 2. If it's a payment, the document amount must be fully applied to one or more invoices. 3. The removal date must be after the document date. The documents are debit notes, are fully paid off (CURTRXAM = .00000) and the document dates precede the cut-off d...

V10 - Transaction by debtor enquiry report
Hi, Anyone any ideas why when printing the transaction by debtor enquiry report, the last digit of the amount is dropped off? This is when printed as A4 - payables is okay going to same printer. Okay when displayed to screen - only lost when actually printed. Thanks Jean -- JB Is the last digit perhaps trying to print outside the 'printable' area of the printer? If you do not use A4 paper does it work? Do you have the A4 module installed? "JB" wrote: > Hi, > > Anyone any ideas why when printing the transaction by debtor enquiry report, ...

How are transactions automatically assigned to categories?
When I download my credit card statements into Money, I notice that some of them are automatically assigned to categories. How does Money do this? Is the information included in the info I download from my bank, or are there rules within money? More importantly, how can I add my own rules to auto- categorize things? Thanks! -Aaron ...

PM Transaction Work vs Open
What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN? Thanks, Steven work = saved open - posted "Steven" wrote: > What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN? > > Thanks, > Steven As an add on, the work also includes recurring transactions. "Doug" wrote: > work = saved > open - posted > > "Steven" wrote: > > > What is the difference between PM_Transaction_WORK and PM_Transaction_OPEN? > > > > Thanks, > > Steven Thanks, Guys! Steven "klewis&quo...

Receivables transactions not aging individual transactions
Looking at smartlist, the Receivables transactions have a search/favourite added, including the aging periods. When you look at the search, it doesn't age the individual transactions, but instead ages the entire customers balance. I would expect it to show the aged balance per transation. Assessment: With how Smartlist is currently designed, the default smartlist object pulls from the Summary table for those aging period amounts. This is the reason why it does not show the aging for individual transactions. I know that the ability to see the aging of the individual accounts would b...

Hi all I have a question about SQL Transactions: For example, I have a table with 3 rows (ID 1, 2 and 3). Now I insert a new row within BEGIN TRANSACTION, and I do not commit yet. In another SQL Session, I try to select data. When I do SELECT * FROM Table, it is blocked. When I do SELECT * FROM Table WHERE ID = 2 I get a result. How can I make SELECT * FROM Table possible even when there is a open Transaction ? Of corse I only expect to get the ID's 1, 2 and 3 back and not the new row. I have looked about IsolationLevel, but this does not help. Thanks for any comments ...

Rounding on Investment transactions
I've seen this problem for quite a while in Monday (at least 01, 02, 03, and 04). But when I'm entering my transactions, often times the final amount (shares*cost+comm) don't equal out, it's always the matter of 1 penny, but I'm a bit anal that way. For instance. 0.78800 shares at 27.8900 per share. Fully worked out it comes to 21.97732. So when Money does the transaction it rounds it to 21.98 (makes perfect sense). My brokerage relays the cost as 21.97. What options do I have to make these transactions actually work out? Since I can't do a negative commis...

Receivables Transaction Entry #2
Anyone have any idea why the Address ID does not get saved on the Receivables Transaction Entry when posted? -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com 5/4/2007 3:27:40 PM There is no field available in the Receivables Open table to store it! I have put in this suggestion since version 5.5, and it still hasnt happened. You will have to develop a customisation to track it in a parrellel table. (Or use VBA & DUOS table) ------ Robert "Japheth Nolt" <japheth.remove@landiscomputer.com> wrote in message news:xn0f5t47t3uqcr000@msnews....

Debugging SQL Server 2005 Transact SQL
I have an urgent requirement to debug Transact-SQL in SQL Server 2005 and I have a couple of questions. 1. Are there any *free* programs that will allow me to debug (step through line-by-line, look at cursor results, variables, etc). 2. If the answer is 'no' and Visual Studio is the least expensive alternative, which versions are compatible and have debugging capability? Thank you very much in advance. allanc (allan.for.g.groups@gmail.com) writes: > I have an urgent requirement to debug Transact-SQL in SQL Server 2005 > and I have a couple of questions. > 1. Are th...

Capitalize Text if 2 lists are equal
I want to compare 2 lists on separate worksheets - (A2:A9) on both sheets. The lists contain text. If the lists are equal I want the text in cell A1 on the second worksheet to be "PROPER"case. If the lists are not equal I want the text to be "UPPER" case. Can I use a standard formula or an array formula to do this? Thanks for any help! -- elevdown ------------------------------------------------------------------------ elevdown's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29668 View this thread: http://www.excelforum.com/showthread.php?...

PM/RM Batch--Transaction Threshold?
1) Does anyone have insight as to the practical limits on the number of transactions which either a PM or RM batch can hold/process prior to presenting a problem. 2) We have had problems in past scenarios where high-transaction volume batches (200+) have caused system problems with posting to the G/L and the Sub-ledgers of either RM or PM. Any way to avoid this w/o reducing the number of transactions contained in the batch? ...

Paid Sales Transaction Removal error message
Hola Familia When I try to do run a "Paid Sales Transaction Removal" against a specify customer (Microsoft Dynamics GP menu >> Tools >> Routines >> Sales >> Paid Transaction Removal) in Dynamics GP 10 with SQL 2005, I get the following error: [Microsoft] [SQL Native Client] [SQL Server] Violation of PRIMARY KEY constraint ‘PKRM30101’. Cannot insert duplicate key in object 'dbo.RM30101'. I searched for the error message in Customer Source Knowledge base and found Article ID : 861084, which I followed and it showed the duplicate document (invoice...

Batch is Receiving Transactions
After going to Transaction>>Financial>>General, clicking on the find and trying to double-click on on a Batch, I receive the message "This batch is receiving transactions." This transaction and another one posted at the same time have been showing this message for over 24 hours. Is there a way to clear/fix this message so the entries can be viewed and posted to the GL? There are 2 things you can check. First check the Dynamics table SY00800 for records related to the batches and clear these records after checking to see that no one is logged into Great Plains. ...

Analytical Accounting Dimension ID for Bank Transaction
Hi. can any one help me out in finding TABLES of AA from which i can link dimensions assigned in the Bank Transaction. I need create a crystal report for it. Thanks in advance!! ...

Reconcile old bank transaction
We switched from bank A to bank B and when I go to Checkbook Balance Inquiry screen, the old bank A still show current checkbook balance with a negative value. The transition from bank A to B are all correct in paper works, but not in the GP. When I look at the data for 2 transactions in tables, I noticed 1 of the transaction is reconciled and the other is not; otherwise, every values are identical. How would I fix this negative balance on old bank? Thanks! ...

GP10: Payables Transaction Inquiry-Vendor window
Hello All I'm having a problem seeing the vendor records in the payables tranaction inquiry-vendor window for some users only (including sa). I've checked the user security settings & assigned the same security role ID to the problematic users as the security role ID that is working properly. I've marked (and unmarked) the task ID but nothing seems to solve the problem. Any ideas how to fix please? ...

Transaction Remains as Transaction to Read
I am using MSMNY03 deluxe on XPpro. One checking account registered transaction remains in the list of Transactions to Read and I have not been able to "Accept Transaction". The account register has a note attached saying: "This downloadable transaction is a probabale match to a manually entered transaction. " After clicking on Accept in the account register, the note remains and the Transaction to Read list remains with that one remaining transaction to be read. How can this be corrected ? de ~Vince~ Have you tried clicking "change" instead? Susan "...

Eaton Vance Direct Online Services
I'm finally adding direct downloads from a number of my accounts. When I set up Eaton Vance online services and connect, all that downloads is my account share balance - no transactions and no account dollar value. The register show the # of shares. The account list shows a dollar value of $0.00. When I look at account settings, for some investment accounts" track cash transactions" is an option; for Eaton Vance it is not. Is this a limitation placed by Eaton Vance, or else what do I need to change to download transactions and account values? TIA In microsoft.public.money, k...

Distributed Transaction on SQL 2005
A stored procedure running from server A database db1 updates both local tables, as well as, remote ones, on server B database db2 via a db link. All updates are part of the same distributed transaction. I have got it to work on one server. In other words, I have made all provisions to make this work like turn off rpc security, configure msdtc in windows components. However, when I changed the remote server to be server C database db2... The two inserts done on the local server succeeded. But delete comman against remote table never comes back. No errors or locks. Wha...

Investment Transactions not appearing in Cash Transactions
The Cash Transactions register is missing items that are present in the Investment Transactions register, causing the month-end money balance to not reconcile with the monthly statement from my brokerage. I'd like to try deleting all my transactions back through the most recently reconciled month, and downloading them all again. Is there any way to do that? Version: Money2001 Deluxe & Business thank you, /Jim What kind of items are missing? Buys and Sells? -- Michael Gordon MVP "Jim F" <hedgefund2020@comcast.net> wrote in message news:694601c3e668$b32bb8...

Transaction in ms crm webmethods ?
Hi all, Does the WebService (WS) MS CRM use transactions while updating or creating records ? For exemple, I want to update a contact record, and in the same transaction add to this contact a new address. If the update of the contact is OK, but the creation of the address fail, I want MS CRM to cancel all the changes made. Is this native to MS CRM, or have I to made the rollback manually ? If I have to do it manually, have you some tips on the best way to do it ? Thanks a lot DA CRM does not use transactions, and there is no roll-back facility. You would need to store the original state...

Unreconcied Transactions not showing in a Cash Transactions #2
HI, I am using Money 2006 Premium. I am downloading all my investments transactions from Broker. They all marked as (E) transactions. But a coupel of times I found missed transactions for stock options and add them manualy to Investments Transactions, but these transactions marked as ( ) - unreconciled and not showing up in Cash Transactions and it make my cash ballance incorrect. I already trryed manualy make Make As.. (C) or (R) but they still not showing in Cash Transactions. How can I make them show up there and fix my Cash balance proble? Thank you. Sam -- Sam. In microsoft.publi...

Moving Transactions #2
Is there a way to move transactions up or down in a list? When I import my account information and have many transaction on the same date, sorting by date, I would like to be able to list those transation in a particular order. Let's say on 4/5 I had 3 transactions a withdrawal, a deposit, and another withdrawal imported in that order. Is there a way to move the deposit up in the list to be the first transaction for that day? In microsoft.public.money, lumaduc wrote: >Is there a way to move transactions up or down in a list? When I import my >account information and have m...

How to tell when a transaction has been rolled back?
I have a CLR stored procedure that uses a transaction to insert a row into a table. I need to tell somehow by looking at my sample data whether or not the rollback has actually happened. The only thing I have to go on is the HeadlineID int identity(1,1) not null column. Is this possible? 1. Run the stored procedure with sample data forcing it to succeed 2. Look at the data in the table itself. The current identity is set to 28. 3. Run the stored procedure again forcing it to fail. This is done by a unique key column [HeadlineTitle]. 4. Look at the table again to make sure this ru...