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.
...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...Conditional Formatting #65
I have a date cell that I need to apply conditional formatting to when
the date is now one year later.
Example: A4 contains the date 1/1/2007 and today's date is in cell F2
with the formula [TODAY()]. If cell A4 is one year in the past I'd
like the font to change so I'll know that date is older than one year
from today's date.
Thanks for any help!
On Apr 10, 9:43=A0am, Trish <trish....@gmail.com> wrote:
> I have a date cell that I need to apply conditional formatting to when
> the date is now one year later.
> Example: A4 contains the date 1/1/2007 ...Formatting Worksheet Rows
Is it possible to format every other row to be shaded -
then when adding a row in the middle of the document it
would reset the all rows following to reset to every other
row being white and every other row shaded
> Is it possible to format every other row to be shaded -
> then when adding a row in the middle of the document it
> would reset the all rows following to reset to every other
> row being white and every other row shaded
If I understand the requirement correctly, one way would be to use
Format >> Conditional formatting
with the formula condition
=MOD(...Built-in Number Format "#,##0_);(#,##0)"
I want to display my negative numbers in parentheses and should be able to
use one of the built-in number formats.
I select (Format > Cells)(Number tab) and in the category listbox, select
The last two items in the Negative numbers listbox do not have parentheses.
The built-in number format that should contain parentheses,
"#,##0_);(#,##0)" has actually changed to "#,##0_);(#,##0)"
Has anyone seen this before ?
I could create a custom number format but this should be built-in.
You'll get the last two number options to include ()...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 ...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...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...Number Format #10
I've got a large spreadsheet which was imported. Apart from the first 2
columns, the rows consist of number which I need to filter, but this isn't
working. Then I noticed an apostrophe before each number in every cell,
which doesn't show in the cell but up in the formula/text bar.
I've set all the columns to numbers but the apostrophe won't go away.
Please can someone tell me how I can without having to go into each cell as
there are hundreds.
Select all the columns with these "numbers" in them, then right click the
tab at the bottom of 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...Lock the format
I have a spreadsheet that I need others to update with values. I want them
to be able to enter text, but not modify the formatting (column width, font,
etc). They may need to add additional rows, though. But still do not want
them to be able to modify the format of those new rows. Seems like I should
be able to do this, but I can't figure out how. Thanks in advance.
By default all cells in a worksheet are locked when sheet protection is
It is up to you to decide which are to be locked or unlocked when the sheet
Format>Cells>Protection is where you w...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 ...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...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.
...Conditional Formats Date Based
I need to format a row in a workbook so that the cells in the range change
color based on a date on another workbook. It needs to be formatted so that
when a certain date ie 12/1/09 is reached, the color changes to green, but is
yellow or red if it's later than 12/1/09 like 3/1/09 depending on what's
entered in the worksheet.
It's best to assign a cell outside your print area to equal the date in the
other workbook, then give that cell a name (like "EffectiveDate"). Then in
your conditional format you can use <EffectiveDate or <=EffectiveDate.
...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...Need an Add-on to view messages in plain old text format
I am looking for an Add-on for Outlook 2002/XP to view messages in their
original text format, including the headers. In Outlook Express, you could
turn off the Preview Pane and use Right
Click-->Properties-->Details-->Message Source, to view the message in its
non-HTML form. Is there an Add-on for Outlook that let you do this?
On Sat, 6 Aug 2005 09:10:05 -0400, "Someone" <firstname.lastname@example.org> wrote:
>I am looking for an Add-on for Outlook 2002/XP to view messages in their
>original text format, including the headers. In Outlook Express, yo...[Beta] New Message From: dropdown sort order
This is a multi-part message in MIME format.
IGlzIHN0aWxsIGFscGhhYmV0a...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'...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?
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...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...conditional formatting #18
how can accomlish this task? When I type text in column A, it appears in
column B automatically in the following format, see below:
<b>abc rugs<br>colors:red, blue<br> size: 2