[muerling]

I’m getting a “No Department” column when I generate a Budget IS with columns by department. All of the fields show -0-. How do I prevent this column from appearing?

Thanks, Melinda
This is a cached copy. Click here to see the original post.

[bboese]

RE: "No Department" Column

Under Filters in the report, select Financial>Department>Name and set it Not Equal To “No Department”. Caution here is that sometimes one or more transactions could unknowingly be posted without a Dept, so preferably you’d run the report showing No Dept column, and if it’s all zeros, you could then run the report that does not show this column.

[Cloud]

Hi,

I know this is a really old thread, but I have a Similar problem. I have created a New Department (Setup > Company > Classifications > Departments) , Christmas Tress & Lights. But orders come through and it appears in the reports as ‘No Dept’. and also on the Sales Order, No Dept is entered when it is autogenerated by the system.

Any idea’s? or am i missing something like all these items = christmas trees and lights?

Thanks

[Cloud]

anyone Please..? I have had like 3 items come through this Dept. and like 30 under No Dept.

[Olivier Gagnon NC]

RE: "No Department" Column

Your transactions must be tagged with the correct department for it to appear correctly in reports. You may need a script or workflow to set a default department for web orders and other automatically created orders.

[Krish0nan]

RE: "No Department" Column

maybe you can use workflow to do it.. but yeah you need to set the value

[Cloud]

correct me if I am wrong, but how would some items appear under this new department? while others are appearing as No Dept? that doesnt make sense? If a script was required surely nothing should appear under the new department?

[Olivier Gagnon NC]

RE: "No Department" Column

Drilldown in the lines correctly classified on the report to see where they come from. My guess is there are a few transactions that were manually created or updated with the correct department.

[Cloud]

Hi Oliver,

I have checked 3 orders that appear under CTL Dept, and none of them have system notes. Meaning no-one has changed the department manually. Then I checked 4 orders which appear as No Dept, and there are system notes but on the sales order it does say

Source : Web (Christmas Trees and Lights)

So If NS knows the Source is CTL, then why it cannot assign a Dept? There is hardly anything on assigning a New Dept. Just a small guide on creating one. I mean, if there was scripting required or workflows surely the guys at NS would have wrote a guide??

Thanks

Mayur

[Author]

Posts