Passing VAT Entries to PeopleSoft Receivables
This topic provides an overview of Receivables interface tables and VAT account types.
Note: VAT reverse charge amounts will not be passed to PeopleSoft Receivables.
The Load AR Pending Items process (BILDAR01) inserts entries into the following tables:
Term |
Definition |
|---|---|
PENDING_ITEM_FS |
Contains information about each new pending item that is created from a billing invoice. |
PENDING_DST_FS |
Contains any associated PeopleSoft Receivables accounting entries that are sent to PeopleSoft General Ledger by PeopleSoft Billing for each pending item. Under certain circumstances, this table also contains accounting ChartField information for VAT transactions. |
GROUP_CNTRL_FS |
Contains PeopleSoft Receivables group control information for the entries that are inserted. |
The following additional table exists for VAT processing:
Term |
Definition |
|---|---|
PENDING_VAT_FS |
Contains VAT-related information for each PeopleSoft Receivables pending item. The records in this table are grouped by physical nature, VAT tax code, VAT tax code percentage, VAT transaction type, VAT applicability, and VAT treatment. In addition, pending items for services are grouped by VAT location country and state of the buyer, VAT location country and state of the seller, where-service-performed country and state, and services-place-of-supply country and state. |
Billing passes the following VAT account types to Receivables for the lines referred to in the right column of this table:
Term |
Definition |
|---|---|
VO |
Most lines with a VAT declaration point of invoice, accounting date, or delivery. |
VOAP |
Deposit-related lines (DEP, DAPP, and DREF) with a VAT declaration point of invoice, accounting date, or delivery. |
VOC |
Credit or adjustment lines. Deposit refund lines (DREF) with a VAT declaration point of payment. |
VOI |
Most lines, including deposit-applied lines (DAPP), with a VAT declaration point of payment. |
VONT |
Lines that are exempt or outside of scope of VAT. |
VORE |
Asset Management lines with a VAT declaration point of invoice, accounting date, or delivery. |
The following example illustrates how PeopleSoft Billing creates new entries in the interface tables for VAT processing when the VAT calculation method is set to gross and VAT calculation type is inclusive.
Program Parameters
Consider the following program parameters:
Invoice with an early payment discount of five percent and four lines, all with the same VAT applicability.
VAT A = 10 percent.
VAT B = 20 percent.
Line 1: Pretax amount = 40 EUR; VAT Code A; VAT Amount = 4 EUR; Physical nature of Goods.
Line 2: Pretax amount = 40 EUR; VAT Code B; VAT Amount = 8 EUR; Physical nature of Goods.
Line 3: Pretax amount = 20 EUR; VAT Code A; VAT Amount = 2 EUR; Physical nature of Goods.
Line 4: Pretax amount = 30 EUR; VAT Code A; VAT Amount = 3 EUR; Physical nature of Services.
Here are the amounts as they appear on invoice:
Pretax amount = 130 EUR.
VAT amount total = 17 EUR.
Here is the VAT invoice summary:
VAT A = 9 EUR. VAT B = 8 EUR (displayed on summary page).
Total invoice amount = 147 EUR.
When Header Is AR Open Item
After you define the AR level on the Installation Options - Billing - Integration Options page as Header is AR Open Item:
Open Item One
|
Open Item One in PENDING_ITEM_FS |
Amount |
|---|---|
|
#entry_amt |
147 EUR |
|
#user_amt1 |
130 EUR (pretax amount) |
|
#item_line |
0 |
|
VAT Basis Amount |
130 EUR |
|
VAT Amount |
17 EUR |
|
VAT Declaration Point |
Captured from invoice header |
|
VAT Recalculation Flag |
Captured from invoice header |
|
VAT Calculation Method |
Gross (from invoice header) |
Entries In PENDING_VAT_FS:
|
VAT Code |
Physical Nature |
Trans. Type |
VAT Amount |
VAT Basis Amt |
VAT Percent |
|---|---|---|---|---|---|
|
A |
Goods |
(From Lines 1 and 3) See note. |
6 EUR |
60.00 EUR |
10 |
|
A |
Services |
(From Line 4) |
3 EUR |
30 EUR |
10 |
|
B |
Goods |
(From Line 2) |
8 EUR |
40.00 EUR |
20 |
Note: It is assumed that both lines for Goods with VAT Code A have the same transaction type and VAT treatment. If this is not the case, those categories have separate entries in this table.
The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS, assuming that AR distribution options are line level:
|
Invoice Line Number/Type of Entry |
Line Amount |
|---|---|
|
Line 1/AR ChartField |
44 EUR (Net + VAT) |
|
Line 2/AR ChartField |
48 EUR (Net + VAT) |
|
Line 3/AR ChartField |
22 EUR (Net + VAT) |
|
Line 4/AR ChartField |
33 EUR (Net + VAT) |
|
Line 1/VAT Distribution ChartField |
–4 EUR |
|
Line 2/VAT Distribution ChartField |
–8 EUR |
|
Line 3/VAT Distribution ChartField |
–2 EUR |
|
Line 4/VAT Distribution ChartField |
–3 EUR |
Entries in PENDING_DST_FS, assuming that AR distribution options are header level:
|
Invoice Line Number/Type of Entry |
Line Amount |
|---|---|
|
Line 0/AR ChartField (Receivables from header). |
147 EUR |
|
Line 1/VAT Distribution ChartField. |
–4 EUR |
|
Line 2/VAT Distribution ChartField. |
–8 EUR |
|
Line 3/VAT Distribution ChartField. |
–2 EUR |
|
Line 4/VAT Distribution ChartField. |
–3 EUR |
When Line Is AR Open Item
When you define the AR Level on the Installation Options - Billing - Integration Options page as line is AR open item:
Open Item One
Open Item One in PENDING_ITEM_FS
Amount
#entry_amt
44 EUR
#user_amt1
40 EUR (pretax amount)
#item_line
1
VAT Basis Amount
40 EUR
VAT Amount
4 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Gross (from invoice header)
Entries in PENDING_VAT_FS:
VAT Code
Physical Nature
Trans. Type
VAT Amt
VAT Basis Amt
VAT Percent
A
Goods
(From Line 1)
4 EUR
40.00 EUR
10
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming AR distributions options are line level:
Invoice Line Number/Type of Entry
Line Amount
Line 1/AR ChartFields
44 EUR
Line 1/VAT Distribution ChartFields
–4 EUR
Open Item Two:
Open Item Two in PENDING_ITEM_FS
Amount
#entry_amt
48 EUR
#user_amt1
40 EUR (pretax amount)
#item_line
2
VAT Basis Amount
40 EUR
VAT Amount
8 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Gross (from invoice header)
Entries in PENDING_VAT_FS:
VAT Code
Physical Nature
Trans. Type
VAT Amt
VAT Basis Amt
VAT Percent
B
Goods
(From Line 2)
8 EUR
40.00 EUR
20
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming that AR distributions options are line level:
Line Number from Invoice/Type of Entry
Amount
Line 2/AR ChartFields
48 EUR
Line 2/VAT Distribution ChartFields
–8 EUR
Open Item Three:
Open Item Three in PENDING_ITEM_FS
Amount
#entry_amt
22 EUR
#user_amt1
20 EUR (pretax amount)
#item_line
3
VAT Basis Amount
20 EUR
VAT Amount
2 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Gross (from invoice header)
Entries in PENDING_VAT_FS:
VAT Code
Physical Nature
Trans Type
VAT Amt
VAT Basis Amt
VAT Percent
A
Goods
(From Line 3)
2 EUR
20.00 EUR
10
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming AR distributions options are line level:
Invoice Line Number/Type of Entry
Line Amount
Line 3/AR ChartFields
22 EUR
Line 3/VAT Distribution ChartFields
–2 EUR
Open Item Four:
Open Item Four in PENDING_ITEM_FS
Amount
#entry_amt
33 EUR
#user_amt1
30 EUR (pretax amount)
#item_line
4
VAT Basis Amount
30 EUR
VAT Amount
3 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Gross (from invoice header)
Entries in PENDING_VAT_FS:
VAT Code
Physical Nature
Trans Type
VAT Amt
VAT Basis Amt
VAT Percent
A
Services
(From Line 4)
3 EUR
30.00 EUR
10
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming AR distributions options are line level:
Invoice Line Number/Type of Entry
Line Amount
Line 4/AR ChartFields
33 EUR
Line 4/VAT Distribution ChartFields
–3EUR
The following example illustrates how PeopleSoft Billing creates new entries in the interface tables for VAT processing when the VAT calculation type is inclusive, VAT calculation method is set to net, and an early payment discount is applied prior to calculating VAT.
Program Parameters
Consider the following program parameters:
Invoice with an early payment discount of five percent and four lines.
VAT A = 10 percent.
VAT B = 20 percent.
Line 1: Pretax amount = 40 EUR; VAT basis amount = 38 EUR; VAT Code A; VAT Amount = 3.80 EUR; Physical nature of Goods
Line 2: Pretax amount = 40 EUR; VAT basis amount = 38 EUR; VAT Code B; VAT Amount = 7.60 EUR; Physical nature of Goods.
Line 3: Pretax amount = 20 EUR; VAT basis amount = 19 EUR; VAT Code A; VAT Amount = 1.90 EUR; Physical nature of Goods.
Line 4: Pretax amount = 30 EUR; VAT basis amount = 28.50 EUR; VAT Code A; VAT Amount = 2.85 EUR; Physical nature of Services
Here are the amounts as they appear on the invoice:
Pretax amount = 130 EUR.
VAT amount total = 16.15 EUR.
Here is the VAT invoice summary:
VAT A = 8.55 EUR.
VAT B = 7.60 EUR (appears on summary page).
Total invoice amount = 146.15 EUR.
When Header Is AR Open Item
When you define the AR level on the Installation Options - Billing - Integration Options page as header is AR open item:
Open Item One
|
Open Item One in PENDING_ITEM_FS |
Amount |
|---|---|
|
#entry_amt |
146.15 EUR |
|
#user_amt1 |
130 EUR (pretax amount) |
|
#item_line |
0 |
|
VAT Basis Amount |
123.50 EUR |
|
VAT Amount |
16.15 EUR |
|
VAT Declaration Point |
Captured from invoice header |
|
VAT Recalculation Flag |
Captured from invoice header |
|
VAT Calculation Method |
Net (from invoice header) |
Entries in PENDING_VAT_FS:
|
VAT Code |
Physical Nature |
Trans. Type |
VAT Amt |
VAT Basis Amt |
VAT Percent |
|---|---|---|---|---|---|
|
A |
Goods |
(From Lines 1 and 3). See note. |
5.70 EUR |
57 EUR |
10 |
|
A |
Services |
(From Line 4). |
2.85 EUR |
28.50 EUR |
10 |
|
B |
Goods |
(From Line 2) |
7.60 EUR |
38 EUR |
20 |
Note: It is assumed that both lines for Goods with VAT Code A have the same transaction type and VAT treatment. If this is not the case, those categories have separate entries in this table.
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming that AR distributions options are line level:
|
Invoice Line Number/Type of Entry |
Line Amount |
|---|---|
|
Line 1/AR ChartFields |
43.80 EUR |
|
Line 2/AR ChartFields |
47.60 EUR |
|
Line 3/AR ChartFields |
21.90 EUR |
|
Line 4/AR ChartFields |
32.85 EUR |
|
Line 1/VAT Distribution ChartFields |
–3.80 EUR |
|
Line 2/VAT Distribution ChartFields |
–7.60 EUR |
|
Line 3/VAT Distribution ChartFields |
–1.90 EUR |
|
Line 4/VAT Distribution ChartFields |
–2.85 EUR |
Entries in PENDING_DST_FS assuming that AR distribution options are header level:
|
Invoice Line Number/Type of Entry |
Line Amount |
|---|---|
|
Line 0/AR ChartFields (Receivables from header) |
146.15 EUR |
|
Line 1/VAT Distribution ChartFields |
–3.80 EUR |
|
Line 2/VAT Distribution ChartFields |
–7.60 EUR |
|
Line 3/VAT Distribution ChartFields |
–1.90 EUR |
|
Line 4/VAT Distribution ChartFields |
–2.85 EUR |
When Line Is AR Open Item
When you define the AR level on the Installation Options - Billing - Integration Options page as line is AR open item:
Open Item One:
Open Item One in PENDING_ITEM_FS
Amount
#entry_amt
43.80 EUR
#user_amt1
40 EUR (pretax amount)
#item_line
1
VAT Basis Amount
38 EUR
VAT Amount
3.80 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Net (from invoice header)
Entries in PENDING_VAT_FS:
VAT Code
Physical Nature
Trans Type
VAT Amt
VAT Basis Amt
VAT Percent
A
Goods
(From Line 1)
3.80 EUR
38 EUR
10
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS:
Invoice Line Number/Type of Entry
Line Amount
Line 1/AR ChartFields
43.80 EUR
Line 1/VAT Distribution ChartFields
–3.80 EUR
Open Item Two:
Open Item Two in PENDING_ITEM_FS
Line Amount
#entry_amt
47.60 EUR
#user_amt1
40 EUR (pretax amount)
#item_line
2
VAT Basis Amount
38 EUR
VAT Amount
7.60 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Net (from invoice header)
Entries in PENDING_VAT_FS:
VAT Code
Physical Nature
Trans. Type
VAT Amt
VAT Basis Amt
VAT Percent
B
Goods
(From Line 2)
7.60 EUR
38 EUR
20
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming that AR distribution options are line level:
Invoice Line Number/Type of Entry
Line Amount
Line 2/AR ChartFields
47.60 EUR
Line 2/VAT Distribution ChartFields
–7.60 EUR
Open Item Three:
Open Item Three in PENDING_ITEM_FS
Line Amount
#entry_amt
21.90 EUR
#user_amt1
20 EUR (pretax amount)
#item_line
3
VAT Basis Amount
19 EUR
VAT Amount
1.90 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Net (from invoice header)
Entries In PENDING_VAT_FS:
VAT Code
Physical Nature
Trans. Type
VAT Amt
VAT Basis Amt
VAT Percent
A
Goods
(From Line 3)
1.90 EUR
19 EUR
10
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming AR distribution options are line level:
Invoice Line Number/Type of Entry
Line Amount
Line 3/AR ChartFields
21.90 EUR
Line 3/VAT Distribution ChartFields
–1.90 EUR
Open Item Four:
Open Item Four in PENDING_ITEM_FS
Line Amount
#entry_amt
32.85 EUR
#user_amt1
30 EUR (pretax amount)
#item_line
4
VAT Basis Amount
28.50 EUR
VAT Amount
2.85 EUR
VAT Declaration Point
Captured from invoice header
VAT Recalculation Flag
Captured from invoice header
VAT Calculation Method
Net (from invoice header)
Entries In PENDING_VAT_FS:
VAT Code
Physical Nature
Trans. Type
VAT Amt
VAT Basis Amt
VAT Percent
A
Services
(From Line 4)
2.85 EUR
28.50 EUR
10
Note: The system does not insert VAT entries into PENDING_DST_FS if PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries or if the declaration point is invoice, delivery, or accounting date and the recalculation option is disabled.
Entries in PENDING_DST_FS assuming that AR distribution options are line level.
Invoice Line Number/Type of Entry
Line Amount
Line 4/AR ChartFields
32.85 EUR
Line 4/VAT Distribution ChartFields
–2.85 EUR
The declaration point determines whether the VAT amounts are written to VAT_AMT and VAT_AMT_BASE or the VAT_AMT_I and VAT_AMT_BASE_I in the PENDING_VAT_FS table.
When the declaration point is set to invoice, delivery, or accounting date the interface uses VAT_AMT and VAT_AMT_BASE.
When the declaration point is set to accounting date and PeopleSoft Billing is configured so that PeopleSoft Receivables creates the accounting entries, the interface supplies the VAT declaration date with null. When Billing creates the accounting entries, the interface supplies the VAT declaration date with the accounting date.
When the declaration point is set to delivery, the interface also supplies the VAT declaration date in PENDING_VAT_FS with either the delivery date or the date that is entered manually.
When the declaration point is set to invoice, the interface also supplies the VAT declaration date in PENDING_VAT_FS with the invoice date.
When the declaration point is set to payment, the interface supplies the VAT declaration date with null and uses VAT_AMT_I and VAT_AMT_BASE_I.
Under certain circumstances, a VAT transaction can have a blank VAT code. When this occurs, the interface makes no entry in PENDING_DST_FS. However, because you still need to track these types of transactions, the interface can place entries into PENDING_VAT_FS.
If the VAT applicability on bill lines is no, no entries are placed into PENDING_VAT_FS.
The Load AR Pending Items process supports credit line VAT reporting and VAT ChartField definition tables.
The following criteria are used when populating the distribution account type in PENDING_VAT_FS:
For all noncredit lines and credit lines with a VAT declaration point of P, use the distribution account type from BI_HDR_VAT.
For credit lines with a declaration point other than P, use VOC as the distribution account type regardless of the value from BI_HDR_VAT.
When the bill header is the open item, lines are grouped together to be inserted into PENDING_VAT_FS in two passes:
First Pass
The first pass groups together two types of lines: non-ACR lines and ACR lines with a VAT declaration point defined as P.
These lines are grouped together based on the following:
Unique physical nature
VAT tax code
VAT percentage
VAT transaction type
VAT applicability
VAT treatment
VAT location country and state of the buyer
VAT location country and state of the seller
Where service performed country and state
Services place of supply country and state
The VAT amounts are summed up and each grouping results in a row in PENDING_VAT_FS. The VAT distribution account type is used as a copy of the value from BI_HDR_VAT.
Second Pass
The second pass uses lines with a line type of ACR and a declaration point that is not equal to P.
These lines are also grouped together based on the following:
Unique physical nature
VAT tax code
VAT percentage
VAT transaction type
VAT applicability
VAT treatment
VAT location country and state of the buyer
VAT location country and state of the seller
Where service performed country and state
Services place of supply country and state
The VAT amounts are summed up, and each grouping results in a row in PENDING_VAT_FS. The VAT distribution account type that is used is set to VOC regardless of the value that is in BI_HDR_VAT. This ensures unique entries in PENDING_VAT_FS. The PENDING_VAT_FS table has the VAT distribution account type as an additional key to prevent duplicate key row insert errors.
The system looks in the VAT_BU_ACCT_TBL table for the set of ChartFields to use when populating PENDING_DST_FS. VAT_BU_ACCT_TBL can be used to define ChartFields at the General Ledger business unit level. If no row is found, the system looks in VAT_ACCT_TBL for the ChartFields to use. ChartField inheritance is applied to the ChartFields that are retrieved for the VAT entries if necessary to complete the accounting entries.