GL Distribution (Window ID-323)

From iDempiere en

Table of Contents

Window: GL Distribution

Description: General Ledger Distribution

Help: If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines. The distribution is a one-step operation based on the percentage of the lines.

Tab: Distribution

Description: General Ledger Distribution

Help: If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines. The distribution is prorated based on the percentage of the lines. If the total percent is less then 100 and one line is 0 (null), it gets the remainder. If there is no line with 0, any rounding is adjusted in the line with the biggest amount.

GL Distribution - Distribution - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. GL_Distribution.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. GL_Distribution.AD_Org_ID
numeric(10)
Table Direct
Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. GL_Distribution.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. GL_Distribution.Description
character varying(255)
String
Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. GL_Distribution.Help
character varying(2000)
Text
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

GL_Distribution.IsActive
character(1)
Yes-No
Sequence Method of ordering records; lowest number comes first The Sequence indicates the order of records GL_Distribution.SeqNo
numeric(10)
Integer
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar GL_Distribution.C_AcctSchema_ID
numeric(10)
Table Direct
Create Reversal Indicates that reversal movement will be created, if disabled the original movement will be deleted. GL_Distribution.IsCreateReversal
character(1)
Yes-No
PostingType The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. GL_Distribution.PostingType
character(1)
List
Document Type Document type or rules The Document Type determines document sequence and processing rules GL_Distribution.C_DocType_ID
numeric(10)
Table Direct
Valid from Valid from including this date (first day) The Valid From date indicates the first day of a date range GL_Distribution.ValidFrom
timestamp without time zone
Date
Valid to Valid to including this date (last day) The Valid To date indicates the last day of a date range GL_Distribution.ValidTo
timestamp without time zone
Date
Any Organization Match any value of the Organization segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyOrg
character(1)
Yes-No
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. GL_Distribution.Org_ID
numeric(10)
Table
Any Account Match any value of the Account segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyAcct
character(1)
Yes-No
Account Account used The (natural) account used GL_Distribution.Account_ID
numeric(10)
Search
Any Activity Match any value of the Activity segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyActivity
character(1)
Yes-No
Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing GL_Distribution.C_Activity_ID
numeric(10)
Table Direct
Any Product Match any value of the Product segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyProduct
character(1)
Yes-No
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. GL_Distribution.M_Product_ID
numeric(10)
Search
Any Bus.Partner Match any value of the Business Partner segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyBPartner
character(1)
Yes-No
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson GL_Distribution.C_BPartner_ID
numeric(10)
Search
Any Project Match any value of the Project segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyProject
character(1)
Yes-No
Project Financial Project A Project allows you to track and control internal or external activities. GL_Distribution.C_Project_ID
numeric(10)
Search
Any Campaign Match any value of the Campaign segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyCampaign
character(1)
Yes-No
Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. GL_Distribution.C_Campaign_ID
numeric(10)
Table Direct
Any Location From Match any value of the Location From segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyLocFrom
character(1)
Yes-No
Location From Location that inventory was moved from The Location From indicates the location that a product was moved from. GL_Distribution.C_LocFrom_ID
numeric(10)
Table
Any Location To Match any value of the Location To segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyLocTo
character(1)
Yes-No
Location To Location that inventory was moved to The Location To indicates the location that a product was moved to. GL_Distribution.C_LocTo_ID
numeric(10)
Table
Any Sales Region Match any value of the Sales Region segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnySalesRegion
character(1)
Yes-No
Sales Region Sales coverage region The Sales Region indicates a specific area of sales coverage. GL_Distribution.C_SalesRegion_ID
numeric(10)
Table Direct
Any Trx Organization Match any value of the Transaction Organization segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyOrgTrx
character(1)
Yes-No
Trx Organization Performing or initiating organization The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. GL_Distribution.AD_OrgTrx_ID
numeric(10)
Table
Any User 1 Match any value of the User 1 segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyUser1
character(1)
Yes-No
User Element List 1 User defined list element #1 The user defined element displays the optional elements that have been defined for this account combination. GL_Distribution.User1_ID
numeric(10)
Search
Any User 2 Match any value of the User 2 segment If selected, any value of the account segment will match. If not selected, but no value of the accounting segment is selected, the matched value must be null (i.e. not defined). GL_Distribution.AnyUser2
character(1)
Yes-No
User Element List 2 User defined list element #2 The user defined element displays the optional elements that have been defined for this account combination. GL_Distribution.User2_ID
numeric(10)
Search
Total Percent Sum of the Percent details GL_Distribution.PercentTotal
numeric
Number
Valid Element is valid The element passed the validation check GL_Distribution.IsValid
character(1)
Yes-No
Verify Verify GL Distribution GL_Distribution.Processing
character(1)
Button

Tab: Line

Description: General Ledger Distribution Target Line

Help: If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines. The distribution is prorated based on the perecent value of the lines. A Percent value of 0 (null) indicates the remainder to 100. There can only be one line with 0 percent.

GL Distribution - Line - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. GL_DistributionLine.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. GL_DistributionLine.AD_Org_ID
numeric(10)
Table Direct
GL Distribution General Ledger Distribution If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines. The distribution is prorated based on the ratio of the lines. The distribution must be valid to be used. GL_DistributionLine.GL_Distribution_ID
numeric(10)
Table Direct
Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. GL_DistributionLine.Line
numeric(10)
Integer
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

GL_DistributionLine.IsActive
character(1)
Yes-No
Description Optional short description of the record A description is limited to 255 characters. GL_DistributionLine.Description
character varying(255)
String
Percent Percentage The Percent indicates the percentage used. GL_DistributionLine.Percent
numeric
Number
Overwrite Organization Overwrite the account segment Organization with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteOrg
character(1)
Yes-No
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. GL_DistributionLine.Org_ID
numeric(10)
Table
Overwrite Account Overwrite the account segment Account with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteAcct
character(1)
Yes-No
Account Account used The (natural) account used GL_DistributionLine.Account_ID
numeric(10)
Search
Overwrite Activity Overwrite the account segment Activity with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteActivity
character(1)
Yes-No
Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing GL_DistributionLine.C_Activity_ID
numeric(10)
Table Direct
Overwrite Product Overwrite the account segment Product with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteProduct
character(1)
Yes-No
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. GL_DistributionLine.M_Product_ID
numeric(10)
Search
Overwrite Bus.Partner Overwrite the account segment Business Partner with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteBPartner
character(1)
Yes-No
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson GL_DistributionLine.C_BPartner_ID
numeric(10)
Search
Overwrite Project Overwrite the account segment Project with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteProject
character(1)
Yes-No
Project Financial Project A Project allows you to track and control internal or external activities. GL_DistributionLine.C_Project_ID
numeric(10)
Table Direct
Overwrite Campaign Overwrite the account segment Campaign with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteCampaign
character(1)
Yes-No
Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. GL_DistributionLine.C_Campaign_ID
numeric(10)
Table Direct
Overwrite Location From Overwrite the account segment Location From with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteLocFrom
character(1)
Yes-No
Location From Location that inventory was moved from The Location From indicates the location that a product was moved from. GL_DistributionLine.C_LocFrom_ID
numeric(10)
Table
Overwrite Location To Overwrite the account segment Location From with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteLocTo
character(1)
Yes-No
Location To Location that inventory was moved to The Location To indicates the location that a product was moved to. GL_DistributionLine.C_LocTo_ID
numeric(10)
Table
Overwrite Sales Region Overwrite the account segment Sales Region with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteSalesRegion
character(1)
Yes-No
Sales Region Sales coverage region The Sales Region indicates a specific area of sales coverage. GL_DistributionLine.C_SalesRegion_ID
numeric(10)
Table Direct
Overwrite Trx Organuzation Overwrite the account segment Transaction Organization with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteOrgTrx
character(1)
Yes-No
Trx Organization Performing or initiating organization The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. GL_DistributionLine.AD_OrgTrx_ID
numeric(10)
Table
Overwrite User1 Overwrite the account segment User 1 with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteUser1
character(1)
Yes-No
User Element List 1 User defined list element #1 The user defined element displays the optional elements that have been defined for this account combination. GL_DistributionLine.User1_ID
numeric(10)
Search
Overwrite User2 Overwrite the account segment User 2 with the value specified If not overwritten, the value of the original account combination is used. If selected, but not specified, the segment is set to null. GL_DistributionLine.OverwriteUser2
character(1)
Yes-No
User Element List 2 User defined list element #2 The user defined element displays the optional elements that have been defined for this account combination. GL_DistributionLine.User2_ID
numeric(10)
Search


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.