Good day Team,
I am trying to push the current period to all bills imported into the Bills and Adjusment screen, The import scenario is suppose to set to import bills into the Bills and Adjusment Screen, I am having some of the bills been set with the Correct Period and other dot not work
The import scenario is using the Post Period to be: =Right('0' + CStr(Month(Today())), 2) + CStr(Year(Today())) also, tried with the ‘-’ =Right('0' + CStr(Month(Today())), 2) + ‘-’ + CStr(Year(Today())), with the Comit Set to true and the Ignore Error set to true as well, I get some mix results
Results:
With The data from the import being:
Somehow the import for bill number 6 is good, but import for 5 and 7 is not working giving the error the 04-2025 and 05-2025 period is locked, also, the other June bills, instead of defaulting to 07-2025, is setting to be 06-2025 as the period is still available.
Any help will be awesome. Thank you!