Inventory Site - Account Segment ID - Switch Segment in Sales Invoice

(0) Share

Report

Posted on by Community Member

Hi!

I am testing on switching the Account Segment ID based on the Site ID that I'll be using in the Sales Invoice in Sales Order Processing.

Even though the Site ID is default to a specific Account Segment and necessary Chart of Accounts with this segment combination exist, it is not changing the Account Segment for Sales/COGS or any accounts while creating/Posting the Sales Invoice.

Is there anything missing in my setup?

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report
Copy link

Link copied!

The Inventory Account is the one that would have a segment swapped out based on the Account Segment ID on the Site ID; is this changing?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ian,

Thanks for the reply. The Segment1 which is defined as Site is not changing for any account including Inventory Account. I was in the impression it will change for Sales/COGS also.

Any clue?

Regards,

Was this reply helpful? Yes No
Dan Liebl 7,322 on at

Like (0)

Report
Copy link

Link copied!

Check the segment ID for sites in Inventory Control setup to make sure the correct segment is identified. It will only swap out the segment in the setup. The corresponding segment identifier needs to then be assigned to the site as Ian suggests. If the setup is already populated with the incorrect segment, you may be able to change it via the back end (direct in SQL). And my understanding is also that it will change the sales and COGS accounts. I have not used it extensively, but occasionally and not for a few years as to my uncertainty. Make sure the GL accounts exist for that expectation to have a chance.

Dan Liebl, CMA CPIM | Senior Consultant | OTT, Inc.| DLiebl@OTT-inc.com

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear All,

Thanks for your replies. I was able to test it successfully after re-doing the setup. Switch works for Inventory, Sales and COGS accounts. Just make sure these three accounts exists with the segment combinations.

Cheers!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

Inventory flipping works not only for inventory account, but for all the AR accounts; Sales, COGS, Markdown, and Inventory returns.

Nothing complicated about it, include these accounts on the item card, and do the setup and you just work just fine.

Was this reply helpful? Yes No
Vijayakumar Kenchug... 1,077 on at

Like (0)

Report
Copy link

Link copied!

Hello Mohammed,

Does this switch happen for Freight account?

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

No,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

What about the commission accounts? Expense and Payable?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Tom,

I do not think those change either as they are not tied to an individual inventory item but rather the entire invoice amount.

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Can we have more than one segment mask those accounts as we have two segments loc and division

Was this reply helpful? Yes No