As a Sage 200 Evolution user, I would like the Trial Balance to calculate and display the correct balances per branch specific GL Stock Control; when using a loan accounts with branch specific stock controls on IBTs.

Short Description

As a Sage 200 Evolution user, I would like the Trial Balance to calculate and display the correct balances per branch specific GL Stock Control; when using a loan accounts with branch specific stock controls on IBTs.

Previously logged as TQ06761

Detailed Expected Outcome:

The Setup required.

Branch Accounting Setup Required.

A Head office

Create 2 Branches

Strubensvalley

Northriding

GL Structure

Branch GL specific accounts

1 Head office loan account

2 Branch loan accounts linked to the head office loan account.

Create a Global Stock Item that will belong to all warehoues.

Inventory Group per warehouse.

Created as Branch specific

Link to Branch specific stock control account

Create a warehouse for each branch (specific to the branch)

Create a damage and variance warhouse for each branch (specific to the branch)

Create a Global GIT account for head office

Create a Global GIT account for each branch. E.g.

For strubensvalley : STRGIT

For northriding : NORGIT

Create a global supplier

Transaction Types

Spilt GRV from SINV is deactivated.

Create a branch specific transaction type for Purchase Order for each branch

For strubensvalley : POSTR

For northriding : PONOR

Create a branch specific transaction type for Warehouse Transfers for each branch

For strubensvalley : WHTSTR

For northriding : WHTNOR

Set the debit account to be that of the branch specific stock control account.

Setup

Enable IBT on warehouse defaults @ head office

Specify the Global Loan that should be used.

Under each branch

Allocate the branch specific warehouse transaction type

For strubensvalley : WHTSTR

For northriding : WHTNOR

Populate the default warehouses for each branch

For strubensvalley : GIT: STRGIT

For northriding : GIT: NORGIT

Process the transactions.

Login to Strubensvalley, process a PO for the Global stock item.

Enter quantity of 10

Enter purchase cost of R399.53. (ex vat)

After the PO, the reports at Strubensvalley show;

Stock valuation is valued @ R3995.30.

GL Stock Control is valued @ R3995.30

Process and IBT from Strubenvalley to Northriding

Quantity issued is 1.

After the IBT Issue, the reports at Strubensvalley show;

Stock valuation is valued @ R3595.77.

Trial Balance

GL Stock Control is valued @ R359GL Branch Loan Account is valued @ R399.53

Open the sync for Strubensvalley and process the export to head office.

Open the sync for Head Office and import the file received from Strubensvalley

After the Sync import into Head office, the reports for Strubensvalley show;

Stock valuation is valued @ R3595.77

Trial Balance

GL Stock Control is valued @ R3595.77

GL Branch Loan Account is valued @ R399.53

On head office, the consolidated reports shows

Stock valuation is valued @ R3995.30

Strubensvalley warehouse is R3595.77

Strubensvalley GIT warehouse is R399.53

On the Trial Balance for all branches

GL Stock Control for Strubensvalley is valued @ R3995.30 (Debit)

Because of the STR and STRGIT warehouse

GL Branch Loan Account is valued @ R399.53 (Debit)

GL Head Office Loan Account is valued @ R399.53 (Credit)

Export information from Head office for North Riding

Open the Sync for North Riding and import the file from head office.

Log into North Riding, Open the IBT and Receive the quantity issued.

After the IBT has being Received, the reports at North Riding show;

Stock valuation is valued @ R399.53.

Trial Balance

GL North Riding Stock Control is valued @ R399.53

GL North Riding Branch Loan Account is valued @ R399.53

After the Sync import into Head office, stock valuation and trial balance shows the following;

All Branches TB Strubensvalley TB North Riding TB

Stock Valuation R3595.77 R399.53

Trail Balance

GL Stock Control - Strubensvalley R3995.30 (Dr) R3595.77 (Dr)

GL Stock Control - North Riding R399.53 (Dr)

GL Branch Loan Account - Strubensvalley R399.53 (Cr) R399.53 (Cr)

GL Branch Loan Account - North Riding R399.53 (Cr) R399.53 (Cr)

GL Head Office Loan Account

North Riding has a GL Stock Control value of R399.53 but its not displayed on the consolidated Trial Balance on head office.

Reason for Request

My Environment is an Online Branch Accounting Site. Branches: Global (All Branches)610 – Head office Branch620 – Factory Branch630 – Wholesale Branch635 – Gauteng Breakdown Branch650 –Fitment Centre 1660 –Fitment Centre 2690 – Warehouse Branch This is a Segmented GL Structure, and Each Branch has its own Stock Control Account in the Balance Sheet. 610 – 0410/000/610620 – 0410/000/620630 – 0410/000/630635 – 0410/000/635650 – 0410/000/650660 – 0410/000/660690 – 0410/000/690Global – 0410/000/101 Each Branch has its own Warehouses. 610 – 610620 – 620630 – 630635 – 635650 – 650660 – 660690 – 690Global – GIT NOTE: Global Stock is only for the Goods in Transit for IBTs stock. As Mentioned, When running Financial Reporting, The Client will Run the Reporting at Head office Level, and Split it By Branch based on the Segment ID for the Branch (610/620/630/635/650/660/690) Therefore, What is Currently Happening when Processing an IBT is as follows: Interbranch Transfer from 690 Branch to 630 Branch With the Above Scenario, you will see that even though the Branch id on the Inventory Control Account for the GIT is 0 for All Branches, When looking at the TB vs the Valuation, for the Warehouse you will see that there is Movement in the Valuation, however, there is no movement in the Control Account Causing inaccuracies the Reporting: 0410/000/690 CR: 500.00 DR: 500.00 Movement = R 0.00 0410/000/630 CR: 500.00 DR: 500.00 Movement: R 0.00 Therefore, the ideal scenario would be as follows: In the Above Scenario, Both Controls and Valuations have Movement. When Stock Leaves 690 Warehouse, it only Credits the 690 Control When it Enters the GIT Warehouse, it Debits 101 Control And the same for the 630 Warehouse When Stock Leaves the GIT Warehouse, it Credits 101 Control When Stock Enters the 630 Warehouse it Debits 630 Control