Method:Classic General Q&A

Re: What is the role of the "LineGroupRecordID" field?

Anonymous — Fri, 24 Feb 2012 21:58:27 GMT

Hi smohyee,

That is correct.

Ronen

Re: What is the role of the "LineGroupRecordID" field?

smohyee — Fri, 24 Feb 2012 21:46:23 GMT

Ah, I see, it's referring to the same "Item Group" that you can create in QB. I believe in QB it also lists the group item as a separate line item.

Thanks for the quick response!

Re: What is the role of the "LineGroupRecordID" field?

Anonymous — Fri, 24 Feb 2012 21:04:15 GMT

Hi smohyee,

Just wanted to give you an update for the SalesOrderLineGroupRecordID. The group item will still be shown on the sales order as a separate line item. This is also applicable to the invoice for the InvoiceLineGroupRecordID.

The group item in both cases is used to link a group of individual items that are related to each other.

I hope that this helps.

Ronen

Re: What is the role of the "LineGroupRecordID" field?

Anonymous — Fri, 24 Feb 2012 20:26:21 GMT

Hi smohyee,

The SalesOrderLineGroupRecordID represents the item group that you have created which represents several individual records IDs that you would not like to place individually on a sales order.

This is also applicable to the invoice and its InvoiceLineGroupRecordID.

I hope that this helps.

Ronen

What is the role of the "LineGroupRecordID" field?

smohyee — Fri, 24 Feb 2012 18:20:47 GMT

In line item tables, such as SalesOrderLineItems or InvoiceLineItems, there are several RecordID fields.

First, there is just the RecordID, which I assume is the ID of the individual line.

Second, there is SalesOrderRecordID (or the Invoice equivalent), which associates a line item with a given Sales Order.

There are a few other record id fields for classes, items, etc, which all make sense to me.

Then, there is the SalesOrderLineGroupRecordID, and I'm unclear what the purpose of this field is. I see it being used in the SalesOrder->Invoice screen, along with some notion of "child" groups. Unfortunately, the short explanations in the action set doesn't clarify it for me, and I can't find any documentation describing the role of default fields. Can you clarify how and why line items are "grouped"?