Skip to Content
0
Former Member
Feb 12, 2010 at 11:37 AM

How to set document splitting?

52 Views

Hi,

I have a problem with document splitting:

If I register a vendor (or customer) invoice as follows:

001 31 FORNIT2500 XXXXXX LOGISTICS 12,00- ** (with Baseline date 22.03.2010)

002 31 FORNIT2500 XXXXXX LOGISTICS 66,00- ** (with Baseline date 20.04.2010)

003 40 0040000001 ACQ MATERIE PRIME 10,00 (with cost center X-> profit center X)

004 40 0040000002 ACQUISTO MATERIALI 60,00 (with cost center Y-> profit center Y)

005 40 0014241004 IVA CONTO ACQUISTI 2,00 20 20% VAT code

006 40 0014241004 IVA CONTO ACQUISTI 6,00 10 10% VAT code

I get this display in new general ledger view:

1 000001 31 0020000001 FORNITORI ITALIA 1,72- profit center X (Baseline date 22.03.2010)

1 000002 31 0020000001 FORNITORI ITALIA 10,28- profit center Y ( Baseline date 22.03.2010)

2 000003 31 0020000001 FORNITORI ITALIA 9,43- profit center X (Baseline date 20.04.2010)

2 000004 31 0020000001 FORNITORI ITALIA 56,57- profit center Y (Baseline date 20.04.2010)

3 000005 40 0040000001 ACQ MATERIE PRIME 10,00 profit center X (with cost center X)

4 000006 40 0040000002 ACQUISTO MATERIALI 60,00 profit center Y (with cost center Y)

5 000007 40 0014241004 IVA CONTO ACQUISTI 0,29 profit center X VAT code 20

5 000008 40 0014241004 IVA CONTO ACQUISTI 1,71 profit center Y VAT code 20

6 000009 40 0014241004 IVA CONTO ACQUISTI 0,86 profit center X VAT code 10

6 000010 40 0014241004 IVA CONTO ACQUISTI 5,14 profit center Y VAT code 10

I donu2019t want a Baseline date splittingu2026 but a profit center splitting.

In other words what I get is :

1 000001 31 0020000001 FORNITORI ITALIA 12,00- profit center X (Baseline date 22.03.2010)

2 000002 31 0020000001 FORNITORI ITALIA 66,00- profit center Y (Baseline date 20.04.2010)

3 000005 40 0040000001 ACQ MATERIE PRIME 10,00 profit center X (with cost center X)

4 000006 40 0040000002 ACQUISTO MATERIALI 60,00 profit center Y (with cost center Y)

5 000007 40 0014241004 IVA CONTO ACQUISTI 2,00 profit center X VAT code 20

6 000008 40 0014241004 IVA CONTO ACQUISTI 6,00 profit center Y VAT code 10

My settings are:

u2022 NGL is active;

u2022 Scenarios assigned to 0L ledger: FIN_CCA (Cost Center Update) and FIN_PCA (Profit Center Update);

u2022 Classify G/L Accounts for Document Splitting has been set;

u2022 Classify Document Types for Document Splitting has been set;

u2022 Zero-Balance Clearing Account was defined;

u2022 Constant for Nonassigned Processes-> Profit Center DUMMY;

u2022 Document Splitting Characteristics for General Ledger Accounting -> Profit Center with flags in u201CZero balanceu201D and u201CMandatory Fieldu201D;

u2022 Activate Document Splitting set as follows:

Flag in "Document Splitting"; Method 0000000012 Splitting: Same as 0000000002 (Follow-Up Costs online);

Level of Detail with flag in "Inheritance";

thanks in advance,

Osvaldo