Dynamics GP
Dynamics GP
Organizer:
- JOSE Organized by
-
-
Voided SOP invoices
-
Voided SOP invoices
-
Hi there,
When I go to Transactions – Sales – Print Sales Documents and I enter a range of Historical invoices to print, it’s printed voided invoices. Is there a way to exclude these invoices?
Thanks
——————————
Christine Boisvert
IT Manager
Floform Countertops
Winnipeg MB
—————————— -
It doesn’t appear that the option you desire exists in the print output screen. One thing you might check is to see if the sales order and its corresponding receivable (invoice) are both actually voided. I use the following every month to verify that my documents are consistent and notify my Accounting department when something pops up:
select rm.CUSTNMBR as Customer_ID
, CAST(rm.DOCDATE as DATE) Doc_Date
, RTRIM(rm.DOCNUMBR) as Doc_Number
, case s.SOPTYPE
when 3 then ‘Invoice’
else ‘Return’
end as Doc_Type
, case rm.VOIDSTTS
when 0 then ‘No’
when NULL then ‘Not Invoiced’
else ‘Yes’
end as Voided_in_RM
, case s.VOIDSTTS
when 0 then ‘No’
when NULL then ‘Not Invoiced’
else ‘Yes’
end Voided_in_SOP
from (
select CUSTNMBR
, DOCDATE
, DOCNUMBR
, case RMDTYPAL when 1 then 3 else 4 end as SOPTYPE
, VOIDSTTS
from RM20101
where RMDTYPAL in (1,8)
union
select CUSTNMBR
, DOCDATE
, DOCNUMBR
, case RMDTYPAL when 1 then 3 else 4 end as SOPTYPE
, VOIDSTTS
from RM30101 where RMDTYPAL in (1,8)
) rm
inner join SOP30200 s on rm.SOPTYPE = s.SOPTYPE
and rm.DOCNUMBR = s.SOPNUMBE
where rm.VOIDSTTS <> s.VOIDSTTS
order by case rm.VOIDSTTS
when 0 then ‘No’
else ‘Yes’
end, rm.DOCNUMBR
——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
————————————————————————- -
Hi Christine! I often instruct clients to use the Sales Transaction Navigation list to print and email historical invoices. Therefore I was leaning towards that as an option, adding a filter to exclude voids. This does not look like it is possible though.So as a second idea – do you have SmartList Builder? If so perhaps you could use it to create your own Nav. list with the restriction to exclude the voids as desired. Let me know ifhow you resolve this otherwise!
Lauri
——————————
Lauri Romaniuk
Senior Solutions Specialist
Encore Business Solutions
Winnipeg MB
————————————————————————- -
I’m curious about your reasons for using the Print Sales Documents option. Are you printing a list of invoices for a specific customer? Have you considered using Collections Main to print a group of invoices for a specific customer? It allows you to print any or all unpaid, posted transactions from the customer’s account. Since it’s only printing documents with a balance, voided documents would be excluded. Is there a reason you are printing historical invoices instead of printing the unposted (‘Documents’) invoices. as these would automatically exclude voided transactions?
——————————
Rebecca Redman
PANDORA Jewelry
Columbia MD
————————————————————————- -
They were using that window simply because that’s what they were used to. They like printing a specific range of invoices. I showed her how to print her invoices in her batch prior to posting. That process excludes voided invoices. It appears that the other way of doing it is a bug in GP 2015. When you print a range of historical invoices through the “Print Sales Documents” window it should be excluding voided invoices. Otherwise, there is no way for the use to know that the invoice that printed is voided.
——————————
Christine Boisvert
IT Manager
Floform Countertops
Winnipeg MB
————————————————————————-
-
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Voided SOP invoices’ is closed to new replies.
