To show up where? I thought you said it shows on the invoice totals as an order prepayment.

Correct, but not on the invoice form as a prepayment of the invoice. I entered a prepayment on the sales order and if I post that prepayment before I ship all and invoice the order the prepayment does not show up on the invoice when printed. It does show up on the invoice under the totals as a prepayment on the order, but shows that the invoice is still open.

Correct, but not on the invoice form as a prepayment of the invoice. I entered a prepayment on the sales order and if I post that prepayment before I ship all and invoice the order the prepayment does not show up on the invoice when printed. It does show up on the invoice under the totals as a prepayment on the order, but shows that the invoice is still open.

The OE order prepayments do not print on the stock OE invoice report. Edit the Crystal report and add the order prepayments to the report.

They do if you enter the prepayment on the sales order at the same time you ship and invoice.

I know.... but order prepayments do not. You have to edit the OE invoice report and add the order prepayments so that they print.

Which field do I need to change on the invoice form. I see spayment and stotaldue, but those do not show a prepayment made on the order.

Look at the prepayment subreport, you need to modify it to show order prepayments + invoice prepayments.

I do not see a prepayment subreport, just a field that shows invoice prepayments and no other payments. I also do not see the field that has the order prepayment. We see it in the OE invoice entry screen, but do not see those payment fields as fields that be place on the invoice form. Any ideas?

There is a subreport named PAYED.RPT on the OE invoice report. This pulls the prepayment from the OEPPRE table, but it shows prepayments for invoices only (APPLYTO=2). This needs to be modified to inlcude prepayments for orders (APPLYTO=4) and shipments (APPLYTO=9). Contact a Sage 300 consultant/report writer if you cannot figure it out.

Unless you are looking at the DATAPIPE OE invoice report OEINV01.RPT - which is useless for this purpose, or any purpose for that matter. You need to look at the ODBC report OEINV04.RPT.

I see the applyto = 2 and those records show up on the invoice. I see applyto=4 and those are the order prepayments that only have the order number on them and no invoice reference. I do not see any applyto=9 records. We are shipping and invoicing from the order screen. Does that make a difference. I also created the following test: Order with two line items, one for $27 and one for $52 dollars and I create a prepayment for $79 dollars. I invoiced line one and at a separate time I invoiced line 2. Both invoices show an order prepayment of $79 dollars. When I do a customer inquiry it shows that the prepayment was applied to both invoices and both invoices have a zero balance, but I cannot see that in the OEPPRE or OEINVH tables. What am I missing?

Thanks for your assistance.

All prepayments are posted to OEPPRE, it does not matter if it is an order, shipment or invoice prepayment.

I see the order prepayment, but even if I attempt to link to that record, it does not show what invoice it is applied against. Is that in another table?

No - you're missing the boat. Link on the order associated with the invoice - each invoice has an order right?

Each invoice has one order, but sometimes an order will produce two invoices. In my example above if I link the $27 dollar invoice to the order prepayment, that amount is $79. Somehow the AR ageing gets it right and the AR customer inquiry is correct, but I cannot see exactly how it is done.