Skip to main content
Question

debit and credit is not match


Forum|alt.badge.img

how can I match debit and Credit in APV thanks a lot.

 

 

9 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 8, 2023

Hello @fdomingo ,

I’d like more information, please, to understand your question.  What do you mean ‘APV’? What are you trying to do?  In what screen do you want to enter this document?

I will make a guess: Are you trying to enter the above document as an AP Bill?

What is the amount owed to the vendor? Depending on whether the net amount is positive or negative, you may enter a Debit Adjustment (if vendor owes you) or an AP Bill (if you owe the vendor) in AP. One or more lines will be negative, to represent the above posting accounts.

If I am guessing incorrectly, I will look for further information from you and then try again to help.

Laura


Forum|alt.badge.img
  • Author
  • 29 replies
  • February 9, 2023

This is the AP Register Detailed full report the problem is when I am trying to print the AP Voucher I see that the Debit Amount and Credit is not balance or same amount unlike in the AP Registered Detailed. And after review the the item having same amount in other item computed as one. what do yu think is the problem? is there a possibility that the form is the problem?

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 9, 2023

Hello,

When I compare the two reports side-by-side, I see 3 extra transactions on the AP Register Detailed that are not included in the other report. I think you are saying the other report is a custom voucher report. Correct?

The ‘custom voucher report’ omits transactions that have the same amount as another transaction. Three missing transactions on ‘custom voucher report’ match up to others: same branch, same account, same subaccount, same reference number, and same transaction description. How is the custom report grouped? Maybe AP Bill’s Line number can be added to the grouping to make sure all unique lines are included in the ‘custom voucher report’.

 


Forum|alt.badge.img
  • Author
  • 29 replies
  • February 13, 2023

is there any possible solution cuz they don’t want to add other item. if its possible to group all the item with the same description and amount? here is the sample code in the report designer 

=[GLTran.AccountID_description] /* [GLTran.SubID] + ' - ' + [GLTran.SubID_Sub_description] */


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 13, 2023

Hi, I can’t work with your sample code out of context, meaning I will need to see that in the screen shot to understand what you are saying.

We can group lines together on a report, but in that case we must sum the amounts.


Forum|alt.badge.img
  • Author
  • 29 replies
  • February 14, 2023

this is the report I have doing my problem is the debit and credit is not match the reason is if the item has same description and amount the report read or compute it once and the duplicate was disregard. note that I don't have a unique identifier in the file because they all the same. So the solution I think is to group all the item with the same GL accounts, description, and amount then sum it. but the problem is I don’t have a background to do it  so can you guide me you know thank you in advance.

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 14, 2023

Hello,

My next recommendation is to move this question out of Financials area and into Reports section of this forum. @Chris Hackett, can you assist?  Thank you!!

 

Laura


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • February 14, 2023

@laurabarber08 - I have moved it 😀


Forum|alt.badge.img
  • Author
  • 29 replies
  • March 9, 2023

Hello Community for this question this not yet solve I also try all the suggested answer or solution but is not working still the same. More ideas?


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