batch RM_OPEN duplicate key
We on on Dynamics GP v9.00.0281
We had a batch die and I was asked to look into it. This is what I found.
I go into Batch Recovery and it is listed.
BatchID: "LK ARII-2/3"
Origin: Receivables Sales Entry
Status: Posting Interrupted
I check the box and click on continue.
It starts running then pops up with:
Batch LK ARII-2/3 failed to complete posting, Use the Batch Recovery window
to complete the process
More Info shows:
A save operation on table 'RM_OPEN' has created a duplicate key.
Any ideas on what I need to do to get this corrected?
do a backup first , t...Sales Tax GL not showing up
We are using Great Plains 7.5 and have a problem where the sales tax GL will
not show up in the invoice. Each sales tax code has the GL, so I'm not sure
what I'm missing. Can someone help?
Jeanie - GHF
Sales Tax is set to display based on Customer (or Item)
and Shipping Method.
Firstly, the Customer (or Item), must be setup as a
taxable customer by giving it a Tax Schedule ID.
Second, check the Shipping Method that is used. A
Shipping Method can have a type of either 'Pickup'
or 'Delivery'. If it is set to 'Pickup', which is the
defau...ap invoice query with gl distribution accounts
I need to make a query that will pull the posted payable payments of each
invoice. I am going to use this
[http://victoriayudin.com/2009/09/11/sql-view-for-all-posted-payables-payments-in-dynamics-gp/ ] query from Victoria Yudin [thank you Victoria]
But I also need to specify what distribution GL account each invoice hit.
How can I add that to this query?
Thanks in advance.
Here you go:
SELECT dbo.PM10400.PMNTNMBR, dbo.PM10400.DOCNUMBR, dbo.PM10400.DOCDATE,
dbo.PM10400.PYENTTYP, dbo.PM10...Cannot post
Msgs I post to this Ng do not appear on this NG. But it appears in the Sent
Items folder. How can I correct the problem?
...Importing Posted Invoices
Anyone out there know of a way to import/migrate posted invoices from Great
Plains to CRM 3.0 in an integrated setup?
Presentations Direct - "Document Finishing Solutions"
Scribe Software has built connector between MSCRM and Great Plains. For more
information visit www.scribesoft.com . Their integration is much easily
customized than the "free" integration from Microsoft.
> Anyone out there know of a way to import/migrate posted invoices from Great
> Plai...How do I block Message Board posts?
I am having a considerable problem with message board posts by
someone using the name niuyne at Remote Name 220.127.116.11. This
person or organization posts numerous nonsense messages, daily,
on my web site message board. Is there any way I can block this
poster? Thanks for any suggestions.
Not without getting rid of your message board. Sorry.
MVP Microsoft [Publisher]
"Gordon" <gordonlr@DELETEswbell.net> wrote in message
>I am having a considerable problem with message board posts by
> someone us...Sales Invoice # in a recurring batch
My client has invoices in a recurring batch and is using 5 characters for the
Document Number (ie. 10001).
When it posts, the Document Number becomes 10001000000000000001,
For recurring batches, it appears that GP is adding characters to the
Document Number to the maximum 20.
The Sales/Invoices field in Receivables Setup holds 17 characters.
The Document Number field on the Receivables Posting Journal holds 20
Can this be controlled anywhere?
...re: my post below re: clearing overload of reminders
BTW, when I turn on office notifications (ie double-click the app), no
reminders pop up. Nothing pops up. Just the pull-down menus at the
top. No option to "dismiss all" or even dismiss one reminder. Only
thing I can do is pull "open" the most recent event for which there is
a reminder, and I do NOT want to select all and then delete, b/c I have
read what happens! (all calendar events wiped out)
Sorry. You should really ask in the Entourage newsgroup, or search the
http://groups.google.com/group/microsoft.public.mac.office.en...PM Transaction Posting Journal
I need to add the Dist Ref line into this report to print the batch edit
list. I was able to pull the field in but can' get it to print with the
FIELD 9 (account number). Has anyone else been able to add to this fields
This is a copy of the KB Article 865470
This article discusses how to add the Distribution Reference from the
Payables Distribution window to the Transaction Posting journal.
Note Do not follow this resolution if you are using Inter-Company
This information can be added, but you will lose your Tax information from
this journal report. If t...post-Exchange Server 5.5 SP4 Information Store fix roll-up
Need help locating the post-Exchange Server 5.5 SP4 Information Store fix roll-up. Does anyone know where I can download it? I need these files:
Any help would be greatly appreciated.
There are several post SP4 patches you may need to review. This will bring
up a few extra links not related.
"Sean" <firstname.lastname@example.org> wrote in message
new...Holds In AP
It makes more sense to me to mark the Payables invoices that need to be paid
rather than mark the holds. When we do the next check run, we have to go
through and unmark the previously held invoices. Instead, if we originally
marked the invoices that we were paying, it would leave us with a clean slate
for the next check run. It's backwards to me.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button,...How is AP check cutting in version 9.0?
We are using version 8.0 and my AP personnel and I doesn't like the AP check
cutting feature too well. Is upgrading to version 9.0 makes the check cutting
so much easiar like in Peachtree or Quickbooks where you pull up individual
vendor sand check mark only the invoices you want to pay?
Any other pros\cons of upgrading from version 8 to 9 are appreciated?
V9 has the functionality to display a list of vendors and mark the invoices
you want to pay. You need to create the batch first.
Charles Allen, MVP
> We are using version 8....Customer/Vendor Consolidations for posted transactions?
For anyone using customer/vendor consolidations, is there a setting somewhere
that effects consolidating posted transactions? I've established
relationships between customer and vendor accounts that both have balances,
but on the consolidation window no transactions are shown. At the bottom of
that window is a status box that shows 'unposted'. The box is not editable.
The Unposted on the bottom is the status of the consolidation, you do not
need to change that. If you have performed the module setup for the
Customer/Vendor Consolidations (Setup &g...is there an AP report
is there a report that shows all accounts that are to be paid.
How about the "Report - Accounts Receivable with Transaction Details" from
"Andaiye" <Andaiye@discussions.microsoft.com> wrote in message
> is there a report that shows all accounts that are to be paid.
the AR report will have details about customers who have to pay me, but what
about ppl that i have to pay
> How about the "Report - Accounts Receivable with Transaction Details" from...AP Checks #2
I processe checks using the Select Checks process. I printed the checks and
tried to process the batch. I got an error and it will not post. The erros
directs to use Batch Recoverty to post the batch. I used Batched Recovery
many times and it still does not work. Any suggestions?
What does the edit list for that batch say? Ie any errors?
> I processe checks using the Select Checks process. I printed the checks and
> tried to process the batch. I got an error and it will not post. The erros
> directs to use Batch Recoverty to post the ba...Run Reg File Silently from Batch File
Windows XP SP3
I have the following in a .REG file:
Windows Registry Editor Version 5.00
I am just using this value as a test and I toggle it between 0 and 1.
I would like to develop a batch file that runs the .REG file
silently. Toward that end, I have placed the following command in a
regedit.exe /s AutoEndTasks.reg
This works if I type it at the command prompt. However, if I put it
in a batch file and then run that batch file from the command prompt,
...Yahoo Group List Posts
I can't reply to Yahoo Group lists posts. Can anyone tell me how to fix this?
"ksvista" <email@example.com> wrote in message
>I can't reply to Yahoo Group lists posts. Can anyone tell me how to
Guess you'll actually have to subscribe to each group in which you want
to member at Yahoo Groups.
And how is this an Outlook question? Yahoo Groups is a private service,
much like forums, and you can't connect any NNTP client, like Outlook
EXPRESS, to them. They do se...Another Cannot Send Mail Post
This inability to send email is going on way too long and is effecting my
business. I use Verizon at home with my wireless laptop. Have been
successfully sending & receiving email for years. Then all of the sudden a
couple weeks ago I began getting the following error message (which others
have posted as well):
The connection to the server has failed. Subject 'SENDING FROM SHOP EMAIL
VIA LAPTOP', Account: 'mail.icecreamshop.com', Server:
'mail.icecreamshop.com', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket
Error: 10060, Error Number: 0x800CCC0E
...Web AP / Scanning AP Invoices
Does anyone have experience with scanning AP invoices and attaching in GP? I
saw that someone mentioned Web AP in an earlier post. Anyone using this
we are gettin ready to implement one where you can enter ap on the web and
attach ascanne dimage. It looks awesome. firstname.lastname@example.org
> Does anyone have experience with scanning AP invoices and attaching in GP? I
> saw that someone mentioned Web AP in an earlier post. Anyone using this
...Form to search database and return found records (re-post)
I have a query that pulls in required data from four tables. I then
created a form populated with fields from this query. To this form I
added a sub-form. The sub-form is based on the same query. Hence
there are two groups of the same fields (except that one group is
within a sub-form). The two groups are linked through the Link Master
Field and Link Child Field, such that when I press page-up/down in the
Master Field, the records in both groups change in a synchronized
fashion. (At this point, only one record is visible at a time in each
I need to be able to fill in one form an...Settle EDC Batch
How I can settle the EDC Batch from the RMS POS instead of the RMS Manager?
That way the cashier doesn't have to go to the RMS manager.
I have used an application called "Workspace Macro" to do this. This
application allows you to record mouse and keyboard movements that you
can then assign to a POS Button. This way you can create a macro to
launch the manager, settle the batch then close the manager. You could
also create a scheduled task that would run during the night and settle
the batch automatically.
New West Technologies
Check out amazing RMS enhancements:
...GP10 posting error message
When I try batch recovery I get the error message
"A save operation on table PM_Vendor_MSTR_SUM has created a duplicate key".
Can anyone help?
...Tracking users who post to public folders
I am running Exchange 5.5. Does anyone know if there is a way to find out
who created a post to a public folder? We have an issue where users are
posting calendar events for other people without their permission in a
public calendar. These posts are being used to inform the whole office that
user X was late today, or did not show up for work yesterday. These are
serious issues and we need to address them since some of the posts may be
wrong. If any one has a solution or a direction to point me in I would
greatly appreciate it.
On Tue, 21 Jun 2005 15:35:30 ...Close Outlook in Batch File
I have a batch file that backs up all the networked computers in the office
to the server. This program will back up the Outlook (pst) file if the
employee remembers to close Outlook. Is there a command line I can use in
my batch program that will close Outlook?
I am the MIS Manager for a non-profit organization. We are running GP 8.0.
There are many batches in the Transactions | Purchasing | Batches. The
Accounting supervisor doesn't know what to do with them.
In the Batches screen it reads: Under Origin, they are Payables Trx Entry
and Computer Check.
Under Status, they are all Available, except one that reads Check Printing.
Under Frequency, they are all Single Use.
There are 7 entries there. Can anyone explain why these are in the batch
screen? Is it possible that the user (they're all from one user) has them as
a recurring batch? ...