Expense Report by Contractors

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Jul 20, 2011
Company:

I have a Report for Expenses by Counterparties and Contractors, which looks like the this:
Counterparty 1
- Goods Group 1 Supply Contract: 210
Counterparty 2
- Goods Group 1 Supply Contract: 130

And I would like to have a report looking like that:
Goods Group 1 Supply Contract
- Counterparty 1: 210
- Counterparty 2: 130

How can I implement this? Any ideas? The Data Composition Schema does not want to group contracts and gives the following best result:
Goods Group 1 Supply Contract
- Counterparty 1: 210
Goods Group 1 Supply Contract
- Counterparty 2: 130

 
#2
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Sep 16, 2011
Company: individual

It looks like you've named contracts by activites. And want to use them to group those activities. This is bad idea. Contracts represent actual agreements between your company and counterparties. To make the analytics which you want (GROUP BY Activity, Counterparty) you need to add the activity field to your documents and registers and build the report on that field. If it is urgent you can add it to the Contract catalog and use for reports as a first groupping level instead of the contract itself.

 
#3
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 5, 2012
Company:

I think you have two goods groups with the same name.

 
#4
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 5, 2012
Company:

can you give reference on the demo-base like this: http://apps.1c-dn.com/1cas/#e1cib/app/Report.BalanceSheet

 
#5
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Jul 20, 2011
Company:

Unfortunately I can not yet.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.