How to Use OneSource

101	How to Delete AP Payments To delete a Check Go to the banking menu and click the Find Check. Once you found the check you can just click the edit button and then the delete button. This will delete the check (and if the bill payment was posted it will unpost that as well). To delete…
102	How to double check inventory costs The General Ledger in OneSource is completely independent (in a separate table called GL Transactions ) from the transactions in OneSource that effect your financial statements, such as Invoices, Invoice Payments, Bills, Bill Payments, Checks, Deposits, Adjustments,…
103	How to enable the Unit of Measure ( UOM ) option ( to insert converted price per x on line item ) OneSource provides a way to quickly calculate and insert (in a Quotation, Sales Order, or Invoice line item description) the price of an item displayed in a different price per X. For instance: If the unit (List/Retail) price of an item is $1.95, and if you…
104	How to enter payroll into the checking account and GL (One time only) Create a suspense (Asset) account in your Chart of Accounts for transfers. Go to the banking tab and click Adjustments. ( Note: Use this option if you have the money automatically coming out of your checking account). Click the new button…
105	How to export and import an Excel file of items using the Auto PO As of version 4.1.1231.66, on the Auto PO detail screen (on the Functions button) and on the Purchase Order (Functions button) there is an option to create an Excel export file. The following bullet points show which column headings need to be in place (before…
106	How to export OneSource Sales Order information into UPS WorldShip (Outdated and/or Obsolete as of 4/10/13???) After UPS WorldShip is properly installed on a PC and OneSource is setup for use with UPS WorldShip, follow these steps to export the Sales Order number and Sales Order Shipping address information: Create a Sales…
107	How to fix an unbalanced Balance Sheet Technically, OneSource has been designed to not allow postings to your GL unless the debits and credits balance. However, with the proper security permissions, OneSource tables can be directly accessed and individual debits and or credits can be changed in…
108	How to give a refund to a customer Create a Credit Memo for the item(s) you wish to give a refund on. Create a check from the Banking > Check Writer in OneSource. Make the Debit account on the check the Sales Account. Go to the Credit Memo and click on the payments button on the bottom.…
109	How to handle checks returned for NSF (bounced checks). Note: It may seem like the easiest approach to handle a bounced check is to just find the payment applied to an Invoice and delete the check. However, because at this point in the process (when you have received an NSF notice from your bank), the deposit…
110	How to import and view Supplier Inventory Levels in OneSource (available to sell, but not in your own physical warehouse) 1 time setup (for each Supplier) Create file links Designate a static (unchanging) file name and file location and file structure that you will use each time you want to import new data. Example: C:\OneSource\Data\SupplierData\SupplierXImport.xls (put that…

...