Live Chat: Purchasing
The transcript for the Purchasing chat is now available here:
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:
This posting is provided "AS IS" with no warranties, and it confers no rights.
Corrected second link below:
&...HOw do i alpha order my columns?
That is called SORTING
Use help to find more info
Bernard V Liengme
remove caps from email
"devilchild" <email@example.com> wrote in message
I have research data entered by age groups. When the bar
chart is created the youngest is at the top. We want the
oldest group at the top.
Is there any way of changing the plotting order without
changing the spreadsheet data?
Select the axis press Ctrl+1 to display the format dialog. On the Scale
tab change the following properties;
Enable: Categories in reverse order
Enable: Value(Y) axis crosses at maximum
> I have research data entered by age groups. When the bar
> chart is created the youngest is at the top. We want...Send form windows to the back of -global- Z-order
I know there is a function to send child form windows to the back of
an app's 'local' Z-order. And there's an easy way to send them to the
-front- of the global Z-order.
But is there any way to send them to the back of the global Z-order?
In other words, place the form windows behind all other currently
> I know there is a function to send child form windows to the back of
> an app's 'local' Z-order. And there's an easy way to send them to the
> -front- of the global Z-order.
> But is there any way to se...Referencing dates against Products, in order to find the Qty. With out using Column referencing
if i have 1 sheet which has the master data for all customers and then
i have several workbooks with customer sales
B2 Sales Date - this row has every day of the
A3 product B3 is sales Qty
Customer sheet has a similar layout but because this is made from a
pivot table its only based on sales so when it comes to christmas day
when there are no sales i cannot simply do a vlookup using column
references as my data will be out of sync
How do i reference the product and the date ...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
> 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...Unable to Open received PO (change to "change order")
Great Plains will not allow me to change this Purchase Order from Received to
Here is the message I get:
However, if I try to enter a quantity cancelled, I get:
How can I re-open this Purchase Order so I can change the price???
Unfortunately, the pasted messages did not come through.
Once a line item is received, you can change its cost only during invoice
matching. The process would be to return the item; add a new row with the
correct cost; and receive and invoice the new item. Not an elegant solution,
Charles Allen, MVP
&quo...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!
Out of the box Advanced Secuirty does not have any SOD information. Feel
free to contact me with any specific que...Add Mail Merge to Order Entity
is there a way to add the abillity to perform a mail merge to the order
entity like there is on the quote entity?
IE. Print Quote to Customer mail merge on the quote entity.
If so, how can this be done?
It does depend on your requirements but may be this
http://crm.georged.id.au/post/2008/01/18/Poor-man-mail-merge.aspx can help?
CRM Certified Professional - Developer
"William" <William@discussions.microsoft.com> wrote in message
> is there a way to add ...alphabetical order #3
I have 2 worksheets i am working with. I have them pasted together so I only have to type the information in once. The problem I am having is the first sheet is listed alphabetically by name. I want the second sheet to be alphabetically by department. When I sort the second sheet though all I get is ****required field****. What did I do wrong or what didn't I do? Please help me with this.
...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?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
> 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...How to Link Purchase Invoice with Purchase Receipts
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.
PM30200.DOCNMBR = POP30300.VNDDOCNM AND
PM30200.VENDORID = POP30300.VENDORID AND
PM30200.DOCTYPE=1 AND (PM30200.BCHSORCE IN ('Rcvg Trx Ivc','Rcvg Trx
Entry'...[Beta] New Message From: dropdown sort order
This is a multi-part message in MIME format.
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?
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.
Tech Sup...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&...Product Key and Purchased New Office
Operating System: Mac OS X 10.5 (Leopard)
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...problem sorting data, says "this operatioin requires merged cells to be identically sized"
Need help with problem sorting data
Error message says "this operatioin requires merged cells to be
After identically resizing the merged cells (which were in the header
row), I still get this error message.
If the merged cells are only in the header, select your range (avoid the header)
and tell excel that your selection doesn't include headers (at the bottom of
> Need help with problem sorting data
> Error message says "this operatioin requires merged cells to be
> identically sized"
> A...Sales tax & work-orders, back-orders
When I recall work orders or back orders, the sales tax box is not being set,
and therefore sales tax is not being charged unless we catch it before
Am I missing a setting somewhere?
Top Dog Shop
Better (pet) products, naturally
Are you using the same customer to place these items on a BO/WO/etc? Like
Special Order Customer or anything. Make sure that, that customer is set to
"Top Dog" <TopDog@discussions.microsoft.com> wrote in message
When I recall work orders or back order...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!
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
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
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:
>...Printing Multiple Sheets in correct order.
I have a Workbook containing 80 worksheets, I would like to create
buttons that when clicked will print a specified selection of th
The issue I have is that worksheets 6,7,8 are printed with eac
selection, but they must be printed in the correct order.
This order is shown below.
(Button 1) Print Worksheets: 1,2,3,4,5,6,7,8,9,10,11,12
(Button 2) Print Worksheets
(Button 3) Print Worksheets: 27,28,29,30,31,32,*6,7,8,*33,34,35,36,37
(Button 4) Print Worksheets
(Button...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?
Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET: Using SQLite with Enterprise Library 3.1
http://w...Limit purchases of medicines
Is there a way to limit the quantity of a specific item being sold. With all
the regulations of Methamphetamine and other over the counter drugs, my
customer needs to comply with, they can only sell two packages to each
Tim M. Lantz
The only option I can seem to find is checking the box under options for
"quantity entry at POS not allowed" but that doesn't prohibit your cashier
of placing it several times on the screen.
"Tim" <Tim@discussions.microsoft.com> wrote in message
news:A2D17BD6-E774-449E-A571-0546A3E5D632@micr...Creating a new list with Last Order Date
I do have a customer transaction history. I would like to get the
latest order date with amount in to another sheet instead of all the
orders under same account number and bring the rest of the
corresponding info to the other columns. Such as bill to information
for my new sales rep. Can someone help me?
D3=Bill to Name
A2 B2 C2 D2
CA123 1234 10/11/06 $500
CA123 2345 09/10/06 $200