Hi!

I have set the tax field to "NO" in tcmcs0136m000 since no tax is applicable and also assigned sales ledger account(interim) in form2. While posting the Sales Integration transactions getting error message:

"cannot define ledger account (sls:tdsls6000/tcmcs036)"

I assigned a dummy tax account in tcmcs0136m000 in the field sales tax account and again posted the transactions. Still getting the same message. Why is system asking for a sales tax a/c when tax field is set to NO? What could be the problem?

Which table is tdsls6000?

Any help is much appreciated.

Narayan

HI!

In addition to the above error msg, i am getting this one also:

" open item present , cannot post to finance"

I checked the open item hisotry in tfacr2520m000 for the particular customer. No record is present.

Narayan

Hi,
1. I encoutnered " open item present , cannot post to finance"
when for some reason duplicate lines for the same sales invoice
were created in integration transactions.
The first set was posted to finance and now when trying to
post again the systemm issued this error.
I had to manually delete the redundant lines from all
integration tables.
(I could not find out the reason !!!)

2. Tax field in sales order header should have been set to "No",
before printing the invoice.
When this is done the system will not search for tax account.


Moshe

Hi! Moshe,

Tks for u r reply. I still get the below error msg even when I set the tax field to "NO".

"cannot define ledger account (sls:tdsls6000/tcmcs036)"

The tax field in sales order header is set to "No", before printing the invoice.

For TO - Sales & FT - Revenue, the system is posting correctly. But for TO - Sales & FT - Sales Invoice, no entry is generated & getting the error msg. Sales invoice is printed as per the order steps defined. The Customer is not getting debited and the interim sales a/c is not getting credited. If already open item is present it shd be reflected in tfacr2520m000, but no record is present for the particular customer.

Still wondering which table is tdsls6000.

Narayan

What are the vat code and country code you entered the data for in tcmcs0136m000?

For your question aboud tdsls6000. That's not a table, it's an include file (function) responsible for getting the right sales invoice and vat accounts.

Hi! Ulrich,

Tks for u r reply.

Since no VAT is applicable in Dubai I hve defined for country code AE (United Arab Emirates) vat code as No Tax. I hve removed the dummy sales tax account assigned earlier and posted fresh integration transactions. Still getting the same error for TO - Sales & FT - Sales Invoice. Is it mandatory to give vat a/c though Tax is set to "NO".

As per the help..... In case of sale for project (standard or customized item) entries for invoice analysis are:

1) Dr Int.Sales a/c
Cr Sales turnover a/c

2) Dr Accounts receivable a/c
Cr Int.Sales a/c (by tax code)

The second entry is not getting generated ... may be due to error.

Narayan

Did you set up this with an empty(!) VAT code, or is the Vat code field filled? Because the VAT Code field has to be empty for such a "No-Vat"-setup!

HI! Ulrich.

I had given --- for the no tax VAT code and filled this code. I hve removed it and posted the integration. It works fine.

Thank u very much 4 the help.

Narayan:)

Did you set up this with an empty(!) VAT code, or is the Vat code field filled? Because the VAT Code field has to be empty for such a "No-Vat"-setup!

Hi, Was going through this thread, as i am facing similar problem. I have check tcmcs0136m000, i have an empty vat caode. but still this error. what could be the reason.

See attachment

PLease see this
http://www.baanboard.com/baanboard/showthread.php?p=149893#post149893

and attachment tfgld4510m000 form4.doc

Need urgent support.

Regards,

Dear Narayan,

Is your problem resolved..?

Regards,

Manish