Accumulation register balance does not contain zero balances

Common questions about 1C:Query language, Query builder tool and Data composition schema

#1
People who like this:0Yes/0No
Active user
Rating: 5
Joined: Sep 27, 2011
Company:

I'm trying to create a report for balance of accumulation register, but it looses rows where balance is 0, but there are documents containing those items. What is wrong?

Code
SEL ECT * FR OM AccumulationRegister.MutualSettlements.Balance

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

This behavior is standard. The result will contain rows with non-zero resources. If you need to have all items in the report you need to join Balance to full items list.

 
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.