Skip to main content
9 votes

What is a line item? And what is a financial item and how are those two linked together?

The Line Item table is oriented towards the current state of an order's line item. The Financial Item table is oriented towards keeping track of the history of the financial aspects of line items. The ...
Joe Murray's user avatar
  • 6,741
4 votes
Accepted

Search Kit - List of Events with their real total amounts

I think what you want can be accomplished by filtering out transactions with an incomplete status, like this:
Coleman's user avatar
  • 18.6k
3 votes
Accepted

How can I record an offline contribution with multiple line items?

Create a Price Set for contributions pointing to the multiple funds needed. Each fund should have a price of 1.00. You could include additional funds besides the two in question so that the Price Set ...
Allen Hutchison's user avatar
3 votes
Accepted

What is a line item? And what is a financial item and how are those two linked together?

The solution to my question is to use the Order API. The order API does create a contribution, line items and the underlyning financial items etc...
Jaap Jansma - CiviCooP's user avatar
2 votes

What is a line item? And what is a financial item and how are those two linked together?

Let me try to explain: Line item, Financial item First of all both line item and financial item are created based on contribution Line item are created only once and financial items are created ...
Ramesh - ARTECH Consultancy's user avatar
2 votes
Accepted

Changing a recurring contribution with multiple line items

The 1.6.x branch of the iATS extension is using contribution repeattransaction API -> to get the details of the contribution and its line items that need to be repeated; If a recurring contribution ...
KarinG - Semper IT's user avatar
2 votes
Accepted

Can't update extension: "You will not be able to install/upgrade Edit Line Item Extension until you have installed the org.civicrm.afform extension"

Afform is shipped with core and is now automatically enabled. I'd upgrade Civi then try again.
Aidan's user avatar
  • 13.5k
2 votes
Accepted

Contribution has no line_items. Shouldn't that be impossible?

Consensus seems to be: This is not normal behavior. There are no known steps to repro, nor a known cause. I've filed a bug report at https://lab.civicrm.org/dev/core/-/issues/4318 ; hopefully others ...
TwoMice's user avatar
  • 1,814
2 votes

API Explorer DB error: Field 'entity_table' doesn't have a default value

The entity table is mandatory for creating line items, unfortunately, in the API spec for line items, the Entity table is not marked as mandatory. In the recent version of Civi it is also mandatory to ...
Pradeep Nayak's user avatar
2 votes
Accepted

How do you handle searching and reports on contributions with line items from Webform CiviCRM

Have a look at the Extended Report extension It offers new reports like Extended Report - Price Set Line Items
petednz - fuzion's user avatar
  • 28.3k
2 votes
Accepted

Edit Line Item error: Tax for amounts above 999.00 = NaN.N

Fixed by https://github.com/JMAConsulting/biz.jmaconsulting.lineitemedit/pull/42 Thanks for the help of Monish Deb and Joe Murray.
Davy Ivins's user avatar
  • 1,114
2 votes
Accepted

(Part solved) Missing line items on event invoice and confirmation email for Event (using Webform CiviCRM)

I believe this PR by Andrei (who works on the Wordpress/Caldera form integration) may help fix this (Core) issue: https://github.com/civicrm/civicrm-core/pull/13477 It removes bad logic re: ...
KarinG - Semper IT's user avatar
1 vote
Accepted

Random Additional LineItem appearing in a membership sign up form

You may need to run below query to disable the field so that they don't appear on screen. Deleting the field is little risky as you may end up creating screwing financial data. UPDATE ...
Pradeep Nayak's user avatar
1 vote

Changing a recurring contribution with multiple line items

I believe the line item info comes from the FIRST recurring contribution, not the most recent one.
Jon G - Megaphone Tech's user avatar
1 vote

How to show contribution items in CiviReports for Contribution Reports

I believe what you are referring to are line items - if the contributions in question are event contributions, then you can use Extended Report - "Participant Line Items" that will allow you to filter ...
Tamar Meir - Cividesk's user avatar
1 vote

How to use Find Contribution to find folk who Donated via a line item on a Membership Price set

How about using Fuzion's Extended Reports extension - the LineItem one? It's a great Extension 😀
KarinG - Semper IT's user avatar
1 vote

How to use Find Contribution to find folk who Donated via a line item on a Membership Price set

Seems like the old chestnut about storing financial type on contribution, where it originated, vs line item, where it later appeared, leading to the sort of issue you've described. There was talk a ...
davejenx's user avatar
  • 2,365

Only top scored, non community-wiki answers of a minimum length are eligible