Share
ReportHi,
Is there is a way that we can have the blank SOP invoice print with subtotal by ship date in report writer.
Thanks,
Ragaei
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
Is there is a way that we can have the blank SOP invoice print with subtotal by ship date in report writer.
Thanks,
Ragaei
*This post is locked for comments
Hi Leslie,
That is exactly how you describe it and here is the answer for your questions
1-Sending one invoice weekly
2-Ship date is on the item detail window
3-Printing invoice from Sales Trx Entry window SOP Blank invoice form.
Thanks,
Ragaei
Hi Ragaei,
Hmm. Maybe it's too late (no, for sure it's too late) or maybe my brain isn't fully engaged (at this hour, it isn't), but I'm having a hard time visualizing what you need.
The numbers are all the same between the two dates and that seems to always lead to confusion. Let me say what I think you are asking. You can clear it up for me because it is most likely wrong. Here goes.
Your invoice contains two line items, let's pretend that you want 7 green phones that is line item one, and 5 hard drives that is line item two.
The total invoice looks like this:
Line item 1: Green Phone qty: 7 Unit Price $50 extended price: $350
Line item 2: Hard Drive qty: 5 Unit Price $60 extended price : $300
The items on this invoice were shipped on two different dates:
On May 1st
3 green phones, price ea $50, extended price $150.
2 hard drives, price ea $60, extended price $120,
subtotal $270
On May 2nd
4 green phones, price ea $50, extended price $200
3 hard drives, price ea $60, extended price $180
subtotal $380
Invoice subtotal $650
OK, my questions:
1. Are you just sending one invoice?
2. How are you recording the ship date on the line item?
3. Where exactly on the invoice do you want this to print?
If you do not yet have a solution, please let me know and I will try to assist you.
Kind regards,
Leslie
Hi Leslie,
What I need to do is to have the following on the invoice
Ship date May1st
Item1 50
Item2 60
Subtotal 110
Ship date May2nd
Item1 50
Item2 60
Subtotal 110
Then total at the end 220
Let me know if you have any other questions
Ragaei
Hi Ragaei,
I may be confused, but if you want to print the subtotal next to the ship date in the Page Header or Report Header of the SOP Blank Invoice Form, the answer is YES.
All you need to do is go to the report writer layout window for the report and add the F/O Subtotal field (for the subtotal) or the F/O Document Amount (if you want the bottom line total) to the Page Header and/or Report Header sections of the report.
Kind regards,
Leslie
This requires the ability to group lines into ship dates. I would suggest Accountable's Forms Printer and use either Crystal or SSRS to create the document. The Forms Printer software updates GP as if the native documents were printed.
If you need help with SSRS documents, we have a great test on Creating Reports in SSRS available through our web site.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (