Hi,

i have some issues..

We are going to have another coy using the same Baan Server.

Both Coy will use the same VRC.

and the Sales invoice have bank account detail at the end.

both coy use different bank and account no, we need to have the bank detail shown at the end of the sales invoices.

We have alots of customise sales invoice like below, to duplicate every of them will have a very long lists.

http://img194.imageshack.us/img194/3289/salesinv.jpg


any one have this issues?

I have a suggestion for this. Even though the VRC may be the same, but the tables belonging to individual companies within the same VRC will still be unique. So you have two options here :

Pick up the Bank account for the Invoice from the standard Cash management Bank data tables based on some criteria (if USD, then account1, if EUR then account2, etc..)

Alternatively, maintain a special table to maintain the bank account with the criteria and pick the field from there in the Print Sales Invoices.

Hope this helps.

i don't get what you mean.

2 coy are under 2 different coy name with 2 different bank and different account no.

eg..

100 coy name 1
200 coy name 2

all are using USD$ for payment.

only GL are using S$

I am assuming that you are using Cash Management module.
In the Cash Management master data set-up, you would have defined bank account codes for the transactions. So while printing invoices, pick the account number from the cash management table (tfcmg001) for the respective company. If you have multiple account codes and multiple banks then have some kind of a logic to pick. For example consider the following scenario :

Company Bank relation currency Account number transaction type
100 HS1 hsbc USd 1234567890 AB1
100 HS2 HSBC SGD 1234567000 AB2
100 CT1 CITI USD 1234589001 AB3

Now, if you have a rule which states that for all invoices you will use only hsbc bank accounts, then hard code the program to pick up the account number based on the bank = HS1 and currency = USD.

Then use the same naming convention for the company 200 also. This way the account number for 200 for hsbc and usd will be picked for the invoices generated from company 200.

The same effect can be had if you can define a customised table to just maintain the bank account and pick it up from there.

Hope it is a bit more clear now.

Rgds