Skip to main content
Solved

Post period to default to Business Date instead of Date from AP Transaction


martingaxiola
Varsity I
Forum|alt.badge.img

Good day team,

 

We are trying to default the Post Period to the business Date using an import scenario, so if business Date is on Febrary to be 02-2024 or if business date is January to be 01-2024 even if todays date is March. We still not have any luck with this, has a solution by using an import scenario?

 

Thank you Team!

Best answer by bheyns05

Hi Martin

 

Yes I would suggest to build the above into the generic inquiry and then use that generic inquiry in your import scenario then it should work. If you leave the period blank in any import scenario then Acumatica auto calculates the period for you. Each of my customers have different financial years so I always leave the posting period blank during my import scenarios.

 

If you have any issues then you can just export the GI and import scenario and share it with me then I can have a look for you.

 

Kind regards,

Bettie

View original
Did this topic help you find an answer to your question?

6 replies

bheyns05
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 19 replies
  • March 13, 2024

Good day Martin

 

I am assuming that your import scenario is based on a generic inquiry from the AP Transactions screen. Have you tried using the formula used in this article to add the current FinPeriod in your import scenario rather than the AP Tran FinPeriod?

 

 

Kind regards,

Bettie


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 100 replies
  • March 13, 2024

Good Morning @bheyns05 ,

 

We are importing Concur Data files for Expenses and AP transactions, but we want to use the Business Date in Acumatica to drive the period, instead of forcing the current date on the period by todays date or the default by the date of the transaction, we are using something similar as the formula you provided, but wanted to see if there is something with the Business Date.


bheyns05
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 19 replies
  • March 13, 2024

Hi Martin

 

Mmm this is an interesting one, the only other way I can think of is to create a Parameter in the Generic Inquiry called BusinessDate and setting the default value to @TODAY

 

Then on the Results Grid add the newly created parameter

 

then on the generic inquiry screen you will find that the new column BusinessDate updates to the Acumatica BusinessDate. See example below I updated the Business Date in my header to 4 March and the generic inquiry displays 4 March even if today is 13 March.

 

Future dates also possible:

 

Then if you leave the posting period blank and use this date in your import scenario then Acumatica will auto calculate the posting period based on this date during the import.

 

Hope this helps.


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 100 replies
  • March 13, 2024

Hola @bheyns05 ,

Do you know if this would work on a Import Scenario? We are going to test this to see if it works. Thank you so much for your response!!!


bheyns05
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 19 replies
  • Answer
  • March 14, 2024

Hi Martin

 

Yes I would suggest to build the above into the generic inquiry and then use that generic inquiry in your import scenario then it should work. If you leave the period blank in any import scenario then Acumatica auto calculates the period for you. Each of my customers have different financial years so I always leave the posting period blank during my import scenarios.

 

If you have any issues then you can just export the GI and import scenario and share it with me then I can have a look for you.

 

Kind regards,

Bettie


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 100 replies
  • March 14, 2024

Thank you @bheyns05 , we will try this gi import idea. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings