Window Enhancements for A/P Service Invoice Allocation in Intercompany Solution

Window Enhancements for A/P Service Invoice Allocation in Intercompany Solution


A new window, Allocation, has been introduced in SAP Business One to allocate A/P service invoices to other branch companies.

To display the Allocation window, navigate to an open A/P Service Invoice, and choose the Open Allocation button.


Allocation Window

Field

Description

Allocation Type

Two types of allocation are supported. Choose either G/L or Invoice from this dropdown list.

Branch

Displays the Branch as on the A/P service invoice.

Description.

Displays the description of the G/L account as on the A/P service invoice.

G/L account

Displays the G/L account as on the A/P service invoice.

Total (LC), Tax Amount

Display the total amount in local currency and tax amount as on the A/P service invoice. 

Posting Date

Displays the posting date as specified in the A/P service invoice.If required, you can change the date.

Project

Displays the project as specified in the A/P service invoice.

Distr. Rule

Displays the distr. rule as specified in the A/P service invoice.

Dimension 

Displays the dimension as specified in the A/P service invoice.

Freight 1 (LC)

Displays the Freight 1(LC) amount as on the A/P Service Invoice. 

Freight 1 Tax(LC)

Displays the Freight 1 Tax (LC) amount as on the A/P Service Invoice. 

Freight 2 (LC)

Displays the Freight 2(LC) amount as on the A/P Service Invoice. 

Freight 2 Tax(LC)

Displays the Freight 2 Tax (LC) amount as on the A/P Service Invoice. 

Freight 3 (LC)

Displays the Freight 3(LC) amount as on the A/P Service Invoice. 

Freight 3 Tax(LC)

Displays the Freight 3 Tax (LC) amount as on the A/P Service Invoice. 

Distribution Amount

Displays the Distribution amount as on the A/P Service Invoice.

Total Allocation Amount

The maximum amount that can be allocated per row.

Use the following formula to calculate the total allocation amount:

[{ Total (LC) + Tax Amount (LC) – Discount } + { Freight 1 (LC) + Freight 1 Tax (LC) + Freight 2 (LC) + Freight 2 Tax (LC) + Freight 3 (LC) + Freight 3 Tax (LC) } + Distrib. Amount (LC)]

Where Discount = [ Discount % / 100 * Total (LC) ]

Journal Entry

Displays the journal entry number for the allocation line.

Account Classification

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

Account Type

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

Allocated

This checkbox becomes selected once the A/P service invoice is allocated to a branch company. 

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 the 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 label of this button is Calculate Allocation Amt

Choose the 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 field 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.

Project

If required, specify a project for the selected row.

Distr. Rule

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

Dimension 

Choose distribution rules for the dimensions.

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.

Document Number

Display document number of the journal entry / A/P invoice document created in the receiver system.

Posting date

Display posting date of the journal entry / A/P invoice document created in the receiver system.

Rejected Document Number

Displays the journal entry and A/R invoice cancellation document created in the sender system as a result of rejection by the receiver system.

Add

Saves the allocation data for posting.

Cancel

Closes the Allocation window.

Allocate

Allocated the A/P service invoice to the selected branch companies.

Load All Branches

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

​​​​


Next Step: Sample Transaction Flow – Invoice Type Allocation in A/P Service Invoice Allocation in Intercompany Solution