• Projects 23
  • Rating 4.9
  • Rating 4 846

Budget: 700 UAH Deadline: 1 day

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?

  • Projects -
  • Rating -
  • Rating 308

Budget: 1000 UAH Deadline: 1 day

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?

Current freelance projects in the category Content Management Systems

11:47
11:24
14 July
13 July
11 July