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.

Exporting Invoices from Customer Inquiry to Excel Produces a Date in the Amount Field

Posted By bp3278 2 months ago

Hello,

We are attempting to export all invoices for a specific customer from the Invoices tab of A/R Customer Inquiry using the Excel button. However, the output in Excel produces a date in the Amount column for all invoices. How can we fix this issue?

Thanks for your help,

0 BigLouie 2 months ago

I would suggest going to Accounts Receivable, Explore, Customer Open Invoices View, filter for that customer and then export to Excel. You have better control over what columns you get in your export.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bp3278 2 months ago in reply to BigLouie

Thank you BigLouie. When accessing the Accounts Receivable > Explore > Customer Open Invoices View, no data is returned.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bp3278 2 months ago in reply to bp3278

Hello,

I determined that the export from Customer Inquiry was a formatting issue in the Amount column. When I changed the format from Date to Number in Excel, the amounts showed correctly. Is there a particular reason that causes Excel to format the data in this column to Dates instead of Numbers?

Thanks for your assistance,

Brian
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Exporting Invoices from Customer Inquiry to Excel Produces a Date in the Amount Field

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING