• Visual Business Solutions | 6225 Old Middleton Road Madison, WI 53705

Monthly Archives :

September 2019

VVUG Tips & Tricks: Speeding Up Month End with Recurring Entries

VVUG Tips & Tricks: Speeding Up Month End with Recurring Entries 150 150 admin

Speeding Up Month End with Recurring Entries

Create recurring journal entries in order to speed up month-end. To set this up you go to Accounting Window, under “Maintain”.

There are 2 tabs labeled “Type” &“Trigger”. For “Type” set the entry type to General and set your tax processing. (Automatic for templates where the amounts do not change or change slightly. Manual for templates where the amounts change constantly.)

For “Trigger” set the date of the entry itself but be aware, this does not mean it will trigger automatically.

Then run your entries through the General Journal Entry Screen. Under “File” select “General Recurring Entries” for automatic.

Under “Edit” select “Recurring Entries” for manual.

Did you also know you could import your GJ directly from an Excel spreadsheet? (But we’ll go more into that in a future Tips & Tricks.)

VVUG Tips & Tricks: Save Time by Using ECN’s to Push Changes from Engineering Master to Work Orders.

VVUG Tips & Tricks: Save Time by Using ECN’s to Push Changes from Engineering Master to Work Orders. 150 150 admin

Save Time by Using ECN’s to Push Changes from Engineering Master to Work Orders.

If you need to make the same changes to multiple Work Orders for the same part, then add the Engineering Master to an ECN and it will track the changes – any Material, Operations or Legs that are Added, Deleted or Edited.

When you are done editing the Engineering Master you can apply the changes to the selected Work Orders right from the ECN window.

BTW, you don’t have to add the Work Orders to the ECN, it’s a nice way to track those changes but not required. 

VVUG Tips & Tricks: Shortcut to Insert a Line in a Grid/Table.

VVUG Tips & Tricks: Shortcut to Insert a Line in a Grid/Table. 150 150 admin

Shortcut to Insert a Line in a Grid/Table

Just about any screen that has a table/grid, you can quickly add a line by double clicking the grey box in the upper left corner.  For those users that use a mouse more than the keyboard, this can keep you focused on the lines and not looking for the icon in the toolbar.  Yes, keyboard shortcut (Ins) works great for those user that prefer a keyboard over a mouse.

BTW, you can double click the square to the left of the line number to mark a line to be deleted.

VVUG WEBINAR: Synoptix

VVUG WEBINAR: Synoptix 150 150 admin

Business Intelligence That is Built for VISUAL

Learn how easy it is to use Synoptix to build and view Dashboards, Reports, Financial Statements all with dynamic filtering and one click drill downs to source data. You don’t need to be a technical wizard to have a great Business Intelligence tool. Join us and you will see just how easy it is!

https://attendee.gotowebinar.com/recording/3697457887771864834

VVUG Tips & Tricks: Where Did That BOM Come From?

VVUG Tips & Tricks: Where Did That BOM Come From? 150 150 admin

Where Did That BOM Come From?

In release 9.0.4 development added new column “Entered_By” to the Work Order table.  It’s didn’t seem like much at the time but upon further review it’s a very nice addition.  You now know who created the structure and what application was used to do it.   Was it from a quote?  Firming a Planning order? Linking a work order to a sales order line? DBR?   The column is displayed on the WO/EM/QM header and a tooltip with the name of the user, application and any associated info is displayed. 

You can also look in the database itself to see this info:

It’s doesn’t solve all of life’s mysteries but it does answer the question – where did that BOM come from?  And it couldn’t be easier to answer.