I've checked EXIT_SAPLV50G_001 function, but it doesn't contain the MM invoice document details, it only contains information about the Purchase order.
you have to code the select yourself. How you get from the purchasing document to the invoice: in table EKBE - PO history you find the invoice - and from there you can go an find the invoice vendor in RBKP, and from there you can select at LFA1 general data vendor to check if the country is in the EU or not.
I thank you for your help .... and for the time you lost to try to help me ...
The problem is solved ... I wrote to SAP and Sap confirmed me that the solution was to change the standard program
My message to SAP:
Hi,
we have 2 big problems with Italian INTRASTAT, because in ITALY Import
(MM) Intrastat MUST be related to the invoice, not to the purchase
order:
1) Purchasing office creates orders related to EU-vendor.
After, the accounting office receive 2 partial MM invoice related
to an only purchase order line item.
These 2 partial invoices are from:
- one, an USA vendor (No intrastat)
- one, an EU vendor (Intrastat)
When we create the Intrastat, the system checks the Order vendor land so, for the system all our invoices are INTRASTAT, but this is wrong. System doesn't know that the first invoice should be excluded
from the declaration.
We know that the system give us the possibility to use the
incl./excl field but it is a purchase order line information, and
for us it's not enough, we need an invoice incl/excl field.
User exit are related to purchase order, not to purchase order
history.
2) There are some MM invoice that are related to transport, so we need
to post to the order, but we mustn't declare them in INTRASTAT.
How can we exclude them? Some purchase order invoices should pass in
Intrastat, but some others not.
I gave a look to OSS notes, but no one seems to be right for us, could
you help us to understand? For us is a legal requirement. For our
INTRASTAT shouldn't be based on the purchase order, but to the MM
invoice.
Please, let us know.
Thanks
Lara
SAP answer:
Dear Ms.
ad 1)
indeedn, the intrastat selection is always done based on the purchase
order document (for good reasons, in my opinion).
But I guess the relevant point is not the invoices but the country
where the goods are delivered from?!
Maybe a part of the problems can be solved by using inbound deliveries/
shipping notifications for the puchase orders (transaction VL31N). Then
set selection logic 'A' in customizing for the intrastat selection
program:
SPRO: material management --> purchasing --> foreign trade/customs -->
periodic declarations --> control data --> data selecton control -->
data selection control:
Intrastat / Italy / 1 Receipt --> doubleclick -->
selection criterion:
set value 'A' (Shipping notification and invoice will be considered)
In this case the dispatching country is taken from the foreign trade
item data of the shipping notification (field EIPO-VERLD). This way it
is possible to handle different dispatching countries.
ad 2)
It is not possible to distinguish different kind of invoices.
Such critical documents should be excluded completely from the
intrastat live run; the missing data can be added to intrastat by
transaction VEFU.
Another option is to modify the system. A good place is:
FORM eleminate_po_hist_items_before in program RMIMSELS
where you may delete item history records from further processing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.