Tips & Tricks
|
Do you have a favorite VISUAL Tip or Trick? Drop us an email. If it makes us say, "Cool!", we'll publish it, and give you credit. International fame will soon follow.*
*Individual results may vary.
|
Manufacturing Exceptions
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.
 View Demo
|
Export to and Import from Excel
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.
View Demo
|
Modify the Personal Menu
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.
View Demo
|
|
Connect Excel to VISUAL
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.
View Demo
|
|
Save Paper
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.
View Demo
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.
|
Automatic Update Notification
Did you know there is a service available from Infor365 that will notify you when patches are released? It's called Proactive Communication, and you can learn about setting it up by clicking here.
|
Clearing Up Uninvoiced PO Receipts
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.
- Match the receiver to a dummy voucher/invoice for the vendor to bring it into accounts payable.
- 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.
- You should leave the invoice total at $0, but be sure the line items also net to $0.
- 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.
|
|
 |
|
|
|
Infor 365
Need a tutorial on how to use the support site? Click here for helpful instructions.
Helpful Links
Earn $500
Simplified Job Tracking (SJT)
Simplified Material Planning (SMP)
AutoFlush
Work Order Receipt Processor (WORP)
|
|
