How do I handle the error for the period when entering a doc date into a bill through an import scenario?

If this isn’t a common import scenario that you have to run I’d add Period to the import file and add period to the import scenario.  

In Excel do it manually or create a formula that use the oldest open period if date is before oldest date that does not cause an error.  

They will be using this import scenario weekly.

I do have period in the import file.  I am setting it to a period based on a formula on the current date.  The problem is the date of the bill.  When it enters the date and the date is not an open period, there is an error that the period is not available.  I want to move past this error so I can then insert the correct period.  (this is how I would do it if I was in the Bills screen).  However, when the import scenario hits that error then it will not continue to the next step to allow me to update the period.

Hello,

I understand you are trying to set an old date with an open period, Date/period mismatch intentional.

Are you a member of Financial Supervisors role? If not, add Financial Supervisor role to yourself and others that may import. The error on the older date should change to a warning.

Did you already try checking ON Ignore Error on in the Import Scenario?

Laura

I was able to replicate her issue and I was thinking the same thing and ignore error didn't do it.  The dialogue box with 'OK' right after Post Period did work.  

For me the dialog answer did not work. But ignore error on the Post Period field worked. But this is only for one row. For the second row, the error pops up again.

Any idea?

It is all good now. There was a duplicate line in the import scenario.