Adjutant Wiki - User contributions [en]

SSDELAY

2022-12-16T22:14:02Z

Bjohnson: Redirected page to Sales Order Delayed Alerts - SSDELAY Rule

#REDIRECT [[Sales Order Delayed Alerts - SSDELAY Rule]]

Sales Order Delayed Alerts - SSDELAY Rule

2022-12-16T22:09:10Z

Bjohnson:

== General Information ==

'''Default Menu Location:''' Maintain >> System >> Rule Maintenance

'''Function:''' This rule enables users to set up auto-emails to be sent to customers x minutes/hours/days/weeks after an SO has been shipped and invoiced. This works whether the order was manually shipped or shipped through a Shipping Event.

'''Special Notes:''' See this section for important notes on how this rule functions.

[[File:SSDELAY.png]]

== Rule Setup - Fields ==

'''SOTYPE:''' Enter in a Sales Order Type Code from the SOTYPE rule. This designates which SO Type will trigger the auto-email.

'''Offset:''' Enter the time offset from when the order is shipped/invoiced to when the email is sent. This can be done using w (week), d (day), h (hour) or m (min). For example, 1d will offset the email delivery by 1 day. Putting a number with no unit will default to minutes.

'''Template Name:''' Enter the name of the email template to be used. These templates can be managed in the Email Templates screen.

== Special Notes ==

'''Email Address in the FROM Line:''' The email being sent will go to the email address associated with the Sold To customer in the Sales Order. It will be sent from the email address of the Salesperson record in the SO as long as the SP has an email address that is within their company's domain. For example, an SP working at ABIS with a gmail address wouldn't have the email be sent from their account. Instead, it would come from notes@abiscorp.com. However, if the SP had an abiscorp.com address in their record (e.g., jr@abiscorp.com) that email address would be placed in the FROM line of the email sent.

'''Signature Line:''' It is recommended that the SP have a User in Adjutant attribute assigned to their contact record, so that the signature line fields (e.g., USERINFO.fullname, USERINFO.company) can be used. You can also overwrite what email address shows up in the FROM line using the FromAddress field in the email template.

[[Category:Rule Maintenance]]
[[Category:Accounts Receivable]]
[[Category:Order Entry]]

Sales Order Delayed Alerts - SSDELAY Rule

2022-12-16T22:08:03Z

Bjohnson:

File:SSDELAY.png

2022-12-16T22:07:27Z

Bjohnson:

Sales Order Delayed Alerts - SSDELAY Rule

2022-12-16T21:55:42Z

Bjohnson: Created page with "== General Information == '''Default Menu Location:''' Maintain >> System >> Rule Maintenance '''Function:''' This rule enables users to set up auto-emails to be sent to cus..."

== General Information ==

'''Default Menu Location:''' Maintain >> System >> Rule Maintenance

'''Function:''' This rule enables users to set up auto-emails to be sent to customers x minutes/hours/days/weeks after an SO has been shipped and invoiced. This works whether the order was manually shipped or shipped through a Shipping Event.

'''Special Notes:''' See this section for important notes on how this rule functions.

== Rule Setup - Fields ==

'''SOTYPE:''' Enter in a Sales Order Type Code from the SOTYPE rule. This designates which SO Type will trigger the auto-email.

'''Offset:''' Enter the time offset from when the order is shipped/invoiced to when the email is sent. This can be done using w (week), d (day), h (hour) or m (min). For example, 1d will offset the email delivery by 1 day. Putting a number with no unit will default to minutes.

'''Template Name:''' Enter the name of the email template to be used. These templates can be managed in the Email Templates screen.

== Special Notes ==

'''Email Address in the FROM Line:''' The email being sent will go to the email address associated with the Sold To customer in the Sales Order. It will be sent from the email address of the Salesperson record in the SO as long as the SP has an email address that is within their company's domain. For example, an SP working at ABIS with a gmail address wouldn't have the email be sent from their account. Instead, it would come from notes@abiscorp.com. However, if the SP had an abiscorp.com address in their record (e.g., jr@abiscorp.com) that email address would be placed in the FROM line of the email sent.

'''Signature Line:''' It is recommended that the SP have a User in Adjutant attribute assigned to their contact record, so that the signature line fields (e.g., USERINFO.fullname, USERINFO.company) can be used. You can also overwrite what email address shows up in the FROM line using the FromAddress field in the email template.

HOW TO - Make changes to a Sales Order which has been shipped

2022-08-25T22:51:42Z

Bjohnson:

===How to change the qty or price on an order that has been invoiced===

'''1.''' Open the invoice associated with the sales order

'''2.''' Void the invoice by clicking the 'Issue Credit for Invoice' button on the left side of the screen. Click through the prompts, selecting Yes. This will unbill and unship the sales order.

'''3.''' Open the original sales order and make specified changes to quantity, items, or pricing.

'''4.''' Once changes have been made, re-ship/invoice the sales order.

'''NOTE:''' ''This action is only available for invoices which have not been paid''

[[Category: Accounts Receivable]]

HOW TO - Make changes to a Sales Order which has been shipped

2022-08-25T22:45:37Z

Bjohnson: Created page with "===How to change the qty or price on an order that has been invoiced=== '''1.''' Open the invoice associated with the sales order '''2.''' Void the invoice by clicking the..."

===How to change the qty or price on an order that has been invoiced===

'''1.''' Open the invoice associated with the sales order

'''2.''' Void the invoice by clicking the Red 'Delete' button on the right side of the screen (Red 'X' symbol). This will unbill and unship the sales order.

'''3.''' Open the original sales order and make specified changes to quantity, items, or pricing.

'''4.''' Once changes have been made, re-ship/invoice the sales order.

'''NOTE:''' ''This action is only available for invoices which have not been paid''

[[Category: Accounts Receivable]]

HOW TO - Issue a Credit for an Invoice

2022-08-15T21:42:50Z

Bjohnson: Created page with "===Function=== The '''Issue Credit for Invoice''' function in Adjutant allows users to void an invoice that hasn't received payment. This can be used to correct errors with a..."

===Function===

The '''Issue Credit for Invoice''' function in Adjutant allows users to void an invoice that hasn't received payment. This can be used to correct errors with an invoice while still remaining GAAP compliant. That is, the existing invoice cannot be directly edited and must be voided. The system creates a separate invoice to apply the credit to the existing invoice, unships the order and reopens the sales order. Corrections can be made to the sales order, and then the order can be reshipped, at which point a new invoice will be generated.

----

===Steps===

'''STEP 1: TRANSACTION >> ACCOUNTS RECEIVABLE >> AR INVOICE MASTER'''

'''STEP 2:''' Enter the invoice number you wish to void in the '''Invoice Number''' field.

'''STEP 3:''' Click the '''Issue Credit for Invoice''' button and verify you want to issue a credit for the invoice.

'''STEP 4:''' Click '''Yes''' when asked "Issue Credit and Unship/Bill?"

'''STEP 5:''' Enter the desired Memo Date and click '''Approve'''.

'''STEP 6:''' Click '''Yes''' to reopen the sales order.

'''STEP 7:''' Click '''YES''' to apply the credit memo to the original invoice.

Once the invoice is credited, the ''Credit Issued'' notice will appear on that invoice, and a header note will automatically be added with the reference number for the invoice applying the credit.

[[File:IssueCreditForInvoice6.PNG]]

[[Category: Accounts Receivable]]

File:IssueCreditForInvoice6.PNG

2022-08-15T21:42:12Z

Bjohnson:

HOW TO - Change the Billing Cycle (Month and Year) of an Invoice

2022-08-10T18:12:53Z

Bjohnson: Created page with "===Default Menu Location=== Transaction >> Accounts Receivable >> AR Invoice Master File:ChangeBillingCycleForInvoice.png ---- ===Procedures=== Enter the Invoice Num..."

===Default Menu Location===

Transaction >> Accounts Receivable >> AR Invoice Master

[[File:ChangeBillingCycleForInvoice.png]]

----

===Procedures===

Enter the Invoice Number you wish to change and press Enter.

Click Edit AR Invoice

In the Billing Cycle field, enter the correct month and year for your invoice

Click Save Changes

[[Category: Accounts Receivable]]

File:ChangeBillingCycleForInvoice.png

2022-08-10T18:12:44Z

Bjohnson:

Generatefinancecharges

2022-08-04T21:50:15Z

Bjohnson: Changed redirect target from Apply Credits to Generate Finance Charges

#REDIRECT [[Generate Finance Charges]]

Generatefinancecharges

2022-08-04T21:49:58Z

Bjohnson: Redirected page to Apply Credits

#REDIRECT [[Apply Credits]]

Generate Finance Charges

2022-08-04T21:49:04Z

Bjohnson:

===General Description===

'''Default Menu Location:''' Transaction>> Accounts Receivable>> Generate Finance Charges

'''Screen Name:''' Generatefinancecharges

'''Function:''' This screen will allow users to generate finance/interest charges on outstanding AR invoices based off the [http://www.abiscorp.com/faq/images/9/97/GenerateFinanceChargesBillTo.png Annual Rate] entered on the Customer's [http://www.abiscorp.com/faq/index.php?title=Bill_To BillTo] attribute.

[[File:GenerateFinanceCharges.png]]

----

===Daily Interest Rate===

Interest is calculated on a daily basis according to the annual rate (converted to daily rate) and the daily balance of each invoice.

To calculate the daily interest rate (R), the program divides the interest rate (I) by the number of days in the year (D).

R = I / D

For example, an annual rate of 18% is calculated as a .049315% daily rate (R = 18/365).

''Remember to enter the ANNUAL RATE on the Bill To screen.''

----

===Finance Charge Calculation===

The Daily Rate is used to calculate the interest on each outstanding invoice.

For our example, we will assume that today is 09/01/13 and that the Annual Rate is 18%. We will also assume that no prior payments have been made on the invoices.

The following invoices will be included in the finance charge:

{| class="wikitable"
|-
! Invoice Number !! Invoice Date !! Due Date !! Balance
|-
| 1001 || 06/25/13 || 07/25/13 || $4200
|-
| 1052 || 06/30/13 || 07/30/13 || $1250
|-
| 1185 || 07/12/13 || 08/11/13 || $500
|}

If calculating interest from the Invoice Date, then the charges are calculated as:

(annual rate ÷ 365) * (today - invoice date) * balance.

For Invoice 1001, interest is calculated as (.18 ÷ 365) * 68 * 4200 = 140.84

For Invoice 1052, interest is calculated as (.18 ÷ 365) * 65 * 1250 = 38.34

For Invoice 1185, interest is calculated as (.18 ÷ 365) * 51 * 500 = 12.58

----

If calculating interest from the Due Date, then the charges are calculated as:

(annual rate ÷ 365) * (today - due date) * balance.

For Invoice 1001, interest is calculated as (.18 ÷ 365) * 38 * 4200 = 78.71

For Invoice 1052, interest is calculated as (.18 ÷ 365) * 33 * 1250 = 20.34

For Invoice 1185, interest is calculated as (.18 ÷ 365) * 21 * 500 = 5.18

Download a spreadsheet of these calculations. (link)

----

===Things to Consider===

The program takes into account when an invoice was paid and what interest is due accordingly.

For example, an invoice that was issued 07/01/13 (due 07/31/13) and paid in full on 08/15/13 will be included in the Interest Charge calculation on 09/01/13 since it was paid after the due date.

Also, if an invoice is partially paid, the program will calculate interest on a daily basis based on the daily balance of the invoice.

For example, an invoice of $1000 is issued on 07/01/13 (due 07/31/13) and has a $500 payment applied on 07/15/13. If calculating from invoice date, then finance charges issued on 08/01/13 will calculate interest based on the $1000 balance for the first 15 days and $500 for the last 15 days.

----

===Fields/Filters===

'''Due Date Cutoff:''' This date determines which invoices will be included in the calculation. Any invoice with a due date after this cutoff will not be included in the finance charges.

'''Invoice date:''' The invoice date of the Finance Charge invoice you will be generating.

'''Bill Cycle:''' Enter the billing cycle (typically month and year) if you normally use this field. It will default to the month and year of the Invoice Date.

'''Minimum Charge:''' Set a minimum charge per invoice. Any finance charges (sum total) not meeting this minimum will be rounded up to the number entered here.

'''Include Old Finance Charges:''' This option allows you to charge interest on top of interest already charged (aka compound interest or capitalizing interest).

''Interest is usually not charged on interest. On some occasions banks may roll interest on a note and thus charge interest on the interest, but this is not advisable and is only done in certain situations that demand that it be done.''

'''Calculate Interest From:''' Choose whether to calculate interest from the Invoice Date or Due Date.

'''Exclude Paid Invoices:''' Check this box to exclude any paid invoices from the finance charges.

----

===Generated Invoices Tab===

To see the invoices that have been used to create finance charges please see the line items of the invoices created.

'''Custno:''' Customer ID

'''Company:''' Customer Name

'''INV#:''' Invoice number

'''Invoice Amount:''' Generated invoiced total amount

[[Category: Accounts Receivable]]

Generate Finance Charges

2022-08-04T21:40:41Z

Bjohnson:

===General Description===

'''Default Menu Location:''' Transaction>> Accounts Receivable>> Generate Finance Charges

'''Screen Name:''' Generatefinancecharges

'''Function:''' This screen will allow users to generate finance/interest charges on outstanding AR invoices based off the [http://www.abiscorp.com/faq/images/9/97/GenerateFinanceChargesBillTo.png Annual Rate] entered on the Customer's [http://www.abiscorp.com/faq/index.php?title=Bill_To BillTo] attribute.

[[File:GenerateFinanceCharges.png]]

----

===Daily Interest Rate===

Interest is calculated on a daily basis according to the annual rate (converted to daily rate) and the daily balance of each invoice.

To calculate the daily interest rate (R), the program divides the interest rate (I) by the number of days in the year (D).

R = I / D

For example, an annual rate of 18% is calculated as a .049315% daily rate (R = 18/365).

''Remember to enter the ANNUAL RATE on the Bill To screen.''

----

===Finance Charge Calculation===

The Daily Rate is used to calculate the interest on each outstanding invoice.

For our example, we will assume that today is 09/01/13 and that the Annual Rate is 18%. We will also assume that no prior payments have been made on the invoices.

The following invoices will be included in the finance charge:

{| class="wikitable"
|-
! Invoice Number !! Invoice Date !! Due Date !! Balance
|-
| 1001 || 06/25/13 || 07/25/13 || $4200
|-
| 1052 || 06/30/13 || 07/30/13 || $1250
|-
| 1185 || 07/12/13 || 08/11/13 || $500
|}

If calculating interest from the Invoice Date, then the charges are calculated as:

(annual rate ÷ 365) * (today - invoice date) * balance.

For Invoice 1001, interest is calculated as (.18 ÷ 365) * 68 * 4200 = 140.84

For Invoice 1052, interest is calculated as (.18 ÷ 365) * 65 * 1250 = 38.34

For Invoice 1185, interest is calculated as (.18 ÷ 365) * 51 * 500 = 12.58

----

If calculating interest from the Due Date, then the charges are calculated as:

(annual rate ÷ 365) * (today - due date) * balance.

For Invoice 1001, interest is calculated as (.18 ÷ 365) * 38 * 4200 = 78.71

For Invoice 1052, interest is calculated as (.18 ÷ 365) * 33 * 1250 = 20.34

For Invoice 1185, interest is calculated as (.18 ÷ 365) * 21 * 500 = 5.18

Download a spreadsheet of these calculations. (link)

----

===Things to Consider===

The program takes into account when an invoice was paid and what interest is due accordingly.

For example, an invoice that was issued 07/01/13 (due 07/31/13) and paid in full on 08/15/13 will be included in the Interest Charge calculation on 09/01/13 since it was paid after the due date.

Also, if an invoice is partially paid, the program will calculate interest on a daily basis based on the daily balance of the invoice.

For example, an invoice of $1000 is issued on 07/01/13 (due 07/31/13) and has a $500 payment applied on 07/15/13. If calculating from invoice date, then finance charges issued on 08/01/13 will calculate interest based on the $1000 balance for the first 15 days and $500 for the last 15 days.

----

===Fields/Filters===

'''Due Date Cutoff:''' This date determines which invoices will be included in the calculation. Any invoice with a due date after this cutoff will not be included in the finance charges.

'''Invoice date:''' The invoice date of the Finance Charge invoice you will be generating.

'''Bill Cycle:''' Enter the billing cycle (typically month and year) if you normally use this field. It will default to the month and year of the Invoice Date.

'''Include Old Finance Charges:''' This option allows you to charge interest on top of interest already charged (aka compound interest or capitalizing interest).

''Interest is usually not charged on interest. On some occasions banks may roll interest on a note and thus charge interest on the interest, but this is not advisable and is only done in certain situations that demand that it be done.''

'''Minimum Charge:''' Set a minimum charge per invoice. Any finance charges (sum total) not meeting this minimum will be rounded up to the number entered here.

'''Calculate Interest From:''' Choose whether to calculate interest from the Invoice Date or Due Date.

===Generated Invoices Tab===

To see the invoices that have been used to create finance charges please see the line items of the invoices created.

'''Custno:''' Customer ID

'''Company:''' Customer Name

'''INV#:''' Invoice number

'''Invoice Amount:''' Generated invoiced total amount

Generate Finance Charges

2022-08-04T21:39:33Z

Bjohnson:

Generate Finance Charges

2022-08-04T21:36:21Z

Bjohnson:

Generate Finance Charges

2022-08-04T21:35:39Z

Bjohnson:

Generate Finance Charges

2022-08-04T21:02:26Z

Bjohnson:

Generate Finance Charges

2022-08-04T20:51:39Z

Bjohnson:

Generate Finance Charges

2022-08-04T20:48:05Z

Bjohnson:

File:GenerateFinanceChargesBillTo.png

2022-08-04T20:45:42Z

Bjohnson:

Generate Finance Charges

2022-08-04T20:45:14Z

Bjohnson: Created page with "===General Description=== '''Default Menu Location:''' Transaction>> Accounts Receivable>> Generate Finance Charges '''Screen Name:''' Generatefinancecharges '''Function:''..."

File:GenerateFinanceCharges.png

2022-08-04T20:45:09Z

Bjohnson:

Dailyinvoicesummaryreport

2022-08-03T17:30:20Z

Bjohnson: Redirected page to Daily Invoice Summary

#REDIRECT [[Daily Invoice Summary]]

Daily Invoice Summary

2022-08-03T15:28:25Z

Bjohnson:

===General Description===

'''Default Menu Location:''' Reports >> Accounts Receivable >> Daily Invoice Summary

'''Screen Name:''' Dailyinvoicesummaryreport

[[File: Daily_Invoice_Summary.png]]

'''Function Daily:''' Invoice Summary generates a summary of all the different invoices for a day for a sales person.

----

===Report Filters===

'''Custno:''' Enter the customer number to generate a report.

'''Company:''' Enter the company name for the invoice.

'''Start Date:''' Enter the start date for the report.

'''End Date:''' Enter the end date for the report.

'''Account Manager:''' Select an account manager for the invoice.

'''Sales Person:''' Select a sales person for the invoice.

'''Warehous:''' Select a warehouse to filter the report by.

'''SO Type:''' Select an SO Type to filter the report by.

'''Sort By:''' Report can be sorted by Bid Order, Change Order, One Time Sales, Recurring Sales, Software License, Work Order.

'''Group By:''' Always set to Invoice Number.

----

===Standard Report Fields (Header)===

Every customer's report is different but some of the formats are the same.

* lc_company

* lc_report

* lc_title

* lc_slist

===Standard Report Fields (Line Items)===

'''Invoice#:''' The invoice number for the report.

invno

'''InvDate:''' The date invoice was generated.

invdate

'''SO#:''' Sales Order number for the invoice.

sono

'''Company:''' Company name for the invoice to generate.

altrim(company)+"("+altrim(custno)+")"

'''P/C:''' The completion status --Partial or Complete.

partcomp

'''Sales Coordinator:''' The name of the sales person for this invoice/report.

sp

'''DistrictMgr:''' Account manager for this invoice.

accmgr

[[Category: Accounts Receivable]]

Daily Invoice Summary

2022-08-03T15:22:19Z

Bjohnson: Created page with "===General Description=== '''Default Menu Location:''' Reports >> Accounts Receivable >> Daily Invoice Summary '''Screen Name:''' Dailyinvoicesummaryreport File: Daily_In..."

===General Description===

'''Default Menu Location:''' Reports >> Accounts Receivable >> Daily Invoice Summary

'''Screen Name:''' Dailyinvoicesummaryreport

[[File: Daily_Invoice_Summary.png]]

'''Function Daily:''' Invoice Summary generates a summary of all the different invoices for a day for a sales person.

===Report Filters===

'''Custno:''' Enter the customer number to generate a report.

'''Company:''' Enter the company name for the invoice.

'''Start Date:''' Enter the start date for the report.

'''End Date:''' Enter the end date for the report.

'''Account Manager:''' Select an account manager for the invoice.

'''Sales Person:''' Select a sales person for the invoice.

'''Warehous:''' Select a warehouse to filter the report by.

'''SO Type:''' Select an SO Type to filter the report by.

'''Sort By:''' Report can be sorted by Bid Order, Change Order, One Time Sales, Recurring Sales, Software License, Work Order.

'''Group By:''' Always set to Invoice Number.

===Standard Report Fields (Header)===

Every customer's report is different but some of the formats are the same.

* lc_company

* lc_report

* lc_title

* lc_slist

===Standard Report Fields (Line Items)===

'''Invoice#:''' The invoice number for the report.

invno

'''InvDate:''' The date invoice was generated.

invdate

'''SO#:''' Sales Order number for the invoice.

sono

'''Company:''' Company name for the invoice to generate.

altrim(company)+"("+altrim(custno)+")"

'''P/C:''' The completion status --Partial or Complete.

partcomp

'''Sales Coordinator:''' The name of the sales person for this invoice/report.

sp

'''DistrictMgr:''' Account manager for this invoice.

accmgr

[[Category: Accounts Receivable]]

File:Daily Invoice Summary.png

2022-08-03T15:22:12Z

Bjohnson:

Customerstatements

2022-07-26T21:50:14Z

Bjohnson: Redirected page to Customer Statements

#REDIRECT [[Customer Statements]]

Customer Statements

2022-07-26T21:49:47Z

Bjohnson: Created page with "===General Information=== '''Default Menu Locator:''' Reports >> Accounts Receivable >> Customer Statements '''Screen Name:''' Customerstatements '''Function:''' The Custom..."

===General Information===

'''Default Menu Locator:''' Reports >> Accounts Receivable >> Customer Statements

'''Screen Name:''' Customerstatements

'''Function:''' The Customer Statements screen is used to generates AR statements for specific customers, or all customers.

[[File:CustomerStatements.PNG]]

----

===Report Filter===

'''Custno:''' Enter the customer number that you want the report to filter to.

'''Company:''' Enter the company name that you want the report to filter to.

'''Project ID:''' Enter the project id that you want the report to filter to.

'''Include Paid:''' Include paid customer invoices.

'''Exclude Credits:''' Exclude customer open credits.

'''Exclude Deposits:''' Exclude customer deposits.

'''Exclude POS Payments:''' Exclude point of sale payments.

'''Show All Payments:''' Check this to see all payments made.

'''Show Recent Payments:''' Check this to show payments made within the last 30 days.

'''Age From:''' Choose the option required for how the report will be generated, either aged from Due Date or Invoice Date.

'''Show Agings/Detail Agings:''' Check one of these options to display the required depth of the report generated.

'''Only x Days after Invoice Date:''' Exclude customers that do not have an invoice older than this number of days.

''Both invoices will print if a cusotmer has an invoice older and newer than this number of days.''

'''Auto Process Options:''' Choose from All, Email, Fax, or Print.

'''Warehouse:''' Filter by only 1 warehouse or Select All.

----

===Standard Report Fields (Header)===

'''Bill To:''' Enter the Customer's name and address

* company
* address1
* alltrim(city)+", "+alltrim(state)+" "+zipcode

----

===Standard Report Fields (Line Items)===

'''Invoice Date:''' The date Invoice was generated

* ttod(invdate)

'''Invoice Number:''' The reference number for the generated invoice

* alltrim(invno)

'''Reference:''' The purpose of the charges for the generated invoice

* Tmplookup.notes

'''Invoice Amount:''' The amount for each services rendered

* totamt

'''Balance:''' The total amount for the services rendered for the invoice

* balance

[[Category: Accounts Receivable]]

File:CustomerStatements.PNG

2022-07-26T21:49:41Z

Bjohnson:

Customer Ledger Report

2022-07-21T14:50:15Z

Bjohnson:

===Default Menu Location===

'''Reports >> Accounts Receivable >> Customer Ledger Report'''

''Please note that this is a custom report and may not be on your menu.''

===General Information===

The Customer Ledger report is a running ledger tracking invoices and payments on a customer. The report can be run by date range for all time for a specific customer, by date range for all customers, or a specific date range for a specific customer.

The customer ledger will show the ending balance for that customer.

[[File:CustomerLedgerReport1.png]]

[[File:CustomerLedgerReport2.png]]

[[Category: Accounts Receivable]]

File:CustomerLedgerReport2.png

2022-07-21T14:50:10Z

Bjohnson:

File:CustomerLedgerReport1.png

2022-07-21T14:49:20Z

Bjohnson:

Customer Ledger Report

2022-07-21T14:48:17Z

Bjohnson: Created page with "''''Italic text''''''Italic text''''''Italic text''''''Italic text''''''Italic text''''''Italic text''''''''''''''"

''''Italic text''''''Italic text''''''Italic text''''''Italic text''''''Italic text''''''Italic text''''''''''''''

Cashreceiptsannualreport

2022-07-21T14:14:26Z

Bjohnson: Redirected page to Cash Receipts - Annually

#REDIRECT [[Cash Receipts - Annually]]

Cash Receipts - Annually

2022-07-21T14:12:40Z

Bjohnson: Created page with "===General Information=== '''Default Menu Locator:''' Reports >> Accounts Receivable >> Cash Receipts - Annually '''Screen Name:''' Cashreceiptsannualreport File:CashRece..."

===General Information===

'''Default Menu Locator:''' Reports >> Accounts Receivable >> Cash Receipts - Annually

'''Screen Name:''' Cashreceiptsannualreport

[[File:CashReceiptsAnnually.png]]

'''Function:''' Customer Cash Receipts- Annually generates a list of annual report for every customer.

----

===Report Filter===

'''Year:''' Choose the correct year you want the report to generate.

'''Order Type:''' Choose a report type from the menu -- Bid Order, Change Order, One Time Sales, Recurring Sales, Software License, Work Order, ALL.

'''Customer ID:''' Enter the specific Customer ID.

'''Priority:''' Choose an appropriate priority status from the menu.

----

===Standard Report Fields (Header)===

'''Year:''' Selected year for the report

* 'YEAR - ' + gd_passdate

* gc_ordtype

* gc_orderstat

* gc_customer

----

===Standard Report Fields (Line Items)===

'''Cust ID:''' The Customer identification number.

* custno

'''Customer Name:''' The name of the Company in most cases.

* Customer

'''YTD CashRec:''' Year To Date cash receipts.

* YTD

[[Category: Accounts Receivable]]

File:CashReceiptsAnnually.png

2022-07-21T14:12:09Z

Bjohnson:

Credit Hold Set Up

2022-07-20T20:40:53Z

Bjohnson:

===General Information===

'''Function:''' The Credit Hold Set Up screen allows users to customize what they will and will not allow for customers on credit hold based on the process. To allow a process while a customer is on credit hold, simply check the process and hit update.

When opening the screen for the first time, it will add the CHOLDPOINTS rule (link to page), and load the main processes by default.

[[File:CreditHoldProcessing.png]]

[[Category: Accounts Receivable]]

Credit Hold Set Up

2022-07-20T20:40:29Z

Bjohnson: Created page with "===General Information=== '''Screen Name:''' CREDITHOLD '''Function:''' The Credit Hold Set Up screen allows users to customize what they will and will not allow for custome..."

===General Information===

'''Screen Name:''' CREDITHOLD

'''Function:''' The Credit Hold Set Up screen allows users to customize what they will and will not allow for customers on credit hold based on the process. To allow a process while a customer is on credit hold, simply check the process and hit update.

When opening the screen for the first time, it will add the CHOLDPOINTS rule (link to page), and load the main processes by default.

[[File:CreditHoldProcessing.png]]

[[Category: Accounts Receivable]]

File:CreditHoldProcessing.png

2022-07-20T20:40:22Z

Bjohnson:

Credit Hold Process Points Rule

2022-07-20T20:02:59Z

Bjohnson: Created page with "===General Information=== '''Default Menu Location:''' Maintain >> System >> Rule Maintenance >> Credit Hold Processing - CHOLDPOINTS '''Function:''' This rule allows users..."

===General Information===

'''Default Menu Location:''' Maintain >> System >> Rule Maintenance >> Credit Hold Processing - CHOLDPOINTS

'''Function:''' This rule allows users to customize the process names to show in the Credit Hold Processing screen. This rule and the default set of descriptions is created automatically when opening the Credit Hold Processing screen. However, before the rule details will display the Rule Header must be updated to define the Text1 and Text 2 values as shown in the Rule Setup - Text Fields section below.

[[File:CHOLDPOINTS.png]]

----

===Rule Setup – Text Fields===

'''Process Name:''' Email address that should be BCC'd when AR Invoices are emailed from Adjutant.

----

===Rule Setup – Number Fields===

'''There are no Logic fields in use.'''

----

===Rule Setup – Logic Fields===

'''There are no Logic fields in use.'''

[[Category: Accounts Receivable]]

File:CHOLDPOINTS.png

2022-07-20T20:02:50Z

Bjohnson:

Credit Hold & Credit Limits

2022-07-19T21:30:40Z

Bjohnson:

===General Information===

A customer's credit limit is set on the [[Bill To]] screen.

The [[Bill To]] screen also allows you to place a customer on Credit Hold.

'''You cannot enter new sales orders for customers on credit hold.'''

[[File:CHCL1.png]]

To get to the Bill To screen, open the [http://www.abiscorp.com/faq/images/3/33/CHCL2.png Organization screen], select the customer, and click the BILLTO attribute.

----

===Default Credit Limit===

The default credit limit amount for new customers can be set in the [http://www.abiscorp.com/faq/images/9/9c/CHCL3.png CID Maintenance] screen.

----

===Credit Limit Calculation===

A customer's credit limit is calculated by adding the current AR balance to the current Open Sales Order amount.

For example, a customer with a $10,000 credit limit will exceed that amount if you enter a sales order for $1000 and they already have a $9100 balance in AR.

The '''Past Due Days Limit''' creates the same restrictions as exceeding a credit limit. If an invoice has remain unpaid for a period greater than the "Past Due Days Limit," then the customer is said to have exceeded their credit limit.

Credit Limits are calculated by the BILLTO, not the SOLDTO. This is done under the belief that the organization required to remit payment for the invoice (the Bill To) is where credit should be maintained.

----

===Credit Limit Restrictions===

By default, a new Sales Order with an Order Amount greater than $0 cannot be saved if the customer has exceeded their credit limit.

There is a security right (EXCEEDCREDITLIMIT) that will allow a user to exceed the credit limit and enter new orders for customers over their limit.

The '''Do Not Exceed''' checkbox on the Bill To screen overrides the EXCEEDCREDITLIMIT security right. It will prevent anyone from entering a new sales order for a customer that is over their credit limit and has the '''Do Not Exceed''' box checked.

----

===Credit Hold Restrictions===

The '''Credit Hold''' checkbox prevents anyone from entering a new sales order for that customer, regardless of their credit limit and current AR balance. You can enter quotes for the customer, but they cannot be converted into Sales Orders until the credit hold is removed.

----

===Credit Hold Exceptions===

Clicking the Credit Limit hyperlink, users can allow selected orders and quotes to be sent through the order process while still keeping the customer on credit hold.

[[File:CHCL4.png]]

Users can also use the Credit Hold Processing screen to always allow certain processes to move forward when a customer is on credit hold. For instance if a customer has an order in production and they are placed on credit hold, the order can be allowed to finish out and be shipped while still locking down the customer to new orders.

[[File:CHCL5.png]]

[[Category: Accounts Receivable]]

Credit Hold & Credit Limits

2022-07-19T21:29:37Z

Bjohnson:

===General Information===

A customer's credit limit is set on the [[Bill To]] screen.

The [[Bill To]] screen also allows you to place a customer on Credit Hold.

'''You cannot enter new sales orders for customers on credit hold.'''

[[File:CHCL1.png]]

To get to the Bill To screen, open the [http://www.abiscorp.com/faq/images/3/33/CHCL2.png Organization screen], select the customer, and click the BILLTO attribute.

----

===Default Credit Limit===

The default credit limit amount for new customers can be set in the [http://www.abiscorp.com/faq/images/9/9c/CHCL3.png CID Maintenance] screen.

----

===Credit Limit Calculation===

A customer's credit limit is calculated by adding the current AR balance to the current Open Sales Order amount.

For example, a customer with a $10,000 credit limit will exceed that amount if you enter a sales order for $1000 and they already have a $9100 balance in AR.

The '''Past Due Days Limit''' creates the same restrictions as exceeding a credit limit. If an invoice has remain unpaid for a period greater than the "Past Due Days Limit," then the customer is said to have exceeded their credit limit.

Credit Limits are calculated by the BILLTO, not the SOLDTO. This is done under the belief that the organization required to remit payment for the invoice (the Bill To) is where credit should be maintained.

----

===Credit Limit Restrictions===

By default, a new Sales Order with an Order Amount greater than $0 cannot be saved if the customer has exceeded their credit limit.

There is a security right (EXCEEDCREDITLIMIT) that will allow a user to exceed the credit limit and enter new orders for customers over their limit.

The '''Do Not Exceed''' checkbox on the Bill To screen overrides the EXCEEDCREDITLIMIT security right. It will prevent anyone from entering a new sales order for a customer that is over their credit limit and has the '''Do Not Exceed''' box checked.

----

===Credit Hold Restrictions===

The '''Credit Hold''' checkbox prevents anyone from entering a new sales order for that customer, regardless of their credit limit and current AR balance. You can enter quotes for the customer, but they cannot be converted into Sales Orders until the credit hold is removed.

----

===Credit Hold Exceptions===

Clicking the Credit Limit hyperlink, users can allow selected orders and quotes to be sent through the order process while still keeping the customer on credit hold.

[[File:CHCL4]]

Users can also use the Credit Hold Processing screen to always allow certain processes to move forward when a customer is on credit hold. For instance if a customer has an order in production and they are placed on credit hold, the order can be allowed to finish out and be shipped while still locking down the customer to new orders.

[[File:CHCL5]]

[[Category: Accounts Receivable]]

Credit Hold & Credit Limits

2022-07-19T21:27:59Z

Bjohnson:

===General Information===

A customer's credit limit is set on the [[Bill To]] screen.

The [[Bill To]] screen also allows you to place a customer on Credit Hold.

'''You cannot enter new sales orders for customers on credit hold.'''

[[File:CHCL1.png]]

To get to the Bill To screen, open the [http://www.abiscorp.com/faq/images/f/f9/CHCL1.png Organization screen], select the customer, and click the BILLTO attribute.

----

===Default Credit Limit===

The default credit limit amount for new customers can be set in the CID Maintenance [[CHCL3.png]] screen.

----

===Credit Limit Calculation===

A customer's credit limit is calculated by adding the current AR balance to the current Open Sales Order amount.

For example, a customer with a $10,000 credit limit will exceed that amount if you enter a sales order for $1000 and they already have a $9100 balance in AR.

The '''Past Due Days Limit''' creates the same restrictions as exceeding a credit limit. If an invoice has remain unpaid for a period greater than the "Past Due Days Limit," then the customer is said to have exceeded their credit limit.

Credit Limits are calculated by the BILLTO, not the SOLDTO. This is done under the belief that the organization required to remit payment for the invoice (the Bill To) is where credit should be maintained.

----

===Credit Limit Restrictions===

By default, a new Sales Order with an Order Amount greater than $0 cannot be saved if the customer has exceeded their credit limit.

There is a security right (EXCEEDCREDITLIMIT) that will allow a user to exceed the credit limit and enter new orders for customers over their limit.

The '''Do Not Exceed''' checkbox on the Bill To screen overrides the EXCEEDCREDITLIMIT security right. It will prevent anyone from entering a new sales order for a customer that is over their credit limit and has the '''Do Not Exceed''' box checked.

----

===Credit Hold Restrictions===

The '''Credit Hold''' checkbox prevents anyone from entering a new sales order for that customer, regardless of their credit limit and current AR balance. You can enter quotes for the customer, but they cannot be converted into Sales Orders until the credit hold is removed.

----

===Credit Hold Exceptions===

Clicking the Credit Limit hyperlink, users can allow selected orders and quotes to be sent through the order process while still keeping the customer on credit hold.

[[File:]]

Users can also use the Credit Hold Processing screen to always allow certain processes to move forward when a customer is on credit hold. For instance if a customer has an order in production and they are placed on credit hold, the order can be allowed to finish out and be shipped while still locking down the customer to new orders.

[[File:]]

[[Category: Accounts Receivable]]

Credit Hold & Credit Limits

2022-07-19T21:22:20Z

Bjohnson:

===General Information===

A customer's credit limit is set on the [[Bill To]] screen.

The [[Bill To]] screen also allows you to place a customer on Credit Hold.

'''You cannot enter new sales orders for customers on credit hold.'''

[[File:CHCL1.png]]

To get to the Bill To screen, open the Organization screen [[Media:CHCL2.png]], select the customer, and click the BILLTO attribute.

----

===Default Credit Limit===

The default credit limit amount for new customers can be set in the CID Maintenance [[CHCL3.png]] screen.

----

===Credit Limit Calculation===

A customer's credit limit is calculated by adding the current AR balance to the current Open Sales Order amount.

For example, a customer with a $10,000 credit limit will exceed that amount if you enter a sales order for $1000 and they already have a $9100 balance in AR.

The '''Past Due Days Limit''' creates the same restrictions as exceeding a credit limit. If an invoice has remain unpaid for a period greater than the "Past Due Days Limit," then the customer is said to have exceeded their credit limit.

Credit Limits are calculated by the BILLTO, not the SOLDTO. This is done under the belief that the organization required to remit payment for the invoice (the Bill To) is where credit should be maintained.

----

===Credit Limit Restrictions===

By default, a new Sales Order with an Order Amount greater than $0 cannot be saved if the customer has exceeded their credit limit.

There is a security right (EXCEEDCREDITLIMIT) that will allow a user to exceed the credit limit and enter new orders for customers over their limit.

The '''Do Not Exceed''' checkbox on the Bill To screen overrides the EXCEEDCREDITLIMIT security right. It will prevent anyone from entering a new sales order for a customer that is over their credit limit and has the '''Do Not Exceed''' box checked.

----

===Credit Hold Restrictions===

The '''Credit Hold''' checkbox prevents anyone from entering a new sales order for that customer, regardless of their credit limit and current AR balance. You can enter quotes for the customer, but they cannot be converted into Sales Orders until the credit hold is removed.

----

===Credit Hold Exceptions===

Clicking the Credit Limit hyperlink, users can allow selected orders and quotes to be sent through the order process while still keeping the customer on credit hold.

[[File:]]

Users can also use the Credit Hold Processing screen to always allow certain processes to move forward when a customer is on credit hold. For instance if a customer has an order in production and they are placed on credit hold, the order can be allowed to finish out and be shipped while still locking down the customer to new orders.

[[File:]]

[[Category: Accounts Receivable]]

Credit Hold & Credit Limits

2022-07-19T21:20:18Z

Bjohnson:

===General Information===

A customer's credit limit is set on the [[Bill To]] screen.

The [[Bill To]] screen also allows you to place a customer on Credit Hold.

'''You cannot enter new sales orders for customers on credit hold.'''

[[File:CHCL1.png]]

To get to the Bill To screen, open the Organization screen [[CHCL2.png]], select the customer, and click the BILLTO attribute.

----

===Default Credit Limit===

The default credit limit amount for new customers can be set in the CID Maintenance [[CHCL3.png]] screen.

----

===Credit Limit Calculation===

A customer's credit limit is calculated by adding the current AR balance to the current Open Sales Order amount.

For example, a customer with a $10,000 credit limit will exceed that amount if you enter a sales order for $1000 and they already have a $9100 balance in AR.

The '''Past Due Days Limit''' creates the same restrictions as exceeding a credit limit. If an invoice has remain unpaid for a period greater than the "Past Due Days Limit," then the customer is said to have exceeded their credit limit.

Credit Limits are calculated by the BILLTO, not the SOLDTO. This is done under the belief that the organization required to remit payment for the invoice (the Bill To) is where credit should be maintained.

----

===Credit Limit Restrictions===

By default, a new Sales Order with an Order Amount greater than $0 cannot be saved if the customer has exceeded their credit limit.

There is a security right (EXCEEDCREDITLIMIT) that will allow a user to exceed the credit limit and enter new orders for customers over their limit.

The '''Do Not Exceed''' checkbox on the Bill To screen overrides the EXCEEDCREDITLIMIT security right. It will prevent anyone from entering a new sales order for a customer that is over their credit limit and has the '''Do Not Exceed''' box checked.

----

===Credit Hold Restrictions===

The '''Credit Hold''' checkbox prevents anyone from entering a new sales order for that customer, regardless of their credit limit and current AR balance. You can enter quotes for the customer, but they cannot be converted into Sales Orders until the credit hold is removed.

----

===Credit Hold Exceptions===

Clicking the Credit Limit hyperlink, users can allow selected orders and quotes to be sent through the order process while still keeping the customer on credit hold.

[[File:]]

Users can also use the Credit Hold Processing screen to always allow certain processes to move forward when a customer is on credit hold. For instance if a customer has an order in production and they are placed on credit hold, the order can be allowed to finish out and be shipped while still locking down the customer to new orders.

[[File:]]

[[Category: Accounts Receivable]]

Credit Hold & Credit Limits

2022-07-19T21:19:53Z

Bjohnson:

===General Information===

A customer's credit limit is set on the [[Bill To]] screen.

The [[Bill To]] screen also allows you to place a customer on Credit Hold.

'''You cannot enter new sales orders for customers on credit hold.'''

[[File:CHCL1.png]]

To get to the Bill To screen, open the Organization screen [[CHCL2]], select the customer, and click the BILLTO attribute.

----

===Default Credit Limit===

The default credit limit amount for new customers can be set in the CID Maintenance [[CHCL3]] screen.

----

===Credit Limit Calculation===

A customer's credit limit is calculated by adding the current AR balance to the current Open Sales Order amount.

For example, a customer with a $10,000 credit limit will exceed that amount if you enter a sales order for $1000 and they already have a $9100 balance in AR.

The '''Past Due Days Limit''' creates the same restrictions as exceeding a credit limit. If an invoice has remain unpaid for a period greater than the "Past Due Days Limit," then the customer is said to have exceeded their credit limit.

Credit Limits are calculated by the BILLTO, not the SOLDTO. This is done under the belief that the organization required to remit payment for the invoice (the Bill To) is where credit should be maintained.

----

===Credit Limit Restrictions===

By default, a new Sales Order with an Order Amount greater than $0 cannot be saved if the customer has exceeded their credit limit.

There is a security right (EXCEEDCREDITLIMIT) that will allow a user to exceed the credit limit and enter new orders for customers over their limit.

The '''Do Not Exceed''' checkbox on the Bill To screen overrides the EXCEEDCREDITLIMIT security right. It will prevent anyone from entering a new sales order for a customer that is over their credit limit and has the '''Do Not Exceed''' box checked.

----

===Credit Hold Restrictions===

The '''Credit Hold''' checkbox prevents anyone from entering a new sales order for that customer, regardless of their credit limit and current AR balance. You can enter quotes for the customer, but they cannot be converted into Sales Orders until the credit hold is removed.

----

===Credit Hold Exceptions===

Clicking the Credit Limit hyperlink, users can allow selected orders and quotes to be sent through the order process while still keeping the customer on credit hold.

[[File:]]

Users can also use the Credit Hold Processing screen to always allow certain processes to move forward when a customer is on credit hold. For instance if a customer has an order in production and they are placed on credit hold, the order can be allowed to finish out and be shipped while still locking down the customer to new orders.

[[File:]]

[[Category: Accounts Receivable]]

File:CHCL5.png

2022-07-19T21:19:15Z

Bjohnson: