PUrchasing G/L Distribution

Good Morning,

We have a situation and are not able to locate the cause, for some strange 
reason the G/L distribution disappears from the purchasing distribution 
window in the enter/match invoice activity. When the transaction is first 
entered the user is able to save it to a batch but when she ask for the edit 
list she gets an error message, she then goes back to the transaction and the 
G/L distribution is no longer present. Any ideas?

0
Utf
1/25/2010 4:55:01 PM
greatplains 29623 articles. 5 followers. Follow

4 Replies
724 Views

Similar Articles

[PageSpeed] 42

Hi Claude,

Since this is unposted transaction, the distribution entry window is 
editable and can be deleted (accidentally or othewise).  However, you can 
always retrieve the default posting accounts when pressing the Default button 
in purchasing distribution.

Lastly, if no default posting accounts have been assigned to (Vendor, Item 
or Company Posting Accounts), then this will be blank.

Hope this helps!

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


"Claude Garceau" wrote:

> Good Morning,
> 
> We have a situation and are not able to locate the cause, for some strange 
> reason the G/L distribution disappears from the purchasing distribution 
> window in the enter/match invoice activity. When the transaction is first 
> entered the user is able to save it to a batch but when she ask for the edit 
> list she gets an error message, she then goes back to the transaction and the 
> G/L distribution is no longer present. Any ideas?
> 
0
Utf
1/25/2010 5:04:01 PM
Denico,

Thanks for the information, one question remains how would "otherwsie" 
apply? we are aware that by using the "default" button we can regenerate the 
entries but what we are searchign for is how they diseapered in teh first 
place?

"Dencio" wrote:

> Hi Claude,
> 
> Since this is unposted transaction, the distribution entry window is 
> editable and can be deleted (accidentally or othewise).  However, you can 
> always retrieve the default posting accounts when pressing the Default button 
> in purchasing distribution.
> 
> Lastly, if no default posting accounts have been assigned to (Vendor, Item 
> or Company Posting Accounts), then this will be blank.
> 
> Hope this helps!
> 
> 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
> 
> 
> "Claude Garceau" wrote:
> 
> > Good Morning,
> > 
> > We have a situation and are not able to locate the cause, for some strange 
> > reason the G/L distribution disappears from the purchasing distribution 
> > window in the enter/match invoice activity. When the transaction is first 
> > entered the user is able to save it to a batch but when she ask for the edit 
> > list she gets an error message, she then goes back to the transaction and the 
> > G/L distribution is no longer present. Any ideas?
> > 
0
Utf
1/25/2010 5:35:01 PM
Hi Claude,

If the user is not altering the distribution entry in any way, then you can 
be sure that by clicking the default button will derive the same posting 
accounts when the transaction is originally entered.  On the other hand, if 
the user is changing the distribution entries depending on the source 
documents, then clicking the default button will not generate the exact 
entries the usr originally entered.  And user would have to correct the 
entries again.

You may need to take note whether this incident is occuring regularly.  If 
it is, please identify whether you have customisation integrated with POP.

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


"Claude Garceau" wrote:

> Denico,
> 
> Thanks for the information, one question remains how would "otherwsie" 
> apply? we are aware that by using the "default" button we can regenerate the 
> entries but what we are searchign for is how they diseapered in teh first 
> place?
> 
> "Dencio" wrote:
> 
> > Hi Claude,
> > 
> > Since this is unposted transaction, the distribution entry window is 
> > editable and can be deleted (accidentally or othewise).  However, you can 
> > always retrieve the default posting accounts when pressing the Default button 
> > in purchasing distribution.
> > 
> > Lastly, if no default posting accounts have been assigned to (Vendor, Item 
> > or Company Posting Accounts), then this will be blank.
> > 
> > Hope this helps!
> > 
> > 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
> > 
> > 
> > "Claude Garceau" wrote:
> > 
> > > Good Morning,
> > > 
> > > We have a situation and are not able to locate the cause, for some strange 
> > > reason the G/L distribution disappears from the purchasing distribution 
> > > window in the enter/match invoice activity. When the transaction is first 
> > > entered the user is able to save it to a batch but when she ask for the edit 
> > > list she gets an error message, she then goes back to the transaction and the 
> > > G/L distribution is no longer present. Any ideas?
> > > 
0
Utf
1/25/2010 5:52:01 PM
Claude,

I think the couple of other posts have danced around possible problems 
trying to be nice.  Try these tests:

1.  Open a transaction, go to the distributions.  If they are blank or some 
are missing, click on the Defaults button.  This attempts to reload the 
distributions the way they are configured in GP.  (If the user made manual 
changes, the manual changes will be lost.)  If after hitting the Defaults 
button, you have missing account numbers, then your accounts are not set up 
correctly.  If after hitting the Defaults button, the accounts are proper, 
then SOMEONE IS CHANGING THE ACCOUNTS MANUALLY (this is what was meant by 
"otherwise").

2.  If the accounts are not fixed using the Default button, examine first 
the Posting Accounts in the Administration->Setup->Posting->Posting Accounts. 
 Make sure they are all filled in.  This is your ultimate safety net 
accounts.  You should then check either the vendor or item accounts depending 
on the setup configuration in purchasing.

Our book Information Flow and Posting covers the source of accounts in 
detail and can be very helpful in setting these up properly.
-- 
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at 
http://www.AccoladePublications.com



"Dencio" wrote:

> Hi Claude,
> 
> If the user is not altering the distribution entry in any way, then you can 
> be sure that by clicking the default button will derive the same posting 
> accounts when the transaction is originally entered.  On the other hand, if 
> the user is changing the distribution entries depending on the source 
> documents, then clicking the default button will not generate the exact 
> entries the usr originally entered.  And user would have to correct the 
> entries again.
> 
> You may need to take note whether this incident is occuring regularly.  If 
> it is, please identify whether you have customisation integrated with POP.
> 
> 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
> 
> 
> "Claude Garceau" wrote:
> 
> > Denico,
> > 
> > Thanks for the information, one question remains how would "otherwsie" 
> > apply? we are aware that by using the "default" button we can regenerate the 
> > entries but what we are searchign for is how they diseapered in teh first 
> > place?
> > 
> > "Dencio" wrote:
> > 
> > > Hi Claude,
> > > 
> > > Since this is unposted transaction, the distribution entry window is 
> > > editable and can be deleted (accidentally or othewise).  However, you can 
> > > always retrieve the default posting accounts when pressing the Default button 
> > > in purchasing distribution.
> > > 
> > > Lastly, if no default posting accounts have been assigned to (Vendor, Item 
> > > or Company Posting Accounts), then this will be blank.
> > > 
> > > Hope this helps!
> > > 
> > > 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
> > > 
> > > 
> > > "Claude Garceau" wrote:
> > > 
> > > > Good Morning,
> > > > 
> > > > We have a situation and are not able to locate the cause, for some strange 
> > > > reason the G/L distribution disappears from the purchasing distribution 
> > > > window in the enter/match invoice activity. When the transaction is first 
> > > > entered the user is able to save it to a batch but when she ask for the edit 
> > > > list she gets an error message, she then goes back to the transaction and the 
> > > > G/L distribution is no longer present. Any ideas?
> > > > 
0
Utf
1/25/2010 6:39:02 PM
Reply:

Similar Artilces:

Stock Purchases
How can I make the stock chart display the points when I bought the stock? "Michael" <Michael@discussions.microsoft.com> wrote in message news:504BBD54-088D-4F17-BF64-CA30478157D2@microsoft.com... > How can I make the stock chart display the points when I bought the stock? Short version: A few weeks after you buy the stock, you have to delete the online price for that day in the manual price update list, and edit the buy transaction in the investment register so that it creates a "Buy" entry in the manual price update list. If you try to do this too soon a...

Outlook Distribution Lists Problems
I have been experiencing a problem with imported Distribution Lists in Outlook XP. I've recently purchased a new computer. My previous computer had Windows 2000 Pro and Office 2000 Premium. The new computer has Windows XP Pro and Office XP Pro. After making all the necessary updates, data was transferred from the old computer to the new computer. Distribution Lists that were imported from Outlook 2000, show up in Outlook XP, as do the individual contacts in the lists, but when I try to open up the contacts I get an error message [Could not find contact name (E-mail). It ma...

Live Chat: Purchasing
The transcript for the Purchasing chat is now available here: http://www.microsoft.com/dynamics/rms/using/chats/0801POs.mspx Our thanks to all of the chat participants and experts. You can find additional chat transcripts, announcements of upcoming chats and events, and helpful articles—including the latest installments in our Inventory Management Series—on the "Using Microsoft Dynamics" site: http://www.microsoft.com/dynamics/rms/using/chats/0801POs.mspx -- This posting is provided "AS IS" with no warranties, and it confers no rights. Corrected second link below: &...

This distribution list has reached the maximum size for your network e-mail server...
Hi there, I am getting this message when trying to add new items to a distribution list... The list so far has 176 items... I could not find any settings by which the max values might be defined. In the properties of the distribution list, no limits are entered... Can anyone help? How can I avoid this problem? Thanks! this is a limit on a personal distribution list...if you want to use a larger list, either make it a server-based list, or make several smaller lists and "nest" them... "Thorsten" <me@privacy.net> wrote in message news:4147e4b0$0$54462$45beb828@n...

Segregation of Duties (Financial , Purchasing)
I'm interested in locating some kind of documentation that will show me what specific permissioning is involved in Advanced Security for segregation of duties. For example, only Class A can only approve and post transactions while Class B approves. What specific permissions do I select for Class A and what specific permissions do I select for Class B in Advanced Security? I'm unable to find doco that shows me what each permission achieves. Thanks! Hi Maatthias, Out of the box Advanced Secuirty does not have any SOD information. Feel free to contact me with any specific que...

cc: in a distribution list
Is it possible to create a distribution list that places the address in designated places such as some of the addresses in To: and some in Cc:? No, but you could use two different lists. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Steve" <anonymous@discussions.microsoft.com> wrote in message news:3aec01c47f08$fb678d30$a601280a@phx.gbl... > Is it possible to create a distribution list that places > the address in designated pl...

Permission/Distribution
Hey Newsgroup, Now I would like to know, which group should I be creating in Windows 2003/Exchange 2003 if I would like to assign permissions and use as a distribution list. Maybe I'm missing something, but I just can't seem to get to it. I want to create a group that I can use to assign permission to files/folders (both in NTFS and Exchange), and also to be used as a distribution list (in Exchange). Which group with ADUC will allow me to do this? I currently create two groups for the purpose, but when I want to assign permissions in Exchange to public folders, I can't us...

How to Link Purchase Invoice with Purchase Receipts
Hi, We are using Great Plains 6.0. I am trying to generate report to link Purchase Invoice with Multiple Purchase Receipt.I am using Crystal Report/Business Objects to make this report. I have used the following tables 1. PM30200 (PM Paid Transaction History File) 2. POP30300 (Purchase Receipt History) 3. POP30310 (Purchase Receipt Line History) I have created two view tables by joining these tables. A. PM30200.DOCNMBR = POP30300.VNDDOCNM AND PM30200.VENDORID = POP30300.VENDORID AND PM30200.DOCTYPE=1 AND (PM30200.BCHSORCE IN ('Rcvg Trx Ivc','Rcvg Trx Entry'...

Purchase order enhancements #3
The functional and originating totals display the same amount (when using multicurrency) in the Purchase Order Enhancements Entry window What release? What Service Pack? Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com "Ben" wrote: > The functional and originating totals display the same amount (when using > multicurrency) in the Purchase Order Enhancements Entry window GP 9 service pack 1. for some reason though the gp version is 9.00.0267 and according to the service pack documentation it should be 9...

Email sent to Distribution Group...not supposed to
Hi, Here is the scenario: Exchange 2k3 Outlook 2k3 Roughly 8 member company. All members of group "test" and default groups. When any of the users email (either from OWA or Outlook), every message they send is getting automatically sent to everyone..I am not sure if it is to this group or just to all mailboxes. I have: *Checked Global Settings -- Message Delivery ---- nothing outstanding *Protocols -- SMTP -- I do not see any place where Exchange should automatically send to this group or all recipients. *IMAP4, NNTP, POP3 are not enabled --- only HTTP and SMTP enabled Pro...

Using Integration Manager for Purchase Orders
It's possible that this question is entirely obvious, but I can't figure it out, so I'll apologize in advance. I'm trying to find a way to import Purchase Orders into Great Plains using Integration Manager and XML files. I've setup the XML Source Adapter to my liking, but as I look at the destination options, I only see SQL Opt 8.0 - Purchase Order. The way I understand it, this is writing the info directly to tables without employing any of the Great Plains business logic. Why is there no Purchase Order Option under the standard Great Plains 8.0 Adapters? Perhaps it&...

bulk purchase
Hi how should I set up Rms to handle this? the customer purchases bulk celphone phone time for resale from the local cellular provider, they then resell the time to end users in smaller amounts of time. how should i handle this? -- Thanks Ian Ian, RMS will not track an item beyond the sale. If you are wanting to track the phone cards that the enduser purchases from your cusotmer it won't do that. We might be able to come up with some other suggestions for you. If you would like to give me a call I would be happy to discuss the situation with you. Daniel techs1@nurol.com Tech Sup...

Integration Manager - Payables Trx
I have to integrate checks cut from another system every month-a few thousand of them. I am now doing these as payables transactions with the corresponding check information at the same time. I was wondering if, after I were to enter the invoice amount, is there a way via the Integration process to have multiple expense accounts in the distribution step or are you allowed to only post one distribution line? Also--is there a way via IM to integrate multiples checks and apply to one invoice? Any help is appreciated. Yes, you can have multiple expense distribution accounts when integ...

Inbound "Distribution List"??
Newbie SBS 2003 admin here... would like to be able to point inbound email for a specific email address (e.g., info@xyz.com) to multiple recipients (one on exchange and one via pop3) without using a user license for that email address... Right now, I have the email addy pointed to one of the users accounts, but only he can see it now and exchange won't let me map the email addy to more than one account... I know I could just set up that account as a user in SBS 2003, but with only 5 licenses, I don't think that's a solution.. Again, one user is receiving via Pop3, so a pub...

Binodal distribution
I need to find the position of the second node in a binodal distribution using pivot tables. Normally I create the pivot and set the summary by: to average. I wish I could set it to trimmean and this would be close enough. Any idea how to customarize the summarize by function or another equation to find the location of a peak in a binodal distribution? ...

Product Key and Purchased New Office
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I too had the problem with not having a valid product key. I restored an earlier version of Microsoft Office (12.1.9) from Time Machine and purchased a new Office 2008. How do I enter the new product key? I'm afraid of inserting the new disk for fear of losing previous emails, settings, etc. Should I download the SP2 update again, delete the "plist" files recommended and then when setup assistant asks for the product key, enter the new product key from the one I just purchased? Does this newly purchased pro...

Problems with distribution groups in Exchange 2003
I have a small business server 2003 with SP1 for both windows and exchange server installed. It recieves mail for two domains. cleevelink.co.uk and cleevehillnursing.co.uk. There are two distribution groups setup both called info one for each domain. The problem occurs when mail is sent to info@cleevehillnursing.co.uk it is routed to the correct members, however mail sent to info@cleevelink.co.uk is routed to the members of cleevehillnursing.co.uk not the cleevlink.co.uk Any thoughts greatly recieved. On Sat, 26 Nov 2005 08:05:02 -0800, "Kevin Cook" <KevinCook@discussio...

description from dimension fields needed in purchase order/item li
We originally did not attach sub descriptions on our matrix/part number because of the way the price tags would read on our merchandise. It is alot cleaner looking to have a simple description and then in the fields below to show size and color. So, it really should not be necessary to attach the dimensions to the part number. As you know with the character limitations this does not give good information anyway. So, what we really need is for the dimension fields to show in seperate colums both when we look at items and when we create purchase orders. Not having the ability to do this i...

purchase limits
Is there any way anybody can think of that i could limit the purhase of an item to 1 per customer ever? I know of the purchase limits feature - but not sure how capable it is! I want to use this for a coupon i will be emailing - so that the customer can only use it once, and not print multiple copies! Any suggestions greatly appreciated! Philip, Looks like you can use limit purchases to limit the purchase to 1 item per customer, but this will only work for 1 year. If this is acceptable to you I'd say go for it. If your coupon expired before 1 year is up you could simply make ...

Purchase Return Does not accept the exiting Purchase Receipt
Hi: I am trying to enter one Purchase Return with credit. Inquiry shows the PO, Receipt and Invoice documents properly. But when I go to create PO return, It accepts the PO Number, Item Number but not the Receipt Number. It is not showing it into the List even. What could be the reason. There is no knowledge base available for Purchase Return. Thanks If this particular receipt item has been sold to a customer and then returned it will not show up as available as a return to vendor - try an Inventory return with credit. Hope this helps "Naseer Ahmed Farooqi" wrote: >...

Distribution List #39
Hi, I'm using Outlook 2007, when I create a distribution list, the icons do not display for Distribution List/Inser/Formal Text. When I click on distribution List, the icons will display but the Name of the distribution list and the list of users is covered. I look at another colleagues pc and it doesn't happen on theirs. Did I shut something off? -- Newbee ...

Attachments and Distribution Groups
Hi When I sent an attachment in a mail to a number of recipients in a distribution group, the attachment is not received. This is very inconvenient. Is there anything I can do about it? Thanks This behavior cannot be reproduced. Perhaps you should start by spelling out the exact steps that will cause this behavior. Outlook version, mail transport type, recipient type, mail format would seem a bare minimum for you to report. -- Russ Valentine [MVP-Outlook] "Mike Carter" <michael@carter14.wanadoo.co.uk> wrote in message news:dso5ri$i7d$1@news6.svr.pol.co.uk... > Hi...

How to handle ETF distribution Reinvestment without additional uni
I own some ETFs which from time to time reinvests its distributions. However, the distribution reinvestment does NOT result in additioanl units (shares) of the ETF. This essentially increases the adjusted cost basis. Example: Buys 100 share of XYZ @ $10 cost basis = $1000 a distribution of $200 is declared and "reinvested" without changing share numbers. The result is holding 100 shares at a adjusted cost basis of $1200 or $12 per share. Distribution reinvestment with additional units/shares is easy and MONEY has specific investment "activities" to handle it. B...

Voids Purchasing Great Plains
We voided an invoice from prior year through the voids open items screen in the Purchasing module in Great Plains. The GL reflects the correct amount of the void but on our AP Aging report is off by the exact amount of the void. When we research the void in the Purchasing system, there's not a star next to the original invoice similar to all the other voids. How do I fix the AP Aging report to relect the voided amount that ties to the gernal ledger? Vuong Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET: Using SQLite with Enterprise Library 3.1 http://w...

How to migrate Distribution Lists
We are migrating Exchange 5.5 to 2000. What is the best method to migrate Distribution Lists to the new server? thanks, Stv The Active Directory Connector can be configured to replicate your DLs into Active Directory as Universal Distribution Groups. -- Neil Hobson Exchange MVP For Exchange news, links, and tips, check: http://www.msexchangeblog.com "stvbrx" <stvbrx@discussions.microsoft.com> wrote in message news:5289FFD0-C6E7-4D9A-B985-E32E0EBA67F0@microsoft.com... > We are migrating Exchange 5.5 to 2000. > What is the best method to migrate Distribution Lists t...