SAF-T for Romania, adding additional fields in Analytics reporting

[fabionii]

Hello experts!

I'm currently implementing the NON_RESIDENT SAF-T report for Romania, in DRC, and one of the current pain point for my user is the lack of some specific fields in the Analytics reports to review the generated SAFT xml file. As of now, we currently have 2 reports tied to it : PURCHASE_INVOICE_LINE_ITEM_A and  SALES_INVOICE_LINE_ITEM_A. And for in the sales line item report, for instance, we dont have the billing document number as an option (in BSEG I have the information under Ref.document field (AWREF)).

After some research, I'm suspecting that my only alternative would be to extend the report to a custom Z, create a new CDS view(s) (copy of C_RO_SAFTSALESINVOICEITEMQ) by adding this and the other fields she need, and then creating a new query to be added to the list of analytical options in that screen.

Wanted to check with the experts if this is the best approach for this and if you guys had any similar experience...

Thank you,

Fabio Nii

[gergely_komjathy]

Hi Fabio,

in case of RO SAF-T, analyze data is provided only on the line item level (<nsSAFT:InvoiceLine>). Invoice header information (<nsSAFT:Invoice>), analysis types (<nsSAFT:Analysis>) and taxes (<nsSAFT:TaxInformation>) are not included. 

For verification of the xml content it is recommended to always check the xml directly. You can also check the data preview, which should have all the data reported in the xml.

I would not recommend to create a copy of the cds views and change the analyze data queries. You can extend the cds views (both C and Q views should be extended) to add more fields to the current queries: EXTEND VIEW ENTITY

Also, the queries are replaced with C_RO_SAFTNonResidentSlsInvcC/C_RO_SAFTNonResidentSlsInvcQ and C_RO_SAFTNonResidentPurInvcC/C_RO_SAFTNonResidentPurInvcQ, so these should be enhanced if required after the latest changes to the report are applied, not the old ones.

Best regards,

Gergely