Small and medium business | Business Central, N...

Posting the same item to different purchasing accounts

(0) Share

Report

Posted on by Mark Fried

Hi,

I am looking for a solution for a client, they are currently using multiple items for each product in order to direct the costs to different purchasing accounts for each item per department.

I am looking for a solution that will enable them to use one item per product. They do not want to use dimensions as a solution for this particular issue.

Does anyone know of a standard or custom solution for this?

Many thanks,

Mark

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,187 Moderator on at

Like (1)

Report
Copy link

Link copied!

There is no standard solution for this scenario. And the use of dimensions are the obvious answer to this request.

A work around could be to have one vendor per department but that comes with some other perks as well i guess.

If they where my customer i think i would go another round with them and try to convince them of using some kind of dimension for this.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,974 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, how about use Item Variants?

More details: https://www.inecta.com/item-variant-sell-by-colors-in-microsoft-dynamics-nav-2015

And there is a Average Cost Calc. Type(Item, Variant, and Location) in the Inventory Setup.

https://docs.microsoft.com/en-us/dynamics-nav-app/design-details-average-cost#setting-up-average-cost-calculation

Hope this info helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Mark,

A little curious why a different purchasing account for an Item when the the Purchasing Account (Posting Group Setup) should be offset by the Direct Cost Applied account (General Posting Setup). The Item, on the Balance Sheet, when sold, will record the COGS to whatever is defined by the Gen. Prod. Posting Group and Ge. Bus. Posting Group combinations and that is the proper setup. If you are trying to expand Item reporting, then I always setup Dimensions for Product Lines/Types (for example).

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No