Vendor & GL Account Balance - department wise

[Former Member]

Hi All,

We have a requirement from the client to show the Vendor Account Balance department wise. The scenario is like this.

A single Vendor is operated by different sections of the Finance department like Raw Materials Bill passing section, Stores Bill passing Section, Works Bills Section, Operations Bill Section, Project Accounts Section etc

Each section has authorisation to posts the document in that vendor account and is responsible for the document it posts. Client wants to know how much balance is outstanding to/from the Vendor each section wise.

I think it is not practical to create separate Profit Centers for all the sections in the Finance department since there are many sections in the Finance department.

Please let me know how to address this issue.

Regards,

Hari

[former_member182098 · Accepted solution]

The Option I can consider is:

Make Assignment Field Mandatory.

Ask the users to input the department name.

In FBL1N sort as per department.

[Former Member · Accepted solution]

Hi Ravi,

Thanks for your reply.

Client is not accepting any manual entry of section code.

He insists that either system should automatically derive the section name or there should be an option for the user to select the section code through F4 selection.

Regards..

Hari

[Former Member · Accepted solution]

Hello Dear

You can use Substitution to update the Assignment or Reference Field

In this way user need not to enter anything and field will be updated automatically.

Hope it Helps

Cheers

IMK