Hi @GDrysdale 

it is true. Also in IFS APPS10 it is the same approach.

You can use the same template for different companies. Otherwise you need to create n templates for each company.

Thanks for confirming. Just checking in case someone had found a way to do this.

Cheers,

Graham

If this is accurate, this is a big step back.  We’ve uploaded multi-company vouchers from Apps 7.5 and its almost all we load in Apps 10.  I do not know about Cloud though.

While the STDVOU template doesn’t include company, you can create your own template based on the ExtVoucher File Type and include company:

When loading, the process separates the file and creates a voucher in each company (in Voucher Entry) not in the ‘multi-company voucher entry’ screen.

I can try and answer more questions if it will help.

Thanks. I was hoping someone would confirm if they had managed to successfully import a Multi-company External GL Voucher in IFS Cloud or if it was not possible.

I’ll investigate further...

Hi,

I managed to successfully import a Multi-company External GL Voucher in IFS Cloud 23r1. 

I copied File Template STDVOU (you cannot edit a System Defined File Template) and created MCVOU.

Edited MCVOU renumbering everything to column number +1 and adding a new column number 1 for Company. Added Company to the first column in my Excel External Voucher Load file.

Import this and it creates a Voucher in Voucher Entry for each Company in the file.No postings are created utilising AP10 and AP11 posting types to generate automatically the corresponding balance sheet entries. The Vouchers must balance in the file for each company.

See attached.

Cheers,

Graham

The External GL voucher upload works as long as you have 4 entries ( Debit and Credit in Company A and Debit and Credit in Company as @GDrysdale have already illustrated.

But if the requirement is to have the Debit in Company A and Credit in Company B ( 2 lines) similar to how we enter in the ‘Multi-company Voucher entry’ window it doesn’t work.

There is an idea that has already been accepted by RnD , but as far as I know this is still under-review and is not 23R2 either

@cynthia.wilson 

Hi Cynthia,

What is the destination column for Company in your File template (IFS10)?

Thanks,

Cora

C70 in my IFS Cloud version.

Cheers,

Graham

Thank you, Graham!

I brought in Company in the External Voucher Template in IFS 10 and is also C70.

Cora