Collector File FYE post back Question

Answered

Comments

8 comments

  • Avatar
    Cathy Salino

    Misty, we just posted a Payroll Accrual back to FY 20.  We loaded the file manually, so we may have proactively manipulated the file.  We did something similar with our final Concur load for the year.  I will ask "how" we do it.  If I remember correctly, we do allow one unit to post their collector file each month in the first few days of the next month. I will confirm and comment back on the how.  Cathy.

     

    0
    Comment actions Permalink
  • Avatar
    Kymber Taylor

    Misty, we don't have a current JIRA to address this. I will create one and we can try to address this prior to next fiscal year end. 

    Cathy, I'm guessing that the Payroll Accrual file you are loading does not have detail lines. The detail lines on a Collector file go into a separate details table that is not accessible from the front end in base. Following is an example of an AC and a DT line. 

    2010BL1031400 4166 AC 10ID01EU06302009 Tricia-Varga 00000000000000002.15C2009-06-30 ID01EU156961
    2010BL1031400 4166 DT 01ID01EU06302009 00000000000000002.15Dtest additional test here

     

    Thanks, Kymber

     

    0
    Comment actions Permalink
  • Avatar
    Misty T Mccormick

    Thank you Cathy and Kymber- I appreciate the information~ 

    Kymber, if you wouldn't mind posting the JIRA number when it's created, I can cross reference on our UA JIRA.  Cheers!

     

    0
    Comment actions Permalink
  • Avatar
    Kymber Taylor

    Hi Misty, are these files being loaded through the Collector File Upload or are they being dropped somewhere? And then error out when the collector job is run? 

     

     

    0
    Comment actions Permalink
  • Avatar
    Misty T Mccormick

    Our collector units drop their files to unique integration directories; we then have a batch job (utilizing control-M) that moves them to staging and creates a matching done (ex staging/gl/collectorFlatFile or staging/gl/collectorXml).

    The log error reads as follows for each entry in the file:

    error: 2020-07-01 19:44 Detail record with key 2020, 01, UA, 2421500, -----, 4690, ---, EX, 2012UR1, IB, AR does not have a matching gl entry record.

    The collectorJob succeeds, but nothing is processed as every line errors, the report reflects:

           ----- THIS FILE WAS NOT PROCESSED AND WILL NEED TO BE CORRECTED AND RESUBMITTED -----
    0
    Comment actions Permalink
  • Avatar
    Kymber Taylor

    Thanks Misty - interestingly, the XML detail version includes a fiscal period.  

    0
    Comment actions Permalink
  • Avatar
    Misty T Mccormick

    Yup, we had tried inserting the correct period of 12 (also tried 13), but it isn't respected when posting back and defaults to 01.

    0
    Comment actions Permalink
  • Avatar
    Kymber Taylor

    OK - I've created FINP-6876. 

     

    Thanks, Kymber

     
     
     
     
     
    0
    Comment actions Permalink

Please sign in to leave a comment.