Project code updation in JE

[Former Member]

Hai,

While creating an A/R invoice - Project is getting updated in JE if we set the same in Settings - A/R Invoice (Project) in row lever & header level except the GL Accounts related to Service Tax, Ces & Ecess. Even if we set the project in COA -> Accounts Details -> Project it is not getting updated in Project column in JE.

Pl. help to solve this issue as the project code should be updated automatically in all the rows in JE while creating A/R Invoice

Thanks & Regards

Narayanan

[former_member583013 · Accepted solution]

Narayanan

Which SBO version are you using?

In SBO 2005A the Project Code at the header level on an AR Invoice does not copy automatically to the Invoice rows NOR does it update the JE lines.

[Former Member · Accepted solution]

Hai

We are using SBO 2005 B version patch level 40.

Header Level & Row level part of A/R Invoice is updated except the bottom level part ie., Service tax GL account is not updated automatically in JE

Regards

Narayanan

[Former Member · Accepted solution]

It is the System behavior that only row of BP would be updated with Project Code in JE if Project Code is selected in Marketing Documents.

Try out choosing the 'Project Code' in the header of JE. This will prompt you 'Do you want to update rows as well?" select OK. So all the Lines in the JE also will have the project field entered.

[Former Member · Accepted solution]

hai,

If we go and update in JV on the header part it is getting updated in all rows. I want it to be automatically updated in all rows of JE while raising A/R Invoice. Is it possible ?

Regards

Narayanan

[Former Member · Accepted solution]

If you want to do so, you can try writing a Formatted Search Query and assign it to the "Project" in the rows.

[Former Member]

Hi

Go to

Sales A/R -> A/R Invoice -> Accounting Tab , select the Project in 'BP Project' dropdown and save the invoice and check the JE, it should have the Project selected in rows of JE against the BP ledger.

[Former Member]

hi,

I tried that option also it is getting updated only in row level and BP but not in service tax GL A/c. Only service tax GL are not being updated.

below is the JE

Particulars Dr. Cr. Project

Vendor A/c 1011 Unit 1 Sales 900.00 Unit 1

Ser.Tax 12% 108.00 Not updated

Cess @ 2% 2.00 Not updated

E Cess @ 1% 1.00 Not updated

Can anybody address how to update the project in Ser.Tax A/c.

Regards

Narayanan