Report Problem

[Former Member]

Hi All,

I post a one A/P Invoice as Item. (Ex: I purchased from XX name Vendor - Item is InK for Rs. 10000).

I designed report in Printlay out Designer.

I want Report Like this:-

Debit Credit

XX A/c Dr 10000

To Ink Cr 10000

But in Report Instead of Ink it will came as Good Received but not Invoiced (GRNI) A/c

How to get report i want mentioned above

Clarify

Thanks

Regards,

Balaji

[Former Member]

What tables are you using in your report, what type of report have you designed?

[Former Member]

Hi Gordon

I posted one Good Receipt Purchase Order (GRPO). Vendor Name: XX and Co - Purchased Item is InK Bottle ( I created INK Bottle as Item in Item master Data ).

Based on this GRPO I posted A/P Invoice for this and I Viewed Journal Entry for this A/P Invoice in Accounting Tab -Journal Remarks Field.

Journal Entry Came Like this:-

XX and CO 10000

Good Recieved Not Invoiced (GRNI) Clearing 10000

I Accept above steps are Correct.

But My Account Manager want Journal Report Like this:-

XX and Co 10000

To Ink 10000

Please Clarify how i set report in Printlayout Designer. Instead of Good Recieved Not Invoiced (GRNI) Clearing I want INK.

Thanks

Balaji

Edited by: balaji1980 on Apr 12, 2010 7:16 AM

Edited by: balaji1980 on Apr 12, 2010 7:32 AM

[Former Member]

That is not possible. Item is not an account. It will not be logical to replace an account with any items.

[Former Member]

You may be able to get the report you need using purchaing reports - these are designed to show item / vendor relationships

[Former Member]

Hi Gordon

I posted one Good Receipt Purchase Order (GRPO). Vendor Name: XX and Co - Purchased Item is InK Bottle ( I created INK Bottle as Item in Item master Data ).

Based on this GRPO I posted A/P Invoice for this and I Viewed Journal Entry for this A/P Invoice in Accounting Tab -Journal Remarks Field.

Journal Entry Came Like this:-

XX and CO 10000

Good Recieved Not Invoiced (GRNI) Clearing 10000

Instead of GRNI I want Control Account in Report. Can You tell me how to generate the report like below:-

XX and CO 10000 Cr

Control Account A/c (EX: Purchase for Sales Dept)

Clarify,

Regards

Balaji

Edited by: balaji1980 on Apr 16, 2010 12:35 PM

[kvbalakumar]

Dear Balaji,

PLD is not flexible enough to get these type of reports, instead you can try QPLD or Crystal reports.

Regards,

Bala

[Former Member]

Hi Balaji,

Your question is not very clear to me. How the Ink as an item got an account in the first place?

Thanks,

Gordon