Blank Fields in Cash Disbursements Journal

[longbow]

While viewing the Cash Disbursements Journal, I clicked on the "Options" button. In the little box which appeared, I selected the "Fields" tab. I then placed checkmarks under the "Show" column for the following Fields:

Item ID
Item Description
Description for Sales
Description for Purchases

When I clicked "OK", I was returned to the Cash Disbursements Journal. Now the Journal has new columns, with the headings of the above checked categories, but the columns contain no data.

How do I get the data to appear in these columns?

Thanks!

[Markr1306]

Originally posted by longbow
While viewing the Cash Disbursements Journal, I clicked on the "Options" button. In the little box which appeared, I selected the "Fields" tab. I then placed checkmarks under the "Show" column for the following Fields:

Item ID
Item Description
Description for Sales
Description for Purchases

When I clicked "OK", I was returned to the Cash Disbursements Journal. Now the Journal has new columns, with the headings of the above checked categories, but the columns contain no data.

How do I get the data to appear in these columns?

Thanks!

Those items really pertain to Inventory, so why do you need them on Cash Disbursements.

You whould have to enter the item id when paying an invoice using the apply to expenses screen to get any infor to appear

Are you on a cash basis ?

[longbow]

Thanks for the reply, Mark.

Actually, I was hoping to be able to hijack those fields & use them to display other data (GL expense account No. for A/P Purchases)

Since those fields are only available in the "Apply to Expenses" tab (I.E Cash Basis), I guess I'll have to take the plunge & upgrade to Premium, so as to have access to Crystal Reports.

[Markr1306]

Originally posted by longbow
Thanks for the reply, Mark.

Actually, I was hoping to be able to hijack those fields & use them to display other data (GL expense account No. for A/P Purchases)

Since those fields are only available in the "Apply to Expenses" tab (I.E Cash Basis), I guess I'll have to take the plunge & upgrade to Premium, so as to have access to Crystal Reports.

Well When I run a CD report I click go to the report order drop down menu to run it by GL account ID then I check off the box which says run in Summary format and I get a report of CD by GL account. I then run a PJ summary by GL account and use and downlaod both to an excell spreasdsheet to see all my Purchases and CD by GL account for each month I then use it in a statement of cash receipts and disbursements. which I use a line called inc/dec in AP to adj to true cash disb

[longbow]

Hmmm... I'm a bit confused by the gramatical structure of this reply.. It seems as though you're advising me to run a CD report "By GL account". This doesn't appear to be an option in Peachtree Complete 2003.

In any event, the GL account for an A/P purchase in an accrual company will always be the A/P account, not the expense account for the item.

If I dump the CD report & the PJ into Excel, I can jump through some hoops & maybe get what I'm after. I think I'll just set up Crystal Reoprts to display the info I need. Any Comments?