Window Enhancements for G/L Allocation in Intercompany Solution

Window Enhancements for G/L Allocation in Intercompany Solution


Journal Entry Window

A button Intercompany Details has been added to the Journal Entry window. Choosing this button will display the Branch Journal Entry Details window with all fields relevant to the Intercompany Integration Solution. This button is enabled only for allocations and centralized Payment transactions. For details of other fields on this window, refer to the SAP Business One Online Help.

Branch Journal Entry Details window contains following fields

Field

Description

Outgoing Intercompany Document

Indicates that the journal entry was created as a result of G/L allocation posting in the sender system. 

This field:

    1. Is automatically selected by the system
    2. Cannot be edited by the user

Incoming Intercompany Document

Identifies the reciprocal journal voucher that is created in the receiver system when user post a G/L allocation entry

This field:

    1. Is automatically selected on the journal voucher 
    2. Cannot be edited by the user 

When user post the journal voucher, this field:

    1. Is automatically selected on the journal entry that is saved
    2. Cannot be edited by the user

Invoice

Indicates that the journal entry was created as a result of allocation from an Service Invoice in the sender system. 

This field:

    1. Is automatically selected by the system
    2. Cannot be edited by the user

IC Sender Branch

The IC branch code of the company that posted the G/L allocation entry.

Allocation No.

The number of the G/L allocation entry.

Allocation Line No.

Indicates the line number in the top matrix of the G/L allocation entry.

BP Code

Displays the vendor code of allocated  Service invoice  of the sender company.

BP Name

Displays the vendor name of allocated Service invoice of the sender company.

Vendor Ref. No.

Displays the vendor reference number of allocated Service invoice of the sender company.

Document Number

Displays the number of allocated Service invoice of the sender company.

Document Row No.

Displays the row number of allocated Service invoice of the sender company.

Posting Date

Displays the posting date of allocated Service invoice of the sender company.

Document Remarks

Displays the remarks of allocated Service invoice of the sender company.

Allocation Rejection

Indicates that the journal entry is created as a result of a Journal Voucher rejection by a branch company.

IC Rejection Branch

Displays the IC branch code of the company that rejected the Journal Voucher.

Incoming Delegation

Indicates that the journal entry is created as a result of a payment delegation by a branch company.

Delegation Reference

Captures the document number of the delegation entry in the sender system. 

Delegation From

Captures the branch code of the company that made the payment delegation. 

Note

All fields in the Branch Journal Entry Details window are read-only and are updated automatically by the system.

Journal Voucher Entry Window

The following fields have been added to the window and are relevant to the Intercompany Integration Solution. For details of other fields on the Journal Voucher Entry window, refer to the SAP Business One Online Help.

Field

Description

Status

When you post a G/L allocation entry, a reciprocal journal voucher with status Pending is created in the receiver system.

To save the journal voucher as a journal entry user must change the status to Accept. 

Intercompany Details

Choosing this button will display the Branch Journal Entry Details window with all fields relevant to the Intercompany Integration Solution. This button will be enabled only for allocations transactions.

Branch Journal Entry Details window contains following fields

Field

Description

Outgoing Intercompany Document

Indicates that the journal entry was created as a result of G/L allocation posting in the sender system. 

This field:

    1. Is automatically selected by the system
    2. Cannot be edited by the user

Incoming Intercompany Document

Identifies the reciprocal journal voucher that is created in the receiver system when user post a G/L allocation entry

This field:

    1. Is automatically selected on the journal voucher 
    2. Cannot be edited by the user 

When user post the journal voucher, this field:

    1. Is automatically selected on the journal entry that is saved
    2. Cannot be edited by the user

Invoice

Indicates that the journal entry was created as a result of allocation from an Service invoice in the sender system. 

This field:

    1. Is automatically selected by the system
    2. Cannot be edited by the user

IC Sender Branch

The IC branch code of the company that posted the G/L allocation entry.

Allocation No.

The number of the G/L allocation entry.

Allocation Line No.

Indicates the line number in the top matrix of the G/L allocation entry.

BP Code

Displays the BP code of allocated Service invoice of the sender company.

BP Name

Displays the BP name of allocated Service invoice of the sender company.

BP Ref. No.

Displays the BP reference number of allocated Service invoice of the sender company.

Document Number

Displays the number of allocated Service invoice of the sender company.

Document Row No.

Displays the row number of allocated Service invoice of the sender company.

Posting Date

Displays the posting date of allocated Service invoice of the sender company.

Document Remarks

Displays the remarks of allocated Service invoice of the sender company.

Incoming Delegation

Indicates that the journal entry is created as a result of a payment delegation by a branch company.

Delegation Reference

Captures the document number of the delegation entry in the sender system. 

Delegation From

Captures the branch code of the company that made the payment delegation. 

Note

All fields in the Branch Journal Entry Details window are read-only and are updated automatically by the system.

G/L Branch Allocation

A new window G/L Branch Allocation has been introduced in SAP Business One to allocate expenses and incomes to other branch companies.

To display the G/L Branch Allocation window, choose Financials â†’ G/L Branch Allocation.


G/L Branch Allocation Window

Field

Description

No.

Displays the number of the allocation entry.

Due Date

Captures the due date for the document; the date on which the entry takes place.

Posting Date

Captures the posting date for the document, which, by default, is the current date. 

Document Date

Captures the document date for the document; the journal entry date for tax reporting purposes.

Ref. 1

Specify the relevant reference for the allocation entry, or leave blank.

Ref. 2

Specify a second relevant reference for the allocation entry; or leave blank.

Trans. Code

Captures the transaction code you selected from the list to use for document searching purposes.

Indicator

Displays a previously defined list of indicator codes from which you select one to find a particular transaction.

Project

Displays a previously defined list of projects from which you select one to link a transaction.

Remarks

Enter additional remarks for future reference purposes.

Template Type

Select the template type from the dropdown list (percentage or recurring).

Template

Select the appropriate template code.

G/L Account

Captures the G/L account for the allocation transaction.

Name

Captures the name of the selected G/L account.

Currency Code

Select the currency code for the G/L allocation transaction

Currency Name

Displays the currency name of the selected currency code

Debit, Credit

Captures the debit and credit amounts.

Branch Code

If Multiple Branches are enabled, Specify the branch code.

Remarks

Displays the information entered in the Remarks field of the header.

Ref. 1, Ref. 2

Display the information entered in the Ref. 1 and Ref. 2 fields of the header. 

Due By

Displays the information from the Due Date field in the header.

Document Date

Displays the information from the Document Date field in the header.

Project

Displays the information selected in the Project field of the header.

Distr. Rule

If required, specify a distribution rule for the selected row.

Dimension 

Choose distribution rules for the dimensions.

Journal Entry

Displays the journal entry number for the allocation line.

Account Classification

When an account is selected in the top matrix of the G/L Allocation window, the account classification defined for the account in the chart of accounts is copied to the this field

Account Type

When an account is selected in the top matrix of the G/L Allocation window, the account type defined for the account in the chart of accounts is copied to the this field

Residual to Rounding

Selecting this field transfers the unallocated amount of the transaction to the default rounding account, as defined in default accounts Setup.  

Allocation Method

The system supports two methods of allocation. Choose either Amount (default) or Percentage from this dropdown list. 

Calculate Allocation Amt / %

When the value in the Allocation Method dropdown field is Amount, the caption of this button is Calculate Allocation %. 

Choose this button to:

    1. Automatically calculate the amount value in the Allocation Amount field as a percentage 
    2. Display the result in the Allocation % field 

When the value in the Allocation Method dropdown field is Percentage, the caption of this button is Calculate Allocation Amt. 

Choose this button to:

    1. Automatically calculate the percentage value in the Allocation % field as an amount 
    2. Display the result in the Allocation Amount field 

IC Branch Code

Press the TAB key in this field and from the Choose from List window select the IC branch code of the company to which the allocation is to be made.

Receiver Branch Code

If receiver company is branch enabled, Specify the receiver company branch code.

Receiver Branch Name

Displays the receiver branch name.

Allocation Account, Name

The code and name of the allocation account. Press TAB in this field and select the relevant allocation account for the receiver company.

Allocation %

When the value in the Allocation Method dropdown list is Percentage, you can enter a percentage value here that can be used to calculate the corresponding Allocation Amount. 

The total of all line percentages in the bottom matrix cannot be greater than 100.

Allocation Amount

When the value in the Allocation Method dropdown field is Amount, you can enter an amount value here that can be allocated to the branch company identified in the corresponding Branch Code field. 

The total of all allocation amounts in the bottom matrix cannot be greater than the Total Allocation Amount value in the top matrix.

Contact Person

Enter the name of the contact person to whom the email notification is to be sent.

Remarks

Enter additional information regarding the allocation entry.

Status

Displays the status of the reciprocal journal voucher / journal entry created in the receiver system when you post the G/L allocation entry.

Confirmed

Indicates that the reciprocal journal voucher created in the receiver system when you post a G/L allocation entry, has been saved as a journal entry.

Journal Entry

Display document number of the journal entry created in the receiver system.

Rejected Journal Entry

Displays the journal entry created in the sender system as a result of rejection by the receiver system.

Posting date

Display posting date of the journal entry created in the receiver system.

Distr. Rule

If required, specify a distribution rule for the selected row.

Dimension 

Choose distribution rules for the dimensions.

Project

Specify the project that you want to assign to the account.

Load All Branches

Inserts in the bottom matrix the IC branch codes of all the other branch companies. 

Add

Choose this button to add the G/L branch allocation.

Cancel

Choose this button to close the G/L Branch Allocation window.




Next Step: Sample Transaction Flow - G/L Allocation in Intercompany Solution