Release/Reopen Orders

Roelof

I have a hard time with Releas/Reopen orders.
In one database I can without any problems release/reopen orders, while in another database I get an error message 'Tax Detail Line not found'.
In both cases I tested the fields 'tax liable', 'tax group code' and 'tax jurisdiction code' fields. All the settings are the same in both databases. Or do I miss something?

Please help!

Thanks.
Roelof de Jong.

Savatage

is this a problem with sales order or purchase orders or both?

lakshmivalluru

Hi,

Let me see if i can throw some light on this..When you try to release the order,the system tries to calculate and update VAT lines again.Hence the error with VAT.Firstly,You can know the place of error by activating the debugger on.Secondly, may i ask you to check if both the databases are of same version ? and if so..check the setups.Last thing you can do is compare the table 37,codeunit 80,414 and 398 by taking the objects in text format from both the databases.Hope this helps u....

Steve_Kaill

Hmm...sounds like you are missing a tax detail line in sales tax setup for a jurisdiction/tax group the order is using. Check the tax area (both header and line!) for what jurisdictions are being used and the line tax group to ensure all jurisdiction/group combinations are setup in tax detail.

You must nail down if this is a setup or code issue. Probably the best first step is to ensure as best as possible that the setup is the same. Places to look include G/L Setup > Tax Posting Group > Tax Posting Setup and G/L Setup > Sales Tax > Groups, Areas, Jurisdictions and Detail. Make sure all important columns are showing and compare the one that works with one that doesn't.

Second is go into each of the orders and do a ctrl-f8 (Zoom) on the header and then the lines. Check for differences in any of the tax fields including tax bus. and prod posting group, tax group, tax area, etc.

If it all looks the same then it sounds like it's time to compare the code!