Microsoft Dynamics GP

Add fields to Sales Invoice form - Is VBA Modifier the solution?

Home » Microsoft Dynamics GP » Microsoft Dynamics GP Forum » Add fields to Sales Invoice form - Is VBA Modifier the solution?
Related Search Results

Dynamics Report Writer is the Best Report Writer in the World

by Anonymous
on 22 Nov 2010
  • 0 comments

Units of Measure stock

by
on 9 Dec 2011
  • Not Answered

Unit of measure error creating a purchase order

by
on 23 Jan 2013
  • Not Answered

Add fields to Sales Invoice form - Is VBA Modifier the solution?

This question is not answered
Barb M
Posted by
on 15 Feb 2013 11:44 AM

Hi.  We have a request to be able to track a second quantity and Unit of Measure on an Invoice Line.  This information comes from another system, and we eventually want to import from that system into GP using an integration (eConnect).

For example we sell a product by weight, but also want to track number of packages. There is no equivalency setup, because 10 Packages could be 500 KG or 525 KG or 499 KG.  We just want to be able to track both for reporting purposes.

Is VBA Modifier the solution for this or are there other ways we can do this?

With VBA Modifier can we actually create fields in GP tables? I don't know how this works.

 
All Replies
  • L Vail
    Posted by
    on 16 Feb 2013 7:56 AM

    Hi barmeh,

    You can use VBA to make an external (ADO) connection to the GP tables, but you would just be slamming data in and not get the benefit of the business logic. There is, however, a User table created by GP just for you. It's called the DUOS table. It's table SY90000 in the company database. The VBA Developer's Guide (VBADevelopersGuide.pdf) in the Documentation folder explains exactly how to populate this table. Using this table, you can collect additional information using the existing database structure.

    If you have a lot of information, this might not work so well, but it's worth a look.

    There are many ways to do what you are wanting. I was just trying to come up with something that might not require any 'outside' data objects.

    I feel certain that other solutions are on the way.  Stay tuned :)

    Kind regards,

    Leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net
  • Sandip Jadhav
    Posted by
    on 17 Feb 2013 11:40 AM

    Hello,

    Already you got great suggession from Leslie. I will recommend to create another table and the details with Invoice # plus Line Items details with additonal requirement.

    This way you are not going to messed up with existing GP logic. Create external report with all other details.

    Thanks

    Sandip

    Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
  • Barb M
    Posted by
    on 17 Feb 2013 12:38 PM

    Thanks to both suggestions. If I understand correctly,you are both suggesting to use the default method that VBA Modifier offers? That being the DUOS tables?  And the data would get into those tables by having extra fields on the Sales Transaction Entry window to capture the add'l information?  I am less concerned with integration and more with having the ability to enter the data, for now. The development for integration will come later.