Skip to main content
K
kpierson67
July 1, 2022
Solved

Invoice line item splits on P&L detail report

  • July 1, 2022
  • 1 reply
  • 0 views

I have some invoice line items that are a simple, one line, entry on the invoice that are splitting into 3 or 4 random amounts on the P&L detail report. Can anyone tell me why and how to fix it? Some line items do not split, some split into 3 -4 random amounts to make up the total line item. I can find no rhyme or reason to how or which ones split. 

 

Thanks

Best answer by Rainflurry

Thanks. Can you give me some more info on why this happens and how to fix it. I have already checked my items list and see no settings that would affect this. I need to understand more about what causes it to be split up and how to make it not do that. Is it doing this because there is a credit line item on the invoice? (You mentioned advance payment. I use a simple credit line type entry) If so, how should it be entered on the invoice so that it does not split in the P&L? 


@kpierson67 

 

Yes, it is because you are entering a credit line item on the invoice.  The proper way to record a customer prepayment is to record the prepayment by going to Customer > Receive Payments.  After entering the info (customer, amount, date, etc), make sure the "Leave the credit to be used later" radio button is checked in the lower-left land corner.  When you create the invoice later, click 'Apply credits' at the top of the invoice screen to apply the credit.

 

If you aren't actually receiving prepayments (your posted screenshot has the same date for the prepayment and the invoice, which is odd) use a sales receipt instead.  Sales receipts are designed to be used when payment is received at the same time as the sale occurs.

1 reply

Candice C
Candice C
July 1, 2022

Hey there, @kpierson67. 

 

Congrats on making your first post here in the Community. I hope your day is going well so far. 

 

To clarify, can you provide me with a screenshot of how the split look to ensure we're on the same page. 

 

This will help me determine the root of the problem. I'll be waiting for your response! 

K
kpierson67Author
July 1, 2022

All of these that are duplicates are on my invoice as one line item. 

 

M
MadelynC
July 1, 2022

I’m here to share insights on why invoices are split into random amounts on the Profit and Loss Detail report, @kpierson67.


There are several reasons why invoices are split into random amounts on the Profit and Loss Detail report. One of the following is partial payments or advance payments and inventory assembly.


I’ve seen advance payments on your screenshot. You can review the affected transactions to verify. Also, check the items on your invoices, then compare them to your Item list. Here’s how:

 

  1. Select Lists at the top.
  2. Go to Item List.
  3. Find the items and select to open.


I’ve added these resources to learn how to draw information clearly and save the same report settings for future use:

 


If you need more help in managing your transactions and reports, don’t hesitate to add a comment. I’ll be here. Take care always!

Terms & ConditionsAccessibility statement