Solved

Entry Type Inquiry

  • 17 March 2023
  • 4 replies
  • 118 views
V
Rank
Userlevel 2

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?

icon

Best answer by aaghaei 17 March 2023, 20:43

View original

4 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @VBrundage 

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

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
V
Rank
Userlevel 2

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

Thank you….

aaghaei
Rank
Userlevel 7
Badge +8

@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.

 

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
K
Rank
Userlevel 4
Badge +1

The issue described is resolved in 22.209.0029,

 

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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved