Skip to main content
Solved

Entry Type Inquiry


Good morning,

We use entry types to deduct fees and other assorted items from our deposits.  Unfortunately in the General ledger the descriptions do not flow through from the Banking module.  I would like to be able to run a report on the amounts for each entry type. 

General ledger for credit card fees the lines are blank

Has anyone encountered this and could help a person out with getting this information?  Or has anyone modified the Account Details report to show this information?

Best answer by aaghaei

@VBrundage CA is not the only module with an unhelpful transaction description. On taxes and project transactions … we see the same issue. Over a year ago I created an “Idea” on the community that considering my account is not linked to a corporate I can not access it anymore to see at what stage it is. Please have a look to see if it has any progress and upvote if you like.

Meantime, if it is really important to you, a customization as follows is your go-to option:

  • Create a graph extension on CADepositEntry
  • Add a RowPersisting or RowPersisted (either will do the work) on GLTran DAC.
  • Inside the Event handler ‘Module=CA’ & ‘TranType=CDT’, get the source record from CADepositCharge where:
    • CADepositCharge.TranType = GLTran.TranType
    • CADepositCharge.RefNbr = GLTran.RefNbr
    • CADepositCharge.AccountID = GLTran.AccountID
    • CADepositCharge.SubID = GLTran.SubID
  • If a record is retrieved, then from CAEntryType retrieve the related record where CAEntryType.EntryTypeID =  CADepositCharge.EntryTypeID
  • If a record is retrieved, get its Descr field value and update the GLTran.TranDesc with it.
  • If you want you can combine CAEntryType.Descr with the CADeposit.TranDesc or any other values and use them as GL Transaction Description.

It is a pretty straightforward customization that can be done and tested and debugged within a day.

Considering the GL Batch Posting runs inside a LongOperation you might need to play a little bit more if the EventHandlers didn’t respond properly to move the logic to “Persist” method Where you can create a new Graph Instance and do further processing.

 

Cheers and Good Luck.

 

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

4 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2158 replies
  • March 17, 2023

HI @VBrundage 

The only description that pulls is the Description on the Actual Bank Deposit:

 


  • Author
  • Freshman II
  • 4 replies
  • March 17, 2023

Yes, unfortunately that doesn’t help me track our credit card fees without looking at each individual transactions.  

Thank you….


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • Answer
  • March 17, 2023

@VBrundage CA is not the only module with an unhelpful transaction description. On taxes and project transactions … we see the same issue. Over a year ago I created an “Idea” on the community that considering my account is not linked to a corporate I can not access it anymore to see at what stage it is. Please have a look to see if it has any progress and upvote if you like.

Meantime, if it is really important to you, a customization as follows is your go-to option:

  • Create a graph extension on CADepositEntry
  • Add a RowPersisting or RowPersisted (either will do the work) on GLTran DAC.
  • Inside the Event handler ‘Module=CA’ & ‘TranType=CDT’, get the source record from CADepositCharge where:
    • CADepositCharge.TranType = GLTran.TranType
    • CADepositCharge.RefNbr = GLTran.RefNbr
    • CADepositCharge.AccountID = GLTran.AccountID
    • CADepositCharge.SubID = GLTran.SubID
  • If a record is retrieved, then from CAEntryType retrieve the related record where CAEntryType.EntryTypeID =  CADepositCharge.EntryTypeID
  • If a record is retrieved, get its Descr field value and update the GLTran.TranDesc with it.
  • If you want you can combine CAEntryType.Descr with the CADeposit.TranDesc or any other values and use them as GL Transaction Description.

It is a pretty straightforward customization that can be done and tested and debugged within a day.

Considering the GL Batch Posting runs inside a LongOperation you might need to play a little bit more if the EventHandlers didn’t respond properly to move the logic to “Persist” method Where you can create a new Graph Instance and do further processing.

 

Cheers and Good Luck.

 


Forum|alt.badge.img+1

The issue described is resolved in 22.209.0029,

https://community.acumatica.com/supported-releases-67/acumatica-2022-r2-update-9-build-22-209-0029-14026

 

See Release notes for the following:

AC-247688: In a journal transaction posted by an AR payment with nonzero bank fees, the entry that debited the cash account had an empty description if the Deduct from Payment check box was selected on the Entry Types (CA203000) form for the entry type used for the bank fees and the bank fee amount was deducted from the payment amount.


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