cancel
Showing results for 
Search instead for 
Did you mean: 

how to create a template for cross company entries that only affect vendor accounts

Sandro91
Newcomer
0 Kudos
198

Hello!

Today we are finishing our monthly report and there is a task I've been trying to find a quick solution for since I can remember ;-). I tried some searches but haven't found anything - So I thought maybe somebody came across the same issue and might be able to help:

At the end of every month I have to post cross company entries that only target vendor accounts (the system creates than automated postings on our so called clearing accounts (G/L) - since all the companies in question are linked within the system).

Basically I have to enter the following entries 4 times (for four different dates and varying amounts, that change every month):

For context -> 27 and 37 are posting keys (27 debit vendor, 37 credit vendor), 90000x = vendor account, (00xx) = company code

07.01.2024:

27 900001 (0010) / 37 900010 (0001)    € 46.484,00

27 900002 (0010) / 37 900010 (0002)    € 47.867,00

27 900003 (0010) / 37 900010 (0003)    € 59.486,02

27 900004 (0010) / 37 900010 (0004)    € 64.861,11

It has to be done for more lines and in total 4 times (for for different dates)-> it would be so much easier If I only had to input the amounts instead of creating the same entries over and over again (with different amounts). So far I have been unable to find a template for cross posting vendor entries.

Does anyone happen to know a work around to this "problem"? Wish you all a nice day!

Sandro

 

Accepted Solutions (0)

Answers (0)