Skip to main content
Solved

Is it possible to show the customer/vendor for the module of "CA"?

  • 29 September 2022
  • 9 replies
  • 195 views

Hi all,

 

Can you help me about my concern, if possible to show the customer/vendor “CA” module in Transactions for period report

 

Image Reference:

 

 

 

Thanks

Best answer by BenjaminCrisman

@bcsmis64 The reason mine are green on the report is because I added the ARPayment.CustomerID field to the report, displaying directly under the other field.

Instead of the way I did it, you can place them on top of each other and then use visibility expressions to control which one prints.

For testing purposes I would just do like I did and place the ARPayment.CustomerID field on the report and then see if it populates, if not, there could be something else going on, though I suspect it will work.

If it does, then you know it works and all you need to do is clean up the report and add the visibility expression (maybe something =[ARPayment.CustomerID]<>Null), I didn’t get that far but if there is difficulty with the visibility expression let me know and I’ll see if I can find a working configuration.

It’s almost there!

View original
Did this topic help you find an answer to your question?

9 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • September 29, 2022

Hi @bcsmis64 ! I checked over this report and there is nothing stopping all the Customer/Vendor data coming into the report, but I don’t see where the Customer/Vendor is stored on the Cash transaction?

Can you show a screenshot in the Cash Transaction screen where you are getting the customer or vendor?


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • September 29, 2022

HI @bcsmis64 

Cash Deposits do not show customers or vendors. It shows on the payments. 

If you are looking for a workaround- You can put the Customer or vendor name in the description. The system is only showing the summary of that deposit. 

For example, if you have 3 customer deposits on one deposit, the system won’t choose which one to show. 

 

 


  • Author
  • Freshman I
  • 4 replies
  • September 29, 2022

Hi @BenjaminCrisman 

 

This is the transactions coming from (please see the image below):

 

This is the invoice transactions

 

This is the Payment for customer

 

 

This is the transactions for Bank Deposit

 

 

When you click the specific reference number from Transactions for Period this is the output 

 

Thanks


  • Author
  • Freshman I
  • 4 replies
  • September 29, 2022

Hi @kbeatty21 

 

What is the reason or best explanation why the system can’t show the details for Customer/Vendor and the workaround only here is to input who’s customer in the description?

 

Thanks


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • September 29, 2022
bcsmis64 wrote:

Hi @kbeatty21 

 

What is the reason or best explanation why the system can’t show the details for Customer/Vendor and the workaround only here is to input who’s customer in the description?

 

Thanks

I believe that it’s because the deposits on the Journal transactions are only showing the summary. 


  • Author
  • Freshman I
  • 4 replies
  • September 29, 2022

Hi @kbeatty21 

 

And one more thing, the one in the GL module also has no customer/vendor listed, does this also mean that it is just a summary in Journal Transactions?


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • September 29, 2022

@bcsmis64 This is possible but it will require more joins into the report to make it happen, and adding more tables could mean more data coming in and create duplicates.

I think I was able to find a way around this by adding in a join from GLTran to CATran, then CATran to CADeposit, then CADeposit to ARPayment:

Join on CATranID = TranID
Join from CATran to CADeposit
CADeposit to ARPayment

The result I was testing for is this Bank Deposit:

This is what my report looks like:

 


  • Author
  • Freshman I
  • 4 replies
  • September 30, 2022

Hi @BenjaminCrisman 

 

I'm not sure if these are the ones I put in Tables

 

 

 

 

I followed your step from this

 

 

 

 

 

 

 

When I run the report, the Customer/Vendor not showing, I just don't know if I missed any steps

 

 

 

 


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • Answer
  • September 30, 2022

@bcsmis64 The reason mine are green on the report is because I added the ARPayment.CustomerID field to the report, displaying directly under the other field.

Instead of the way I did it, you can place them on top of each other and then use visibility expressions to control which one prints.

For testing purposes I would just do like I did and place the ARPayment.CustomerID field on the report and then see if it populates, if not, there could be something else going on, though I suspect it will work.

If it does, then you know it works and all you need to do is clean up the report and add the visibility expression (maybe something =[ARPayment.CustomerID]<>Null), I didn’t get that far but if there is difficulty with the visibility expression let me know and I’ll see if I can find a working configuration.

It’s almost there!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings