Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0048754
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo Localizations] Localization Portugalmajoralways2022-03-09 15:502022-03-10 12:54
ReporterucarrionView Statuspublic 
Assigned Tojorge-garcia 
PriorityhighResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Regression introduced in release
Summary

0048754: Copy store process fails if there is a document type with no fiscal prefix defined

DescriptionWhile running a Copy Retail Store process for a Portuguese configured store, if there is any involved document type that has no document type prefix defined, the copy store shows an error.

FIND THE ERROR LOG ATTACHED
Steps To Reproduce-Login the backoffice, select an store set as Portuguese Configuration=true
-Open the document type document and filter for the mentioned store
-Take the POS Order and set the document type prefix (portuguese configuration section) and set is as empty.
-Do a copy store process using the mentioned store as template
-You will get an error
Proposed SolutionCould be some cases where, by any reason, some document types have no document type prefix. I would say, if the document is not SAFT signed, I wouldn't care of it during the copy store.
TagsNOR
Attached Filestxt file icon 48754log.txt [^] (25,192 bytes) 2022-03-09 16:22 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0048763 acknowledgedRetail Retail Modules To include Tax Id organization info in Copy Retail Store window 

-  Notes
(0135619)
jorge-garcia (reporter)
2022-03-10 12:54

 Once SAFT prefix for a document type is set, there is no way to change it through the ERP, however, it is possible to change it through a database query

The query used to change it was:
update C_DocType set em_saft_doctype_prefix = '' where c_doctype_id = '511A9371A0F74195AA3F6D66C722729D';

The problem with this query is that the em_saft_doctype_prefix is not null (indicating the field has a value) and then the regular expression to verify the prefix contains only uppercase letters fails

Instead, if it is needed to delete a SAFT prefix through database, should be:
update C_DocType set em_saft_doctype_prefix = null where c_doctype_id = '511A9371A0F74195AA3F6D66C722729D';

- Issue History
Date Modified Username Field Change
2022-03-09 15:50 ucarrion New Issue
2022-03-09 15:50 ucarrion Assigned To => aferraz
2022-03-09 16:20 rafaroda Tag Attached: NOR
2022-03-09 16:22 ucarrion Description Updated View Revisions
2022-03-09 16:22 ucarrion File Added: 48754log.txt
2022-03-09 16:37 aferraz Assigned To aferraz => jorge-garcia
2022-03-10 12:54 jorge-garcia Note Added: 0135619
2022-03-10 12:54 jorge-garcia Status new => closed
2022-03-10 12:54 jorge-garcia Resolution open => unable to reproduce
2022-03-10 15:19 jorge-garcia Relationship added related to 0048763

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker