Readsoft User's Forum
Register Latest Topics
 
 
 


Reply
  Author   Comment  
Ignacio

Senior Expert Member
Registered:
Posts: 60
Reply with quote  #1 
Hi all,

I would like to know if any of you have Repetitor installed and how do you manage FI invoices. I have a requirement from one of our Countries, where they would like repetitor to post with posting date = last day of previous month during the first days of the month. Example: during the period 1-5 of June, they would like repetitor to post with posting date = 31 May.

Our posting date in Process Director is usually blank, I know we could fill it with 31 May (in our example), but for workflows approved after month end repetitor would error for these documents as May would be a closed month.

I would like to know how do you manage this, provided someone around here is using Repetitor.

Many Thanks for any advice.

Kind Regards.
0
kmonroe

New Member
Registered:
Posts: 6
Reply with quote  #2 
We do use Repetitor for FI docs.  We do not change the posting date, instead the accountants review the postings and make accruals where necessary. This is the same principal we apply to all interfaces into the GL that create postings: the posting date is the date the program executes.
0
Ignacio

Senior Expert Member
Registered:
Posts: 60
Reply with quote  #3 
Many thanks for your reply kmonroe.

The problem is that this country has a requirement to not to mix postings in two periods, this is due to the Tax Agency (the country is Italy). Then in my example they keep period 6 closed until they have finished postings in period 5 (about 4 working days). I guess you keep both periods open, we do the same in the rest of the group, but for Italy this is not a solution.

Kind Regards.
0
nicothebee

Senior Expert Member
Registered:
Posts: 120
Reply with quote  #4 
Hello,

In Italy the SAP accounting document numbering must be sequential and chronological. This is the big constraint.
To unsure that, we generally define a field status group that prevent the posting date to be manually selected by the AP Clerc.
In your case, this will not work during the closing period.
You then need a user exit that will set the posting date. The main point is that, if the posting fails, for some reason, the posting date should be left initial.
I would do it as follow :
- create a function group with 2 function modules and a top report
- the top report declares a global variable (date type)
- 1 function module with template /COCKPIT/USEX_BEFORE_POSTING. This function module will check if the FI period for the current date is closed. If it is so, it will populate the global variable with the last day of the previous month. This function module is declared in /COCKPIT/C13 for exit 004 (specifically for your italian companies).
- 1 function module will just return the global variable. This function module will be called from a FI substitution rule (just check that this field is available for substitution: I am not sure of it). The substitution rule will call the function module and apply the returned date if not initial.

The process will then be :
- at the posting (from REPETITOR or from the Cockpit transaction), the user exit "before posting" will populate the global variable if we are in a closing period.
- the substitution rule will read this global variable and force the posting date when required
- if the posting is successfull, the PD-AP document is updated from the FI document (is specified in /COCKPIT/C6).
- if the posting is unsuccessfull, the PD-AP document is not updated

Hope this helps...

Nicolás
0
nicothebee

Senior Expert Member
Registered:
Posts: 120
Reply with quote  #5 
One more thing: when you reverse a document, the posting date is set to the original posting date. You then have a problem if the field status group prevents any modification.
Once more a user exit will fix the situation.
0
Ignacio

Senior Expert Member
Registered:
Posts: 60
Reply with quote  #6 
Hi Nicolas,

That is brilliant, many thanks for your reply.

Yesterday I came back from Italy and as a short term solution we just added "posting date" field on Verify then during the closing period they will fill it, leaving it blank during the rest of the month. Clearly it's not a good solution as it's completely manual and errors may happen, but it will work in the short term.

I will open a request inside my company to develop your proposed solution.

Thanks again.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.



Follow @readsoftuser