Skip to main content
Answer

AP Check Register

  • December 6, 2022
  • 6 replies
  • 441 views

Forum|alt.badge.img

I’m trying to generate a report to submit to the bank for positive pay.  The check register has everything I need except it only shows 10 characters of the Vendor Name.  Is it possible to show all of the characters?

 

Thank you!

Best answer by aborisova37

@kstockman try clearing the Schema Field for the Vendor Description. It brings the format from the field selected here. I bet it’s a Vendor ID with a lenght of 10 characters.

6 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 6, 2022

Hello @kstockman ,

Acumatica has no report “Check Register”.  Maybe you have a custom report. Maybe you mean AP Payment Register?  I printed AP Payment Register (mine is not customized) and on it I see all characters of the vendor names.

More information is needed, in order to answer your question. Please show where your Check Register is found on the menu and a screenshot of the report results so that we may help you.

Thank you.


Forum|alt.badge.img
  • Author
  • Freshman I
  • December 6, 2022

I guess it isn’t a report it’s an inquiry and when you export to excel it only shows the 10 characters of the vendor’s name.  The AP Payment Register has more information than what is needed. 

 

 


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 6, 2022

Thank you! I forgot about that Inquiry.  If you are a member of the Customizer’s role, you can click Customization, Edit Generic Inquiry to change the columns.

I don’t see where a limitation has been added, that we could change or update.  I think you’ll need to add the Vendor table to the GI and replace the below field wiht the full  name of the vendor from the vendor table:

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • December 6, 2022

I’ll try that!  Thank you for your help!!


aborisova37
Semi-Pro I
Forum|alt.badge.img+1
  • Semi-Pro I
  • Answer
  • December 7, 2022

@kstockman try clearing the Schema Field for the Vendor Description. It brings the format from the field selected here. I bet it’s a Vendor ID with a lenght of 10 characters.


Forum|alt.badge.img
  • Author
  • Freshman I
  • December 7, 2022

I was able to change the Schema Field to Vendor.AcctName and it’s showing what I need.

 

Thank you so much! @aborisova37