Skip to main content

Hi all! I’m new to Acumatica; we just converted on 12/1 from Quickbooks.  How can I show an invoice marked as paid for my customers?  They ask for a paid invoice all the time for their records.  We sell high end products that many people need this for insurance purposes. 

Sometimes a customer will make a partial payment.  Example, a customer has an invoice for $100,000 worth of goods for which he paid $80,000.  I need the invoice to show:

 

Total:  $100,000

Amount Paid: $80,000

Balance Due: $20,000

 

Or if it’s paid in full, it would be marked as such and balance due would be zero.  How can I do this?

@ChandraM I was wrong - I ran the report with the subreport on a test invoice with two payments. It brings in the 1st applied payment. It also duplicated the one line item. I am stumped.

Hi @rwhetsell77 I attached the zip file as  I was unable to upload .rpx file( report file). I have submitted.a topic in this community to allow .rpx files.


Did you try unzipping the file? Where are you stuck in downloading the zip file.

Thanks

 

@rwhetsell77 I’ve had trouble downloading zip in community posts as well, especially when using Google Chrome. When using Edge I can click on the attachment and downloads the zip no problem.

Hi @rwhetsell77 I attached the zip file as  I was unable to upload .rpx file( report file). I have submitted.a topic in this community to allow .rpx files.


Did you try unzipping the file? Where are you stuck in downloading the zip file.

Thanks

 

Yea, Chrome was not being cooperative before, but tried again and it worked. Reviewing per previous comment.

@ChandraM Ok, validated the relationships and still getting the same results. Going to step away from this until tomorrow, been looking at it too much today. Thanks for all the assistance!

Reply


Terms & ConditionsCookie settings