Description |
[http://inet.irelyserver.com/display/GL/14.4+One+Time+Closed+Year+Conversion?focusedCommentId=47907386#comment-47907386]
**** You will need to delete BBF records for all years that you are converting from glarcmst in the glhstmst.
Example:
glarcmst Year 2013
glhstmst will have BBF records for all years prior + Year 2013. You will need to delete 2013 BBF records ONLY.
The closing of fiscal year 2013 in i21 will create these records. By keeping the 2013 BBF records it will be a duplicate of the closing journal entries that i21 will make.
Here's Agrowstar's conversion of closed year 2013:
select distinct glarc_period from glarcmst
order by glarc_period
glarc_period
201301
201302
201303
201304
201305
201306
201307
201308
201309
201310
201311
201312
Here's the entry you need to delete out of glhstms during conversion.
select * from glhstmst where glhst_src_id = 'BBF' and glhst_period = '201312'
|