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:
&...Multiple Formula Custom Formatting
I was recently challenged to create a formula that displays two values
separated by a slash in the same cell. For example A1=40 and B2= 10. C3
displays [30 / .75]. The difference between the two, and what should be the
percentage. The formula I put together is =(A1-B2)&" / "&((A1-B2)/A1).
The formula works but I can not get the second value to format as a %, it
only displays as a decimal. Does anyone know how I can make the second value
display as a percentage without messing up the formatting of the first value?
Any advice would be much appreciated.
...header.htm automatically generated for emails
Okay, I'm pretty frustrated right now. I had to do a full install of a new
operating system (Vista Business) earlier this month that was previously an
Windows XP system. That also forced me to reinstall all of my applications
(in some cases new versions). which also included reinstalling Office 2003
Pro. Of course nothing works the same any more. Upgrades will not install
because of some obsecure Error Code 779. (separate issue and unresolved.)
The newest problem is that all of my emails now generate an xmlns file that
either adds a bunch of lines drawn at the bottom, or worse,...junk mail and multiple mailboxes
I've have a user who checks 2 mailboxes other than her
own. I've enabled the junk mail filter, but it seems to
work only for her own mailbox. I don't want to create a
bunch of rules; Outlook does a good enough job of
filtering messages. Is it possible to have it filter the
other 2 mailboxes as well?
Her computer is using Outlook 2003 on an Exchange 2003
rosanna <firstname.lastname@example.org> wrote:
> I've have a user who checks 2 mailboxes other than her
> own. I've enabled the junk mail filter, but it seems to
> ...sumproduct 2 criterias, multiple tabs
i need sumproduct to validate two things for it to produce a sum
1. needs to look at all tabs (001-013) and see if the month actually
has a value and if it matches the value in D8
2. needs to again look at all tabs and look at range $C$24:$C$37 has a
value and match it to the range in B55:B78
3. if date & code match, produce the sum
Month(H:6) = Date
C24:C37 = Code match
J24:J37 = Total Value of that code
Where the formual will sit (range C55:N78)
B55:B78 = Code the tabs will validate against
C8:N8 = Month(Date) of which the tabs will validate against
i have t...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...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...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
If you set up a Mix and Match quantity discount there seems to be a problem
when doing returns! If the person meets the quantity they receive the special
Mix and Match discount price but when doing a return for the same items that
also meet the Mix and Match they receive a return for the full price of the
items. Not a profitable set-up!
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, follow this
lin...Outlook.exe has generated error messages and Closed by Windows
I did a search and came up with a thread with this subject(Outlook.exe
has generated error messages and will be Closed by Windows) and did as
I was told Detect and Repair,scan hard disk and defragment it but it
did not help. Also I did as told here
None of the suggestions helped. After about 45 seconds Outlook gives me
the message and closes. I am using outlook 2k on win 2k machine.
I would appreciate any help.
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...cppying multiple cells using left cell only
when copying multiple cells to another position or another
sheet, the upper left hand cell will not paste all the
other cells to the new position
Are there any hidden rows and columns that are getting those new values?
> when copying multiple cells to another position or another
> sheet, the upper left hand cell will not paste all the
> other cells to the new position
...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...Printing multiple columns on one page
I have 40 rows of data 52 columns wide. First row are the dates of each
Sunday of the year. Remaining rows are data. How can I print each row of
data with the dates on separate pages? Would like to have each row of dates
and data fit on one page.
Choose File/Page Setup/Sheet and enter A:A in the Columns to keep at
Insert Select each column (C:AZ) and insert a page break between each
In article <D75E4E90-73D0-4DA8-964E-62EFC4C25104@microsoft.com>,
tdj <email@example.com> wrote:
> I have 40 rows of data 52 colu...Multiple-level category labels
I know excel can do it.. I have seen some examples... but
how do I set up my chart to do it. I have one column with a
date and one column with the hour of the day and the third
is the value I want to plot.
My data looks like this.
Date Hour Value
9/17/03 20 1694
9/17/03 21 11
9/17/03 22 11
9/17/03 23 10
9/18/03 0 8
9/18/03 1 10
9/18/03 2 12
9/18/03 3 8
9/18/03 4 9
9/18/03 5 8
9/18/03 6 10
9/18/03 7 8
9/18/03 8 8
9/18/03 9 10
9/18/03 10 14
9/18/03 11 12
9/18/03 12 8
9/18/03 13 8
9/18/03 14 6
9/18/03 15 3
9/18/03 16 6
9/18/03 17 6
9/18/03 18 7
9/18/03 19 185
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 ...Find/Filter multiple non unique list
I'm trying to figure out the quickest way to search a column for a lis
of values and the answer may not always be exact.
For example, within a column, I want to find if there are any of a lis
companies (ABC, IBM, Sears, XYZ, etc.). Those companies may be liste
there, but not exact. For example, there may be ABC Inc. or AB
Corporation. This is a routine search that is needed to be done.
When I use vlookup, I can only do exact matches. Any ideas on how t
do this quickly? It would save a lot of people a lot of time.
Thank you for any help
Message posted from http://www.ExcelForum...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:
>...Multiple calendars in Outllok
We view 10 public calendars side-by-side and it's been great. But
suddenly the words 'in Public Folder' starred being added to the
calendar title, so 'M.Smith' became 'M.Smith in Public Folder'. It may
not sound like much, but since the full column title is centered, we
can not longer see the users names - all we see is 'h in Public F' or
something like that. One minute it was fine, next it appended the
Any ideas how to go back to just the Calendar title?
...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...Multiple Page Layouts
I would like to use different layouts on pages that I have added. Is that
possible? I try and click on the layout panel on the left side but it is grey.
Open a new instance of Publisher, find the layout you want for another page, copy and
paste it to your project.
Mary Sauer MSFT MVP
"Wally" <Wally@discussions.microsoft.com> wrote in message
>I would like to use different layouts on pages that I have added. Is that
> possible...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...Multiple criteria for countif()
Is there some method to use countif for multiple criteria instead of
adding several single-criteria countif's together?
Message posted from http://www.ExcelForum.com/
We generally use SUMPRODUCT to count rows meeting conditions.
mvpearl omitthisword at verizon period net
"theillknight >" <<firstname.lastname@example.org> wrote in
message news:theillknight.1askww@excelforum...Multiple Currencies #3
I have recenly moved to Europe and now have Euro and US Dollar accounts. How
do I manage this. Can somebody guide me in the right direction ?
In microsoft.public.money, Bartcelona wrote:
>I have recenly moved to Europe and now have Euro and US Dollar accounts. How
>do I manage this. Can somebody guide me in the right direction ?
I don't know, but I think I can guide you to those who do:
http://groups.google.com/groups?as_q=base.currency+account+money&num=50&as_scoring=d&hl=en&btnG=Google+Search&as_epq=&as_oq=conversion+rate&as_eq=google&as_ugroup...Multiple Data Migrations
We have our initial information in CRM. Can we do more
data migrations of new accounts and products with our
current CRM data intact so that it will just append to
what we have out there?
Yes, according to the documentation, the DMF always
>We have our initial information in CRM. Can we do more
>data migrations of new accounts and products with our
>current CRM data intact so that it will just append to
>what we have out there?
Yes and No - if you already have the Accounts and
Products in CRM you...