The item code used in your imp file must be linked in Sage 50 to the proper department for it to post to the correct department, sorry. There is no way to directly post to a department using information in the imp file when importing sales invoices. This can only be done when importing general journal entries.

That is actually exactly what I'm doing. For example, into customer "A", I choose department 4200-0003 for item #3. But when imported, I stay with 4200 but loosing -0003 (division).

Any idea if we can fix it?

Items are customer independent but if you have set item 3 linked Revenue account to 4200-0003 and it exists, I would expect it to post to that account. However, I am not completely sure of the order of preference as I have not tested this stuff directly in about 10 years, before, I believe the default sales account was added to the program. Is it possible you have the customer default revenue account set to 4200 still? This account is the default and it might be overriding the import.

I would like to post a screenshot but don't know how...

In the Import/Export customer tab, I check off This Customer uses Sage 50...
Under the section of corresponding item # to my account #, I type for example item #4 linked to my account 4200-0004. But when importing item #4, works fine for 4200 but the division -0004 is not following...

NicPhysio said:

I would like to post a screenshot but don't know how...

Click on Use Rich Formatting and then click on the icon that says Insert/Edit Media and pick the correct options to upload a file from your computer.

I am not referring to the setup of the customer (first image below).  I am referring to the setup of the item (second image below).  I have never played with the linked items in the customer setup so I have no idea how it handles things.  In the image below, my item H1020 would be the customer's item 4.

But what if I'm using my account 1115 which is a work in process account. I don't want to use Revenue, COGS & variance accounts. If I choose Service instead of Inventory account I can't use an asset account...

I've never tested that kind of scenario. I'm surprised it's not posting to the correct account when you can select the department in that dialog.

So the only option I would have to suggest, if the import is not honouring the proper account structure in the customer Item setup, is to import, then adjust the entry and change the account to the correct department. I can't think of any other way with the imp file. Sorry it's not a better solution.