Manufacturing Exceptions

See your issues

Have you ever looked at a work order in the Manufacturing Window and wished problems with the work order would just jump off the screen? Well, we haven’t gotten the jumping technology perfected yet, but here is the next best thing. Watch the demo and see.

Export to and Import from Excel

It’s pretty easy

Love using Excel but hate entering data into Excel? Use the tools in VISUAL to query the data you want, and then export it out to Excel. From there, chart, graph and sort to your heart’s content. Want to bring information into VISUAL from Excel? You can do that also, providing you have SYSADM rights, or the person with SYSADM rights unlocks this feature for you.

Modify the Personal Menu

Have everything at your fingertips

Here is a simple yet effective time saver anyone can do: Modify your Personal Menu in VISUAL. All your favorites will be one click away, and you are not limited to VISUAL items. View the demo, modify your Personal Menu, and impress your co-workers.

Connect Excel to VISUAL

Watch us create a negative inventory report

Did you know you can connect to the VISUAL database with Excel? It’s a great way to get the information you want, in a format that you are probably comfortable with. In addition, you can use the tools in Excel to sort, graph, or evaluate the raw data from VISUAL. Click on the link below to see how to accomplish this. In the demo, Nick will show you how to create a negative inventory report.

Save Paper

Here is one example

Do you run the Material Planning Report? Would you like the same information without the paper? View the demo to see how a little used feature can provide this for you. Sorry, this will not work if you have independently planned warehouses.

After you view the demo, here is the statement you’ll need:

p.QTY_IN_DEMAND>(p.QTY_ON_HAND+p.QTY_ON_ORDER) AND p.PURCHASED=’Y’ AND p.CONSUMABLE=’N’

You can copy and paste this statement in the query window under Search condition.

Clearing Up Uninvoiced PO Receipts

Easy fix to a nagging issue

Does this sound familiar? Your purchase order accrual account carries a credit balance from the receipt. When you print out your uninvoiced receiver report, this receiver now stands alone, and you’ve already paid the vendor. Try this 4-step process to get your reporting back on track.

1. Match the receiver to a dummy voucher/invoice for the vendor to bring it into accounts payable.
2. Add a second line on the invoice for negative the amount on the first line and book it to the account that you used when creating the original voucher. This creates a $0 voucher.
3. You should leave the invoice total at $0, but be sure the line items also net to $0.
4. Save and post the voucher.

This journal entry reverses the double posting to Inventory, relieves the purchase receipts accrual account, and removes the purchase order from the Uninvoiced Receiver Report.