Steven Chinsky MVP
Forum Replies Created
-
@debpeters Scrap Factor % on the Routing Line is defined as scrap in relation to an operation. BC has a scrap factor % field in the routing that can be used to define if an operation generates scrap. This will increase the required quantities for all the components that are used in the operation and all previous operations. It will also increase the capacity need for the operation and all previous operations. If you use this then linking the components to the operations using the routing link codes are important (otherwise all your components will have increased quantities).
When the production order is created the value of the Scrap Factor % field from the routing line is transferred to the Scrap Factor % field of the production order routing and the capacity need for the operation is increased accordingly. The related components quantities are also increased accordingly. A great example of why to use this is operations that have a certain
expected failure rate.Now Fixed Scrap Quantity on the Routing Line Scrap is related to an operation that has defined fixed scrap quantity. Dynamics NAV has a fixed scrap quantity field in the routing; it has the same effect as the scrap factor % but with the difference that it is specified in an absolute quantity instead of a percentage.
You set this up in the Fixed Scrap Quantity field on the routing. When the production order is created the value of the Fixed Scrap Quantity field from the routing line is transferred to the Fixed Scrap Quantity field of the production order routing and the capacity need for the operation is increased accordingly. The related components quantities are also increased accordingly. This could, for example, be used for operations on a machine that needs to be setup and tested on a few units before starting the run. Another common example is if you are doing some destructive testing on a certain quantity as part of the operation.
I hope this helps. Now one thing to note, if you intention is to solely scrap at the component level, then setting the Scrap % on the BOM is the best approach.
Thanks,
Steve
-
Chris – I am going to add a tech guru to this and a close friend. He started to ask me questions only you can answer about setting the service settings and separate service tier for ODATA. Meet Brad. I will let him jump into the questions.
Thanks,
Steve
Brad – All yours 🙂
-
Jessie – What the upcoming BC 3 Amigos You Tube podcast coming out this week. It is on 2024 Wave 1 new functionality. You can also go here: https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave1/smb/dynamics365-business-central/
Steve
learn.microsoft.com
Overview of Dynamics 365 Business Central 2024 release wave 1
Overview of Dynamics 365 Business Central 2024 release wave 1
-
Chris – Predictive or Historical Sales Forecasting I normally turn to 3 APPs: 1) Microsoft <b style=”font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”>Sales and Inventory Forecast. Yes Microsoft has one not used a lot and uses Cortana and AI to predict and history. 2) StockIQ I have used several times now. 3) AGR
If you need names to call StockIQ or AGR tell me.
Thanks,
Steve
-
Jonathon – Here is my developers reply as a sample…
If you have a flowfield and you want the drilldown to show a different set of data you can write code in the ondrilldown trigger.
This example has a flowfield for the sum of the Item quantity, but if you drill down – you’ll get the sales orders. I didn’t do anything but filter on the order, but you can see how it is as an example. This is a basic sample based on what I understand is the ask. It may be done differently with different requirements.
table 50100 “DEV New Table”
{
Caption = ‘New Table’;
DataClassification = CustomerContent;
fields
{
field(1; “Item No.”; Code[20])
{
Caption = ‘Item No.’;
TableRelation = Item;
}
field(15; “Quantitiy”; Decimal)
{
CalcFormula = sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“Item No.”)));
Caption = ‘Quantity’;
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
}
keys
{
key(PK; “Item No.”)
{
Clustered = true;
}
}
}
page 50100 “DEV New Page”
{
ApplicationArea = Basic, Suite;
Caption = ‘New Page’;
Extensible = false;
PageType = List;
SourceTable = “DEV New Table”;
UsageCategory = Lists;
layout
{
area(Content)
{
repeater(DevControl1)
{
field(Item_No; Rec.”Item No.”)
{
}
field(Quantitiy; Rec.Quantitiy)
{
trigger OnDrillDown()
var
SalesHeader: Record “Sales Header”;
begin
SalesHeader.SetRange(“Document Type”, “Sales Document Type”::Order);
Page.RunModal(Page::”DEV Sales List”, SalesHeader);
end;
}
}
}
}
}
page 50101 “DEV Sales List”
{
ApplicationArea = Basic, Suite;
Caption = ‘Sales List’;
Editable = false;
Extensible = false;
PageType = List;
SourceTable = “Sales Header”;
UsageCategory = None;
layout
{
area(Content)
{
repeater(DevControl1)
{
field(DocumentType; Rec.”Document Type”) { }
field(No_; Rec.”No.”) { }
field(ExternalDocumentNo; Rec.”External Document No.”) { }
}
}
}
}
Thanks,
Steve
-
@tracytrippler – I know how you feel. Yes, the Link from SO demand to the PROD Order is removed after the Item is manufactured and Prod Order finished. I have had several customers pull their hair out because of this. May I suggest a solution that has help other customers of mine who Allocate inventory and have priorities they want to consider… Look at Cavallo Order Management APP. For decades, in the NAV and BC world, we have to live with Reservations and trying to manage Orders, Customer Priorities, and supply and demand. I have always wished their was a way to just Allocate or provide an Allocation rule to NAV/BC. I then was asked to look at Cavallo Order Management and it answered the missing functionality. Take a look: https://www.cavallo.com/our-solutions/bc/business-central/
I do have one underlying question though, when your Item is Make-to-Order and the Sales Order links to the Production Order, after creating the Prod Order, you might consider that Item have a reservation since it will stick with the Item Output and transfer to picking Bin for shipment. You might not want reservations, and I understand, so look at Cavallo.
Hope this helps.
Steve
cavallo.com
Microsoft Business Central Integration | Cavallo
Combine the flexibility of a CRM package with the breadth of data Business Central provides. Sell with confidence, gain transparency into your sales cycle and order process, and provide better care for your customers — all with greater control over … Continue reading
-
@rmumawmastermeter-com – NAV or BC have a few Shipping APPs out there. However, you are looking for LTL connectivity or at least the ability to work with LTL. E-Ship, by Lanham Associates, has an LTL functionality. I have used this several times in the past and it work s as prescribed. Here is a link: https://www.lanhamassoc.com/e-ship-and-e-receive-extension.htm#ltl
Another LTL Shipping APP is Insight Works Ship LTL Parcel for Dynamics 365 Business Central. Here is a link: https://dmsiworks.com/features/2ship-ltl-parcel-for-dynamics-365-business-central
I have used both and they do work with LTL’s. You say you are using Dynamic Ship but is it the Ship LTL APP? I would contact Insight Works or your Partner to resolve this. I think you might need 2Ship APP.
Thanks,
Steve
-
Hi Lewis,
Sadly, maybe one day, NAV and BC only had the ability to create an electronic file that conformed to IRS specifications. You would then upload the form to the IRS on their website.
Search for: Vendor 1099 Magnetic Media and you are off an running. Nothing to change just run and save file locally.
Thanks,
Steve
-
@kristafoster – Teams is not a tool for storage of documents, like DocXtender or SharePoint. DocXtender can use SharePoint and allow you to build a schema for storing documents. You might think about using the SharePoint Connector APP (SharePoint Connector – EFOQUS). I have used both. Each offers its own solution for what you need. I know DocXtender is free but the SharePoint Connector has a cost of around $2400/per year. It offers more functionality between BC and SharePoint. Consider looking at this to solve your requirements for short dollars.
Thanks,
Steve
efoqus.ca
SharePoint Connector allows you to seamlessly connect data in SharePoint and Microsoft Dynamics 365 Business Central. Try it now, free of charge!
-
@Steve Simon – Is this an APP in AppSource and certified by Microsoft? or more an extension you designed for your customers? If the latter you can default GL Accounts using Recurring Purchase Lines, just an FYI.
I wanted to echo Kim’s reply that we are not using the Forum to self-promote personal extensions.
Thanks,
Steve
-
Joseph,
Adding to Dave’s reply… Most user would run Inventory Valuation report to reconcile Inventory to GL, but you should not use that report as it is wrong. You should be running the Inventory to G/L Reconcile report. This will show you the starting Inventory Valuation (dollars) and then your reconciling transactions (Received Not Invoiced, Shipped Not Invoiced, and Manufacturing Output where Production Order is still open). This will also show the G/L Entries posted for each Item and reconcile to the sub-ledger report you just ran.
Try this.
Steve
-
@debpeters If you are looking to apply against components (Raw Materials) only, then I would use the Production BOM Scrap %. This way you are always pulling x% more than the stated Quantity per for the components. As for MRP, scrap % effects the expected quantity required for a Production Order and therefore is used in the planning engine. Your last statement about Standard Cost, if your Costing Method is Standard Cost and you have the Production BOM reflecting a Scrap%, when you rolled the Standard Cost the additional item cost will be included.
Hope this helps.
Steve
