How to Print PO Number and Check Number to GL Trial Balance Detail

Hi,

Can anyone help me to print the PO Number from Purchase Order Entry and 
Check Number from Payables transaction Entry to GL Trial Balance Detail 
report. I've searched some knowledgebase but it doesn't work. can you make me 
that report or can you give me step by step procedure on how to print po 
number and check number. The code i've already check are listed below: Note: 
it doesn't work!
1. 863689
2. 855515
3. 850888

Pls hope for your response
-- 
Jeremy Ayaay
Technical Supervisor
STRC
0
Jher (28)
5/3/2006 3:46:01 AM
greatplains 29623 articles. 6 followers. Follow

2 Replies
1103 Views

Similar Articles

[PageSpeed] 26

You should insert the orginating document number from the Year to Date Table

this will bring up any documents like PO, Invoice and Check

Cheers,

Ems

"Jher" wrote:

> Hi,
> 
> Can anyone help me to print the PO Number from Purchase Order Entry and 
> Check Number from Payables transaction Entry to GL Trial Balance Detail 
> report. I've searched some knowledgebase but it doesn't work. can you make me 
> that report or can you give me step by step procedure on how to print po 
> number and check number. The code i've already check are listed below: Note: 
> it doesn't work!
> 1. 863689
> 2. 855515
> 3. 850888
> 
> Pls hope for your response
> -- 
> Jeremy Ayaay
> Technical Supervisor
> STRC
0
Ems (26)
5/3/2006 3:54:02 AM
Yah, i already done that, but it seems the output is not the check number, 
invoice number are the one that showed up!.
-- 
Jeremy Ayaay
Technical Specialist
STRC


"ems" wrote:

> You should insert the orginating document number from the Year to Date Table
> 
> this will bring up any documents like PO, Invoice and Check
> 
> Cheers,
> 
> Ems
> 
> "Jher" wrote:
> 
> > Hi,
> > 
> > Can anyone help me to print the PO Number from Purchase Order Entry and 
> > Check Number from Payables transaction Entry to GL Trial Balance Detail 
> > report. I've searched some knowledgebase but it doesn't work. can you make me 
> > that report or can you give me step by step procedure on how to print po 
> > number and check number. The code i've already check are listed below: Note: 
> > it doesn't work!
> > 1. 863689
> > 2. 855515
> > 3. 850888
> > 
> > Pls hope for your response
> > -- 
> > Jeremy Ayaay
> > Technical Supervisor
> > STRC
0
Jher (28)
5/3/2006 4:41:02 AM
Reply:

Similar Artilces:

how to uninstall ms publisher after a one week trial?
I have used the control panel software remove facility to get rid of a trial version of ms publisher but it remains in the computer and nothing seems to be able to delete it. Can anyone help please? See: How to uninstall the 2007 Office system if you cannot uninstall it by using the Add or Remove Programs feature http://support.microsoft.com/kb/928218/en-us -- Mary Sauer http://msauer.mvps.org/ "removing an ms publisher trial version" <removing an ms publisher trial version@discussions.microsoft.com> wrote in message news:01C8FA93-917E-4A98-945C-7C3813FFA9F4@microsoft....

How do I find my serial number?
Hi I want to purchase the upgrade from Microsoft Office X to the new 2004 version BUT I cannot find my original install disks with the Serial number on. Is there any way I can discover what my serial number is from the installed software? Cheers. Robin In article <BD842C67.1AB92%robinjackson@mac.com>, Robin Jackson <robinjackson@mac.com> wrote: > I want to purchase the upgrade from Microsoft Office X to the new 2004 > version BUT I cannot find my original install disks with the Serial number > on. > > Is there any way I can discover what my serial number is ...

How do I print a list of the directory contents
I need to print the disk directory contents. In DOS this was possible. Is it possible in WORD? Thanks No - but you could use the freeware Printfolders utility you can download from my web site that will produce a text listing that you can open in Word. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <...

Beginning Balances
We are setting up a database to recreate bank account information for multiple accounts. We want to be able to produce reports queried by our choice of time period that show a beginning balance for that time period, activity for that time period and the ending balance for that time period. We may want to produce one report for all accounts showing this information for a one month period, one quarter period, one year period, or life to date. We may also want a report for each seperate account showing this information. How do you make access calculate an ending balance for any time per...

routing numbers #3
Third time is the charm maybe... How do I change the routing numbers on my accounts in Money 2004? If nobody knows... OK. I just need to know if there is a way! What is this routing number used for? Epay? "Stephen" <guzzetti@xmission.com> wrote in message news:10b6301c3f36c$7ab537a0$a501280a@phx.gbl... > Third time is the charm maybe... > > How do I change the routing numbers on my accounts in > Money 2004? If nobody knows... OK. I just need to know > if there is a way! All accounts have a routing number and account number. The routing number can ...

printing copies
under print options: Number of copies___. It will only print out 1 copy. I say 5 and it still prints out 1. I am a new user of 2007 Excel I suspect the problem is with the printer. Try getting the newest driver best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Val in Texas" <Val in Texas@discussions.microsoft.com> wrote in message news:78A83505-189A-4731-AF25-CD5505E33510@microsoft.com... > under print options: Number of copies___. It will only print out 1 copy. > I > say 5 and it still prints out 1. ...

Ghosted print and print preview
Hello everyone, I have a problem with printing in excel. The print and print preview options appear ghosted. I still can print through the print icon on the toolbar. Any suggestions??? Martin ...

Print Dynamic Range
I have a basic excel template used for ordering parts. It runs from A1:N250 and I can print easily repeating rows 1:11 on each page (contains job details) . Trouble is sometimes there may only be 10 part numbers requiring only first page and I finish up throwing away trees by printing entire sheet! I know I can reset print area each time am setting this up on Sharepoint for multi users and need a macro/button to recognise number of items and print accordingly. Any help greatly appreciated -- Message posted via http://www.officekb.com Sub SetPrintArea() 'change this cons...

TCP/IP printing
Hello, I have a networking question. I have a print device with a static IP address on one network. A computer on another network can connect to the printer (NBT is enabled and so is LPR) and the drivers are installed but cannot print. I know this is correct behavior but want to know in detail why it seems to half work. I am guessing it has to do with port 138,139 and 515 but not positive. Probably a better question to ask a networking forum but hey. Thanks can you access the printer through the printer IP address? -- ashvin :D Just chill -pls post your feedback on...

Number to Text Value
Hey, I have data coming from Access via ODBC with a value of 0 (NO) or 1 (YES) from a tickbox in Access. Is there a way I can covert these 0 & 1's to a text word in excel in another column. 0 = NO or FALSE 1 = YES OR TRUE Thanks in Advance. "=?Utf-8?B?S1lNTw==?=" <KYMO@discussions.microsoft.com> wrote in news:C7FAFC78-67BA-4747-905D-497AF99727DB@microsoft.com: > Hey, > > I have data coming from Access via ODBC with a value of 0 (NO) or 1 > (YES) from a tickbox in Access. > > Is there a way I can covert these 0 & 1's to a text word ...

GL Cross-Reference Report - no results
Trying to use the GL cross-reference report to reprint posting journals but I'm not getting any results. I've checked to confirm that all audit trail codes are marked to allow reprints. In the report options I've tried using open years, historical years, priting by JE range, audit trail, dates, source documents but nothing is returned regardless of the combination. On your report options window, do you have one of the account types checked off under 'Include'. It's on the left side of the window near the top. Kind regards, Leslie "irishjamr&q...

Printing booklet
I am producing a 50 to 60 page booklet using Pubisher 2003. The page format will be using 8.5 x 11 paper folded in half. I need to print both sides of the paper. How do I print the booklet so that I print half the project on one side of the paper and the other half on the back. Will publisher keep track of the pages so that for example; that page 2 and page 50 print on the same side/sheet of paper so when all pages are printed, folded and bound the book reads correctly. Thanks John Houston, Tx more info...I am using a single side printer so I have to run the pages through twice ...

Unable to check auto complete option
I'm using outlook 2002, with service pack 2 runnning on Win2000. The option for me to select the auto complete feature is greyed out, it doesn't allow me to select the option at all. Pls advise! Thanks! Hello Shaun, Have you look under EXTRAS | OPTION | attitudes | ADVANCED E_MAIL OPTIONS ? And there is the point to activate. >-----Original Message----- >I'm using outlook 2002, with service pack 2 runnning on >Win2000. The option for me to select the auto complete >feature is greyed out, it doesn't allow me to select the >option at all. > >Pls adv...

Check printing in GP 7.0
Dear Guys, I have check payments for vendors, where I'm dealing with LOCAL CURRENCY & FORIGHN CURRENCY. When I paid by check in LOCAL CURRENCY then the amount in words prints perfectly but if i paid by check in FORIGN CURRENCY then the amount in word prints in numeric which i want to print amount in words instead of numbers. Please help me to print checks amount in words for FORIGN CURRENCY as well. Your suggestion would be appricated on above issue thnx Shamin ...

Balancing Ckg Acct.?
I converted to MSMoney 2005 from Quicken. I am used to balancing my checking in Qkn by downloading transactions daily, accepting, then click on BALANCE, and it is usually -0- difference, click on YES to reconcile, and all is well with the world. I know the checks that have cleared, have not, and my register balance as well as the actual bank balance. In MONEY, I download transactions, accept them, making sure categories are correct, and then click on BALANCE, and it asks me for a paper statement. I DO NOT GET PAPER Statements. Therefore, I do not know the starting date, ending dat...

Excel BUG (All Versions) Excel Macro Margins using Print Preview
Where can i post this BUG? (Excel Macro Margins using Print Preview) Is there an Excel BUG reporting site? Steps: 1) New worksheet, write something in it 2) Start recording a new macro 3) File -> Print Preview 4) Click on the Margins Button, the page margins will appear, so that you can visually change and move them 5) Set one or more margins 6) Close the Print Preview 7) Stop the Macro What happened is that in the VBA code there will be writtenthe following lines: ..LeftMargin = Application.InchesToPoints(0.91) ..RightMargin = Application.InchesToPoints() Where in second line ther...

"Tiled" print setting.
I just want the page that I designed to print on one page! I can't change the print setting "tiled" and as it is, it's printing on four pages all broken up. It is possible that you have created your document on a paper size that is not supported by your printer. Try changing your paper size to 8 1/2 by 11 and see if the print options are more to your liking. "MissMarple" <MissMarple@discussions.microsoft.com> wrote in message news:A6776BEA-37EE-4645-B389-866A6CDB2D96@microsoft.com... >I just want the page that I designed to print on one ...

CHtmlView and Printing
Hi Everyone, The CHtmlView is giving me alot of head aches. Here is what I am doing. I am opening an XML file (being formatted using XLST) in a hidden CHtmlView and printing it. Here is how the process goes: 1. I create the XML file on the fly. 2. load the XML file in to CHtmlView. 3. Once loaded I tell it to print the resulting HTML page. 4, I need to delete XML file after the printing is done. (this is the problem). I can't figure out how to find out when the CHtmlView is done printing. CHtmlView::OnFilePrint is asynchronous. And CHtmlView doesn't tell me that it is currently p...

Problems with printing
Dear all I have an application, which has been working without problems for the last 7 years. The application has some printing capabilities. Now, we have just gotten a new printer (HP Laserjet CM4370), and when I try to print, my application crashes. The app crashes in the print setup dialog even before I press OK. If I select any other printer as default printer, the app doesn't crash. Then I can show the print setup dialog without problems. But then, when I select the CM4370, the app crashes again, even if I do not press OK. Even if I choose to not show the print setup dialog, and j...

Text vs. Number
Why is is that if I have a tab-deliminated file or csv file that I open in excel the following happens: If the field has twelve digits (a UPC code) -- say 068888701648 -- that when it gets into the Excel spreadsheet is drops the front zero and calls it a number. I don't want that to happen. Also when I export to a csv file I want the field to be a text field -- "068888701648" -- as opposed to a number. This is the reason. What I've been doing up to this point is creating a custom format -- 000000000000 -- twelve digits. Most UPC codes have a zero at...

Printing--How not to Print Bkground
In my wrksht there is a cell range highlighted with an autofill color. We use this to show the user where to enter the data. Is there anyway to avoid printing this background color. We want to keep the color in the cell range in our wrksht but we dont want it printed. Hi Jeff, have you tried Print preview, Setup, Sheet, Black & white? Gilles "Jeff" <anonymous@discussions.microsoft.com> wrote in message news:001201c3ba81$023b8af0$a301280a@phx.gbl... > In my wrksht there is a cell range highlighted with an > autofill color. We use this to show the user where t...

Sales Return with Lot Number
Hi All, I have spent almost 4 days now tryingt o figure out whats wrong, search every document realated to Sales Return , SOP Integration...... but of no help.... I am trying to integrate the Returns in SOP Transaction Entry Screen using Integration Manager. we are running GP10 with SP1. Issue Example: Item No: TEST101 UofMSchedule: EACH UofMSchedule Master Table: EACH = 1 = EACH CASE = 10 = EACH PACK = 20 = EACH I am able to integrate all the items with lot as return Returned Qty = On Hand. if the item UOM = EACH (which is actullay Base UOM). But if the same item is returned in C...

Formula/Macro to tally up numbers in Excel
I have a list of numbers in a column, e.g. :- 1 4 6 1 35 14 15 15 2 1 6 6 1 19 15 5 and want the computer to work out for me, how many times number x has turned up in column B? I presume this is possible with a function/macro within excel fairly easily? Any advice/pointers in the right direction would be appreciated. Please prefably reply in the newsgroup, or via email to "newshelp@the-core.freeserve.co.uk.DELETE", removing the .DELETE from the end of my address. Thanks, Mark Pyne Hi Have a look at COUNTIF() and try something like: =COUNTIF(B:B,1) to count how many 1s there ...

Printing in Vista
After each document prints another sheet prints which has the filename, directory,title, subject, author, creation date, last saved on, total editing time, last printed on. These are just some of the items that print on this one sheet of paper. Can anyone help me? In your Print dialog, uncheck "Document Properties." On Nov 30, 1:34=A0pm, peppermint patty <peppermint pa...@discussions.microsoft.com> wrote: > After each document prints another sheet prints which has the filename, > directory,title, subject, author, creation date, last saved on, total edi= ti...

Access Input Mask for phone number
What is a phone number input mask that would result in the first case 916.723.5828 and second case if 916 is not entered 723.5828 notice the first "." is left off. "Bruce" <Bruce@discussions.microsoft.com> wrote in message news:B4830038-5478-4859-B5AD-70C5311EDF1F@microsoft.com... > What is a phone number input mask that would result in the first case > 916.723.5828 and second case if 916 is not entered 723.5828 notice the > first > "." is left off. "Bruce" <Bruce@discussions.microsoft.com> wrote in message n...