[GNC] BUSINESS CHECK PRINTING - BILLS PAID INFORMATION ON STUBS

[Greg Crawford]

Victor, thanks for the reply. The data for the splits will be present in my
company file moving forward, I will be entering it complete and in real
time. I'm looking for workable solutions prior to migrating all of my
companies to GNUCASH. And printing bill payment checks, with meaningful
stubs is a must.

My level of programming expertise is spotty. I've messed around extensively
with VBA doing work with Excel, cobbling together solutions for my own very
specific accounting tasks. At the moment, if nobody has something much
simpler to offer here... I see the most likely solution being to write an
external VBA script that will go and grab the data right from my XML file
itself and build the checks external to GNUCASH. To a man with a hammer...
everything looks like a nail, I guess. I don't love it. It seems labor
intensive and clunky. I had hoped for more from GNUCASH... Especially since
the data points I need all seem to be present somewhere... Just not linked
up accessibly.

Hoping others might have a solution up their sleeves. Or that someone can
definitively say there is NOT one. I hope that's not the case, but it would
at least be a starting point, I suppose.

On Thu, Feb 28, 2019 at 5:22 PM R. Victor Klassen <rvklassen at gmail.com>
wrote:

> I know of no way to get that information automatically included.
>
> With the right format, you can get the name and address, and - if the
> information on the stubs is in the splits - the rest of the information
> more or less as shown.
> The lack of automation is in getting the information into the splits.
>
> With some moderate programming you could likely extract the information
> for the splits from a vendor report and then massage it into a format
> suitable to be imported as qif or perhaps csv, thereby automatically
> populating the splits.
> But I have no idea what your level of programming expertise is.
>
> > On Feb 28, 2019, at 2:09 PM, Greg Crawford <gcrawfordemail at gmail.com>
> wrote:
> >
> > Hello,
> >
> > Please advise if I err in format or in conforming to mailing list rules.
> > I'm new to this and as well as to GNUCASH and open source programs.
> >
> > I've installed GNUCASH on my Windows 10 PC this month. I'm still trying
> to
> > figure out functions.
> >
> > When I print a check that I have paid bills with, I need it to display
> the
> > original bill information on the stubs. So far, I have only been able to
> > get it to display "Liabilities:Accounts Payable" and the total amount of
> > that bill.
> >
> > I've attached a sample check (generated from Quickbooks exported check
> data
> > by a VBA macro I wrote). This shows the information that I need on
> checks.
> > Is there a way to print checks in this manner from GNUCASH? Or, maybe a
> > report I can generate that will contain that information?
> >
> > Thanks for your help,
> > g
> > <SAMPLE VENDOR CHECK
> PDF.pdf>_______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>