Purchase order Formatting.

Is there any where I can download new purchase order formats? I don't need 
the tax colum and I would like to shift some of hte columns around as well as 
a line item column. So that I can quickly identify problems with number of 
hte item placed obviously sequential numbers.
0
PeterLiu (19)
1/14/2005 11:43:03 PM
pos 14173 articles. 0 followers. Follow

7 Replies
273 Views

Similar Articles

[PageSpeed] 0

Hi peter,

Currently I'm working on the exact same thing.  I'll try to get some help as 
well and post back to you if I do.  I'm also trying to remove the tax colum 
and shift some of the columns around as well as adding a vendor client number 
and add the time the PO was created.

Good Luck.

"Peter Liu" wrote:

> Is there any where I can download new purchase order formats? I don't need 
> the tax colum and I would like to shift some of hte columns around as well as 
> a line item column. So that I can quickly identify problems with number of 
> hte item placed obviously sequential numbers.
0
yaniv966 (52)
1/15/2005 7:31:01 PM
there should be some Report templates in the Customer Source, otherwise you
can use a text editor or FrontPage to edit the PO.xml file directly.  After
looking at the format it is quite easy to modify.  Always back up before
modding.




"Peter Liu" <PeterLiu@discussions.microsoft.com> wrote in message
news:7DC9BFF5-EC05-4A46-A85C-9C52035C08BC@microsoft.com...
> Is there any where I can download new purchase order formats? I don't need
> the tax colum and I would like to shift some of hte columns around as well
as
> a line item column. So that I can quickly identify problems with number of
> hte item placed obviously sequential numbers.


0
anonymous (74717)
1/15/2005 7:44:56 PM
Hi,

Can you explain to me what do you mean by Customer Source?

I was looking at the PO.xml and you right it can be easily read and 
understood.  I still need some help in changing things around and adding 
different variables but it sure does help.  

Would you know what the variable for the time of the PO release would be?  I 
would like to replace it with the PurchaseOrder.Requisitioner variable.  Last 
I would also need the variable for the Custom Text 1 field in the additional 
tab for the suppliers properties window in manager.  This why I can add the 
cstomer number the supplier assigned to my client and included in the PO 
order.

Thanks again

"root" wrote:

> there should be some Report templates in the Customer Source, otherwise you
> can use a text editor or FrontPage to edit the PO.xml file directly.  After
> looking at the format it is quite easy to modify.  Always back up before
> modding.
> 
> 
> 
> 
> "Peter Liu" <PeterLiu@discussions.microsoft.com> wrote in message
> news:7DC9BFF5-EC05-4A46-A85C-9C52035C08BC@microsoft.com...
> > Is there any where I can download new purchase order formats? I don't need
> > the tax colum and I would like to shift some of hte columns around as well
> as
> > a line item column. So that I can quickly identify problems with number of
> > hte item placed obviously sequential numbers.
> 
> 
> 
0
yaniv966 (52)
1/17/2005 8:05:05 AM
Yaniv, here's the variables that you wanted, I listed all 4 dates for,
PurchaseOrder you pick the one that you need.

PurchaseOrder.DateCreated
PurchaseOrder.DatePlaced
PurchaseOrder.RequiredDate
PurchaseOrder.LastUpdated

Supplier.CustomText1

Moe

0
1/17/2005 12:10:57 PM
Yaniv,

Howz the reformating going It would take me forever to reformat and if you 
can share your po.xml that would much appreciated.
-Peter 

"Yaniv Zahavi" wrote:

> Hi,
> 
> Can you explain to me what do you mean by Customer Source?
> 
> I was looking at the PO.xml and you right it can be easily read and 
> understood.  I still need some help in changing things around and adding 
> different variables but it sure does help.  
> 
> Would you know what the variable for the time of the PO release would be?  I 
> would like to replace it with the PurchaseOrder.Requisitioner variable.  Last 
> I would also need the variable for the Custom Text 1 field in the additional 
> tab for the suppliers properties window in manager.  This why I can add the 
> cstomer number the supplier assigned to my client and included in the PO 
> order.
> 
> Thanks again
> 
> "root" wrote:
> 
> > there should be some Report templates in the Customer Source, otherwise you
> > can use a text editor or FrontPage to edit the PO.xml file directly.  After
> > looking at the format it is quite easy to modify.  Always back up before
> > modding.
> > 
> > 
> > 
> > 
> > "Peter Liu" <PeterLiu@discussions.microsoft.com> wrote in message
> > news:7DC9BFF5-EC05-4A46-A85C-9C52035C08BC@microsoft.com...
> > > Is there any where I can download new purchase order formats? I don't need
> > > the tax colum and I would like to shift some of hte columns around as well
> > as
> > > a line item column. So that I can quickly identify problems with number of
> > > hte item placed obviously sequential numbers.
> > 
> > 
> > 
0
PeterLiu (19)
1/17/2005 7:25:06 PM
I will be happy to share my PO.xml with you as soon as I'm done with it.  I 
have done everything I wanted to do except two more things that I'm stuck on. 
 I'm trying to see if there is a why to include the time the PO was created 
(not just the date), and how can I insert the supplier account number in the 
PO.

"Peter Liu" wrote:

> Yaniv,
> 
> Howz the reformating going It would take me forever to reformat and if you 
> can share your po.xml that would much appreciated.
> -Peter 
> 
> "Yaniv Zahavi" wrote:
> 
> > Hi,
> > 
> > Can you explain to me what do you mean by Customer Source?
> > 
> > I was looking at the PO.xml and you right it can be easily read and 
> > understood.  I still need some help in changing things around and adding 
> > different variables but it sure does help.  
> > 
> > Would you know what the variable for the time of the PO release would be?  I 
> > would like to replace it with the PurchaseOrder.Requisitioner variable.  Last 
> > I would also need the variable for the Custom Text 1 field in the additional 
> > tab for the suppliers properties window in manager.  This why I can add the 
> > cstomer number the supplier assigned to my client and included in the PO 
> > order.
> > 
> > Thanks again
> > 
> > "root" wrote:
> > 
> > > there should be some Report templates in the Customer Source, otherwise you
> > > can use a text editor or FrontPage to edit the PO.xml file directly.  After
> > > looking at the format it is quite easy to modify.  Always back up before
> > > modding.
> > > 
> > > 
> > > 
> > > 
> > > "Peter Liu" <PeterLiu@discussions.microsoft.com> wrote in message
> > > news:7DC9BFF5-EC05-4A46-A85C-9C52035C08BC@microsoft.com...
> > > > Is there any where I can download new purchase order formats? I don't need
> > > > the tax colum and I would like to shift some of hte columns around as well
> > > as
> > > > a line item column. So that I can quickly identify problems with number of
> > > > hte item placed obviously sequential numbers.
> > > 
> > > 
> > > 
0
yaniv966 (52)
1/19/2005 3:33:05 PM
Can Someone tell me the variable to use so that I can come up with line item 
number that would just be sequential?

"Peter Liu" wrote:

> Anyway you can give me a copy of the file without those features. I just 
> wanted the original features I mentioned
> "Is there any where I can download new purchase order formats? I don't need
> the tax colum and I would like to shift some of hte columns around as well as
> a line item column. So that I can quickly identify problems with number of
> hte item placed obviously sequential numbers."
> First column line item number
> second column order number
> third lookupcode
> fourth description
> fifth unit price
> sixth total 
0
PeterLiu (19)
1/21/2005 6:29:05 PM
Reply:

Similar Artilces:

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: &...

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 www.stfx.ca/people/bliengme remove caps from email "devilchild" <devilchild@discussions.microsoft.com> wrote in message news:CF046202-7A02-4723-BCBF-79B11880CFB5@microsoft.com... > ...

Plot order
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? Hi, 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 Cheers Andy anonymous@discussions.microsoft.com wrote: > 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! Trish 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 "Number". 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. Hi James! 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 Master sheet B2 Sales Date - this row has every day of the year A3 product B3 is sales Qty 1 1 2 55 3 55 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 active windows? Bob wrote: > 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 Change Order: 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??? Thank you. 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, for sure. -- Charles Allen, MVP &quo...

Number Format #10
Hello 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. Thank you J 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 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...

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 enabled. It is up to you to decide which are to be locked or unlocked when the sheet is protected. 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? -- George Doubinski CRM Certified Professional - Developer Blog: http://crm.georged.id.au/ "William" <William@discussions.microsoft.com> wrote in message news:D3F44CE0-DCF1-4E4E-BD5A-5871237FB4B6@microsoft.com... > 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! Hi Maatthias, 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? 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...

Need an Add-on to view messages in plain old text format
Hi, 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" <nobody@cox.net> wrote: >Hi, > >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. ------=_NextPart_000_0113_01CB418F.8651D5F0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Q2FuIGFueW9uZSB3aXRoIGxvdHMgb2YgYWNjb3VudHMgY29uZmlybSB0aGF0DQooYSkgdGhlIGxp c3Qgb2YgRnJvbSBhZGRyZXNzZXMgaW4gdGhlIG1lc3NhZ2UgY29tcG9zZSB3aW5kb3cgZHJvcGRv d24gaXMgbm93IHNvcnRlZCBieSAoZG9tYWluKSh0bGQpKHVzZXJuYW1lKT8gSW4gdGhlIGN1cnJl bnQgcmVsZWFzZSAodi4xNCkgYW5kIGVhcmxpZXIsIHRoaXMgbGlzdCB3YXMgc29ydGVkIGJ5IGFj Y291bnQgbmFtZS4NCihiKSB0aGUgb3JkZXIgb2YgYWNjb3VudHMgYmVpbmcgc3luY2hyb25pemVk IGlzIHN0aWxsIGFscGhhYmV0a...

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'...

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...

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...

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: column A <b>abc rugs<br>colors:red, blue<br> size: 2 column B colors:red:1:1:0:|colors:blue:2:0:0: ...