Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Lewis Rosenberg]

Has anyone mapped a tax (TXI) segment at the invoice (EDI 810) line level using Lanham EDI and if yes, how did you map the tax amount (TXI02)?  Lanham EDI captures the entire invoice tax amount as an EDI OUT field, but I do not see a line level tax amount field anywhere.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Commitee
NAVUG Membership Committee
——————————

[Joel Baines]

Hi Lewis

 

Who wants the tax information in their 810 at the line level?    Do you have an implementation guide?   It is normally included as a summary level transaction only.

 

It’s normally in a TXI segment after the TDS

[Don’t forget to repeat segment on the SEGMENT SCREEN for TXI]

 

 

Joel Baines, PMP, MCP

Navision Business Analyst

 

______________________________________________________________________
This transmission may contain information that is privileged, confidential and /or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the information contained herein is STRICTLY PROHIBITED. If you receive this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Unless stated otherwise, any test results included or attached to this email are provisional, and may be subject to revision at a later stage.

This email is sent on behalf of Exova Group plc or the relevant subsidiary with which you are dealing. Exova Group plc is a company incorporated in England and Wales with registered number 08907086. Its registered office is at 6 Coronet Way, Centenary Park, Eccles, Salford M50 1RE.

Exova is the trading name of Exova Group plc and its subsidiaries.

Exova Warringtonfire Aus Pty Ltd is registered in Australia with its registered office at Unit 2, 409-411 Hammond Road, Dandenong, VIC 3175, Australia, ABN 81 050 241 524.

Please consider the environment before printing this e-mail and any associated attachments.
_____________________________________________________________________

——Original Message——

Has anyone mapped a tax (TXI) segment at the invoice (EDI 810) line level using Lanham EDI and if yes, how did you map the tax amount (TXI02)?  Lanham EDI captures the entire invoice tax amount as an EDI OUT field, but I do not see a line level tax amount field anywhere.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Commitee
NAVUG Membership Committee
——————————

[Jason Chance]

Hi Lewis.  

We did this on our outgoing EDI810.  We just created a new EDI Out field called ‘Line Tax Amount’ and added this code to the LoadEDIOutFields() function in codeunit 14002360

‘Line Tax Amount’: DecimalVariable := SalesInvoiceLine.”Amount Including VAT”-SalesInvoiceLine.Amount;

I hope this helps. 

——————————
Jason Chance
Senior Programmer/Analyst
Seventh Generation
Burlington VT
——————————
——————————————-

[Lewis Rosenberg]

Thanks Jason,

Unfortunately my developers license won’t let me develop!  Sometimes I wonder why this license is even offered.  I understand protecting historical data, but there has to be a better way.

..and Stephen, yes it is for a customer in Canada.  We figured out all the NAV tax setups and now we’re just trying to satisfy the EDI requirements.  We’ve never had to send a TXI at the line level before; only at the total level.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Commitee
NAVUG Membership Committee
——————————
——————————————-

[Lewis Rosenberg]

Hey Jason,

I just wanted to thank you and let you know that your solution worked.  I just needed to get my NAV partner to make the CU change, since my license would not allow it.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Stephen Marsh]

Yes, and because we have different tax levels and types of tax that may apply to the invoice, it was a bit of a puzzle.

First, we set up entries in the General Cross References to link the Tax Jurisdiction Code from the Tax Jurisdiction table to the appropriate Customer’s tax identifier. Then, in the map we set up TX1 as a repeat segment and did a Reverse Cross Reference to the Tax Jurisdiction Code (to populate the TX01 element with the Customer’s tag) from the VAT Entry Table and then pulled the tax Amount from the same table entry.

I can’t remember if the Tax Jurisdiction Code (Outbound) cross reference was a custom piece we had Lanham perform.

We’re in Canada so, this may not work for your tax setup but it may be of some help.

——————————
Stephen Marsh
Enterprise Services Manager
Axxess Logistics
Vaughan, ON
Canada
——————————
——————————————-

[Stephen Marsh]

To expand a bit on my previous comment, I’ve included some screen caps of the General Cross Reference entries and the elements of the TX1 segment.

——————————
Stephen Marsh
Enterprise Services Manager
Axxess Logistics
Vaughan
——————————
——————————————-

[Dave Cintron]

Lewis,

The newer versions of Lanham EDI allow you to map the 810 TXI to the VAT Entry table as a repeating segment. What is your SEO version?

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Lewis Rosenberg]

It looks like SE0.60.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Dave Cintron]

Then this should work for you:

Multiple taxes can be mapped from the VAT Entry table using the “Repeat Segment” setting on the E.D.I. Segment page. Mapping from the VAT Entry table was introduced in SE0.55.03.

Tax Jurisdiction General Cross Reference is # 28 in the E.D.I. General Cross Reference table. It’s an outbound cross reference that is used with the Reverse Cross Reference feature. It will allow the mapping of the Customer’s Tax Code for a specified NAV Tax Jurisdiction code.

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Lewis Rosenberg]

What do you mean by “Repeat Segment”?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Dave Cintron]

This is an example of a live 810 with TXI using Lanham SE0 60 (sorry, header got cut off the segment list. The column on the right is “Repeat Segment”)

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Lewis Rosenberg]

So that’s for multiple tax codes on a single invoice?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-