Adjust the report work in BAS

Good day.

I have reviewed the task description. The problem is clear - the items from the supplier's order that are linked to the buyer's order but are missing from the buyer's order do not appear in the report.

The likely reason is in the logic of the report query or the type of table join. I will be able to adjust the query so that all item positions from the supplier's orders related to the buyer's order are included in the report.

Please let me know:

What configuration of BAS is being used?
…
Is there access to the configurator for editing the report?

Show original

Translate

Good afternoon.

I have studied the description of the problem with the report "Data on Orders - Cost" — the situation is clear.

The essence of the problem: positions from supplier orders that are not in the customer order do not appear in the report, although the documents are correctly linked. Most likely, the issue is with the type of join in the query — this can be resolved by replacing it with a LEFT JOIN or adding a separate selection branch.

To prepare a ready solution, I need to clarify a few points:
1. What configuration of 1C is being used (UT, ERP, UNF, or custom)?
2. Is the report standard or has it been modified?
… 3. Can you send the text of the query from the CKD?
4. Is there a test database for checking changes?

As soon as I receive the answers — I will prepare the correction. This is a small task, I think we can resolve it quickly.

Show original

Translate