Solution-IV® FAQ Frequently Asked Questions
General questions
The following document outlines the requirement for both the Server as well as the Client hardware:
Solution-IV Hardware Requirements
This is due to the TZ, Time Zone, variable being set incorrectly in the operating system. The follow chart outlines the proper codes to use:
  • AKST9 – Alaskan Standard Time
  • AST4 – Atlantic Standard Time
  • CST6 – Central Standard Time
  • EST5 – Eastern Standard Time
  • HST10 – Hawaii-Aleutian Standard Time
  • MST7 – Mountain Standard Time
  • PST8 – Pacific Standard Time
  • AKDT8 – Alaskan Standard Time
  • ADT3 – Atlantic Standard Time
  • CDT5 – Central Standard Time
  • EDT4 – Eastern Standard Time
  • MDT7 – Mountain Standard Time
  • PDT6 – Pacific Standard Time
You should use the disk number associated with SOL4 Example:
				Disk
				Nmbr      Directory		         Status
				----      ------------------------------ ------
				D0        IDL4
				D1        WORK
				D2        SOL4
				D9        .
				
  • F1 – Change modes (Add/Change/Delete/Inquire)
  • F2 – Lookup on Master file records
  • F3 – Allow maintain Master file records
  • F4 – End/Exit
  • F5 – Allow you to change the sort order for Views
  • F6 – Help
  • F10 – Goto
  • F12- Wild card search (Customers/Vendors/Items)
  • Shift + Insert – Line Insert
  • Shift + Delete – Line Delete
Accounts Receivable
Do the following:
1. Go to AR – Cash Receipts Entry
2. In the first section, make a deposit for $0.00
3. In the second section, make a payment for $0.00
4. In the last section, enter the invoice number being corrected; this will show you the remaining amount on the invoice (in this case -0.01)
5. Enter through the remaining fields, leaving the totals at 0.00 until you are at the Write-off/Bal field for the Invoice
6. Enter the outstanding amount in this field (in this case -0.01); this will cause the distribution to be equal
7. Finally, run the Cash Receipts Journal Update and problem should be fixed
The Aged Trial Balances are base on the Terminal Date, this date can be changed from the Main Menu, select "Change Terminal Date". This option will only change it for this workstation's session.
While in AR Cash Receipts Entry, on the Bank Code field, press F2 and select Deposits.
  • For Sales numbers you should use, Order Processing Reports menu, History Sales Journal
  • For Sales Tax you should use Accounts Receivable Reports menu, Sales Tax Report by Date
  • For Commissions you should use, Accounts Receivable Reports menu, Commission Report by Date
  1. Payments/Deposits entered via POS or on an order go to Cash Receipts Entry via the Deposit Journal & Update
  2. Payments entered on an invoice go to Cash Receipts Entry via the Sales Journal & Update
  3. Run the Cash Receipts Journal & Update to post payment records to customer’s account
  1. Go to Accounts Receivable, Transaction Menu, Cash Receipts Entry
  2. Enter in a deposit of $0
  3. Enter Customer code, Reference of “Cleanup”, Amount of $0
  4. Select the –PP record and enter through fields until back to Invoice Number and the credit balance is now in the distribution field
  5. Select the invoice record and enter through and apply that amount to bring the distribution down to 0
  6. Run the Cash Receipts Journal & Update so the –PP record will now officially be tied to the –IN record in AR
  1. In AR Cash receipts, enter a 0 balance check for this customer
  2. Enter Pre-payment or Credit Memo number
  3. In the invoice field, type “GL”, this will bring up the GL Distribution window. Enter a GL Account number you can use as a wash account.
  4. Run the Cash Receipts Journal and Update
  5. In AP Manual Check entry, write a check to the customer.
  6. In the invoice field you will create a new one, you could use today’s date.
  7. In the GL Distribution window, use the same wash account you used in AR Cash Receipts.
The end result is the Customer Account is clean, the wash account is clean, and the cash is reduced.
Accounts Payable
1. Create a new bank code representing the credit card (ie VS, AX, MC, etc)
2. For the General Ledger account on that bank, create and use a "Credit Card Payables" account
3. When you get the invoice from the vendor, if you don't know either when you are going to pay it or that you might pay it by credit card, enter the invoice as a regular invoice through Invoice Entry. You should expense it to the appropriate expense account, based on what was purchased
4. When you are ready to pay the invoice using your credit card, go to Manual Check Entry, and use the bank code created in step 1 above. Make up a check number, or use the vendor code plus date (or whatever makes sense to you), and pay the invoice
5. If you know right away that you are using your card, you can skip step 3 and simply enter the payment as a manual check, entering the appropriate expense account in Manual Check Entry
6. When you get the credit card bill, instead of detailing the expenses, you'll debit the "Credit Card Payables" account instead
7. If you enter all of your credit card payments in this manner, it will be easy to keep straight. And you'll be able to view the amount owed on your credit card by looking at the "Credit Card Payables" account in GL
You can see what your current AP Period is by going to Accounts Payable, Code File Maintenance Menu, AP Parameters Maintenance. The current month/year is a little more that half way down the screen.
AP happens to be a module where if you separate out your invoices by date, you can keep two months open at a time. In fact, we recommend this method, primarily because we are very aware that you will be getting both last month's and this month's invoices for the first couple of weeks of the new month. So it is good to just pick a day of the month (say the 15th or the 20th) when you will consistently close AP and PO. The system is smart enough to look at the date in the AP Parameters and determine if the invoices belong in "Current Month" or "Next Month". In order to make this work, however, you must separate out the invoices into batches by date -- October invoices together and November invoices together, for example -- and run the Invoice Register and Update in between the batches, making sure that the Posting Date matches the contents of the batch -- ie 10/30/19 and 11/18/19. And, of course, you must remember to consistently run Period End Processing mid-month.
  1. Account Payable, Payment Processing Menu, Manual Check Entry
  2. Select Manual Checks
  3. Enter the Bank
  4. Enter thru the Batch field
  5. Enter the Check Number
  6. Answer Yes to “Reverse this check?”
  7. F4 out and run the Register and Update.
Order Processing
1. When in Order Entry Payment, go to the sequence number field
2. Press F1 on the field until the mode changes to Delete
3. Enter the sequence number you want to remove and then press Enter
4. The sequence number should now be removed from Payments list
1. From the Order Processing Menu
2. Select Code File Maintenance
3. Then select Contract Maintenance and press F2 and select Contracts
When you are in Lines Entry, go to the Ordered/Shipped field, select F7, go down to the discount field and enter the percentage.
Purchase Order
This happens because the Valuation UOM may be different from the UOM shipped by the vendor. Set up a Priced Item type item and use it to post the pricing discrepancy. Just add this line to the end of the PO Invoice.
Inside the PO Period End Update there is an option to remove completed orders. This is tied to a flag in the PO Parameter file for number of days to retain completed orders. Based off what you set in here is how it determines what to remove. 0 days means remove everything that is completed and 999 days means never remove anything. 998 is the maximum amount allowed otherwise, which is roughly 2.5 years; generally users set this field to 30-60-90.
Inventory Control
There are 3 steps to creating a Quantity Break Table:
1. Create an Item Price Class
  • Inventory Control Menu
  • Code File Maintenance
  • Class Code Maintenance
2. Create the Price Break Table
  • Inventory Control Menu
  • Code File Maintenance
  • Price Break Maintenance
3. Assign the Class to the Item
  • Inventory Control Menu
  • Item Maintenance Menu
  • Enter Item Code
  • Select Option 2, Code and Commission Maintenance
  • Enter Class into Item Price
There are 2 steps to deleting an Item:
1. Mark the Item for Deletion
  • Inventory Control Menu
  • Item Maintenance Menu
  • Enter Item
  • Select "Change/Delete Item Code"
2. Run Status Change Update
  • Inventory Control Menu
  • Status Change Update
    • a. Perform update for this IC application only? – "Y"
    • b. Automatically Update after report is okay? – "N"
    • c. Report will print with all items marked for change and delete, Items with an "*" are not able to be deleted since they are in use in the files listed
General Ledger
APIN – Accounts Payable – Invoices
APMC – Accounts Payable – Manual Checks
APCK – Accounts Payable – Check Printing
ARSJ – Accounts Receivable – Sales Journal
ARCR – Accounts Receivable – Cash Receipts
ARFC – Accounts Receivable – Finance Charges
BRAJ – Bank Reconciliation – Adjustments
FAAJ – Fixed Assets – Acquisitions
FADJ – Fixed Assets – Depreciation
FARJ – Fixed Assets – Retirements
ICPC – Inventory – Physical Count
ICTR – Inventory – All Other Transactions
OPSJ – Order Processing – Sales Journal
PORC – Purchase Order – Receipts
PORT – Purchase Order – Returns
POIN – Purchase Order – Invoices
PRCK – Payroll – Checks