Author Archives: Archie Tucker

Adjust A/P Open Invoice

The Open Invoice Data Entry selection on the Accounts Payable Invoice and Manual Check Menu can be used to adjust invoice dates and make adjustments to invoice amounts.

Enter the vendor code or ? to insert the vendor from the display window
Enter the invoice number or ? to insert the invoice number from the display window
‘Is This An Invoice Adjustment?’ (Y)es or (N)o? -> Press Y to continue

Notes:

The invoice dates, terms, purchase order number, memo and invoice amounts displays on your screen.

‘Is The Data Correct?’ (Y)es or (N)o?

Type N to edit the invoice amount -> Enter the amount of the adjustment

Notes:

You can adjust the entire amount or a partial amount. The
amount must be a negative amount. If you are adjusting a credit
invoice, the amount would be positive.

The General Ledger distribution will display on the bottom of your
screen.
Press Enter to accept the line number assigned by the system
Press Enter to accept the expense account(s) displayed that was on the original invoice.

Notes:

Multiple General Ledger account numbers can be distributed.
For example, you may want to adjust only the amount of freight.

Run the Invoice Data Entry Register and Update to complete the process.

Adjust A/R Open Invoice

The Open Invoice Data Entry selection on the Accounts Receivable Invoice System Menu can be used to adjust invoice dates and make adjustments to invoice amounts. It must be noted that if you change the amount of an open invoice in this manner, it will not affect anything in the system except the customer’s account and will make a posting to the General Ledger.

Notes:

The proper way to adjust an invoice amount is to issue a credit memo in the Order Entry system, so it affect all receivables, inventory and sales analysis reports. The system will prompt you to enter a General Ledger account number. If you are going to only adjust the date of the invoice, you will enter the Accounts Receivable account number so the amounts posted to the General Ledger will be zero. If you are going to adjust the amount of the invoice, you will enter a revenue account that was used on the original invoice.

Enter the invoice number or ? to insert the invoice number from the display window. Press the Enter key to accept the customer code displayed on your screen. The invoice date and due date, discount amounts and invoice amounts display on your screen.

‘Is This An Invoice Adjustment?’ (Y)es or (N)o? –> Press Y to continue

Press Enter for invoice date or change the date on the invoice
Press Enter for due date or change the due date on the invoice
Press Enter for discount date, if applicable, or Enter to bypass the discount date
Adjust the amount of the discount, if applicable
Enter the amount of the invoice adjustment

Notes:

If you are only changing the dates of the invoice, you must enter a zero for invoice amount so the original amount of the invoice is not altered. If you want to adjust the invoice amount, you must enter the amount as a negative. If this invoice happens to be a credit invoice, the amount would be positive.

Press Enter to accept the line number assigned by the system

Press Enter to accept the revenue account displayed or input the General Ledger account that you want to distribute 

Notes:

Multiple General Ledger account numbers can be distributed.

Run the Open Invoice Data Entry Register and Update to complete.

Write Off Bad Debts

When a customer does not pay their open invoices or will not pay sales tax on an invoice, or perhaps has to close their business, you may want to write off their invoices to a General Ledger account to reflect on your corporate tax return.

To write off of an invoice or a customer’s balance on account, you will use the Cash Receipts Data Entry screen on the Cash Receipts Menu. Following are the step by step instructions:

Enter the date for the write off -> Deposit amount is always zero
Type the customer code or ? to insert a customer from the display window
Enter check number as a reference (i.e. BADDEBT, WRITEOFF)
ABA field can be a memo or left blank -> Debit cash amount will always be a zero

Enter the invoice(s) that you want to write off -> Bypass discount field -> Press the Enter key to accept the amount shown or enter a partial invoice amount if you are only writing off a portion of the balance.

Once all of the invoices are entered, type ‘MISC’ in the invoice field to distribute to the General Ledger -> Enter the General Ledger account number -> Press Enter to accept the amount displayed.

Notes:

If you want to distribute the amount to more than one General Ledger account, continue to enter account numbers and amounts until the distribution amount is equal to zero.

Apply A/R Credit Memo

A credit memo is entered in Order Entry so it will reflect in invoice history, Accounts Receivable reports, Inventory reports and Sales Analysis reports. It is possible to enter a credit invoice in the A/R module, but it won’t affect anything but the customer’s account.

Credit memos are applied using Cash Receipts Data Entry on the Cash Receipts Menu. Following are the step by step instructions:

Enter deposit date -> Enter a deposit code or can be left blank
The deposit amount will always be zero
Type the customer code or ? to insert a customer from the display window
The check number can be used as a reference (i.e. APPLY, CREDIT)
ABA field can be a memo or left blank -> Debit cash amount will always be a zero

Notes:

The invoice and credit memo numbers will display on the bottom portion of your screen. Press the Enter key for multiple screens.

Select the credit memo in the invoice number field -> Bypass the discount field
Press the Enter key to accept the amount shown or you may apply a partial amount of the credit memo

Type the invoice(s) numbers you are paying with this credit memo or type AUTO to apply the credit to the oldest invoices on account.

Enter Prepayment on Account

To apply a prepayment to a customer’s account, you must use the Cash Receipts Data Entry screen on the Cash Receipts Menu. This would be used if an advance payment is received on an order that has not been invoiced. Following are the step by step instructions:

Enter deposit date -> Select type of deposit code (cash, check, credit card)
Enter the amount of the prepayment for deposit amount
Type the customer code or ? to insert a customer from the display window
Use PREPAY for check number
ABA number can be left blank -> Enter the amount of the payment

Type the invoice number, if known, or use a number of your choice
‘Is This a PrePayment? (CR-N)’ message will display -> Press the Enter key
Bypass the discount field -> Enter the amount of the payment

Print the Cash Receipts Journal and Update

Reverse Cash Receipts Payment

To reverse an Accounts Receivable Cash Receipts Payment, you must use the Cash Receipts Data Entry screen on the Cash Receipts Menu. A payment would only need to be reversed if the original payment was applied to the wrong customer’s account, a returned check, etc. Following are the step by step instructions:

Enter deposit date -> Select type of deposit code (cash, check, credit card)
The deposit amount must be entered as a negative number (-150.00)

Type the customer code or ? to insert a customer from the display window and enter the check number to reverse

Notes:

If the check number is not known, you can use the word REVERSE.

You can use the ABA number field as a memo field (Perhaps an explanation of why you are reversing the payment or leave blank)

The debit cash amount must be entered as a negative number

Select the invoice(s) number you want to reverse, bypass the discount field unless there was a discount taken when the payment was posted

The invoice amount must also be entered as a negative amount

Setup A New Inventory Product Category

There are four steps that are required to set up a new inventory product code. Select Inventory Control -> Select Inventory Control Definition Menu

1) Select Segment One Maintenance and enter the new product category code and the description of the product category.

2) Select Distribution Code Maintenance and enter the new product category code. You must enter a debit and credit General Ledger account number for Receipts, Issues, Adjustments, Physical Count and Sales.

Notes:

See the Total Order Plus Inventory Control manual for detailed information on how to enter the distribution account numbers for each category.

3) Enter ? to display the I/C Options Menu. Select Product Category Maintenance and enter the product category and the description will automatically display. This code can be up to three characters and is used for categorizing reports.

4) Select Discount Class Maintenance on the I/C Options Menu. Enter the discount class code and the description will automatically display. The discount class code can be the same as the segment one code for simplicity.

Enter L for level pricing, P for quantity break pricing or N for net quantity break pricing. Depending on your selection, you will enter the discount percentages or quantity breaks for each level.

Level M is used for custom pricing and N is used for best price.