BizTechBlog Logo
Thursday, October 18, 2018

What's new in CloudSuite Industrial v10 - Financial Features

New to Accounts Payable

Generate A/P Transactions by PO Number

  • Streamlined matching PO Receipts to Invoices
  • Current process requires you to select the Vendor then Currency before selecting the PO number.

csi-tip-finance-1

Auto-post Financial Processes – background
  • A/P Voucher Posting
  • A/R Invoice Posting
  • A/R Multi-Site Invoice Posting
  • A/R Payment Posting (All 5 payment types)
  • There are error reports for any transactions that don’t post cleanly.
    • Voucher Posting background Message Report

Purchasing and Payables – Blue = pre-existing, Green = new features

  • Enter and Print Purchase Orders
  • Enter PO Receipts with Auto Vouchering
  • Generate AP Transactions, to match invoices to receipts (by PO Number)
  • Post Vouchers and Adjustments (background)
  • Pay the Vendors
  • Mass Journal Posting (background)
csi-tip-finance-2

Note: Background Post Status

  • Allow: vouchers can auto post in background IF background process has been set up.
    • FYI – This is the Default.
  • Hold: If you are entering a transaction and can’t decide on the account, or you have an invoice that has many account distributions and do not want it posting in the background while you are working on the distribution.
  • Error: Will show on Voucher Posting Background Message Report
    • Find, fix and change status to allow it to be posted.
Set Up A/P Voucher Posting Background
  • A/P Voucher Posting form
    • Check: Post in Background Queue
    • Select – Actions – Background
    • Schedule Day and Time for voucher posting to occur

csi-tip-finance-3

 

New to Accounts Receivable

Invoicing and Receivables - Blue = pre-existing, Green = new features

  • Enter Customer Orders
  • Ship the Order Lines
  • Order Invoicing (background)
  • Post Invoices, Debit and Credit Memos (background)
  • Multi-Site Invoice Posting (background)
  • Enter A/R Payments (background)
  • Post A/R Payments (background)
  • Mass Journal Posting (background)
  • When there is an error, the AR Payment Posting Background Error Report (not on any report menu) is printed to Report Output folder for the user that setup the background queue.
csi-tip-finance-4
  • Same Background Post Status choices as the A/P Vouchers and Adjustments

csi-tip-finance-5

  • Invoice posting can be set up exactly the same way as A/P Voucher Posting

csi-tip-finance-6

  • A/R Payments has the same Background Post Statuses
csi-tip-finance-7
  • A/R Payment Posting can be set up in the background

csi-tip-finance-8

  • To be notified when a background error message report is printed, you can subscribe to these 3 reports from the Publication Subscribers form.
  • Similarly, all errors need to be fixed and the statuses changed to Allow for the posting to complete during the next posting cycle.
Setup Steps
  • Set up Auto Voucher for trusted Vendors
    • Use Vendors form
  • Set up A/P Voucher Posting to run in the background
  • Set up Order Invoicing to run the background
  • Set up Invoice Posting to run in the background
  • Set up Multi-Site Invoice Posting to run in the background
  • Set up A/R (Check) Payment Posting to run in the background
  • Set up A/R Adjustment Posting to run in the background
  • Set up A/R Direct Deposit Posting to run in the background
  • Set up A/R Draft Posting to run in the background
  • Set up A/R Wire Posting to run in the background
  • Set up Mass Journal Posting to run in the background
Standard Order Invoicing for Shipment Masters
  • Prior to this release, if you used Pick, Pack & Ship (PPS), you had to use Consolidated Invoicing
csi-tip-finance-9
  • PPS Shipment Masters can be invoiced on the Order Invoicing/Credit Memo form
  • The existing Consolidated Invoicing checkboxes control whether shipments use the Consolidated Invoicing or the Order Invoicing/Credit Memo form
    • Consolidated Invoicing checkbox is on: Customers, Orders and Order Line forms
  • During the upgrade to CSI 10, any lines in the PPS process (that were not yet invoiced) have the Consolidated Invoicing flag selected
    • Can be unchecked prior to invoicing if we no longer want to use that method
Shipment Master Form
  • Consolidated Invoice button is disabled when all lines on the Customer Order are not selected for Consolidated Invoicing.
  • The reverse is true if all lines are selected for Consolidated Invoicing, then the Order Invoicing button is disabled.

csi-tip-finance-10

Customer Form – Codes Tab

  • New option for one invoice per shipment per order
  • This only applies to orders on the Shipment master that is invoiced on the Order Invoicing/Credit Memo formcsi-tip-finance-11
  • Order Invoicing, No, Create from Shipments
    • Only Lines NOT on a Shipment are Invoiced.
  • Order Invoicing, Yes, Create from Shipments
    • When One Invoice per Shipment, per Order is checked for Customer
      • Order Invoicing prints one invoice for each order on each shipment
    • When One Invoice per shipment, per order is not checked for Customer
      • Order Invoicing prints one invoice for each Shipment Master that meets the selection criteria on the Order Invoicing form.
      • Order Lines that are not a Shipment Master are not Invoiced
  • Both the Order Invoicing and Consolidated Invoicing move the Current Freight and Misc. Charges to the Accumulated fields

csi-tip-finance-12

  • When a Customer Order has both Consolidated and non-Consolidated Lines
    • Create the Shipment Master
    • Perform Order Invoicing
    • Then, perform Consolidated Invoicing to see Freight and Misc. Charges on BOTH INVOICES.
  • Change Consolidated Invoicing Utility
    • To quickly change the Consolidated Invoicing flag on Customer Orders and Lines.

csi-tip-finance-13

Dunning Letters
  • Set up on the Dunning Schedules form Dunning Group
  • Dunning Schedules
    • Dunning Group stages
  • Dunning Group field on A/R Parameters, Customer Types & Customer forms
  • Dunning fees
  • Print/Send Dunning Letters with Background Task
    • A/R Dunning Alert (to internal sales person/team, for example)
  • Dunning Report (Dunning Letter)
    • For each Dunning Group, for each stage, up to 20 text fields
    • Customer Name, Address, Billing Contact, A/R Balance and Past Due Items are displayed

csi-tip-finance-14

Sample Dunning Letter

csi-tip-finance-15

Automating Dunning Letters

  • Verify Customer Document Profiles are accurate
  • Set up a Background Task to run A/R Finance Charge Generation
  • Run Finance Charge Posting
  • Set up a Background Task to print Dunning Letters
  • The A/R Dunning Alert notifies key personnel that Dunning Letters were sent
Monthly Invoices Moved from Japan Country Pack to CSI core.
  • Customers form – Invoice Batch Cut Off Day (of the Month)
  • Generate Invoice Batch
  • Invoice Batches
  • Invoice Batch Detail, where we delete any unwanted transactions
  • Print Invoice Batch Report
  • Verify A/R Posted Transactions Detail

csi-tip-finance-16

General Ledger (GL)

  • General Ledger Vouchers (similar to China Country Pack) GL Voucher Templates give us recurring GL Vouchers
  • Approval may be required before posting
  • General Journals restricted similar to China CP
  • All Journal entries must be processed through GL Vouchers
  • GL Vouchers can be reversed
  • GL Voucher transaction numbers appear on GL Posted Transactions.
  • This must be enabled on the General Parameters form. May not be for everyone.
  • Can only update or delete Vouchers with a status of Requested or Rejected.
csi-tip-finance-17
  • Post Journal is not active until the G/L Voucher status is “Printed”.

csi-tip-finance-18

  • Typical order of events (if using G/L Vouchers)
    • Set up G/L Voucher Templates
    • Copy Templates to G/L Vouchers as needed (status = Requested)
      • G/L Vouchers may or may not have Approval required
    • Approve G/L Vouchers and/or Reject some G/L Vouchers
    • Print G/L Voucher Report
      • G/L Voucher status => Printed, which allows the Journal Entries to be posted
    • Post the General Journal and User Journals for your G/L Vouchers
      • G/L Voucher status => History when its Journal Entries are posted
    • Reverse G/L Vouchers if necessary. (Reversals go into original Journal)
    • Post the General Journal and User Journals for your G/L Voucher reversals
    • Query G/L Posted Transactions by G/L Voucher

Accounting Period Status

  • Can now have 3 statuses:
    • Open:
      • Same functionality
    • Closed:
      • We do not allow the transaction
    • Adjusting:
      • Allowable Days are overridden, and we allow business transactions only by users in the Enter out of Date Range Group – even in the Current Period.
      • Allowable Days are overridden, and we allow Journal Posting only by users in the Posting out of Current Period Group – even in the Current Period.


This Infor CloudSuite Industrial / Infor SyteLine tip was brought to you by BizTech ERP Consultant, Rod Lindstrom

 

Need help with CSI/SyteLine or want to explore if this is the right ERP for your company? 

Schedule a Free ERP Consultation

    

Follow BizTech!

Subscribe to Email Updates

 
 
 
 
Schedule Your Free Consultation

Popular Posts