Posts Tagged ‘order’

Dynamics GP 2013 (beta) – Consolidated Invoicing

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

Why my integration is changed? Sort-wise

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

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.

Manufacturing Order Entry in Dynamics GP

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.

Create a Manufacturing Order Transaction.

Navigate to: Transactions >> Manufacturing >> Manufacturing Orders >> Entry

Look up your finished good item.

Create a default Scheduling Preference if you don’t have one.

Enter an Ending Quantity amount.

Assuming a “Forward Infinite” Scheduling Method, enter a “Start Date”.

Click on “Schedule MO” button.

Click on “Build Picklist” button.

You are done entering the manufacturing order transaction.

To proceed, change the “MO Status” field to, “Released”, and save.

Create a Manufacturing Order Receipt transaction to add the finished good item and relieve the component items from inventory.

Navigate to: Transactions >> Manufacturing >> Manufacturing Orders >> Entry

Look up your manufacturing order, and enter the quantity of the finished good created.

The Quick MO offers an alternative to the Manufacturing Order, but I like this best, and don’t feel it’s much more complicated than the Quick MO.

Try this out in the Fabrikam sample company, and you’ll see that basically, it’s fairly straight forward.
There are significantly more options and functionality, but this will help you get over the initial feeling of being overwhelmed.

Subscription Options:
Subscribe via RSS
Articles Categories