Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding a second page for Terms to Invoice Form

Status
Not open for further replies.

brendasql

Programmer
Apr 1, 2003
58
US
Does anyone know if this can be done in GP9? I am trying to modify the blank invoice form to include a second page that would be the Terms and Conditions of Sale. Currently users are loading pre-copied sheets with the Terms and printing the invoices onto the sheets that way. I would like to elimate this step for my users and add the Terms to be printed at the time of the invoice. I have tried adding static text boxes but so far I have not had much luck.
Thanks,
Brenda

 
Do you have Modifier and VBA?

I have a method using VBA which can print a custom report with the terms and conditions. My example is for POP but you could make it work for SOP too.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

mailto:David.Musgrave@online.microsoft.com

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Thanks for responding David. No we do not have Modifier or VBA, so I guess that means that we are stuck with doing things the way that we are for now.

Brenda
 
Brenda,

Not sure if this is an option for you, but adding a second page that would be the Terms and Conditions of Sale in Crystal Reports is pretty straightforward. Plus you get a lot of other options with Crystal that are not always possible in Report Writer. I would say at least 50% of our customers have invoices in Crystal because what they wanted to do was either not available or very difficult/costly to do in RW.

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports
 
Victoria,

That's real interesting. I have created several reports in CrystalXI, which is being used as a stand-alone. All of these reports are for summary of sales, and a few for inventory. I will start trying this option now.
Thanks!

Brenda
 
Brenda,

Forgive me for the shameless plug, but I thought this might be of interest to you.

We have a number of Crystal reports available for sale, and we just completed a 'simple' version of the SOP Invoice/Return and Historical Invoice/Return. They're not on our website yet, but if you're interested, please let me know and I can get you more info/samples. We also have a product that will let you run the Crystal reports you already have inside GP to make it very user friendly and allow shortcuts to the reports from GP windows, lookups of parameters directly from GP, etc. Not sure if that's something you're looking for, just thought I would let you know. (In fact, that's our ad at the top of this page. :))


Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top