sapnote_0000818079

06.03.2012 of 13

SAP Note 818079 - PL: Down Payment Invoice for Poland

Note Language: English Version: 13 Validity: Valid Since 18.06.2008

Summary

SymptomThe down payment process for Poland is currently not possible in the salesorder -> Delivery -> Billing process.

Legal requiements Poland: Decree of Minister of State Finances from April27th 2004 regarding return of VAT tax to some payers, return of VAT tax inadvance, rules for issuing and storing invoices and list of items notrelevant for tax exemption.

Polish law requirements:

o Generation of Down Payment Invoice

o Delivery related billing

o Clearing note according different tax rates

o Only items belonging to the same sales order are billed together.

Note: -----a. Multiple Sales order which has a Down payment cannot be invoiced together.

Eg: 1. Sales Order 1 -> DP Invoice -> Final Invoice ----> Allowed

2. Sales Order 1 -> DP Invoice Sales Order 2 Sales Order 1 & Sales Order 2 -> Final Invoice ----> Not Allowed

b. The Downpayment Invoices will not be displayed in t-code VF05 and VF05n, its only possible with the note 371675.

Other termsDown payment, Down Payment Invoice, Delivery-related invoice, VF01,Clearing note

Reason and PrerequisitesLegal change in PolandPrecondition: Process starts from sales order

Solution

Please make the following customizing steps to install thesolution:

1. Create new document pricing procedure '1' - Down Payment Poland:

06.03.2012 of 13


IMG path is Sales and distribution -> Basic Functions -> Pricing ->Pric control -> Define and assign pricing procedures -> Definedocument Pricing procedure.

2. Create a new billing type:

This will be used to generate the down payment invoice. Go totransaction VOFA. Copy the billing type F5 - Proforma for order tocreate the new billing type FAF. Change the SD document category ofthe new billing type to 'M' - Invoice. Transaction group = "8" -Proforma invoices.

For the billing type define an appropriate document type. This couldbe 'DR'. Define an appropriate cancellation billing type. This couldbe 'S1'. Also define an appropriate reference number for thecancellation billing type. This could be 'E'.

In the account assigment/pricing subscreen maintain the accountdetermination procedure as 'KOFI00' and account determinationreconciliation account as 'KOFIAB'. Change document pricing procedureto the document pricing procedure '1' -Down Payment Poland (created instep one).

For the DP scenario with service items please copy the new billingtype FAF into FAFS - PL DP Invoice Service without(!) copy control.Assign to Cancell.billing type "S1S"- Cancel Invoice (S1S).

3. Maintain the copy control from the order to the new billing typecreated:

IMG path is Sales and distribution -> Billing -> Billing documents ->Maintain Copying Control For Billing Documents -> Copying control:Sales document to billing document.

Customizing example for material items:

Target billing type: FAF PL DP Invoice

Source sls doc. type: OR Standard Order

TAN - Standard Item

Pricing type should be 'B' - Carry out new pricing

Pos./neg. quantity should be '0' - Zero

Customizing example for service items:

Target billing type: FAFS PL DP Invoice Service

Source sls doc. type: OR Standard Order

06.03.2012 of 13


TAD - Service

Pricing type should be 'B' - Carry out new pricing

Pos./neg. quantity should be '0' - Zero

4. Create a new condition type PB01 - Gross down payment by copying fromthe condition type PB00:

IMG path is Sales and distribution -> Basic Functions -> Pricing ->Priccontrol -> Define condition types -> Maintain condition types.

Control data 1:

Cond. class: B Prices

Calculat.type: B Fixed amount

Maintain the condition category as blank.

Group condition:

Mark the Group condition.

Changes which can be made:

Mark the check boxes "item condition", Delete" and "Value".

Unmark the remaining check boxes in this sub screen.

Scales:

Scale basis should be blank.

5. Create a new condition type ZWIG - Tax from hund-stat by copying fromthe condition type MWIG - Tax from hundred:

IMG path is Sales and distribution -> Basic Functions -> Pricing ->Priccontrol -> Define condition types -> Maintain condition types.

Access seq: MWST

Control data 1:

Cond. class: D Taxes

Calculat.type: H Percentage included

Condition category: D Tax

Group condition:

Mark the Group condition.

06.03.2012 of 13


Changes which can be made:

Manual entries: D not possible to process manually

Mark the check boxes "item condition".

Unmark the remaining check boxes in this sub screen.

Master data:

RefConType: MWST

RefApplication: V

6. Create a new accounting key EDP - Down Payment:

IMG path is Sales and distribution -> Basic Functions -> AccountAssignment -> Revenue Account Determination -> Define and assignaccount keys -> Define account key.

7. Create a new pricing procedure by copying the pricing procedureRVAB02:

IMG path is Sales and distribution -> Basic Functions -> Pricing ->Pric control -> Define And Assign Pricing Procedures -> Maintainpricing procedures.

Let this copied pricing procedure be ZVAB02 - Gross Down PaymentPoland and change ZVAB02 according to attached pricing_ZVAB02.zip (seeattachments).

8. Define Pricing Procedure Determination:

In transaction OVKK - "Pricing procedures: Determination in salesdocuments" make an entry that the pricing procedure ZVABO2 is pickedup when billing using the billing type FAF.

Example:

Sales org / DocProc / CuPP / Pricing procedure

PL99 01 01 / 1-DP Poland / 1 / ZVAB02 DP Poland - Gross Pric

9. For the account key EDP assign the appropriate Deferred Revenues GLaccount number:

IMG: Transaction VKOA -> Table 005 - Acc Key

New entries as example:

06.03.2012 of 13


a) V KOFI CAPL PL99 EDP 845000 (= account for deferred revenue postingin down payment invoice)

b) V KOFI CAPL PL99 ERL 701001 (= account for sales revenue posting instandard invoice)

c) V KOFI CAPL PL99 ERS 701001 (= account for sales revenue posting instandard invoice)

10. Define settings in Reconciliation account determination so that the"Down Payments received" account is found instead of the normalreconciliation account during creation of down payment invoice:

In transaction OV64 maintain the "Down Payments Received"reconciliation account. This can be either at the sales org (table004) or sales org/distribution channel level (table 008).


VB KOAB CAPL PL99 205100

11. Maintain the "Down Payments received" account as the alternativereconciliation account:

IMG: Sales & Distribution -> Basic Functions -> Account Assignment ->Reconciliation account determination -> Define alternativereconciliation accounts


CAPL - G/L account:201000 - alternative account:205100

12. Maintain sales document type:

Go to transaction VOV8 - Maintain sales order types.

Change your sales order type (example: OR):

Billing - Dlv-rel.billing type: F2 - Invoice Billing - Order-rel.bill.type: Blank

Please continue with the following development changes:

User exit EXIT_SAPLV60B_008 in report SAPLV60B (function group V60B) isused to change the accounting entries during the creation of a deliveryrelated invoices by checking for any open down payment amounts.

13. For this do the following steps:

a) Call CMOD, enter new project name

06.03.2012 of 13


b) Enter Enhancement 'SDVFX008', function exit 'EXIT_SAPLV60B_008'

c) Maintain source code given in this note in ZXVVFU08.

d) Activate project and program.

Steps for printing the down payment related billing documents:

14. Create the new printing program for down payment billing documents

Go to transaction SE38 and create the new printing program with nameRVADINPLDP - Print program for Polish invoices with down payments.Maintain the following attributes for the program

Type - 1 Executable Program

Status - P SAP standard production program

Application - V sales

Development Class - ID-FI-PL

Uncheck the fixed point arithmetic check box.

Import the program code given in this note into the program andactivate it.

15. Create a new output type

In the transaction V/40 copy the output type RDPL to a new outputtype. You could name this output type as ZDPF - DP Invoices.

Go to processing routines. Make the following entries for for Medium 1- Print output. The program is RVADINPLDP, form routine is ENTRY_PLand form is called J_1PL_DP_INVOICE.

Delete the processing routines for other mediums. Save your entries.

Assign this output type to the output determination procedure that youhave assigned for the billing type FAF. The IMG path is -> Sales andDistribution -> Basic Functions -> Output Control -> OutputDetermination -> Output Determination using condition technique ->maintain output determination for Billing Documents -> Maintain Outputdetermination Procedure. Typically the output determination procedureused for billing documents is V10000.

In transaction V/25 assign the output type ZDPF to the billing typeFAF.

16. Changes required in Down payment pricing procedure copied from RVAB02(ZVAB02)

Copy the condition type MWIG to a new condition type ZWIG. Change thedescription to 'Tax from hundred-Stat'.

06.03.2012 of 13


In the pricing procedure ZVAB02 add the condition type ZWIG at stepnumber 810. Fill 99 in the from column. Check the mandatory andstatistical check boxes for this entry. Enter small case 'a' in theprint column. Ensure that against the condition type MWIG the printcolumn contains upper case 'A'. Save the pricing procedure.

Print layouts for the Down payment process:The print layouts for Down Payment Invoice, Clearing Note,Final Invoice are delivered with note 853068 - PL: Down Payment process forPoland - printouts.

Alternate numbering range for clearing documents:

If you require that the clearing billing document is to be numbered in anumber sequence sequence other than that for the normal billing documentsplease use the user exit USEREXIT_NUMBER_RANGE (Module pool SAPLV60A,program RV60AFZZ). The suggested code that can be used is given in thecorrection instructions. The number range that you would like to use forclearing documents needs to be set against the variablelv_clearing_no_range during data declaration.

Detailed Down Payment process description (example 1 - withoutcancellation):

Step 1: Creation of sales orderAccording to the polish law, DP amounts should be specified in relation toparticular tax rates, so that tax calculation should be possible based ongrouped items with the same tax rate (tax group). Also clearing of DPshould be based on this group.Transaction VA01: Creation of the order with 2 groups of items.

Example: Sales order 10 PL-MM1 1M TAN A3 20 PL-MM1 10M TAN A3 30 PL-MM1 20M TAN A3 40 PL-HAWA 1KG TAN A5 50 PL-HAWA 15KG TAN A5 60 PL-HAWA 25KG TAN A5

Step 2: Agreement with CustomerAn agreement with customer is made assuming, that he'll down payment (oneor more) on future deliveries and dividing into item groups.

Step 3: Payment in FITransaction F-29 (Post customer down payment):

06.03.2012 of 13


Customer pays down payment amount (1100 PLN).Please assign "A" as special G/L Indicator for down payment.

Posting schema in FI: 40 131000 Bank 1100,00 19 PL-KUNDE (205100) Customer down pay received 1100,00-

Step 4: Creation of down payment invoiceTransaction VF01: Creation of down payment invoice with billing type FAF-PL DP Invoice for the sales order. The down payment per tax rate group isgross amount based and will be entered in this way into the system. The taxamount are calculated automatically backward based on the gross amountsaccording the pricing procedure ZVABO2.

Select 1 material item of each tax rate group and maintain the conditionPB01 - Down Payment Gross with the down payment gross amount of this group.Repeat it for down payment amount of each tax rate group.

Example: 10 PL-MM1 1M TAN, Condition PB01-Down Payment Gross 1000 PLN 40 PL-HAWA 1KG TAN, Condition PB01-Down Payment Gross 100 PLN

Posting schema in FI: 09 PL-KUNDE (205100) Customer down pay received ** 1.100,00 50 222000 Output tax A3 107,14- 50 845000 Deferred revenue A3 892,86- 50 222000 Output tax A5 18,03- 50 845000 Deferred revenue A5 81,97-

Step 5: Clearing customer accountTransaction F-32 - Clearing customer account: The payment posting in FI(step 3) will be cleared against the down payment invoice (step 4). Thedown payment invoice accounting document gets the status "cleared".

Posting schema in FI: 09 PL-KUNDE (205100) Customer down pay received 1100,00 19 PL-KUNDE (205100) Customer down pay received 1100,00-

Step 6: Partial delivery of material and goods issue postingTransaction VL01N: Example 10 PL-MM1 1M 20 PL-MM1 2M 30 PL-MM1 3M 40 PL-HAWA 1KG 50 PL-HAWA 5KG 60 PL-HAWA 10KG

Step 7: Delivery-related Invoice with clearing noteDelivery created in previous step is billed. The clearing note should becreated as long as the value of a created invoice document is fully coveredby the remaining part of down payments made. Transfer posting of deferredrevenues to sales revenues is done. The reposting of the the calculated net

06.03.2012 of 13


value based on gross value of the DP invoice is made.

Transaction VF01: Billing type F2-invoice 10 PL-MM1 1M 100,00 20 PL-MM1 2M 200,00 30 PL-MM1 3M 300,00 40 PL-HAWA 1KG 10,00 50 PL-HAWA 5KG 50,00 60 PL-HAWA 10KG 100,00

Posting schema in FI: 01 PL-KUNDE (201000) Acc receivables A5 95,20 40 845000 Deferred revenue A3 600,00 40 845000 Deferred revenue A5 81,97 50 222000 Output tax A5 17,17- 50 701001 Sales revenues A3 600,00- 50 701001 Sales revenues A5 160,00-

Step 8: Delivery of material and goods issue postingTransaction VL01N: Example 10 PL-MM1 8M 20 PL-MM1 17M 30 PL-HAWA 10KG 40 PL-HAWA 15KG

Step 9: Delivery-related Invoice with clearing noteThe normal invoice is created with VAT calculation based on net value. Thedelivery created in previous step is billed. The clearing note generatesthe reposting from deferred revenues to sales revenues.

Transaction VF01: Billing type F2-invoice 20 PL-MM1 8M 800,00 30 PL-MM1 17M 1700,00 50 PL-HAWA 10KG 100,00 60 PL-HAWA 15KG 150,00

Posting schema in FI: 01 PL-KUNDE (201000) Acc receivables ** 2.777,00 40 845000 Deferred revenue A3 292,86 50 222000 Output tax A3 264,86- 50 701001 Sales revenues A3 2.500,00- 50 701001 Sales revenues A5 250,00- 50 222000 Output tax A5 55,00-

Detailed Down Payment process description (example 2 - withcancellation):

Step 1: Creation of sales orderAccording to the polish law, DP amounts should be specified in relation toparticular tax rates, so that tax calculation should be possible based ongrouped items with the same tax rate (tax group). Also clearing of DP

06.03.2012 of 13


should be based on this group.Transaction VA01: Creation of the order with 2 groups of items.

Example: Sales order 10 PL-MM1 1M TAN A3 20 PL-MM1 10M TAN A3 30 PL-MM1 20M TAN A3 40 PL-HAWA 1KG TAN A5 50 PL-HAWA 15KG TAN A5 60 PL-HAWA 25KG TAN A5

Step 2: Agreement with CustomerAn agreement with customer is made assuming, that he'll down payment (oneor more) on future deliveries and dividing into item groups.

Step 3: Payment in FITransaction F-29 (Post customer down payment):Customer pays down payment amount (1100 PLN).Please assign "A" as special G/L Indicator for down payment.

Posting schema in FI: 40 131000 Bank 1100,00 19 PL-KUNDE (205100) Customer down pay received 1100,00-

Step 4: Creation of down payment invoice with wrong amountTransaction VF01: Creation of down payment invoice with billing type FAF-PL DP Invoice for the sales order. The down payment per tax rate group isgross amount based and will be entered in this way into the system. The taxamount are calculated automatically backward based on the gross amountsaccording the pricing procedure ZVABO2.

Select 1 material item of each tax rate group and maintain the conditionPB01 - Down Payment Gross with the down payment gross amount of this group.Repeat it for down payment amount of each tax rate group.


Posting schema in FI: 09 PL-KUNDE (205100) Customer down pay received ** 110,00 50 222000 Output tax A3 10,71- 50 845000 Deferred revenue A3 89,29- 50 222000 Output tax A5 1,80- 50 845000 Deferred revenue A5 8,20-

Step 5: Cancellation of down payment invoiceTransaction VF02: Cancellation of down payment invoice because of enteringwrong amount. Changing of billing document => Cancel of billing document.

System reverses automatically the postings of the created billing document.

06.03.2012 of 13


Posting schema in FI: 19 PL-KUNDE (205100) Customer down pay received ** 110,00- 40 222000 Output tax A3 10,71 40 845000 Deferred revenue A3 89,29 40 222000 Output tax A5 1,80 40 845000 Deferred revenue A5 8,20

Step 6: Creation of down payment invoice with correct amountTransaction VF01: Creation of down payment invoice with billing type FAF-PL DP Invoice for the sales order.


Posting schema in FI: 09 PL-KUNDE (205100) Customer down pay received ** 1.100,00 50 222000 Output tax A3 107,14- 50 845000 Deferred revenue A3 892,86- 50 222000 Output tax A5 18,03- 50 845000 Deferred revenue A5 81,97-

Step 7: Clearing customer account

Step 8: Delivery of material and goods issue posting

Step 9: Delivery-related Invoice with clearing note withwrong amount

Step 10: Cancellation of Delivery-related Invoice withclearing note because of wrong amountEqual step 5: Transaction VF02: Cancellation of delivery related invoicebecause of entering wrong amount. Changing of billing document => Cancel ofbilling document.

System reverses automatically the postings of the created billing document.

Step 11: Delivery-related Invoice with clearing note withcorrect amount

Header Data

Release Status: Released for CustomerReleased on: 18.06.2008 11:12:01

06.03.2012 of 13


Master Language: EnglishPriority: Correction with medium priorityCategory: Legal changePrimary Component: XX-CSC-PL-LO Logistics

Secondary Components:SD-BIL-IV-DP Down Payments

XX-CSC-PL Poland

Valid Releases

Software Component Release FromRelease

ToRelease

andSubsequent

SAP_APPL 46 46B 46B

SAP_APPL 46C 46C 46C

SAP_APPL 470 470 470

SAP_APPL 500 500 500

SAP_APPL 600 600 600

Support Packages

Support Packages Release Package Name

SAP_APPL 46C SAPKH46C52

SAP_APPL 470 SAPKH47026



Related Notes

Number Short Text

1629758 DP PL: Alternate number range for the clearing invoices

1587818 DP Poland: Redesigning of Down-payment functionality

1464694 Error F5 704 - Inconsistent Amnts in Invoice with Down Pymnt

1383455 Error F5702 produced when trying to post final downpayment

1244831 Invoice quantity doubled when DP Invoice cancelled - Poland

1241359 Incorrect Downpayment values in one-step invoice for Poland

1179924 Incorrect exchange rate picked for DP invoice for Poland

1167396 DP invoice not considered in final invoice print for Poland

1013558 PL: Correction Invoices in DP process - printouts

1007635 PL: Handling Correction Invoices in DP process

956434 SD DP Poland: DP functionality with multiple exchange rates

934940 Down Payment Poland: Invoice Printing is incorrect

893050 Incorrect printing of invoices for down payment process

853068 PL: Down Payment process for Poland - printouts

Attachments

06.03.2012 of 13


FileType

File Name Language Size

ZIP pricing_ZVAB02.zip E 23 KB

Correction Instructions

CorrectionInstructions

Validfrom

Validto

SoftwareComponent

Type*)

ReferenceCorrection

LastChanged

371541 46B 600 SAP_APPL C 23.03.200610:09:39

381291 46B 600 SAP_APPL C NL1K900671 23.03.200610:59:18

436656 600 600 SAP_APPL C P7DK012258 11.11.200509:20:58

734752 46C 46C SAP_APPL C P9CK448249 02.09.200508:41:12

747030 470 470 SAP_APPL C P6BK202801 02.09.200508:39:26

747031 500 500 SAP_APPL C P6DK056882 02.09.200508:39:58

*) C Correction, B Preprocessing, A Postprocessing, M Undefined Work

sapnote_0000818079

Documents

source sls doc

goods issue posting

pricing procedure zvabo2

target billing type

billing type f2

billing type faf

system reverses automatically

condition type zwig