Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

How To Share One Custom Form Layout Between Multiple Sage 100 Company Codes

March 12, 2019 by Wayne Schulz

If you have multiple companies that will each use the same customized form layout you can create one modified copy of that form and share it between all the companies.

In this example lets share a Sage 100 AP check layout.

Create the form in MAS_SYSTEM\Reports\AP_CheckPrinting

Each company code has to use the same custom configuration and TYPE of check (typically Plain). This is set the first time you go to print the form from within the company code.

If a mistake is made you may need to access the specific record for the company/form in:

SY_ReportManagerFormat – FormatDesc$
SY_ReportSetting – TemplateDescription$

NOTE: You must have field #15 in SY_ReportSetting equal to the proper template

1 – AP_Check1 = PREPRINTED
2 – AP_Check2 = Plain
3 – AP_Check3 = Marbled
4 – AP_Check4 = Dot Matrix

I’ve seen a situation where a user chose plain for one company code when the CUSTOM check had been created with MARBLED. By going into SY_ReportSetting and changing the template from Plain to Marbled it picked the proper form.

Note that under the above process NONE of the companies will have a \MAS_XXX\REPORTS ( unless it is needed for a different custom form ) — they will ALL get their form layouts centrally from the ..\MAS_SYSTEM\Reports\AP_CheckPrinting

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Error 15 CI_ eFilingCommon.pvc 247 when generating Aatrix Form
  • Sage 100 2023 e-File Payroll Tax Deadlines
  • Beware Fake Sage Support Sites
  • When Is Sage 100 Payroll 2.24 for 2023 Due?
  • Which Crystal Reports Versions Are Compatible With Sage 100 (As of October 2023)?
  • Windows Server 2012 R2 No Longer Supported with Sage 100
  • How can I see the tax tables being used for Payroll taxes?
  • Sage TLS 1.2 Change Deferred For Some Through March 2024
  • Sage 100 Updates for 2023: The Year-End Edition You Can’t Afford to Miss
  • Summit Hosting Rebrands as Summit

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.