Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

SY_State when added to InvoiceHistoryHeader duplicates the InvoiceNumbers? And it freezes the report when InvoiceHistoryDetail around 23K records.

Posted By Darkjedi 2 months ago

How come when I add SY_State to get the state name it duplicates the InvoiceNo from AR_InvoicehistoryHeader. The only field I use is StateName from SY_State. And when I add AR_InvoiceHistoryDetail it freezes the report around 23,000 records.

0 lwadana 2 months ago

Do you have a link on the Country Code field as well? You should since its part of the key to SY_State. Sounds like its finding multiple records that match that State.

Your 2nd issue could be a number of things, most likely linking or report layout.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie 2 months ago

I would add the name as a UDF.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

SY_State when added to InvoiceHistoryHeader duplicates the InvoiceNumbers? And it freezes the report when InvoiceHistoryDetail around 23K records.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING