170
Hello,
I'm very new to NAV, we are using 2013 R2. By mistake, some of our salespeople have been selling items that should only be part of an assembly. Is there a way to restrict that from happening ?
*This post is locked for comments
Yeah, except we actually WANT to sell items as stand-alone products and use those same items in assemblies.
Think flour. We sell flour in a store. We also USE flour in the bakery. We buy/source flour from a single vendor.
Now think about a bagel. We use flour to make the bagel which we sell wholesale in multiples (dozens). We also sell individual bagels. We sell breakfast packages that include a bagel and assorted toppings. Would we be creating separate items, "bagel-single", "bagel-dozen","bagel-meal", that are all exactly the same item, just to use in various ways/assemblies? Would they be received into inventory separately, even as they come out of the ovens on the exact same conveyors?
Are you saying we can't have a single item called "flour", or a single "bagel" that we can both sell and use internally?
Follow the following steps;
Share
Report
All responses (
Answers (
IF (Type=CONST(" ")) "Standard Text" ELSE IF (Type=CONST(G/L Account),System-Created Entry=CONST(No)) "G/L Account" WHERE (Direct Posting=CONST(Yes),Account Type=CONST(Posting),Blocked=CONST(No)) ELSE IF (Type=CONST(G/L Account),System-Created Entry=CONST(Yes)) "G/L Account" ELSE IF (Type=CONST(Item)) Item WHERE (Part of Assembly Item=FILTER(No)) ELSE IF (Type=CONST(Resource)) Resource ELSE IF (Type=CONST(Fixed Asset)) "Fixed Asset" ELSE IF (Type=CONST("Charge (Item)")) "Item Charge"
You are good to go. You do not have to code anything in the table or do any other modification. By doing that only the item with "part of assembly item = false will show in the drop down of your item list in the sales line.
add a boolean field to table item: isassemblypart
add this field to the item card.
in trigger no.-onvalidate of table sales line the selected item is checked. there you could add a check for that new field.
1) Are you selling your items in multiple unit of measure? If no then, you can remove the sales unit of measure from item card for those items which you do not want to sell and make the UOM field non editable in sales order. by this way they will not be able to sell this items.
2) Another option: Create one boolean (tick mark) field on item card as "Non salable" and put one validation on sales line No. field that if line type is "item" then check above boolean field and if it is true then error message. - This is very small modification in system but can solve your problem.
by default there is no any standard method but by using above you can achieve your requirement.
Regards,
-Saurabh Shah
No by default
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156