EDI TXI Segment in 810 Transaction

We don't have to deal with state tax here but it doesn't look like you're missing anything to me. What does the MA540CSV file look like after the 810 is processed?

Did you set up ST as an Add On Cost Code?

Hey Guys,

I actually had figured it out a couple days ago but just hadn't had time to update the thread. Unfortunately I don't have any MA540 data to share to show the problem for anyone else that runs into it.

The problem was in the substitution table, the external value needed to be "TX" and then relate that back to the MA08.1 record (ST). It was actually kind of a pain to notice because we only get taxed for a couple vet locations that we buy for and that's really only once every week or so.
Here's an example of how I made it work.
List name- L1_TAX_TO_AOC
Your value- ST
External value- TX

It's actually a little counter-intuitive because the TXI01 segment comes across with the value of "ST" or "LS" and typically that's what you put in the external value of the sub table for SAC 02 codes.

Counter-intuitive yes. Doesn't seem to follow the rule at all. I did find the code in the laws_inb_91_la4010 file that handles this routine.

##### 810 INVOICE ROUTINES #####

#####

sub process_TXI {

print_calling( $TRACE_LEVEL, \@_ ) if $TRACE_LEVEL;



my $segment = shift;

my $level = shift;



next if ($loop eq 'SAC' && $substitutions->{'MAP_AOC_TAX'} eq 'N' );



my $aoc_code;

## see if there is a TAX_TO_AOC record

$aoc_code = $substitutions->lookup( $tpid . '_TAX_TO_AOC', $segment->[1] )

|| $substitutions->lookup( 'L1_TAX_TO_AOC', $segment->[1] );



if ( $aoc_code ) {

create_AOC( $aoc_code, $segment->[2], $level );

return;

}

### default through to processing as tax

### if tax_as_aoc not set or aoc_code not found

if ( $level eq 'SUM' ) {

$sum_tax = $sum_tax + $segment->[2];

}

elsif( $level eq 'DTL' ) {

$line_tax = $line_tax + $segment->[2];

}

Hey John, 

Thanks for throwing that up here. I'm not sure I have access to view that or where I would be able to. 

 

I do have a new issue concerning this subject though; now that we're processing the tax in the TXI01 segment we're running into a new error in MA54 where we get the message "Add on cost total amount cannot be zeroes" if the vendors send a "0" for the tax amount. 

 

I put in a ticket to Infor and they said that this is normal behavior, but I also added the substitution table record below in an attempt to remap the tax. 

 

L1_TAX_TO_AOC

LS

LS

 

here's the raw 810 data:

PID^F^^^^VERIFY HPU CHEMICAL INDICATOR (200/BX)~ 

TDS^8659~ 

TXI^LS^0~ 

SAC^C^G830^^^959~ 

CTT^1~ 

SE^26^829370001~ 

GE^1^282937~ 

IEA^1^001496577~

 

It actually applied the tax to the AOC tab, but left the amount field blank, so the substitution table entry seems like it's working correctly. Does anyone know if we can avoid this or is it something that we need to tell vendors not to send tax if there's "0"? 

 

 

Because you need to transfer the tax amount to AOC when there is

an amount you can't really do anything with the substitution tables to correct this. I think you'll have to ask the vendor if they can change this on their end.

Yeah, that's what Infor said too. I was just curious to see if anyone had found a workaround. It looks like for now we'll be doing an addins query and accompanying upload to delete those aoc lines.

Thanks for the insight!