Problem - tcmcs0136m000 posts to correct dept, not product line

Company scenario - Single Finance / Multi Logistic

Using dimensions - warehouse, prod. line, Dept

Also using an interim sales account to post initial invoice totals, which will be debited out @ Sales Invoice Details Accounts. Need the sales account by warehouse, cc for financial statement setup. As seen in screen shot, setup is providiing correct posting for all cases except the interim revenue vs. AR (as seen)

Is there some step missing in integrations?

Thanks,

Hi,
Please check the following:
If is an sls invoice, all the integrations regarding must be defined.
Review the session tfgld4510m000 (display transaccions by project/order).
The most common problem is when, the numeber sales order change from one digit to another. For example, if you start with the series order 10 and now the series order changes to 20, this new series order must be defined also in the session tfgld4112m000 (Mantain options by integration element).

Hope this help.

As per baan help only customer group and country, are available for dimension analysis for sales invoice /invoice totals.



DEFINITION OF FINANCIAL TRANSACTIONS
This transaction is carried out due to the total turnover on a sales
invoice (entered in the session "Maintain Invoice Analysis Accounts by Tax
Code (tdsls6103m000)").

WHERE AND WHEN CREATED
This transaction is created after printing the sales invoice, in the
sessions:
- Process Delivered Sales Orders (tdsls4223m000)

DEFINING LEDGER CHART
- debit : A/R (control account)
- credit: To turnover

The control account of the group of customers has been entered in the
session "Maintain Ledger Accounts by Customer Group (tfacr0111s000)".
The turnover account is entered by Tax code and by country in the
session "Maintain Tax Codes by Country (tcmcs0136m000)".

The amounts entered here are net turnover amounts (exclusive of the
order discount).

USE OF TRANSACTIONS IN GROUP OF FINANCIAL COMPANIES
- debit : Company of sales order
- credit: Company of sales order

LINKING KEY ELEMENTS WITH DIMENSIONS
The following key elements are available for this transaction:
- Country
- Financial Customer Group

Hi,

I think that the situation is as follows:

Dimension values for the control account 1140 comes from tfacr0111 - Ledger accounts by customer group.

Dimension values for the sales interim 4105 comes from tcmcs0136 (Form 2).

Both are not influenced by the SLS integration element.
This is the reason you do not get values in dimension PRD.


Moshe

Thanks All,

So for the first 4105 transaction coming from Form 2, the only way you are saying we can get PRD is if we code it directly into Form2. When I did that, the dimension shows up for 1140 but not 4105.

The other option is to define the financial statements with only 4105 Dept / CC dimension, as there should be a cancelling of Debit / Credit in that transaction . The only problem with that is the position 0 for 4105 ledger account retains a debit balance.

Any ideas? Thanks in advance.

As far as I remember dimension analysis of sales and a/r account through integration setup is not meaningful (it could be misleading) for integration elements other that country and customer group .