cancel
Showing results for 
Search instead for 
Did you mean: 

Document Splitting variance between Domestic sales and Export sales in entry view and GL View in FAGLB03

Former Member
0 Kudos

Dear Friends,

in my company we are activated document splitting

0000000012 splitting: same as 0000000002 (follow-up cost online)

000000002 splitting: Customer, Vendor, Tax, Money, Co.Code

 

Transaction 0200 customer invoice variant 0001

Below is the nature of  issue:

                   

                         we are Dealing Domestic Sales as well as Export sales at the time of sales invoice booking

                         FI automatic entry will get generated at the time in the Genral ledger view Vs Entry view has some conflict

                          below is the brief overview about.

Domestic Salese ( FI Automatic Entry) GL View

ItmCost CtrD/CPKTxSGAccountDescription    AmountRef.key 1Ref.key 2Ref. key 3
1 S1 1200Rec.-Export 5,099.94 1417YY9000007
3 S40 2000Sales -Export508.00 1417YY9000007
2 H50 2000Sales -Export(4,801.00)1417YY9000007
2 H50 2000Sales -Export(131.00)1417YY9000007
4 H50 1640Fright -Export(675.94)1417YY9000007

Domestic Salese ( FI Automatic Entry) Entry View

ItmCost CtrD/CPKTxSGAccountDescription    AmountRef.key 1Ref.key 2Ref. key 3
1 S1 AABBCustomer name 5,099.94 1417YY9000007
3 S40 2000Sales -Export508.00 1417YY9000007
2 H50 2000Sales -Export(4,932.00)1417YY9000007
4 H50 1640Fright -Export(675.94)1417YY9000007

Export Salese ( FI Automatic Entry) Entry View

ItmD/CPKAccountDescription      AmountRef.key 1Ref.key 2RefKey 3
1S1YYYYCsutomer name399,177.00 8455part1xx11
2H501100Sales -Domestic(315,451.00)8455part1xx11
3H501100Sales -Domestic(29,637.00)8455part1xx11
4H501060VAT Payable (50,038.00)
5H501210Freight(3,978.00)8455part1xx11
6H508640Insurance (73.00)8455part1

xx11

Export Salese ( FI Automatic Entry) GL View

ItmD/CPKAccountDescription      AmountRef.key 1Ref.key 2RefKey 3
1S11300Recon domestic399,177.00 8455part1xx11
2H501100Sales -Domestic(315,451.00)8455part1xx11
3H501100Sales -Domestic(29,637.00)8455part1xx11
4H501060VAT Payable (50,038.00)
5H501210Freight(3,978.00)8455part1xx11
6H508640Insurance (73.00)8455part1xx11

                    Below is the Observation abt Domestic sales GL automatic entry

1. In GL View as per document spliting concept customer recon account displayed in reporet.

2. In GL View and Entry view Amounts are same no splitting happen in Amount wise

3. the cost center and profit center are same. .

                    Below is the Observation abt Export sales GL automatic entry

1. In GL View as per document spliting concept customer recon account displayed in reporet.

2. In GL View and Entry view Amounts are not same splitting happen  Amount wise

3. the cost center and profit center are same.

                              Questin (Help Required)

1. In domestic sales why the amount wise splitting not happen...?

2. In Export sales cost center and profit center are same even though why Amount wise splitting happen...?

your answer much appreciatable.

.Best Regards

Senthil

Accepted Solutions (0)

Answers (2)

Answers (2)

João_FI_FIN-CS
Active Contributor
0 Kudos

Hi Senthil,

I guess for the domestic posting is correct because the Document Splitting can split the amount in two lines. For some reason the function did the split and for this, it has to be analyzed your configurations.

But first, repeat this post by FB01 and before to save, choose the "simulate General Ledger". There you can research what is the category type line was used.

H502000Sales -Export(4,801.00)1417YY9000007
H502000Sales -Export(131.00)1417YY9000007
Former Member
0 Kudos

Dear JPA,

Thanks for your reply , we will research on it.

Best Regards

Senthil

João_FI_FIN-CS
Active Contributor
0 Kudos

Hi Senthil,

Are using the same type of documents for export and domestic sales?

JPA

Former Member
0 Kudos

Dear JPA,

We are not using same document type we are using different document type.

Best Regards

Senthil