Rose Business Solutions Dynamics GP

Posts Tagged ‘order’

If you use the Advanced Distribution functionality in GP and run the Fulfillment Workflow component, you can combine  numerous orders onto one invoice to your customer. This is handy if you receive many orders from your customers and they want all shipments for a given period of time, consolidated onto one invoice.

To use the this function you must catch all your Fulfillment Order Invoices just prior to the “Confirm Shipment” step in your workflow.

This is the screen from which you select the order shipments you want to consolidate:

Here is a Microsoft PowerPoint that explains this a bit: GP2013 FOD Consolidated Invoicing

Here is a quick video showing this in action.

Here are a couple of drawbacks:

• If you go past the “Confirm Shipment” step, too bad; you won’t be able to consolidate the orders
• This seems like an ideal function to include in the sales transaction list action pane; it’s not there

Its not new for support dealing with Integration Manager crazy requirements, transformations, translations, scripts and many things that are often missed.

Even customers are truly surprised when I show them how Integration Manager can pull information from one company or even better from another SQL server into Dynamics GP as a source.

Yes I know you are surprised too that I am telling you that your source can be a SQL Query Script…….

We have many ways of sorting data in integration manager, we even have filters and sort fields on the source definition, but nothing beats the customer frustration when they have a sorted file and Integration Manager scrambles the file, then open up the distributions for example on a JE import and see that the order is not even close to what the source file have.

One thing important is that there is a setting in the IntegrationManager.ini file. This setting is called UseOptimizedFilter normally I see this option with the value True. 

When this option is enabled, Integration Manager uses a series of ninja techniques to optimize the data upload but that has an impact on the sort order.

If you want to have the distributions ordered or your transactions in the order you have them in your source file, close your Integration Manager, go to this file located on the Integration Manager code folder and set to false this setting.

Try your integration once again and voila!!!! Its just like magic, everything is the way you had it on your source file.

I am hoping to save techs from headaches here, and if this tip helps you, let us know, we want to know if our work can actually influence a better Dynamics community.

Francisco.

Here’s a simple example of creating a manufacturing order in GP. This will give you an idea of how the process works.

You will need two things in order to create a manufacturing order transaction:
1.) Bill of Material (See my example of simple BOM) For this example make the BOM a “Backflush” BOM
2.) Routing

Let’s make the routing first. Create a simple one that has one sequence. Navigate to: Cards >> Manufacturing >> Routings >> Routing Entry.

Look up your finished good item number.

Create a Routing Name.

When the Routing Header Creation screen comes up, check, “Primary Routing” and save.

Enter “100″ for the sequence number.

Select a work center. If you don’t have any, they’re simple to create.

Save, and you’re done.