Search Engine: Elastic

Article ID: 129409, created on Sep 13, 2016, last review on Nov 21, 2017

  • Applies to:
  • Business Automation 7.1
  • Business Automation 6.0

Symptoms

No revenue reports are sent from the specific installation. Send Revenue Report event fails with an error message:

cast to numeric type on NULL value

Cause

The root cause of the issue is empty (NULL) values for "TaxAmt_Code", "TaxAmt_Value", "TaxInclAmt_Code", "TaxInclAmt_Value" in "DocDet" table.

For Odin Automation Premuim 7.0 or earlier:

The issue is caused by #PBA-67982 "CreateManualOrder_API may set incorrect Tax Category"

For Odin Automation Premuim 7.2, if EZTax is configured for taxes calculation:

The issue is caused by #PBA-83065 "An Order Detail with NULL Taxes can be created by EZTax with leads to Revenue Report generation fail".

Resolution

Contact Odin Technical Support Team to resolve an issue.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 3627d36199b8ff577605df76e2fa222b bb7e9177fb03488961a3ea554120f328 7c0b495571a6c1bec50e4f324a20ec14 b2c3b33425dfc50c7d41a2efaa7f84f3

Email subscription for changes to this article
Save as PDF