Specifically the Error 43 means the number of columns for SO_InvoiceHeader and from the tables corresponding to the other data sources (see list below), exceeds 999. On my v2020.2 system which has some UDFs, I have 845 columns. This means you have a crap ton of UDFs among all these tables. If there are some you don't need anymore or were just experimental, just delete them with UDF Maintenance.
Data Sources for SO_Invoice_bus (SO_InvoiceHeader):PaymentType, ArDivisionNo CustomerNo, TaxSchedule, SalesOrderNo, TermsCode, SalesPersonDivisionNo, SalesPersonDivisionNo2, SalesPersonDivisionNo3, SalesPersonDivisionNo4, SalesPersonDivisionNo5, SalesPersonNo, SalespersonNo2, SalespersonNo3, SalespersonNo4, SalespersonNo5, ShipVia, BillToCountryCode, ShipToCountryCode, BillToZipCode, ShipToZipCode, ShipToCode, ShipperId, BillToDivisionNo, BillToCustomerNo, WareHouseCode,
------------------------------
Alnoor Cassim
Email:
alnoor@asifocus.comPh: 949-689-9887
Orange County, CA
------------------------------
Original Message:
Sent: 09-01-2021 23:23
From: Jeff Schwenk
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
AWESOME!!!!! But one step forward and the brick wall appears. When I try to modify my existing ALE or create a new one, when I click on the "New Field" button, an error 43 SWQMAN line 4120 comes out of nowhere. WHAM!!! See attached. Apparently, I have more than 1000 query column definitions? Not seeing it! Interesting that they suggest that I create an enhancement request on the Ideas site.
Drats, stymied again. So close!
BTW, V2021
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
Original Message:
Sent: 09-01-2021 22:17
From: Alnoor Cassim
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
Jeff - Like this. In S/O Invoice Data Entry - Click the ALE Lookup for Sales Order No, click on Custom button then modify that lookup like this:
** Any field that is not in the default lookup can be prefixed with "dat." and should be appended with a $ if a string field.
In my data set, the CurrentInvoiceNo value of 0137445 for SO 0052766 is correct.
------------------------------
Alnoor Cassim
Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
Original Message:
Sent: 09-01-2021 18:33
From: Jeff Schwenk
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
@Brett Zimmerman - Interesting thought, but if the SO Inquiry is in play, I could just keep that panel open along side the SO invoice panel.
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 09-01-2021 12:45
From: Brett Zimmerman
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
What about just adding S/O Inquiry (button) to Inv Entry screen? I think that lookup has the field you need.
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
Original Message:
Sent: 09-01-2021 12:07
From: Jeff Schwenk
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
@Kevin Moyes - Thanks for the suggestion but I am not a scripter. If I need a script, I sub it out. This appears to be a WAD that has existed for many moons. Not sure why the current invoice field was omitted from the - S/B ALE as it is as important as the LASTINVOICE field (which made the list). Back in the day, there was a post on adding a new table to the ALE via VI Export but I doubt that this would work as the SO header table is the subject of the ALE. Short of a solution from the group, I am not going to pursue with Sage. There are many more important bugs that they are ignoring.
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 09-01-2021 11:55
From: Kevin Moyes
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
Are UDF's available in the lookup? If so, try that with a mirror script (column post validate on the Sage field to update the UDF).
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 09-01-2021 11:53
From: Jeff Schwenk
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
@Brett Zimmerman - You are at the point where my question applies. The SO ALE inside the SO Invoice panel only pulls up the ALE ..... Header List - S/B. I added the field to the ....... Header List - ALL. SO entry uses the - ALL ALE, SO invoice entry uses the - S/B ALE. I don't see a way to change this or display the current invoice field in the ALE. Looking for a hack if this is the case.
------------------------------
Jeff Schwenk
FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 09-01-2021 11:42
From: Brett Zimmerman
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
@Jeff Schwenk, it looks like you can use this one which has the CurrentInvoiceNo field, or does that Lookup not apply to the SO field in Inv Entry?:
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
Original Message:
Sent: 09-01-2021 11:39
From: Brett Zimmerman
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
However, it appears that field is NOT available via the SO lookup inside S/O Invoice Data Entry. Maybe you can just add S/O Inq button to Inv Entry screen.
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
Original Message:
Sent: 09-01-2021 11:35
From: Brett Zimmerman
Subject: SO Invoice Entry, SO Number look up (ALE), Current Invoice field Missing
Do you have to use the User Lookup 'Wizard'? Can you just use the Custom button on the SO lookup? That has the CurrentInvoiceNo field.
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area