Electronic Reporting: Want to Bind the Registration Ids of Company in Model Mapping

(0) Share

Report

Posted on by Prashanth Shanker

I just add the Registration Ids as Node (Record List) and Add two Siblings (Registration Name and Registration Type) in the Data Model.

I want to Bind the The Registration Ids in Model Mapping. Please check the attached file and guide me.

Actually Company have more Licenses instead of Tax Registration. So I add the other Licenses Numbers as Registration Ids.

Please let me know this right approach to define the Registration Ids as Record List in Data Model. Please guide about this.

Once I get the Registration Ids related to Company then I will show them in one line in Format Mapping using Formula like:

ACN: 123456, Police Number: 7678888

0131.0a-Registration-IDs-for-Company.PNG

2133.1a-Add-the-node-of-Registration-IDs-in-CompanyInfoDataModel.PNG

8662.1b-Add-RegisterNumber-as-String.PNG

5381.1c-Add-RegisterType-as-String.PNG

3021.1da-In-MappingModel-I-want-to-Bind-the-RegistrationIds.PNG

5100.1db-In-MappingModel-I-want-to-Bind-the-RegistrationIds.PNG

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Adrian Vlad on at

Like (0)

Report
Copy link

Link copied!

Hi Prashanth,

Please consider to open a support request.

If you want to continue on your own, you can explore FTA VAT AUDIT FILE (AE) configuration and look at the supplier/customer TRN number:

This code retrieves the tax number form Registration ID of the primary address by validating the tax type= TRN

Best regards!

Was this reply helpful? Yes No
Verified answer

Arsalan Muhammad Am... 60 on at

Like (1)

Report
Copy link

Link copied!

Hey Dude

First you have to fetch the records using Runnable class then map those field in your Electronic Report Mapping. Hope you understand. Have a look and if satisfied, mark this YES :

class RunnableClass1

{

public static void main(Args _args)

{

LegalEntity legalEntity = CompanyInfo::findRecId(CompanyInfo::current()).RecId;

info(strFmt("%1",legalEntity));

TaxRegistration taxRegistration;

TaxRegistrationType taxRegistrationType;

DirPartyTable dirPartyTable;

DirPartyLocation dirPartyLocation;

select * from dirPartyTable

where dirPartyTable.RecId == legalEntity;

select * from dirPartyLocation

where dirPartyLocation.Party == dirPartyTable.RecId;

while select taxRegistration

join taxRegistrationType

where taxRegistration.RecId ==taxRegistrationType.RecId && taxRegistration.dirPartyLocation == dirPartyLocation.RecId

{

info(strFmt("Registration Type: %1 and Registration Number: %2",taxRegistrationType.TaxRegstrationType,taxRegistration.RegistrationNumber));

}

}

}

Was this reply helpful? Yes No
Prashanth Shanker 40 on at

Like (0)

Report
Copy link

Link copied!

Hi Arsalan

Much appreciated you resolved my problem. Thanks buddy.

Was this reply helpful? Yes No
Suggested answer

K.G 20 on at

Like (0)

Report
Copy link

Link copied!

There's no need to develop a class. A series of Table record and FILTER functions will give you what you need.

Start with companyinfo

Add dirPartyRecords

Add dirPartyLocation

Create a separate calculated field for a record list

Start with TaxRegistrationType

filter for TaxRegistrationType.TaxRegstrationType="VATID"

Add calculated field using FILTER for TaxRegistrationTypeApplicabilityRule

Add calculated field using FILTER for TaxRegistration with TaxRegistration.TaxRegistrationTypeApplicabilityRule=TaxRegistrationTypeApplicabilityVAT.RecId

Lastly, add the filtered tax registration to dirPartyLocation

Was this reply helpful? Yes No