Sage 100

Error: ""Terms Code must be numeric"" - Trying to import customer invoices via Visual Integrator in Sage ERP 100 version 4.50 PU#4. Included on the VI data tab is TermsCode, that is File Assigned from the Customer File. In the VI data dictionary the TermsCode is shown as a String Data Type field. Any ideas?

Michael - you do not need this field in your import. It wil find the data.

Some things that jump to mind: Have you confirmed that the customers you are trying to import invoices for have terms codes assigned in customer maintenance? Do you get the same error if you assign the terms code as 00 just as a test?

Yes, try the less is more theory of Diana's. Hard to let go of all of the legacy framework ways in VI, but this is one area where I do like the BF.

@DianaLaughner and @JeffSchwenk Thank You! Removed the TermsCode from data tab and import worked! 90Minds Socialcast is the greatest thing since sliced bread!

I think the 90Minds Socialcast group is even greater than sliced cinnamon raisin bread!

Oh, the LOVE Fest....... All together now! Age Of Aquarius lyrics When the moon is in the Seventh House And Jupiter aligns with Mars Then peace will guide the planets And love will steer the stars This is the dawning of the Age of Aquarius The Age of Aquarius Aquarius! Aquarius! Harmony and understanding Sympathy and trust abounding No more falsehoods or derisions Golden living dreams of visions Mystic crystal revelation And the mind's true liberation Aquarius! Aquarius! When the moon is in the Seventh House And Jupiter aligns with Mars Then peace will guide the planets And love will steer the stars This is the dawning of the Age of Aquarius The Age of Aquarius Aquarius! Aquarius! [From: http://www.elyrics.net/read/0-9/5th-dimension-lyrics/age-of-aquarius-lyrics.html ] Let the sun shine, Let the sun shine in..........................................

LOL!! You go ahead and record it @JeffSchwenk so we can all listen to it. It can be the theme song for the group!

So is 90minds putting together a band for Summit next year?

No, I am thinking maybe a ""Gleeish"" show choir. After all, we seem to fit the show's group profile - young at heart, hard working, idealistic, super intelligent (well maybe not Peter) and not quite ready to face the real world.............

I can see it now - all us from 90 Minds with headbands, love beads and tie-dye singing the Age of Aquarius. Too bad that song came from the musical Hair, which after working with Sage, we may no longer have in abundance.