This Help File Page was last Modified on 01/17/2018
Receivables Section Data Entry Requirements
This Help File Page was last Modified on 01/17/2018
❑Accounts Receivable Information - This section within the Edit View on the Subscribers Form contains the fields required for the Accounts Receivable System and shows the Account's current status as it relates to Receipts and Sales.
•To access the Accounts Receivable Information Data Entry Section:
✓Select the Receivables tab on the MKMS Desktop and Click the Subscribers (F3) Icon.
✓Click the Edit View Icon and Choose the Subscriber Tab
✓Click the Receivables option or Drag the right side Slide Bar down until the Accounts Receivable section appears.
❑This Receivables section provides two key functions:
2.Viewing the Account Status which includes the Last Pay, Last Sale and the associated Dates, the Yearly RMR (Annualized Billing Amount of the Subscriber's currently defined Recurring Revenue), and the Subscriber's net Current Balance - none of which may be changed here.
Subscribers Form - Edit View - Accounts Receivable section
•Export to ItsPayd - If your Company is using the ItsPayd feature/service, and this Account will be submitted to them, Check this box.
•Tax Rate ID - Using the Drop-Down Selection List provided, Double-Click the appropriate Sales Tax ID for this Subscriber.
➢Optionally, Click the Ellipse Icon to open the Sales Tax Rates Maintenance Form. where Sales Tax Rates may be created new or revised (if the appropriate User Access Rights have been granted for the Sales Tax Rates Form)
•Tax Code - Using the Drop-Down Selection List provided, Select the appropriate Tax Code (from those defined for the assigned Tax Rate ID):
✓Y - Yes they are Taxable and the assigned Tax Rate ID was defined as not having Multiple Tax Rates
✓1 - Yes they are Taxable and the assigned Tax Rate ID was defined as a Multiple Tax Rates class and this Tax Code number represents the Tax Rate to be assessed.
✓2 - Same as 1 above.
✓3 - Same as 1 above.
✓N - No the Subscriber is Not Taxable.
✓E - This Subscriber is always Sales Tax Exempt.
•Tax Rate - This field will be populated automatically based on the Rate information for the Tax Code selected above, based on the information entered in the Tax Rates record of that selected Tax Code.
➢Note: Once this Tax Rate ID and Tax Rate information is saved, if Auto Bill records have been defined, and if this information is subsequently modified, a Rate Change Detected message will be displayed with the option to Update those affected Auto Bill records with the correct Tax Code and Tax Rate information.
•Division - If you have implemented the Division Codes functionality, using the Drop-Down Selection List provided, Double-Click the appropriate Division code.
➢Optionally, Click the Ellipse Icon to open the Divisions Maintenance Form. where Division may be created new or revised (if the appropriate User Access Rights have been granted for the Divisions Form)
•Credit Limit - If you want this Subscriber to have a Credit Limit, enter that maximum Credit Limit amount.
✓This is only designed to be a visual check for the User and not to prevent or discourage additional Sales entries.
✓It does not provide an automated Credit Limit alert message.
✓Using the Drop-Down Selection List provided, Double-Click the appropriate Late Fee Group.
➢Optionally, Click the Ellipse Icon to open the Late Fee Group Maintenance Form. where a Late Fee Group may be created new or revised (if the appropriate User Access Rights have been granted for the Late Fee Groups Form)
➢Note: If you have elected to Charge Interest and will be billing Recurring Revenue using the Recurring Billing Cycles feature (where different groups of Subscribers may be billed for their Recurring Revenue Fees at different times throughout the month), you should create Late Fee Groups for each of these Billing Cycles to ensure that their Past Due status better equates to when each Subscriber was actually billed.
•Pricing Mark Up Group - Using the Drop-Down Selection List provided, Double-Click an optional Pricing Mark Up Group, if appropriate.
✓Click the Ellipse Icon to open the Pricing Mark Up Group Maintenance Form. where a Pricing Mark Up Group may be created new or revised (if the appropriate User Access Rights have been granted for the Pricing Mark Up Group Form)
✓However, your Company may establish individualized Payment Terms for each (any) of your Subscribers.
✓This feature is enabled in Company Settings
▪If the UseSubscriberTerms option is set to True ("T") in Company Settings, this Terms field will become available.
set Terms = (Select Terms from dba.Useroptions)
where SubscriberID IN
(Select SubscriberID from dba.Subscriber where SubscriberID = BillPayer)
▪Then, this Terms field in the Receivables section will be enabled and you may re-set any individual Subscriber's Terms as needed, on a Subscriber by Subscriber basis.
✓Once this script shown above has been run, the Terms field will contain the Terms i.e., Number of Days after the Sale Date when the Payment for an Invoice is Due) established in the General sub-tab in the Company Options tab on the User Options Form,
✓Those Terms may be modified, as and when needed, on a Subscriber by Subscriber basis.
•Click the Save Icon on the Edit View Menu to record the entries.
❑Account Status items, as indicated by the Teal colored box around these fields, are maintained by the system and so are displayed for information only.
•Last Pay - the Amount of the last Receipt entered for this Subscriber
•Last Sale - the Total Amount of the last Sales Invoice entered for this Subscriber
•Yearly RMR - Annualized Billing Amount of the currently defined Recurring Revenue.
•Date of Last Sale - the Date of the last Sales Invoice entered for this Subscriber
•Date of Last Payment - the Date of the last Receipt entered for this Subscriber
➢Note:If the currently selected Subscriber record represents a Service Address which is not the Bill Payer for this set of Accounts, the Accounts Receivable section will have no Account Status information section.