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!

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

Added BIN number

Status
Not open for further replies.
tjbennett

tjbennett

MIS
Feb 8, 2005
95
US
Macola ES 9.5.700, Crystal Reports XI

Has anyone added the BIN number, from the IMINVBIN_SQL table to the Crystal Report Pick Ticket? I am once again getting the "Run-time error ‘9’, Subscript out of range” error after adding it. And I went through every sub-report this time and can't find any problems.

I heard that Macola may have included it in a suppressed (serial/lot/bin) sub-report somewhere on this report. But I haven't found it.
 
Sort by date Sort by votes
I am about 80% sure you must modify the subreport to do this. You should call your business partner or exact regional office and this should be a reasonable issue to address.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:
 
Upvote 0 Downvote
Hi,

If it's the same as the Progression one, then in details c section there is a subreport which has IMBINTRX_SQL in it, not sure how IMINVBIN could even work for this?
 
Upvote 0 Downvote
We only have ONE bin per part (at least right now). So I just needed to show what BIN number is assigned to a particular P/N. Anyway I did finally get it all to work. The MAJOR problem I was having was updating the Macola database used to create the ICR to my database. Until I was able to do that I would just keep getting the error messages and not be able to do anything with the data.

So to fix it ...... I had to create a new "OLE DB (ADO)" connection to my Macola database and then I was able to "update" the Macola database to mine. Then I could work with the data.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MMPierce
  • Locked
  • Question
General Ledger BBF Erroneous Number
Replies
1
Views
272
dgillz
dgillz
mlb90
  • Locked
  • Question
Vendor/Supplier - Next Default Code Number
Replies
1
Views
230
flutepic
flutepic
sans2174
  • Locked
  • Question
macola progression 7.8.200 Link Purchase order line item to voucher number and voucher date
Replies
2
Views
293
sans2174
sans2174
MenuItem
  • Locked
  • Question
OE: Confirm Picking - Capture OE Line Number
Replies
0
Views
158
MenuItem
MenuItem
kevvlol
  • Locked
  • Question
Crystal reports quote printing many pages when a formula referencing the bedryf table is added
Replies
3
Views
220
kevvlol
kevvlol

Part and Inventory Search

Sponsor

Back
Top